Excel template · HR & payroll

Income Tax on Salary Calculator in Excel – TDS 2026-27 (New vs Old)

Enter annual salary, HRA and rent, deductions and what you have already deducted. The calculator computes income tax for tax year 2026-27 under the new and old regimes side by side, shows which is lower, and works out the TDS to deduct in each remaining month.

For: Employers, payroll accountants and salaried employees planning tax for 2026-27.

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

Preview of the Salary TDS Calculator 2026-27 Excel template with sample data
Main sheet with sample data

At a glance

What it is
Salary TDS Calculator 2026-27 — an Excel workbook for Indian employers, HR and payroll teams
Free edition
3 sheets (Guide, Inputs, Tax Computation) — free download, no sign-up
Pro edition
5 sheets, adds Monthly TDS Plan and Declaration & Proofs — ₹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
Salary, previous employer, other income, rent, deductions, and editable 2026-27 rates and limits
Tax Computation
New and old regime side by side, lower-tax regime, and monthly TDS for the remaining months
Monthly TDS Plan
Actual salary and TDS for paid months, projected months, and the TDS to deduct each month to cover the year's tax
—
Declaration & Proofs
Form 124 (earlier 12BB) tracker of declared vs proved investments and rent, reconciled to the computation
—

Pro edition

Get Salary TDS Calculator 2026-27 – Pro

₹19₹9981% OFF

Everything in the free edition, plus:

  • Monthly TDS Plan — Actual salary and TDS for paid months, projected months, and the TDS to deduct each month to cover the year's tax
  • Declaration & Proofs — Form 124 (earlier 12BB) tracker of declared vs proved investments and rent, reconciled to the computation
  • 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 HR & Payroll Kit has all 9 hr & payroll Pro templates, including this one, for ₹134.

How to use it

  1. 1Download the free file and read the Guide sheet.
  2. 2On Inputs, enter the employee, regime chosen, the month you're working on and TDS already deducted.
  3. 3Enter annual salary components, any previous-employer salary and TDS, and other income declared.
  4. 4For the old regime, enter rent paid, city, and investments and insurance with their limits.
  5. 5Read the comparison and the monthly TDS on Tax Computation; update when proofs come in.

TDS on salary from 1 April 2026

The Income-tax Act, 2025 replaced the 1961 Act from 1 April 2026 and introduced the 'tax year' in place of previous year and assessment year. Salary TDS is now under section 392. The employer estimates the employee's tax for the whole year and deducts it evenly from the salary, adjusting each month as pay or declarations change. Investment declarations are made in Form 124 (earlier Form 12BB), perquisites are reported in Form 123 (earlier 12BA), the annual certificate is Form 130 (earlier Form 16) and the quarterly statement is Form 138 (earlier 24Q).

New regime for 2026-27

The new regime is the default. Income up to ₹4 lakh is tax-free; the rates then rise in ₹4 lakh steps – 5%, 10%, 15%, 20% and 25% – to 30% above ₹24 lakh. The standard deduction is ₹75,000, and the rebate makes income up to ₹12 lakh tax-free, with marginal relief so tax just above ₹12 lakh cannot exceed the income above that level. Most deductions are not available, but the employer's NPS contribution is deductible up to 14% of Basic + DA.

Old regime

In the old regime the basic exemption is ₹2.5 lakh (₹3 lakh for those aged 60–79 and ₹5 lakh from 80), with rates of 5%, 20% and 30%; the rebate covers income up to ₹5 lakh. It allows the standard deduction of ₹50,000, professional tax, HRA exemption, home-loan interest on a self-occupied house up to ₹2 lakh, and deductions such as specified investments up to ₹1.5 lakh (old section 80C), an extra ₹50,000 for own NPS contributions and health insurance premiums.

HRA exemption is the least of HRA received, rent paid minus 10% of Basic, and 50% of Basic in a metro (40% elsewhere). The Income-tax Rules, 2026 list eight metros: Delhi, Mumbai, Kolkata, Chennai, Bengaluru, Hyderabad, Pune and Ahmedabad.

Which regime is better?

It depends on deductions. Someone with modest investments and no rent or home loan usually pays less under the new regime; someone claiming HRA, the full ₹1.5 lakh of investments, NPS and a home loan may still do better in the old regime. The calculator shows both side by side with the saving, but the choice is the employee's to declare.

Monthly TDS

The TDS section takes the tax for the regime chosen, subtracts any TDS by a previous employer and what you have already deducted, and spreads the balance over the months left to March. Deposit it by the 7th of the following month, and by 30 April for March. Surcharge (on income above ₹50 lakh) is calculated, but marginal relief on surcharge is not – check those cases manually.

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

Frequently asked questions

What are the income tax slabs for 2026-27 under the new regime?

Nil up to ₹4 lakh, 5% from ₹4–8 lakh, 10% from ₹8–12 lakh, 15% from ₹12–16 lakh, 20% from ₹16–20 lakh, 25% from ₹20–24 lakh and 30% above ₹24 lakh, plus 4% cess. Income up to ₹12 lakh is tax-free because of the rebate.

What is the standard deduction for 2026-27?

₹75,000 in the new regime and ₹50,000 in the old regime.

Which section covers TDS on salary now?

Section 392 of the Income-tax Act, 2025, from 1 April 2026 (section 192 under the old Act).

Which form replaces Form 16 and Form 12BB?

Form 130 replaces Form 16, and Form 124 replaces Form 12BB for investment declarations, under the Income-tax Rules, 2026.

How is HRA exemption calculated?

The least of HRA received, rent paid minus 10% of Basic + DA, and 50% of Basic + DA in a metro city (40% elsewhere). It is available only in the old regime.

How is monthly TDS worked out?

Estimated tax for the year, less TDS already deducted and any previous-employer TDS, divided by the months left to March.

Does it include surcharge?

Yes, surcharge above ₹50 lakh is calculated, but marginal relief on surcharge is not – check cases near the thresholds manually.

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: Monthly TDS Plan, Declaration & Proofs.

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.