Template
TDS Tracker
TDS is unforgiving: deduct late and there is interest, deposit late and there is more interest, miss the return and the deductee cannot claim credit. This tracker is built for Indian businesses that deduct tax on rent, professional fees, contractor payments, and commission. It records each payment, the section and rate applied, the tax deducted, and the date it must reach the government by the 7th, then tracks quarterly return filing and Form 16A issue. Use it to deduct the right amount under the right section, deposit on time, and keep your vendors’ credit clean.
Free · Excel / Google Sheets compatible · no signup — see what’s inside below, then download.
What it does
The template gives you a single register for every payment on which your business must deduct tax at source. For each entry you record the payee and their PAN, the nature of the payment, the relevant section (such as 194C for contractors, 194J for professional fees, or 194I for rent), the rate, the gross amount, and the TDS deducted. The sheet flags the deposit due date — generally the 7th of the next month — and tracks whether the challan has been paid, so you never carry an undeposited liability. A quarterly block ties the entries to the right return (24Q for salary, 26Q for other payments) and reminds you to issue Form 16/16A so deductees can claim credit in their own returns.
Who it’s for
- Businesses paying rent above the threshold, deducting under section 194I.
- Companies and firms paying contractors and sub-contractors under 194C.
- Anyone paying professional or technical fees to consultants under 194J.
- Employers and growing SMEs managing salary TDS (24Q) alongside vendor TDS (26Q).
Fields included
How to use it
- Set up your TAN, the deductor type, and the quarter at the top of the sheet.
- For each payment, record the payee, PAN, nature of payment, and the applicable section.
- Enter the gross amount; apply the correct rate to compute TDS (use 20% if PAN is missing).
- Note the deposit due date — the 7th of the next month — and mark the challan once paid.
- At quarter end, total the deductions section-wise for the 24Q or 26Q return.
- File the quarterly return and record the token/acknowledgement number.
- Issue Form 16 (salary) or 16A (others) to each deductee so they can claim credit.
Preview
| Payee | Section | Gross (₹) | TDS (₹) |
|---|---|---|---|
| Office landlord | 194I (rent) | 60,000 | 6,000 |
| Freelance designer | 194J (professional) | 40,000 | 4,000 |
| Courier contractor | 194C (contractor) | 50,000 | 500 |
| Sales commission agent | 194H (commission) | 30,000 | 1,500 |
| Total TDS — June | — | 1,80,000 | 12,000 |
Free Excel / Google Sheets template — no signup required.
Download Excel template (.xlsx)Example workflow
Krishna Consultancy in Hyderabad pays office rent of ₹60,000 a month and a designer’s professional fee of ₹40,000 in June. Rent crosses the annual threshold, so they deduct 10% under section 194I — ₹6,000 — and pay the landlord ₹54,000. The designer’s fee falls under 194J at 10%, so ₹4,000 is deducted and ₹36,000 paid. Both deductions, totalling ₹10,000, must reach the government by 7 July; the tracker flags the date and the owner pays a single challan on the 5th, recording the BSR code. At quarter end the sheet groups these under 26Q, the return is filed, and Form 16A is issued to both the landlord and the designer so they can claim the ₹10,000 in their returns.
Frequently Asked Questions
Ready to put this to work?
Download Excel template (.xlsx)