Course Syllabus
📘 MODULE 1: Fundamentals of Accounting
Objective: learn basic accounting concepts and manual accounting skills
Topics:
- Introduction to Accounting
- Need & Importance of Accounting in Business
- Accounting Terminologies (Assets, Liabilities, Capital, Income, Expense)
- Types of Accounts – Personal, Real, Nominal
- Golden Rules of Debit & Credit
- Journal Entry Preparation
- Ledger Posting & Balancing
- Trial Balance
- Cash Book, Petty Cash Book
- Bank Reconciliation Statement (BRS)
- Final Accounts – Trading, P&L, Balance Sheet
- Depreciation Methods (SLM, WDV)
- Rectification of Errors
Practical Project:
Manual accounting for a small business (Purchase → Sale → Final Accounts)
📗 MODULE 2: Tally Prime Essentials
Objective: Learn tally Prime environment and accounting basics
Topics:
- Introduction to Tally Prime Interface
- Company Creation, Backup, Restore, Split
- Configuring Accounting & Inventory Features
- Ledger & Group Creation (Capital, Sales, Purchase, Expense)
- Voucher Entry: Payment, Receipt, Contra, Journal, Sales, Purchase
- Trial Balance, P&L, Balance Sheet in Tally
- Display Menu & Reports
- Day Book, Cash Book, Bank Book
- Voucher Customization & Narrations
- Backup, Restore & Password Protection
Practical Project:
Creating a company and recording daily transactions
📙 MODULE 3: Inventory Management in Tally
Objective: Learn stock, inventory, and item management
Topics:
- Inventory Configuration & Features
- Stock Groups, Categories, Items, Units
- Stock Valuation Methods (FIFO, LIFO, Average)
- Multiple Godown Creation & Stock Transfer
- Purchase & Sales with Inventory
- Batch-wise & Expiry Date Management
- Bill-wise Details & Outstanding Management
- Cost Centers & Cost Categories
- Job Costing & Job Work in Tally
- Manufacturing Journal & Bill of Material (BOM)
Practical Project:
Inventory setup and manufacturing report generation
📒 MODULE 4: GST & Taxation in Tally Prime
Objective: GST-enabled accounting & taxation compliance
Topics:
- GST Overview – CGST, SGST, IGST Concepts
- Enabling GST in Tally Prime
- Creating GST Masters (Tax Ledgers, HSN Codes)
- GST Purchase & Sales Entries
- Input Tax Credit (ITC) & Output Tax Liability
- Composition Scheme Accounting
- GST Returns: GSTR-1, GSTR-3B Reports
- E-Way Bill & E-Invoice in Tally
- TDS & TCS Configuration & Entries
- GST Adjustment Entries & Reconciliation
Practical Project:
GST accounting for a trading company (with returns)
📕 MODULE 5: Payroll Management in Tally
Objective: Employee management, salary processing & statutory compliance
Topics:
- Payroll Configuration & Features
- Employee Creation & Groups
- Salary Structure, Attendance, & Leave Management
- Computation of Basic, HRA, DA, Bonus, Overtime
- Payroll Voucher Entry
- Payslip Generation & Salary Reports
- PF, ESI, PT Configuration
- Payroll Statutory Reports
- Employee Loan & Advance Management
Practical Project:
Complete payroll system for a medium-sized company
📔 MODULE 6: MIS, Data Analysis & Integration
Objective: Reports, automation, and data management in expertise
Topics:
- MIS Reports: Cash Flow, Fund Flow, Ratio Analysis
- Comparative Statements & Budgeting
- Cost Analysis & Profitability Reports
- Multi-Currency & Multi-Location Accounting
- Export & Import Data (Excel, XML, JSON)
- Tally ODBC Integration with Excel
- Audit Trail & Verification Tools
- Data Backup, Restore & Security Control
- Multi-User Management in Tally
- Data Migration from Older Versions
Practical Project:
MIS Dashboard using Excel Integration
🧮 BONUS MODULE: Excel for Accounting
Objective: Excel professional accounting analysis
Topics:
- Excel Formulas for Accountants (SUMIF, COUNTIF, VLOOKUP, IFERROR)
- Pivot Table for Ledger Analysis
- Bank Reconciliation in Excel
- Excel Dashboard for Profit & Loss Summary
- Linking Excel with Tally via ODBC
💼 FINAL PROJECT:
Prepare a Complete Business Accounting System including –
Company Creation → Inventory → GST Billing → Payroll → MIS Reports → Final Accounts
🏆 LEARNING OUTCOME:
✅ Master Manual + Computerized Accounting
✅ Learn GST, Payroll, and Business Analysis
✅ Hands-on Practice with Real Business Scenarios
✅ Ready for roles like Accountant, Tally Operator, GST Executive, MIS Analyst