Excel template · Tax & compliance

TDS Calculation & Tracker in Excel (Income-tax Act, 2025)

Record each payment to contractors, professionals, landlords, agents, lenders and suppliers. The tracker picks the section 393 rate (with the old 1961 section alongside), checks single and annual thresholds, applies the no-PAN rate, and shows the deposit due date, interest on late deposit and quarter-wise totals.

For: Accountants and small businesses that deduct TDS on resident, non-salary payments.

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

Preview of the TDS Tracker (Income-tax Act, 2025) Excel template with sample data
Main sheet with sample data

At a glance

What it is
TDS Tracker (Income-tax Act, 2025) — an Excel workbook for Indian taxpayers, businesses and tax practitioners
Free edition
5 sheets (Guide, Section Master, Deductees, Register, Summary) — free download, no sign-up
Pro edition
7 sheets, adds Deductee Statement and 26AS-AIS Recon — ₹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
Section Master
TDS codes under section 393 with the old section, rates and thresholds — editable
Deductees
Payees with PAN; payee type read from the PAN's 4th character
Register
Payment-wise TDS with threshold catch-up, no-PAN rate, due date and interest
Summary
TDS by section and quarter, deposits, pending, overdue and checks
Deductee Statement
Payee-wise statement of every payment, TDS and deposit — handy for certificates and payee queries
—
26AS-AIS Recon
Match TDS credits reported against your TAN with your register
—

Pro edition

Get TDS Tracker (Income-tax Act, 2025) – Pro

₹19₹9981% OFF

Everything in the free edition, plus:

  • Deductee Statement — Payee-wise statement of every payment, TDS and deposit — handy for certificates and payee queries
  • 26AS-AIS Recon — Match TDS credits reported against your TAN with your register
  • 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. 2Review the Section Master — rates and thresholds are inputs, so you can update them if the law changes.
  3. 3Add every payee with PAN on the Deductees sheet.
  4. 4Enter the deductor, TAN, financial year, report date and interest rate at the top of Summary.
  5. 5Record each payment in date order on the Register (date, payee, code, bill number, amount excluding GST). Add the challan and deposit date once you pay.

TDS under the Income-tax Act, 2025

From 1 April 2026 the Income-tax Act, 2025 replaces the 1961 Act. TDS provisions that were spread across sections 192 to 196 are now consolidated in section 393, organised as tables. For example, payments to contractors (old 194C) are at Table serial 6(i), professional fees (old 194J(b)) and technical fees (old 194J(a)) at 6(iii), commission or brokerage (old 194H) at 1(ii), rent (old 194-I) at 2(ii), interest other than on securities (old 194A) at 5(iii), and purchase of goods (old 194Q) at 8(ii).

Because most people still think in the old section numbers, the tracker shows the new reference and the old section side by side for every entry.

Thresholds and the catch-up rule

Several sections have both a single-payment and an annual limit. For contractors, TDS applies when a single payment exceeds ₹30,000 or the total for the year exceeds ₹1,00,000. When the annual limit is crossed, TDS is due on the whole amount paid during the year — including earlier bills on which nothing was deducted. The register keeps a running year-to-date total for each payee and section and applies this catch-up automatically on the bill that crosses the limit.

Other common thresholds in the Section Master include ₹50,000 for professional or technical fees, ₹20,000 for commission, ₹50,000 per month for rent, ₹10,000 for interest from non-bank payers and ₹50 lakh for purchase of goods. They are editable inputs, so check them against the law before you rely on them.

No PAN, higher rate

If the payee has not furnished a PAN, section 397(2) requires deduction at the higher of the normal rate or 20% (5% for purchase of goods). The Deductees sheet checks the PAN format and reads the payee type from its fourth character — P for an individual, H for an HUF, anything else is treated as 'others' — so the right rate is picked without manual selection.

Due dates, interest and returns

Tax deducted by a non-government deductor is deposited by the 7th of the following month; for deductions in March the due date is 30 April. Interest under section 398 is 1% per month or part of a month from the date tax was deductible to the date it was actually deducted, and 1.5% per month or part from the date of deduction to the date of deposit. The register works out the due date and interest for each line.

Quarterly statements have new numbers too: Form 140 replaces Form 26Q for resident non-salary TDS, Form 138 replaces 24Q for salary, Form 144 replaces 27Q for non-residents, and Form 131 replaces Form 16A as the deductee's certificate. The register tags every entry with its quarter so filing is easier.

What the tracker doesn't cover

It is built for resident, non-salary payments. Salary TDS, payments to non-residents, lower-deduction certificates and TCS are outside its scope. Rates and thresholds change — always confirm against the Act, the rules and CBDT notifications, or with your tax adviser.

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

Frequently asked questions

What is the new section for 194C under the Income-tax Act, 2025?

Payments to contractors are covered by section 393(1), Table serial 6(i). The tracker shows both the new reference and the old section number.

What is the TDS rate if the payee has no PAN?

Under section 397(2) of the 2025 Act, the higher of the applicable rate or 20%, and 5% for purchase of goods.

When is TDS to be deposited?

By the 7th of the next month for non-government deductors, and by 30 April for tax deducted in March.

What is the interest on late deposit of TDS?

1.5% per month or part of a month from the date of deduction to the date of deposit. Late deduction attracts 1% per month or part.

Which form replaces Form 26Q?

Form 140 is the quarterly statement for TDS on payments to residents other than salary under the Income-tax Act, 2025.

Does the tracker handle the annual threshold catch-up for contractors?

Yes. When the year's total to a payee crosses ₹1,00,000, TDS is calculated on the full amount including earlier bills. Keep entries in date order for this to work.

Can I update the rates if they change?

Yes. Every rate and threshold lives on the Section Master sheet as an input.

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: Deductee Statement, 26AS-AIS Recon.

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.