Master GST with our Comprehensive Online GST Practitioner Course

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

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 [Introduction to Excel

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