Excel template · Tax & compliance

Advance Tax Calculator 2026-27 in Excel (New Tax Act)

Enter your expected income for April 2026 to March 2027 – salary, house property, business (actual or presumptive), other income and capital gains – with deductions and TDS. The calculator compares the new and old regimes, tells you whether advance tax applies, works out the four instalments and estimates interest for any shortfall.

For: Business owners, professionals, freelancers, investors and salaried people with other income – and the accountants who estimate tax for them.

Free download · no sign-up · no macros · Excel 2010+, Google Sheets, LibreOffice

Preview of the Advance Tax Calculator 2026-27 Excel template with sample data
Main sheet with sample data

At a glance

What it is
Advance Tax Calculator 2026-27 — an Excel workbook for Indian taxpayers, businesses and tax practitioners
Free edition
3 sheets (Guide, Inputs, Computation) — free download, no sign-up
Pro edition
5 sheets, adds Quarterly Estimate and Challan Log — ₹19 one-time (regular ₹99)
Works in
Microsoft Excel 2010 or later, Google Sheets, LibreOffice Calc — no macros
Checked
Recalculated with zero formula errors; sample data and a Guide sheet included
Made by
Prakash Bagchi, finance professional, PB Lab (Raipur, India)

Free vs Pro: what you get

SheetFreePro
Guide
What it does, how to use it, assumptions and a live status check
Inputs
Age group, regime, income by head, presumptive turnover, capital gains, deductions, TDS and the instalments already paid; rates as editable inputs
Computation
Tax under both regimes side by side with rebate and marginal relief, capital gains at special rates, cess, TDS, the four instalments, shortfalls and interest
Quarterly Estimate
Revise full-year income at each instalment date and see exactly what to pay in that instalment
—
Challan Log
BSR code, date, challan number and amount for every payment, checked against the total paid
—

Pro edition

Get Advance Tax Calculator 2026-27 – Pro

₹19₹9981% OFF

Everything in the free edition, plus:

  • Quarterly Estimate — Revise full-year income at each instalment date and see exactly what to pay in that instalment
  • Challan Log — BSR code, date, challan number and amount for every payment, checked against the total paid
  • One-time payment, instant .xlsx download, free updates
+91

Secure payment by Razorpay · UPI, cards, netbanking & wallets

We use your details only to deliver the file and support your purchase. See our privacy policy and terms.

Need more than one? The Tax & Compliance Kit has all 5 tax & compliance Pro templates, including this one, for ₹74.

How to use it

  1. 1Download the free file and read the Guide sheet.
  2. 2On Inputs, choose your age group and regime and enter the income you expect for the whole year.
  3. 3Enter TDS/TCS from AIS or Form 26AS and any advance tax already paid.
  4. 4On Computation, compare the regimes and see the amount due by each date.
  5. 5Before every due date, update the estimates and pay the shortfall.

Who has to pay advance tax

If your tax for the year, after TDS and TCS, is ₹10,000 or more, you pay it during the year as advance tax rather than at the end. Resident senior citizens (60 or more) with no income from business or profession are exempt. Salaried people usually have enough TDS, but rent, interest, capital gains, consulting fees or a side business can make advance tax due.

Due dates and instalments

Under the Income-tax Act, 2025, which applies from tax year 2026-27, the schedule is unchanged: 15% of the year's tax by 15 June, 45% by 15 September, 75% by 15 December and 100% by 15 March. If you declare business or professional income under the presumptive scheme (old sections 44AD and 44ADA), you can pay the whole amount in one instalment by 15 March. Capital gains or dividends that arise after a due date can be covered in the later instalments without interest for the earlier ones.

How the tax is worked out

The calculator applies the 2026-27 slabs: in the new regime, nil up to ₹4 lakh, then 5% to 30% in ₹4 lakh steps above that, with a ₹75,000 standard deduction on salary and a rebate that makes normal income up to ₹12 lakh tax-free (with marginal relief just above). The old regime uses the ₹2.5 / 3 / 5 lakh exemption limits by age, deductions such as investments and health insurance, and a rebate up to ₹5 lakh.

Capital gains are taxed separately at special rates: 20% on short-term gains from listed shares and equity funds, and 12.5% on long-term gains, with the first ₹1.25 lakh of long-term gains on listed equity exempt. The rebate is not available against these gains. 4% health and education cess is added; surcharge for incomes above ₹50 lakh is not included.

Interest if you pay late or too little

Two kinds of interest apply. For deferment of instalments (old section 234C), you pay 1% a month on the shortfall – for three months for the June, September and December instalments and one month for March. There is no interest if at least 12% is paid by June and 36% by September. For default (old section 234B), if less than 90% of the tax is paid by 31 March, interest of 1% a month runs from April until you pay. The Computation sheet estimates both from the payments you enter.

Free vs Pro

The free edition does the full calculation for both regimes with instalments and interest. The Pro edition adds a quarterly re-estimate, because income rarely turns out as planned in June, and a challan log with BSR codes and serial numbers that you need when filing the return.

Written by Prakash Bagchi, finance professional and founder of PB Lab. Last reviewed .

Frequently asked questions

What are the advance tax due dates for 2026-27?

15 June 2026 (15%), 15 September 2026 (45%), 15 December 2026 (75%) and 15 March 2027 (100%). Presumptive taxpayers can pay the full amount by 15 March 2027.

Who is exempt from advance tax?

Anyone whose tax after TDS/TCS is below ₹10,000, and resident individuals aged 60 or more who have no income from business or profession.

Do salaried employees need to pay advance tax?

Only if they have other income – rent, interest, capital gains or freelance fees – that is not covered by TDS and the balance tax is ₹10,000 or more.

What is the interest for late advance tax?

1% a month on the shortfall in each instalment (old 234C) and 1% a month from April if less than 90% is paid by 31 March (old 234B). The calculator estimates both.

Is the new regime better for me?

The Computation sheet works out the tax under both regimes side by side. The new regime usually wins unless you have large deductions such as a home loan, investments and health insurance.

Does it include capital gains?

Yes – short-term gains on listed equity at 20%, long-term gains at 12.5% with the ₹1.25 lakh exemption on listed equity. For detailed sale-by-sale gains, use the Capital Gains Calculator.

How do I pay advance tax?

Online through the e-Pay Tax service on the income-tax e-filing portal, choosing advance tax for the right tax year. Keep the challan details – the Pro edition logs them.

How much does the Pro edition cost and how do I get it?

The Pro edition is ₹19 (regular price ₹99), a one-time payment through Razorpay by UPI, card, netbanking or wallet. You download the .xlsx file right after paying, and the download page works again later if you bookmark it. Pro adds: Quarterly Estimate, Challan Log.

Related free calculators

More Excel templates

See all templates →

Disclaimer: This template is a working aid, not legal, tax or accounting advice. Sample data is fictional. Laws, rates and thresholds change — verify them against the current Act, rules and notifications, or with a qualified professional, before relying on the results. PB Lab is not responsible for decisions made using this file.