:E-Accounting Course – Syllabus

MODULE-1(ADVANCE EXCEL)

1. Excel Basics

• Excel Interface
• Workbook/Worksheet
• Rows, Columns, Cells
• Basic Formatting
• Number Formatting (Date, Currency, %, etc.)
• Basic Formulas:
• SUM, AVERAGE, MIN, MAX
• COUNT, COUNTA
• Percentage formulas

2. Data Handling Tools

• AutoFill & Flash Fill
• Sorting (Single & Multi-Level)
• Filtering (Auto, Custom)
• Remove Duplicates
• Text to Columns
• Data Cleaning Techniques
• TRIM, PROPER, UPPER, LOWER

3. Intermediate Formulas

• IF, AND, OR, NOT
• Text Functions: LEFT, RIGHT, MID, LEN, CONCAT
• Date Functions: TODAY, NOW, DATEDIF, MONTH, YEAR
• Lookup Functions:
• VLOOKUP
• HLOOKUP
• XLOOKUP (if needed)

4. Advanced Excel

• INDEX + MATCH
• Nested IF
• SUMIF, SUMIFS
• COUNTIF, COUNTIFS
• FILTER, UNIQUE, SORT
• INDIRECT
• Error Handling Functions:
• IFERROR, ISBLANK, ISNUMBER

5. Data Analysis Tools

• Pivot Table
• Pivot Chart
• Grouping
• Slicers
• Data Consolidation
• What-If Analysis
• Goal Seek
• Scenario Manager

6. Charts & Dashboards

• Column, Line, Pie Charts
• Combo Charts
• Trendlines
• Sparklines
• KPI Charts
• Creating Professional Dashboards

7. Data Validation & Protection

• Drop-down lists
• Restrict data entries
• Protect Sheet
• Protect Workbook
• Lock & unlock cells

8. Reporting & MIS

• Sales Report
• Purchase Report
• Attendance Sheet
• Stock & Inventory Sheet
• Expense & Profit Sheet
• Bank Reconciliation Format
• Automated Business Templates

9. Productivity & Automation (Non-Macro)

• Keyboard Shortcuts
• Dynamic Ranges
• Template Creation
• Time-saving techniques

10. Practical Projects

• Full MIS Project
• Dashboard Creation
• Lookup-based project
• Data cleaning & analysis project
• Monthly Report preparation project

MODULE-2(TALLY WITH GST)

Introduction to E-Accounting

• What is E-Accounting
• Difference between Manual & Digital Accounting
• Accounting terminologies (Debit, Credit, Ledger, Voucher, Trial Balance)
• Accounting cycle overview

1. Introduction to Tally Prime

• What is Tally Prime
• Features of Tally
• Tally interface & navigation
• Company creation, alteration, deletion
• Data backup & restore

2. Basic Accounting Concepts

• Accounting terms (Assets, Liabilities, Income, Expense)
• Debit & Credit rules
• Accounting cycle
• Double entry system

3. Masters in Tally

A. Accounts Masters

• Ledger creation
• Groups & classifications
• Creating sundry debtors/creditors

B. Inventory Masters

• Stock groups
• Stock items
• Units of measure
• Godown creation

4. Voucher Entries (Accounting)

• Contra
• Payment
• Receipt
• Journal
• Sales
• Purchase
• Debit Note
• Credit Note

5. Inventory Management

• Stock entry
• Purchase & sales with inventory
• Item-wise, group-wise reports
• Godown / warehouse management
• Batch-wise inventory

6. GST (Goods & Services Tax)

GST Basics

• CGST, SGST, IGST
• Input & Output GST
• HSN & SAC codes
• GST slab setup

GST in Tally

• Enabling GST in Tally
• GST ledger creation
• GST invoice creation
• Auto GST calculations
• GST adjustment entries
• GST reports
• E-way bill basics

7. Banking

• Bank ledger
• Bank reconciliation (BRS)
• Cheque printing & management
• Payment/Receipt through bank

8. TDS Module (Optional)

• TDS basics
• TDS ledger creation
• TDS deduction entries
• TDS reporting

9. Payroll Module (Optional)

• Employee creation
• Attendance setup
• Salary structure
• Salary slip generation

10. Financial Reports

• Trial Balance
• Profit & Loss Account
• Balance Sheet
• Cash/Bank Book
• Outstanding Reports
• Ratio Analysis

11. GST Return Preparation

• GSTR-1
• GSTR-3B
• GSTR-2A checking
• Exporting data for GST portal

12. Advanced Features

• Cost Centers & Cost Categories
• Budget & Controls
• Interest Calculations
• User Roles & Security
• Data Audit

13. Practical Projects

• Complete company setup
• Daily accounting entries
• GST billing project
• Inventory & stock project
• GST return project
• Final financial statements preparation

MODULE-3 BUSY Accounting

1. Introduction to BUSY Software

• What is BUSY Accounting Software
• Features & Advantages
• BUSY Interface & Navigation
• Types of BUSY Editions (Basic/Standard/Enterprise)

2. Company Setup

• Create Company
• Modify / Delete Company
• Password & Security Setup
• Backup & Restore Company Data

3. Masters Creation

a) Account Masters

• Ledger creation (Sundry Debtors, Creditors, Expenses, Income)
• Group creation & modification

b) Inventory Masters

• Item Master
• Item Groups
• Unit Masters
• Godown / Warehouse Setup

4. Voucher Entries

Accounting Vouchers

• Sales
• Purchase
• Receipt
• Payment
• Journal
• Contra
• Debit/Credit Notes

Inventory Vouchers

• Material In / Out
• Stock Transfer
• Production & Manufacturing (if enabled)

5. GST in BUSY

• GST Configuration
• Creating GST Ledgers
• GST Invoice generation
• Auto GST calculations
• HSN & SAC code setup
• Input & Output GST Management
• GST Reports (Summary & Detailed)

6. Inventory Management

• Stock maintenance
• Stock Valuation Methods
• Batch-wise & Lot-wise inventory
• Item-wise & Group-wise reports
• Reorder Level setup
• Production Planning (optional module)

7. Banking

• Bank Master
• Bank Book
• Bank Reconciliation (BRS)
• Cheque Management

8. Financial Statements

• Trial Balance
• Profit & Loss Account
• Trading Account
• Balance Sheet
• Cash Book & Day Book
• Debtors/Creditors Outstanding Reports

9. GST Return Preparation

• GSTR-1
• GSTR-2A
• GSTR-3B
• Exporting data for online portal
• Error checking & report corrections

10. Advanced Features

• Budgeting
• Price Lists
• Discount Setup
• User Rights & Permissions
• Data Audit Feature
• Multi-currency (if required)
• Multi-branch accounting

11. BUSY Utilities

• Data backup & restore
• Data export to Excel/PDF
• Emailing bills directly from BUSY
• Barcode label printing (optional)

12. Practical Projects

• Full company setup
• GST-based transactions
• Inventory + accounts entry project
• GST return project
• Final financial reports preparation