📎 This article includes 1 downloadable practice file ↓
In this article
TDS mistakes cost interest and late fees, and they’re nearly always the same few: wrong rate, missed PAN check, a deposit forgotten. A simple register catches them.
Register layout
Date, Vendor, Section, PAN available, Amount, Rate, TDS, Net paid. Keep the rate in a section master (see the TDS calculator) and look it up, rather than typing it on each row.
TDS per payment
=ROUND([@Amount] * IF([@PAN]="No", MAX(20%, [@Rate]), [@Rate]), 0)Without a PAN, the higher rate applies (commonly 20%, or the normal rate if that’s higher). Thresholds decide whether TDS applies at all; the calculator lesson covers them.
Monthly deposits
TDS deducted in a month is generally deposited by the 7th of the next month (March has a different date). Summaries:
TDS deducted in August: =SUMPRODUCT((MONTH(T[Date])=8)*T[TDS])
Due date for a deduction: =EOMONTH([@Date], 0) + 7Quarterly summary for the return
=SUMIFS(T[TDS], T[Section], "194J")
=SUMIFS(T[Amount], T[Section], "194C")
=COUNTIF(T[PAN], "No")A pivot with Section in rows, Month in columns and TDS as values matches how quarterly returns group deductions.
Where people go wrong
| Mistake | Effect |
|---|---|
| Normal rate for vendors without PAN | Short deduction |
| TDS on GST-inclusive amount when GST is shown separately | Over-deduction |
| Deposits tracked in email | Late payment interest |
Tax rates, thresholds and rules in this lesson are examples to teach the Excel method. Check current law and your adviser before using figures for filing.
Practice
Download the workbook below. Build each figure in the yellow column of the Practice sheet; the Check column turns green when it matches, and the Answers sheet has a working formula for every task.
📎 Practice files for this article
- 📗Practice workbookQ2 (July-September 2026) vendor payments with section, PAN status and amounts.⬇ XLSX · 15 KB
Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.
Stuck on a step? Ask a question and the AI answers using this article.