Course Syllabus
🟦 Module 3: GST (Goods & Services Tax) – Complete Practical Training
- Introduction to GST
- GST Structure & Principles
- GST Registration Process
- HSN & SAC Codes
- Input Tax Credit (ITC)
- GST Adjustments
- Creating GST Masters in Tally
- GST Sales/Purchase Entry
- GST Reports
- GSTR-1, GSTR-3B Filing (Practical)
🟦 Module 4: Inventory Accounting
- Stock Creation
- FIFO, LIFO
- Stock Valuation
- Batch & Expiry
- Multiple Godown Handling
- Item-wise Profit Analysis
- Inventory Reports
🟦 Module 5: Payroll Management
- Employee Data
- Attendance & Overtime
- Salary Structure
- PF/ESI
- Payroll Entries
- Payroll Reports
🟦 Module 6: Banking & Taxation Work
- TDS (Basics + Practical)
- TCS
- PAN, TAN Overview
- Online Banking
- UPI, NEFT, RTGS
- Cheque Book Handling
- Cash Deposit/Withdrawal Records
🟦 Module 7: Microsoft Excel – Accounting & MIS Reporting
- Excel Basics to Advanced
- Formulas (SUMIF, COUNTIF, VLOOKUP)
- Pivot Table & Pivot Charts
- MIS Analysis
- Financial Reports
- Excel Validation
- Invoice Format
- GST Billing in Excel
🟦 Module 8: Business Accounting Tools
- PDF Editing (Tax Docs)
- Emailing Reports
- Scanning/Printing
- Maintaining Office Accounts
- Preparing Balance Sheet
- Preparing Profit/Loss Statement
🟦 Module 9: Practical Office Work Training
- Real Business Transactions Practice
- Invoice Management
- Vendor Management
- Online Form Filing
- Data Entry Accuracy
- Office Documentation Skills
🟦 Module 10: Final Projects (Compulsory)
✔ GST Billing Project
✔ Complete Company Accounting Project
✔ Excel MIS Dashboard Project
✔ Final Tally Company Setup & Reports
✔ Office Accounting Practice