Does it cover both the old and new regime?

Yes — the computation sheet shows old and new regime side by side and flags the lower-tax regime. Under the new regime only the standard deduction (Rs 75,000) and employer NPS under 80CCD(2) apply.

Are the deduction caps applied?

Yes — 80C is capped at Rs 1,50,000, 80CCD(1B) at Rs 50,000 and home-loan interest under Section 24 at Rs 2,00,000 automatically in the computation.

Home › Downloads › Salary TDS Investment-Proof Kit

Salary TDS Investment-Proof Kit (Excel)

Q: What does the salary TDS kit do?

It helps an employer collect and verify employees' investment proofs (the Form 12BB items) and then compute each employee's salary TDS under the old vs new regime for FY 2026-27, including the standard deduction, Chapter VI-A caps, the 87A rebate, cess and the monthly TDS.

Format

Excel (.xlsx)

Updated

FY 2026-27

Cost

Free

In short

For employers: collect and verify employees’ investment proofs, then compute each employee’s salary TDS under the old vs new regime for FY 2026-27 — so the year-end (Q4) deduction is right and nobody is over- or under-deducted.

⬇ Download Excel (.xlsx)

Who it's for

Employers and payroll teams finalising salary TDS
CA firms handling 24Q / Form 138 for clients
Anyone reconciling Form 12BB declarations against actual proofs

What's inside

A Proof Tracker — one row per employee: declared vs verified amounts, auto shortfall and a status (Complete / Pending proofs / Short proof)
A TDS Computation sheet — old vs new regime side by side for FY 2026-27
Standard deduction (₹50,000 old / ₹75,000 new), Chapter VI-A with caps applied (80C ₹1.5L, 80CCD(1B) ₹50k, Section 24 ₹2L)
Slab tax, the 87A rebate (nil tax to ₹5L old / ₹12L new), 4% cess, annual and monthly TDS
A lower-tax-regime recommendation
Input cells open; formula cells locked & password-protected

How to use it

On the Proof Tracker, log each employee’s declared and verified amounts — the status updates as proofs come in
On the Computation sheet, enter one employee’s salary and verified deductions
Read the old vs new comparison, the recommended regime and the monthly TDS
Use the figure to finalise the Q4 salary deduction

FAQs

What does it do?
Collects/verifies proofs and computes salary TDS old vs new for FY 2026-27.

Both regimes?
Yes — side by side, with the lower-tax regime flagged.

Caps applied?
Yes — 80C ₹1.5L, 80CCD(1B) ₹50k, Section 24 ₹2L automatically.

Free · verified 30 June 2026 against the Income-tax Act 2025 / FA 2025. General information, not professional advice; verify each computation before deducting.