Skip to main content
Jay Sudha

Template

Income Tax Planner — Tax Year 2026-27

By Jay Sudha · Last updated September 30, 2026

Tax year 2026-27 is the first under the Income-tax Act, 2025, and the regime choice still has to be made one person at a time. The answer depends on the whole picture — salary and HRA, a home loan, interest and dividends, business income, capital gains taxed at their own rates — and a family often has one person for whom the old regime still pays and another for whom it never will. This planner computes both regimes line by line for up to four people, shows how much extra deduction it would take for the old regime to win, and lays out the advance-tax instalments that follow from the answer.

₹999 on Gumroad · Google Sheets (your own copy) · Filled example · Quick Start Guide (PDF) · Delivered by email — see what’s inside below.

What it does

Inputs has one column per person: profile, salary and allowances, house property, interest, dividends, business income, capital gains, investments and deductions, and tax already deducted or paid. Computation then works out each person’s tax under both regimes, line by line: gross total income, the HRA exemption with the eight-city rule, the standard deduction, deductions under the old regime, tax at slab rates, capital gains at their special rates with the basic-exemption adjustment, the rebate with marginal relief — which does not reach tax on capital gains at special rates — and cess. The Dashboard picks a person and states the better regime, the saving, the balance payable after TDS, TCS and advance tax, and the next instalment. Regime Planner shows, for every person at once, how much room is left in the old-regime baskets and what the old-regime tax would be with ₹25,000, ₹50,000 or ₹1,00,000 more in deductions. Advance Tax lays out the instalments due on 15 June, 15 September, 15 December and 15 March with what has been paid, the shortfall and an interest estimate. Key Dates lists the year’s deadlines; Section Map finds the new section for an old one; Rates & Rules holds every slab, limit and rate with its section and source, editable.

Who it’s for

  • Salaried employees choosing a regime for tax year 2026-27, with their employer or in their return.
  • Families who plan tax together and want each person’s answer side by side.
  • Freelancers and consultants who pay advance tax and need the instalments worked out.

Fields included

Person profileName, age during the year, residential status, city for HRA, employer type, business income and the regime for advance tax.
IncomeSalary and allowances, house property, interest, dividends, business income and capital gains.
Deductions and investmentsOld-regime baskets such as 80C, own NPS contribution and health insurance, and employer NPS.
Taxes paidTDS, TCS and advance tax already paid.
ComputationBoth regimes line by line: exemptions, deductions, slab tax, special-rate gains, rebate with marginal relief and cess.
Regime plannerRoom left in each basket and the old-regime tax with extra deductions, for every person.
Advance taxInstalments for 15 June, 15 September, 15 December and 15 March, paid, shortfall and interest estimate.
Section map and rulesOld-Act to new-Act section finder, and every rate and limit with its source.

How to use it

  1. On Inputs, fill one column per person — profile, income under each head, investments and deductions, and tax already deducted.
  2. Pick a person on the Dashboard to see both regimes, the better one and the saving.
  3. Open Computation to follow the tax line by line and check each figure.
  4. Use Regime Planner to see whether more deductions would change anyone’s answer.
  5. Take the instalments and dates from Advance Tax, and record payments as you make them.

Preview

Tax planner dashboard for tax year 2026-27: new regime tax ₹2,67,410, old regime ₹3,20,169, saving ₹52,759 a year, balance payable ₹74,410 and the next advance-tax instalment
Dashboard in the EXAMPLE file: both regimes for one person, the better option and what to do next.
Regime planner comparing four family members: tax under new and old regimes, the better regime, room left in deductions and old-regime tax with extra deductions
Regime Planner: four people side by side, the room left in each deduction and the what-if rows.

₹999

Get it on Gumroad ↗

Google Sheets (your own copy) · Filled example · Quick Start Guide (PDF) · Delivered by email

Sold by Jay Sudha. Checkout and delivery by Gumroad.

Example workflow

The EXAMPLE file plans a fictional family of four. For the main earner, whose income under the better regime is ₹23,80,000, the old regime would cost ₹3,20,169 and the new one ₹2,67,410, so the new regime saves ₹52,759 a year even after giving up ₹3,24,000 of HRA exemption and ₹2,67,000 of deductions. After TDS the balance payable is ₹74,410, which makes advance tax compulsory, and the next instalment is ₹55,808 by 15 December 2026. The Regime Planner puts all four side by side: the new regime is better for each of them, by ₹44,720 for one and by ₹1,29,979 for another, and the what-if rows show that even ₹1,00,000 of extra deductions would not reverse the answer for anyone in this family.

Get it on Gumroad — ₹999 ↗

Frequently Asked Questions

Reviews

No reviews yet.

Bought this template? Review it

I read every review and publish it here, with the name you give, once I have matched your email to a Gumroad purchase. Your email is never shown. Privacy Policy

Rating