Sheet 1 — Old Regime Computation
- Assessee details (Name, PAN, DOB, Category)
- Part B: Salary income — Basic, DA, HRA (with exemption), LTA, allowances, perquisites → Standard Deduction → Net Salary
- Part C: House Property — GAV, municipal taxes, NAV, 30% deduction, interest on loan
- Part D: Business / Profession income
- Part E: Capital Gains — STCG (Sec.111A), LTCG (Sec.112A), exemptions u/s 54/54EC
- Part F: Other Sources — savings interest, FD interest, dividends, lottery
- Part G: All Chapter VI-A deductions — 80C, 80CCD(1B), 80D, 80E, 80EEA, 80G, 80TTA, 80TTB etc. with limit reminders
- Part H: Tax computation with slab rates + surcharge + 4% cess
- Part I: Rebates — 87A, 89, TDS credit, advance tax → Net Tax Payable / Refund
Sheet 2 — New Regime Computation
- Streamlined income entry (fewer exemptions), ₹75,000 standard deduction
- New slab rates (Nil up to ₹3L, 5%/10%/15%/20%/30%), 87A rebate up to ₹7L income
- Net Tax Payable under New Regime
Sheet 3 — Regime Comparison
- Side-by-side: GTI, Deductions, Taxable Income, Tax Liability, Effective Rate
- Auto-recommendation formula — tells you which regime saves more tax and by how much
Sheet 4 — TDS & Advance Tax Tracker
- TDS by source (Salary/192, FD/194A, Dividend, Rent, Professional fees, etc.)
- Advance tax installment tracker (Jun / Sep / Dec / Mar due dates)
Sheet 5 — Notes & Instructions
- Color-coding guide, key sections (10(13A), 24(b), 80C–80U, 87A, 234A/B/C)
- New vs Old regime deduction rules, due dates, and document checklist
