Salary Tax Calculation Sheet

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, […]

๐Ÿ”„ Published Jul 2026

Trusted by 6,00,000+ CA professionals across India

โฌ‡ Available Downloads

Excel Format (Editable) ๐Ÿ”’

XLSX Pro 23 KB โœ๏ธ Editable

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.

Get Unlimited Access with Pro Membership

Download unlimited formats, get editable files, and access premium CA resources.

  • Unlimited downloads
  • Editable Word / Excel formats
  • Premium CA toolkit access
  • GST / ROC / Audit templates
  • Priority format updates
  • AI drafting tools (coming soon)
โ‚น99
per month
โ‚น1,499
lifetime
๐Ÿ‘‘ Upgrade to Pro

What is Included in This Format?

This format includes a professionally structured template ready for immediate use. Fields are clearly labeled for easy customization.

Disclaimer: This format is provided for general information only. Please review applicable laws and professional requirements before use.