Sheet 1 โ Old Tax Regime
| Section | Coverage |
|---|---|
| Employee Details | Name, PAN, AY, Age, Residential Status |
| Gross Salary | Basic, DA, HRA, LTA, Bonus, Perquisites, Allowances |
| Exemptions u/s 10 | HRA (auto-calc with Metro/Non-Metro), LTA, Gratuity, Children Education |
| Deductions u/s 16 | Standard Deduction โน50K, Professional Tax, Entertainment Allowance |
| Chapter VI-A | 80C, 80CCD(1), 80CCD(1B), 80CCD(2), 80D, 80E, 80EEA, 80G, 80TTA |
| Tax Computation | Slab tax by age (Normal/Senior/Super Senior), Rebate 87A, Surcharge, Cess |
| TDS & Net Payable | TDS reconciliation + monthly TDS required |
Sheet 2 โ New Tax Regime (Default) Full computation under new slabs (FY 2024-25), โน75K standard deduction, โน25K rebate at โน7L income threshold.
Sheet 3 โ Regime Comparison Dashboard Side-by-side comparison with an automatic verdict showing which regime saves more tax and by how much, plus a slab reference card and key differences table.
Sheet 4 โ Monthly TDS Schedule 12-month tracker (AprilโMarch) with cumulative TDS, balance tax remaining, and auto-calculated monthly deduction needed.