Advanced Income Tax Calculator Excel – AY 2026-27, All Heads
The complete computation workbook for CAs, traders, landlords and investors: salary, house property, business, capital gains and other sources – Old vs New regime side by side for FY 2025-26, with the post-July-2024 capital gains rates, the basic-exemption adjustment, residency switches and every marginal relief computed correctly.
⬇️ Download Excel – FreeNo signup. No email required. Direct download.
What you get
The full CG engine
STCG 111A at 20%, LTCG 112A at 12.5% above the auto Rs 1.25 lakh exemption, other LTCG at 12.5% without indexation – plus the resident lower-of option (12.5% vs 20% indexed) for land or building acquired before 23 July 2024.
Exemption adjustment built in
Unexhausted basic exemption automatically adjusts against capital gains for residents – in a documented order – so low-income CG cases compute correctly in both regimes.
Residency aware
Select Non-Resident and the sheet switches off 87A, the CG exemption adjustment, senior slabs, the indexation option and 80TTB – automatically.
Rebate rules per regime
New regime: 87A against slab tax only, with marginal relief above Rs 12 lakh. Old regime: rebate covers 111A and 112 but never 112A – exactly as the law reads this year.
Surcharge done properly
Band on total income, 15% cap on capital-gains taxes, and marginal relief at every threshold – with the working rows visible.
Casual income isolated
Lottery and online-game winnings taxed flat at 30% with no exemption adjustment and no rebate – kept out of your slabs instead of corrupting them.
Sheet-by-sheet overview
Workbook contents (3 sheets)
- Cover – scope, the capital-gains rate card summary and method notes
- Computation – 7 input blocks (assessee, salary, house property, business, capital gains, other sources, Chapter VI-A) and the full statement of income with both regimes line by line
- Reference – the AY 2026-27 capital-gains rates table, surcharge rules and an honest list of methodology notes
How to use
Work the yellow cells block by block. The statement shows normal income and each special-rate income separately, the exemption adjustments, tax by component, rebate, surcharge with its working, cess and the total – for both regimes – ending in the regime verdict. Formula cells are protected and hidden; every input is open.
Salaried-only computation? The lighter Income Tax Calculator (Salaried) Excel is quicker. Prefer the browser? The online Advanced Calculator mirrors this workbook.
Frequently asked questions
Which capital gains rates does it use?
The post-23-July-2024 rates that apply to the whole of FY 2025-26: 20% on 111A STCG, 12.5% above Rs 1.25 lakh on 112A LTCG (grandfathering intact), and 12.5% without indexation on other LTCG – with the resident option to pay 20% with indexation on land/building acquired before 23 July 2024 where that is lower. The workbook takes both figures and picks the lower tax automatically.
Does the basic exemption adjust against capital gains?
For residents, yes – any exemption left after normal income automatically reduces gains in the order 111A, then 112, then 112A. Non-residents do not get this adjustment, and the sheet enforces that.
Can the 87A rebate wipe out capital gains tax?
In the new regime, no – the Finance Act 2025 restricts the rebate to slab-rate tax. In the old regime the rebate can cover 111A and 112 tax (income up to Rs 5 lakh) but never 112A. The workbook applies each rule.
How is business income handled?
Enter your net taxable business or professional income (regular books or presumptive 44AD/44ADA figure). The workbook taxes it at slab within the chosen regime – it does not compute books or presumptive eligibility; pair it with the Tax Audit Applicability Calculator for that.
Is this the same as the salaried Excel?
This is the superset – all five heads with the CG engine and residency switches. If you only have salary, house property and deductions, the salaried workbook is simpler and has more granular Section 10 blocks.
Will it be updated?
Yes – subscribe in the optional popup on download and every new version is emailed automatically.