GST Practitioner

Build a Professional Tax Career.

  • Next batch starting date : 12/03/2025 8:00 pm
  • Duration : 4 Months
  • Qualification : 12th
  • Certification : Course Completion

Syllabus

Office 365

 

MS OFICE

 

Text Basics

  • Typing the text, Alignment of text
  • Editing Text: Cut, Copy, Paste, Select All, Clear
  • Find & Replace

Text Formatting and saving file

  • New, Open, Close, Save, Save As
  • Formatting Text: Font Size, Font Style
  • Font Color, Use the Bold, Italic, and Underlined
  • Change the Text Case
  • Line spacing, Paragraph spacing
  • Shading text and paragraph
  • Working with Tabs and Indents

Working with Objects

  • Shapes, Clipart and Picture, Word Art, Smart Art
  • Columns and Orderings – To Add Columns to a Document
  • Change the Order of Objects
  • Page Number, Date & Time
  • Inserting Text boxes
  • Inserting Word art
  • Inserting symbols
  • Inserting Chart

Header & Footers 

  • Inserting custom Header and Footer
  • Inserting objects in the header and footer
  • Add a section break to a document

Working with bullets and numbered lists

  • Multilevel numbering and Bulleting
  • Creating List
  • Customizing List style
  • Page bordering
  • Page background

Tables

  • Working with Tables, Table Formatting
  • Table Styles
  • Alignment option

Styles and Content 

  • Using Build- in Styles, Modifying Styles
  • Creating Styles, Creating a list style
  • Table of contents and references
  • Adding internal references
  • Adding a Footnote
  • Adding Endnote 

Merging Documents 

  • Typing new address list
  • Importing address list from Excel file
  • Write and insert the field
  • Merging with outlook contact
  • Preview Result
  • Merging to envelopes
  • Merging to label
  • Setting rules for merges
  • Finish & Merge options

Sharing and Maintaining Document

  • Changing Word Options
  • Changing the Proofing Tools
  • Managing Templates
  • Restricting Document Access
  • Using Protected View
  • Working with Templates
  • Managing Templates
  • Understanding building blocks 

Proofing the document 

  • Check Spelling as You Type.
  • Mark Grammar Errors as You Type
  • Setting AutoCorrect Options

Printing 

  • Page Setup, Setting margins
  • Print Preview, Print 

MS EXCEL

Introduction to Excel

  • Introduction to Excel interface
  • Understanding rows and columns, Naming Cells
  • Working with excel workbook and sheets

 Formatting Excel workbook:

  • New, Open, Close, Save, Save As
  • Formatting Text: Font Size, Font Style
  • Font Color, Use the Bold, Italic, and Underlined
  • Wrap text, Merge and Centre
  • Currency, Accounting and other formats
  • Modifying Columns, Rows & Cells

Perform Calculations with Functions 

  • Creating Simple Formulas
  • Setting up your formula
  • Date and Time Functions, Financial Functions
  • Logical Functions, Lookup and Reference
  • Functions Mathematical Functions
  • Statistical Functions, Text Functions

Sort and Filter Data with Excel

  • Sort and filter data
  • Using a number filter, Text filter
  • Custom filtering
  • Removing filters from columns’ conditional formatting

Create Effective Charts to Present Data Visually

  • Inserting Column, Pie chart etc.
  • Create an effective chart with Chart Tool
  • Design, Format, and Layout options
  • Adding chart title
  • Changing layouts
  • Chart styles
  • Editing chart data range
  • Editing data series
  • Changing chart

Analyze Data Using PivotTables and Pivot Charts

  • Understand PivotTables, Create a PivotTable
  • Framework Using the PivotTable and PivotChart
  • Create Pivot Chart from the pivot Table.
  • Inserting slicer
  • Creating Calculated fields

Protecting and sharing the workbook

  • Protecting a workbook with a password
  • Allow users to edit ranges
  • Track changes
  • Working with Comments
  • Insert Excel Objects and Charts in Word Documents and PowerPoint Presentation.

Use Macros to Automate Tasks

  • Creating and Recording Macros
  • Assigning Macros to the worksheets
  • Saving Macro enabled workbook

Proofing and Printing

  • Page setup, setting print area, Print titles
  • Inserting custom Header and Footer
  • Inserting objects in the header and footer
  • Page Setup, setting margins, Print Preview, Print
  • Enable background error checking
  • Setting AutoCorrect Options

MS POWERPOINT

 

Setting Up PowerPoint Environment:

  • New, Open, Close, Save, Save As
  • Typing the text, Alignment of text
  • Formatting Text: Font Size, Font Style
  • Font Color, Use the Bold, Italic, and Underlined
  • Cut, Copy, Paste, and Select All, Clear text
  • Find & Replace
  • Working with Tabs and Indents

Creating slides and applying themes

  • Inserting new slide
  • Changing the layout of slides
  • Duplicating slides
  • Copying and pasting slide
  • Applying themes to the slide layout
  • Changing theme color
  • Slide background
  • Formatting slide background
  • Using slide views

Working with bullets and numbering

  • Multilevel numbering and Bulleting
  • Creating List
  • Page bordering
  • Page background
  • Aligning text
  • Text directions
  • Columns option

Working with Objects

  • Shapes, Clipart and Picture, Word Art, Smart Art
  • Change the Order of Objects
  • Inserting slide header and footer
  • Inserting Text boxes
  • Inserting shapes, using quick styles
  • Inserting Word art
  • Inserting symbols
  • Inserting Chart

Hyperlinks and Action Buttons

  • Inserting Hyperlinks and Action Buttons
  • Edit Hyperlinks and Action Button
  • Word Art and Shapes

Working With Movies and Sounds

  • Inserting Movie from a Computer File
  • Inserting Audio file
  • Audio Video playback and format options
  • Video options, Adjust options
  • Reshaping and bordering Video

Using SmartArt and Tables

  • Working with Tables, Table Formatting
  • Table Styles
  • Alignment option
  • Merge and split option
  • Converting text to smart art

Animation and Slide Transition

  • Default Animation, Custom Animation
  • Modify a Default or Custom Animation
  • Reorder Animation Using Transitions
  • Apply a Slide Transition, Modifying a
  • Transition, Advancing to the Next Slide

Using slide master

  • Using slide master
  • Inserting layout option
  • Creating custom layout
  • Inserting place holders
  • Formatting place holders

Slide show option

  • Start slide show
  • Start show from the current slide
  • Rehearse timing
  • Creating a custom slide show

 Proofing and Printing

  • Check Spelling as You Type
  • Setting AutoCorrect Options
  • Save as Video
  • Save as JPEG files
  • Save as PowerPoint Show file
  • Print Preview, Print

Introduction to Accounting

Key Accounting Terminologies | Understanding Accounting: Event and Transaction | Bookkeeping vs. Accounting | Role of Stakeholders in Business | Important Business Terminologies

Types of Business Entities

Sole Proprietorship | Partnership | Company | Formalities and Procedures for Establishing Each Entity

Accounting Principles and Concepts

Capital and Revenue Transactions | Generally Accepted Accounting Principles (GAAP) | Capital and Revenue Expenditure | Deferred Revenue Expenditure | Capital and Revenue Receipt | Accounting Concepts and Conventions | Double Entry System of Bookkeeping

Classification and Rules of Accounts

Account Definition | Classification of Accounts: Assets, Liabilities, Equity, Revenue, and Expenses | Debit and Credit: Traditional and Modern Rules

Journal and Ledger

Understanding the Journal: Purpose and Preparation | Ledger: Posting and Balancing | Trial Balance: Purpose and Preparation

Cash Book and its Types

Types of Cash Books: Simple, Two-column, Three-column | Understanding Discounts in Cash Book | Day Book Preparation Using Google Sheets

Depreciation and Its Impact

Definition of Depreciation and Its Causes | The Necessity of Charging Depreciation | Factors Considered for Depreciation Calculation | Methods of Depreciation (Straight-line, Diminishing Balance, etc.) | Provisions and Reserves

Trial Balance Preparation

Importance of Trial Balance | Steps for Preparing a Trial Balance

Trading and Profit & Loss Account

Trading Account: Definition and Preparation | Profit and Loss Account: Definition and Preparation

Year-End Adjustments

Adjustments in Final Accounts | Handling Prepaid and Outstanding Expenses | Treatment of Depreciation, Provisions, and Reserves

Balance Sheet Preparation

Structure and Format of a Balance Sheet | Preparation of Financial Statements Using Excel

Accounting Documents

Key Accounting Documents and Vouchers | Purpose of Accounting Documents | Filing and Storing Documents: Best Practices

Industrial-Oriented Journal Entry Practice

Practical Journal Entry Practice Using JET Simulation

Level 1

Introduction to Tally Prime & Company Management:

Overview of Tally Prime Features | Company Creation, Alteration, and Deletion | Selecting and Configuring Companies | Company Features and Configuration

Accounting Masters:

Ledger Management: Creation, Alteration, Display, and Deletion | Navigation and Shortcuts | Introduction to Chart of Accounts | Group Management: Single and Multiple Creation, Alteration, and Deletion

Inventory Management

Inventory Master Setup: Groups, Categories, Units, Stock Items, and Locations | Stock Summary and Reports | Godown Transfer and Stock Allocation | Inventory Ageing Analysis

Accounting Vouchers

Voucher Types: Contra, Receipt, Payment, Journal, Sales, Purchase, Debit Note, Credit Note | Voucher Management: Creation, Alteration, and Deletion | Bill-wise Allocation for Sundry Debtors and Creditors

Banking Features

Bank Reconciliation | Deposit Slip Printing and Payment Advice | Bank Payments and Cheque Numbering

Management Information System (MIS)

MIS Reports: Receivables, Payables, Ratio Analysis, Cash Flow, Stock, and Exceptional Reports | AI-Powered Analysis: Insights, Summaries, and Visualization

Level 2

Data Security and Backup
Security Controls: Activation, User Management, and Tally Vault | Backup and Restore Procedures

Advanced Features in Tally
Credit Limits and Zero-Value Vouchers | Sales Invoice Customization: Logos, Banking Details, and Voucher Classes | Batch Management: Creation, Expiry Dates, and Reports | Price List Creation and Management

Order Processing
Purchase Orders: Quotations, Receipts, Rejections, and Reports | Sales Orders: Delivery Notes, Rejections, and Outstanding Reports

Cost and Budget Management
Cost Centres and Categories | Budget Creation and Variance Reports | Sales Invoice Numbering

Interest Calculations
Interest Calculations for Debtors, Creditors, and Bank Loans

Manufacturing in Tally
Bill of Materials (BOM) | Standard Pricing and Manufacturing Voucher Management

Multi-Currency Transactions
Forex Conversions | Reports and Non-Accounting Vouchers

Level 3

GST in Tally Prime
GST Overview: CGST, SGST, IGST, UTGST | Activation and Master Setup | GST Reporting: Inward/Outward Supply and Interstate Transactions | GST Entries for Purchases, Sales, Services, and Fixed Assets

Advanced Excel

Introduction to Advanced Excel | Excel sheet Creation, edit, save, Folder Creation | Project 1 

Conditional Formatting & Data Validation

Cell reference, Conditional formatting| Data validation| Important functions in Excel, Remove duplicate values, Hyperlink| Filter, Unique, Sort, SortBY, Sequence, Randarray Functions|

Logical & Statistical functions

Logical functions | Sum & Count if functions| Graphics, Print area setup , Camera tool project| Statistical functions, mathematical functions , Date related functions,  Financial Functions| Dsum, subtotal functions, Text functions, Insert object| Data extraction| Averageif& Averageifs.

Advanced Pivot Table

Classic pivot table and chart| Slicers, timelines and calculated fields| Building hierarchies in pivot tables| Advanced Pivot table data analysis

Advanced Formula for Data Analysis

Custom view, Header and footer, Text to column function| Goal seek, Solver, Scenario manager| Lookup| Project| Match and index function, Consolidating data

Advanced Formula for Data Analysis

Sparkline chart, People graph, Data forecast, Import text file| Mail merge, Consolidating data| Form data, Auditing tool, Web data, Speak cell | Macro, Password protection

Data Preparation and Cleaning

Importing data from various sources. | Handling missing values and duplicates. | Using Text-to-Columns and Flash Fill. | Data validation and error checking for quality assurance.|

Date and Time Analysis

Working with DATE, TIME, NETWORKDAYS, and EOMONTH. | Automating rolling date ranges for dynamic reports. | Calculating time differences in hours, minutes, and seconds. | Custom formatting for date and time (e.g., “MMM-YYYY”). | Dynamic date ranges and custom date logic with WEEKNUM, WORKDAY.INTL

Power Query (Get & Transform)

Importing and cleaning data from various sources| Merging and appending queries| Advanced filtering and transforming data

Introduction to Dashboard Design

Understanding the importance of dashboards | Planning a dashboard project| Data visualization best practices| Advanced Charts

GST Essentials & Foundations

Introduction to GST | Advantages of GST | Taxes Subsumed under GST | Components of GST | GST Rates | GST Council

Supply Under GST: Meaning of Supply | Scope of Supply | Composite Supply | Mixed Supply | Schedule 1 and 2 of Supply

Regular Scheme & Procedures for Registration under GST

 Registration under GST | Electronic Ledgers under GST | Issuance of Invoice | Particulars of an Invoice | HSN Code and SAC Code | Bill of Supply and Other Vouchers

Composition Scheme under GST

Eligibility and Non-eligibility for Composition Scheme | Conditions and Restrictions for Composition Levy | Composition Tax Rate | Important Forms | Validity of Composition Levy

Reverse Charge Mechanism

Forward Charge Mechanism | Reverse Charge Mechanism | Section 9(3) of CGST | Supply of Specific Services | Supply by an Unregistered Person

Time of Supply and Value of Supply

Time of Supply of Goods (Forward Charge and Reverse Charge) | Time of Supply of Services (Forward Charge and Reverse Charge) | Value of Supply

Place of Supply of Goods

Supply Involving the Movement of Goods | Goods Delivered at the Direction of a Third Party | Supply Not Involving Movement: Goods Assembled at Site | Goods Supplied on Board a Conveyance | Other Cases of Place of Supply

Input Tax Credit (ITC)

 Introduction to ITC | Availability of ITC | Blocked Credits with Examples | Utilization of ITC | Process of Availing ITC | ITC Set-Off Process | Conditions for Availing ITC | Input Service Distributor (ISD) under GST

E-Way Bill:

 Introduction to E-Way Bill | Goods Exempted from E-Way Bill | Modification, Rejection, and Cancellation of E-Way Bill

Returns Under GST:

Return Forms for Various Registered Dealers | ITC Forms | Due Dates and Purpose of Returns | Annual Return | Late Fees | Interest | Audit under GST | Refund Process | GST E-Invoicing

GST Using Tally Prime:

 Composition Dealer Accounting | Regular Dealer Accounting | GST Reports | JSON File Generation | ITC Adjustment Entries | Blocked Credit Entries | Reverse Charge Mechanism (RCM) Entries | GST on Advance Receipts | GST Tax Payment Entries | Generating and Exporting GST Reports in Various Formats | Accounting for Mixed Supply and Composite Supply | Supply of Exempted/Nil Rated Goods | Supply of Goods to SEZ | Supply of Goods to Another Territory | Reversal of ITC

Projects

GST Registration Using Simulation

Introduction to GST Registration | Importance of Registration | Eligibility Criteria | Documents Required | Types of GST Registration | Step-by-Step Registration Process | Common Errors in Registration | Validation and Approval Process

GST Filing and Challan Generation Using Simulation

Overview of GST Returns | Types of Returns (GSTR-1, GSTR-3B, etc.) | Filing Deadlines | Offline GST Return Preparation | Input Tax Credit (ITC) Reconciliation | Challan Generation Process | Common Errors in Filing | Penalties for Late Filing

Offline GST Filing and Compliance Using Tally Prime

Overview of Tally Prime | Configuring GST in Tally | Recording GST Transactions | Sales and Purchase Entry | Journal Entries for GST | Preparing GST Returns (GSTR-1, GSTR-3B) | Exporting Data for Filing | Practical Challenges in Tally

E-Way Bill Generation and Management Using Simulation

Introduction to E-Way Bills | Importance and Uses | When E-Way Bills are Required | Documents Needed | Steps for Generating E-Way Bills | Modifications and Cancellations | Validity Periods and Exceptions | Monitoring and Compliance

E Way Bill | Introduction| When to issue E Way Bill | Who should generate E Way Bill | Advantages | Disadvantages | Documents or details required to be generated in goods exempted from E Way Bill | Validity of E Way Bill | Blocking and unblocking of E Way bill  | E Way Bill generation online using Tally | Consolidated E Way Bill |  Modification, rejection and cancellation of E Way Bill .

Become a partner

VC Room Technologies

First Floor, Kailas Plaza,
Pattom, Trivandrum- 695004

  • Privacy Policy
  • Terms of use
© 2025 VC Room Technologies. All rights reserved
Website Designed & Developed by Redwet Solutions