In short
Log every Section 197 certificate against the amount you have already deducted under it, so a deduction never breaches the certified rate, limit or validity.Who it's for
- Deductors paying vendors who hold a 197 certificate
- Accountants and CA firms tracking multiple certificates
What's inside
- One row per certificate (number, section, rate, validity)
- Certified limit vs amount utilised
- Auto-calculated balance available
- Active / Expired / Exhausted status with colour flags
- Input cells open; formula cells locked & password-protected
How to use it
- Open the file and enable editing
- Enter each certificate's details in the white cells
- The balance and status update automatically
- Watch the status column — the normal rate revives once a certificate is expired or exhausted
FAQs
Where do I get the certificate number?
From the deductee's TRACES certificate issued under Section 197. Validate it on TRACES before applying the lower rate.
What happens when the limit is used up?
The tracker marks it Exhausted; from that point the normal TDS rate applies again.
Free · verified 28 June 2026 against the Income-tax Act 2025 / FA 2025. General information, not professional advice.