In short
One row per vendor. Choose the section and vendor type and the sheet fills in the payment code, base rate, applicable rate, threshold and a “threshold crossed” flag — so the right rate is applied every time.Who it's for
- Businesses and deductors managing many vendors
- Accountants and CA firms running TDS for clients
- Anyone onboarding vendors who needs the correct rate at a glance
What's inside
- Vendor Master sheet with auto rate logic
- No-PAN → 20% rule (Section 397(2), old 206AA)
- Section 197 lower-rate override
- MSME / 43B(h) flag and YTD threshold tracker
- Editable Rate Reference tab
- Input cells open; formula cells locked & password-protected
How to use it
- Open the file and enable editing
- Type vendor details into the white input cells
- Pick the section and vendor type from the dropdowns
- Read the auto-calculated applicable rate and threshold status
- Check the Rate Reference tab figures against the live rate chart before you rely on them
FAQs
Is this template free?
Yes. It is free to download and use, with no sign-up. Built and maintained by a CA firm.
Does it track 206AB non-filer status?
No. Sections 206AB and 206CCA (higher TDS for non-filers) were removed from 1 April 2025, so that column is intentionally not included.
Can I edit the formulas?
The main sheet is password-protected so the formulas are not overwritten by mistake; the Rate Reference tab is open for you to adjust rates and thresholds.
Free · verified 28 June 2026 against the Income-tax Act 2025 / FA 2025. General information, not professional advice.