Income tax calculation formula in Excel for FY 2025-26 under new regime

Dear Sir/Madam,

Please help/share to get income tax calculation formula in excel for fy 2025-26 under new regime. for TDS deduction on salary.

Regards,

Krishna

Replies (3)
Quick Summary
This discussion provides an Excel formula for calculating income tax under the new regime for the Financial Year 2025-26, specifically for TDS deduction on salary. The shared formula calculates income tax before surcharge and cess. For formulas including surcharge and cess, users are advised to contact the provider directly or use the linked income tax calculator for further assistance.

Attached Excel has the Income tax Formula.

Please note that the formula is Income tax before Surcharge and Cess.

If you need the formula for Surcharge and Cess as well, then please DM me. Further you can refer below link to get Income tax calculated.

https://habco.in/income-tax-calculator/

Attached Excel has the Income tax Formula.

Please note that the formula is Income tax before Surcharge and Cess.

If you need the formula for Surcharge and Cess as well, then please DM me. Further you can refer below link to get Income tax calculated.

https://habco.in/income-tax-calculator/

For FY 2025–26 (AY 2026–27), calculate salary tax under the new regime using the applicable slab rates, then apply the Section 87A rebate (for a resident individual with total income up to ₹12 lakh; maximum rebate ₹60,000), add 4% health and education cess, and divide the annual tax by the remaining salary months for TDS. The rebate is not available against special-rate income, and marginal relief may apply near the ₹12 lakh threshold. Include eligible salary deductions such as the standard deduction—up to ₹75,000 for salaried employees—before applying the slabs.

A basic Excel structure is: `Taxable income = Gross salary – eligible deductions`; `Tax before rebate = slab-wise tax`; `Tax after rebate = MAX(0, tax before rebate – eligible rebate)`; `Annual tax = tax after rebate × 1.04`; `Monthly TDS = (Annual tax – TDS already deducted) ÷ remaining months`. The exact formula depends on salary components, other income and any special-rate income, so verify the relevant FY 2025–26 provisions before finalising the payroll calculation.

Salary-tax working papers are easier to maintain when the slab calculation, rebate and monthly TDS adjustment follow a consistent workflow. Manual Excel work can be difficult to update and reconcile, while automation reduces repetitive tasks and keeps professional judgment in control. At Jir AI we provide 2,000+ AI agents and 650+ integrations to streamline your practice’s day-to-day workload. Message us on WhatsApp to explore how it can help: https://wa.me/message/3HVOZ7HIY4ESC1

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
24 October 2026
CA Industrial Trainee

Fytomax Nutrition Private Limited

Aurangabad

CA Inter

View Details
Company
31 October 2026
Accountants

sankaran and krishnan

New Delhi

B.Com

View Details
Company
12 November 2026
Tax Product Specialist

BharatX.ai

Gurgaon

B.Com

View Details
Company
10 November 2026
FP&A Executive

Gujarat Guardian

Ankleshwar

CA Final

View Details
Company
13 November 2026
Accountant

New Mobile India

Muzaffarpur

B.Com

View Details
Company
30 October 2026
Asst Manager Accounts

Goodwin Pumps India Pvt Ltd

Chengalpattu

CA Inter

View Details
Company
ARTICLESHIP 28 October 2026
Article assistants

Shyam S Gupta and Company

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 14 November 2026
Articleship Assistant

B Thejas and Associates

Bengaluru

CA Foundation

View Details