Automation Expert
10728 Points
Posted on 13 November 2026
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