Income Tax Calculator (Excel) — Free Download
Updated June 2026 · VerifiedWhy Use an Excel Tax Calculator?
- Offline access: Works without internet once downloaded.
- Customisable: Add your own columns, notes, or adjust for specific scenarios.
- Side-by-side comparison: Compare old vs new regime tax in one view.
- Audit trail: Keep a personal record of your tax computation for future reference.
- Privacy: Your financial data stays on your computer — no data is uploaded anywhere.
What Does This Excel Calculator Include?
| Feature | Details |
|---|---|
| Tax Year | 2026-27 (as per Income-tax Act, 2025) |
| Regimes Covered | Both Old Regime and New Regime |
| Standard Deduction | ₹75,000 (new regime) / ₹50,000 (old regime) |
| Deductions (Old Regime) | 80C, 80D, 80E, 80G, 80TTA/80TTB, HRA, LTA |
| Rebate u/s 87A | Auto-applied for both regimes |
| Surcharge | All slabs with marginal relief |
| Cess | 4% Health & Education Cess |
| Age Categories | Below 60, Senior (60-80), Super-Senior (80+) |
| Regime Comparison | Side-by-side old vs new regime summary |
| Format | .xlsx (compatible with Excel, Google Sheets, LibreOffice) |
How to Download and Use the Calculator?
- Click the Download button below to get the .xlsx file.
- Open the file in Microsoft Excel, Google Sheets, or LibreOffice Calc.
- Go to the Input sheet and enter your details:
- Gross salary / total income
- Age category
- Deductions (for old regime comparison)
- The Computation sheet will automatically calculate:
- Taxable income under both regimes
- Slab-wise tax breakdown
- Rebate, surcharge, and cess
- Final tax payable under each regime
- Check the Comparison sheet to see which regime saves you more tax.
File: income-tax-calculator-2026-27.xlsx · ~150 KB · No signup required
Which Tax Slabs Are Used in the Calculator?
New Regime Slabs (Default)
| Income Slab | Tax Rate |
|---|---|
| Up to ₹4,00,000 | Nil |
| ₹4,00,001 – ₹8,00,000 | 5% |
| ₹8,00,001 – ₹12,00,000 | 10% |
| ₹12,00,001 – ₹16,00,000 | 15% |
| ₹16,00,001 – ₹20,00,000 | 20% |
| ₹20,00,001 – ₹24,00,000 | 25% |
| Above ₹24,00,000 | 30% |
Old Regime Slabs
| Income Slab | Below 60 yrs | 60-80 yrs | 80+ yrs |
|---|---|---|---|
| Up to ₹2,50,000 | Nil | Nil | Nil |
| ₹2,50,001 – ₹3,00,000 | 5% | Nil | Nil |
| ₹3,00,001 – ₹5,00,000 | 5% | 5% | Nil |
| ₹5,00,001 – ₹10,00,000 | 20% | 20% | 20% |
| Above ₹10,00,000 | 30% | 30% | 30% |
Changelog
| Version | Date | Changes |
|---|---|---|
| v1.0 | June 2026 | Initial release for Tax Year 2026-27 under Income-tax Act, 2025. Both regimes, rebate, surcharge with marginal relief, cess. |
Frequently Asked Questions
Is this Excel calculator free to download?
Yes, the Excel income tax calculator is completely free. No signup, email, or payment is required. Simply click the download button and start using it.
Does the calculator work with Google Sheets?
Yes. The .xlsx file is fully compatible with Google Sheets. Upload it to your Google Drive and open with Google Sheets. All formulas and formatting will work correctly.
Does the calculator cover both old and new tax regimes?
Yes. The calculator computes tax under both the old regime (with full deductions) and the new regime (default under Income-tax Act, 2025). It also provides a side-by-side comparison showing which regime results in lower tax.
Is the calculator updated for the Income-tax Act, 2025?
Yes. This calculator reflects the latest slabs, rebate limits, and surcharge rules under the Income-tax Act, 2025 applicable from Tax Year 2026-27. It replaces the earlier version based on the repealed Income-tax Act, 1961.
Can I use this calculator for business income?
This calculator is designed primarily for salaried individuals and those with income from other sources. For business/professional income with presumptive taxation or detailed P&L, consult a CA for accurate computation.