Sheet 1 – Director Tax Sheet (main computation)
- Section A: Gross Remuneration — Basic, DA, HRA, Allowances, Sitting Fees, Commission
- Section B: Exemptions u/s 10 — HRA, Conveyance, Medical, LTA
- Section C: Taxable Salary with Standard Deduction u/s 16(ia)
- Section D: Deductions under Chapter VI-A — 80C, 80CCD(1B), 80D, 80G
- Section E: Total Taxable Income
- Section F: Tax Computation with slab reference (Old Regime FY 2024-25)
- Section G: TDS deducted quarter-wise
- Section H: Net Tax Payable / Refundable
Sheet 2 – TDS Challan Tracker Month-wise due dates, challan numbers, BSR codes, and payment tracking for Form 24Q
Sheet 3 – Form 16 Summary Part A (Employer details) + Part B (linked auto-calculations from Sheet 1)
All formulas are live (171 formulas, 0 errors). Blue cells are input fields; black cells are calculated automatically.