Category: Business

Semester I: Financial Accounting, Advanced Excel & Tally Core (Months 1–6)

Month 1: Computer Fundamentals, Office Productivity & Numeric Speed (Weeks 1–4)

Goal: Build operational fluency in Windows, numeric data-entry speed, digital banking workflows, and official correspondence.

  • Week 1: Computer Fundamentals, Windows 10/11 & Numeric Keypad Mastery

    • Hardware/software basics, file/folder management, ZIP/RAR backups, and 10-key numeric pad touch typing.

  • Week 2: Digital Banking Tools, Cloud Storage & Email Etiquette

    • Safe online banking workflows, Google Drive/Docs/Sheets sharing, PDF merging/splitting, and formal vendor/client emails.

  • Week 3: MS Word — Official Accounting Correspondence & Agreements

    • Formatting quotations, purchase orders, demand letters, letterheads, tables, watermarks, and Mail Merge for bulk notices.

  • Week 4: MS PowerPoint — Financial Presentations & Month-1 Assessment

    • Designing financial review decks, embedding tables/charts, and exporting reports.

    • Month-1 Evaluation: Numeric keypad speed test + formatted official quotation/notice (Word) and 6-slide financial summary (PowerPoint).

Month 2: Advanced MS Excel for Accounting & MIS (Weeks 5–8)

Goal: Master spreadsheet accounting, automated reconciliation, loan/depreciation schedules, and MIS dashboards.

  • Week 5: Spreadsheet Architecture & Core Accounting Formulas

    • Cell referencing (relative, absolute, mixed), formatting, sorting, filtering, SUM, AVERAGE, COUNT, SUBTOTAL, and ROUND.

  • Week 6: Logical, Conditional & Lookup Functions

    • IF, SUMIFS, COUNTIFS, VLOOKUP, XLOOKUP, INDEX-MATCH, and date/text functions for invoice ageing analysis.

  • Week 7: Financial Functions, Pivot Tables & Data Validation

    • Loan/EMI and depreciation formulas (PMT, FV, PV, SLN, DB), Data Validation dropdowns, Conditional Formatting, and Pivot Tables/Charts.

  • Week 8: Automated Accounting Trackers & Month-2 Assessment

    • Building an automated Cash Book, Debtors/Creditors Ageing Report, Employee Payroll Sheet, and Sales MIS Dashboard.

    • Month-2 Evaluation: Timed 60-minute Excel practical test covering SUMIFS, VLOOKUP/XLOOKUP, Pivot Tables, and depreciation/EMI schedules.

Month 3: Principles of Financial Accounting & Manual Bookkeeping (Weeks 9–12)

Goal: Master double-entry accounting logic from journalizing raw transactions to finalizing Trial Balances and Balance Sheets.

  • Week 9: Accounting Concepts, Conventions & Double-Entry System

    • GAAP principles, accounting terminology (capital, drawings, assets, liabilities, revenue, expenses), and Golden Rules of Accounting.

  • Week 10: Journal Entries, Ledger Posting & Account Balancing

    • Passing opening, compound, and adjustment journal entries; posting to Ledger accounts and balancing accounts.

  • Week 11: Cash Book, Subsidiary Books & Bank Reconciliation

    • Single, Double, and Triple-column Cash Books, Petty Cash Book, Purchase/Sales Day Books, and manual Bank Reconciliation Statement (BRS).

  • Week 12: Rectification of Errors, Final Accounts & Month-3 Assessment

    • Preparing Trial Balance, Trading Account, Profit & Loss Account, and Balance Sheet (with closing stock, depreciation, and outstanding/prepaid adjustments).

    • Month-3 Evaluation: Complete manual-to-Excel Final Accounts case study from a 30-transaction business problem.

Month 4: Computerized Accounting — Tally (ERP 9 & TallyPrime) Core (Weeks 13–16)

Goal: Transition manual bookkeeping into computerized accounting with complete voucher, bill-wise, and ledger control.

  • Week 13: Company Setup, Security Control & Configurations

    • Company creation, alteration, Tally Vault password, User Security Control, and F11/F12 feature configurations.

  • Week 14: Chart of Accounts — Groups & Ledgers

    • Primary vs. Sub-Groups, creating/altering Ledgers (Single & Multiple modes), and entering opening balances.

  • Week 15: Day-to-Day Accounting Vouchers

    • Recording Contra (F4), Payment (F5), Receipt (F6), Journal (F7), Sales (F8), Purchase (F9), Debit Note (Ctrl+F9), and Credit Note (Ctrl+F8).

  • Week 16: Bill-Wise Accounting, Interest Calculation & Month-4 Assessment

    • Bill-wise receivable/payable tracking, interest calculation on overdue bills, Day Book scrutiny, and Financial Statement analysis.

    • Month-4 Evaluation: Process 1 month of service & trading vouchers in Tally and verify Trial Balance and Balance Sheet.

Month 5: Inventory Accounting, Order Cycle & Costing in Tally (Weeks 17–20)

Goal: Track multi-godown stock, manage complete purchase/sales order cycles, and allocate departmental costs.

  • Week 17: Inventory Masters, Units & Multi-Godown Setup

    • Stock Groups, Stock Categories, Units of Measure (Simple & Compound), Stock Items, and multiple Godowns/Warehouses.

  • Week 18: Complete Purchase & Sales Order Processing

    • Purchase Order (Alt+F4), Receipt Note (Alt+F9), Rejection Out (Alt+F6), Sales Order (Alt+F5), Delivery Note (Alt+F8), and Rejection In (Ctrl+F6).

  • Week 19: Manufacturing (BoM) & Batch/Expiry Tracking

    • Bill of Materials (BoM) for raw-material-to-finished-goods conversion, Stock Journal (Alt+F7), batch-wise details, and manufacturing/expiry dates.

  • Week 20: Stock Valuation, Cost Centers & Month-5 Assessment

    • Stock valuation methods (FIFO, LIFO, Weighted Average), Price Lists, Cost Categories/Cost Centers, Budgets, and Physical Stock verification (Alt+F10).

    • Month-5 Evaluation: Complete a trading & light-manufacturing inventory case study with Godown, Cost Center, and Stock Summary reports.

Month 6: Banking, Payroll & Semester-I Comprehensive Exam (Weeks 21–24)

Goal: Master bank reconciliation, employee payroll processing, and data backup/year-end closing procedures.

  • Week 21: Banking Operations & Automated Bank Reconciliation (BRS)

    • Cheque range management, cheque printing, deposit slips, payment advice, and automated/manual Bank Reconciliation Statement (BRS).

  • Week 22: Payroll Accounting & Statutory Deductions

    • Employee Groups/Masters, Attendance/Production types, Pay Heads (Basic, DA, HRA, Conveyance, PF, ESI, PT), and monthly salary voucher processing.

  • Week 23: Data Security & Year-End Financial Splitting

    • Data Backup, Restore, Split Company Data for new financial years, and exporting reports to Excel/PDF.

  • Week 24: Semester-I Comprehensive Examination

    • Semester-I Practical & Theory Exam: Combined assessment covering Advanced Excel, Financial Accounting principles, and Core Tally accounting/inventory.

Semester II: Taxation (GST & Income Tax), Cost Accounting & Auditing (Months 7–12)

Month 7: Goods & Services Tax (GST) — Law & Tally Implementation (Weeks 25–28)

Goal: Configure GST in Tally and pass accurate intrastate, interstate, reverse-charge, and export/import tax entries.

  • Week 25: GST Framework, Registration & Place of Supply Rules

    • CGST, SGST, IGST, UTGST, Regular vs. Composition dealers, GSTIN structure, Place of Supply rules, and HSN/SAC classification.

  • Week 26: GST Configuration & Intrastate / Interstate Invoicing

    • Activating GST in Tally, configuring tax ledgers, and recording intrastate & interstate B2B/B2C tax invoices.

  • Week 27: Reverse Charge Mechanism (RCM), Advances & Adjustments

    • Passing Reverse Charge Mechanism (RCM) entries (GTA/freight, legal fees), advance receipts, and GST Credit/Debit notes.

  • Week 28: E-Way Bill, E-Invoicing & Month-7 Assessment

    • E-Way Bill threshold rules, generating JSON for E-Way Bill/E-Invoicing, and GST tax payment entries.

    • Month-7 Evaluation: Configure GST for a multi-state trading firm and record 25 mixed B2B, B2C, RCM, and Credit Note transactions.

Month 8: GST Return Preparation & ITC Reconciliation (Weeks 29–32)

Goal: Prepare, reconcile, and simulate filing monthly/quarterly GST returns accurately.

  • Week 29: Outward Supplies Return — GSTR-1

    • Reviewing B2B, B2CL, B2CS, HSN summary, and document summary in Tally; resolving incomplete/mismatch errors and exporting GSTR-1 JSON.

  • Week 30: Input Tax Credit (ITC) & GSTR-2A / GSTR-2B Reconciliation

    • Eligible vs. blocked ITC (Section 17(5)), reconciling purchase registers with GSTR-2B in Excel/Tally, and handling supplier mismatches.

  • Week 31: Monthly Summary Return — GSTR-3B & Tax Set-Off

    • Preparing GSTR-3B, ITC utilization hierarchy (IGST → CGST/SGST), Electronic Cash/Credit Ledger, and late fee/interest calculation.

  • Week 32: Annual Return (GSTR-9) Overview & Month-8 Assessment

    • Understanding GSTR-9 annual summary structure and the statutory GST compliance calendar.

    • Month-8 Evaluation: Reconcile a sample purchase dataset against GSTR-2B and compute net GST payable for GSTR-3B.

Month 9: Direct Taxation — Income Tax, TDS & TCS Compliance (Weeks 33–36)

Goal: Compute individual/business income tax, deduct/deposit TDS/TCS, and manage statutory challans.

  • Week 33: Income Tax Basics & Five Heads of Income

    • Financial Year vs. Assessment Year, residential status, and computation rules under Salary, House Property, Business/Profession (PGBP), Capital Gains, and Other Sources.

  • Week 34: Tax Deductions & ITR Preparation Basics

    • Chapter VI-A deductions (80C, 80D, 80CCD, 80G), Old vs. New Tax Regime comparison in Excel, and overview of ITR-1, ITR-2, ITR-3, and ITR-4.

  • Week 35: Tax Deducted at Source (TDS) in Tally

    • Key TDS sections (192, 194A, 194C, 194H, 194I, 194J), PAN vs. Non-PAN rates, configuring TDS Nature of Payments in Tally, and passing TDS deduction/Challan 281 payment entries.

  • Week 36: Tax Collected at Source (TCS) & Month-9 Assessment

    • TCS applicability (scrap, motor vehicles, sale of goods 206C(1H)), configuring TCS in Tally, and overview of Form 24Q/26Q/27EQ.

    • Month-9 Evaluation: Compute personal income tax in Excel + process contractor, rent, and professional bills with TDS in Tally.

Month 10: Cost & Management Accounting + Secondary Software (Weeks 37–40)

Goal: Analyze business profitability, cost structures, and cash flows while gaining secondary accounting software versatility.

  • Week 37: Cost Sheet Preparation & Break-Even Analysis

    • Direct vs. indirect costs, factory/office/selling overheads, preparing Cost Sheets, and Break-Even (CVP) analysis in Excel.

  • Week 38: Financial Ratio Analysis & Budgeting

    • Computing and interpreting Liquidity (Current/Quick), Profitability (GP/NP), Solvency (Debt-Equity), and Turnover ratios in Tally and Excel.

  • Week 39: Cash Flow & Fund Flow Statements

    • Operating, Investing, and Financing activities (AS-3 Cash Flow Statement) and working capital analysis.

  • Week 40: Secondary Accounting Software (BUSY / Marg ERP) & Month-10 Assessment

    • Company creation, GST billing, barcode/batch inventory, and GST report generation in BUSY Accounting Software.

    • Month-10 Evaluation: Prepare a Cost Sheet, Ratio Analysis report in Excel, and process a 1-week GST billing cycle in BUSY.

Month 11: Auditing, Finalization of Accounts & Career Readiness (Weeks 41–44)

Goal: Develop book-scrutiny and audit-readiness skills while preparing for corporate accounting interviews.

  • Week 41: Vouching, Verification & Ledger Scrutiny

    • Internal vs. Statutory Audit basics, vouching cash/bank/purchase entries, clearing Suspense Accounts, and checking negative cash/stock balances.

  • Week 42: Year-End Closing Entries & Audit Working Papers

    • Preparing depreciation schedules, accrued/prepaid adjustments, bad-debt provisions, and tax provisioning for Balance Sheet finalization.

  • Week 43: Statutory Compliance & Professional Communication

    • Udyam (MSME) registration basics, EPF/ESIC portal overview, and professional communication with statutory auditors, bankers, and tax consultants.

  • Week 44: Accountant Resume & Mock Technical Interviews

    • Drafting an accounting-focused resume, solving real-world accounting interview tests, and mock HR/Accounts Manager interviews.

    • Month-11 Evaluation: Audit a pre-built Tally company file containing 15 deliberate accounting/GST errors, rectify them, and submit an Audit Report.

Month 12: Final Capstone Project & Diploma Certification (Weeks 45–48)

Goal: Execute an end-to-end financial quarter as an independent accountant and earn final diploma certification.

  • Weeks 45–47: End-to-End Accounting Capstone Project

    • Students manage the complete books of a simulated trading & manufacturing firm for one full financial quarter—processing raw purchase/sales invoices, bank statements (BRS), employee payroll, TDS deductions, GST reconciliations (GSTR-1, GSTR-2B, GSTR-3B), Ratio Analysis, and Final Balance Sheet with Excel MIS reports.

  • Week 48: Final Diploma Examination & Viva Voce

    • Final Certification Exam: Comprehensive practical lab exam (Semester I & II), capstone project defense, and viva voce for final Diploma in Accounting certification.

Top