TDS on purchases: 194Q month-wise calculator
Purchase register in: finds the month each seller crosses ₹50 lakh and works out the 0.1% TDS from there, month by month, with charts.
No file at hand?
Purchase register
Tally or Excel export with the seller's name, the invoice date and the taxable value. PAN or GSTIN columns, if there, join a seller's bills across states. Purchase returns can be in the same file.
IN SHORT
This free calculator takes a purchase register in Excel and works out TDS on purchase of goods (section 194Q, now section 393(1), code 1031) for every seller, month by month. It adds up each seller's purchases through the year, finds the bill that takes them past ₹50 lakh, and charges 0.1% only on what is above it. It shows charts, flags sellers close to the limit, and gives an Excel with the month-wise TDS. The file is read in your browser.
STEP BY STEP
How it works
- Export the purchase register from Tally or your accounting software to Excel, with the seller, the invoice date and the taxable value.
- Drop it here. Columns are found by themselves; point to any that are not.
- Read the TDS for each month or each quarter, which sellers have crossed ₹50 lakh and when, and which are close to it.
- Download the Excel: seller summary, month-wise and quarter-wise TDS and purchases, and the bill-by-bill working.
GOOD TO KNOW
Common questions
- How is the ₹50 lakh counted?
- For each seller, on the taxable value of everything bought from them in the financial year, in date order. Nothing is charged on the first ₹50 lakh. The bill that crosses it is taxed only on the part above, and every later bill is taxed in full. A new financial year starts again from zero.
- Is it worked on the value with GST or without?
- Without. Where GST is shown separately on the bill and tax is deducted when the bill is booked, CBDT Circular 13 of 2021 says the tax is on the amount before GST. An advance paid before the bill is taxed when paid, on the whole amount, and a purchase register does not show it.
- My supplier bills from two states. Is each GSTIN counted separately?
- No. The limit is per seller, and a seller is one PAN. Where the file has GSTINs, the PAN inside each is used, so bills from the same seller's Maharashtra and Gujarat registrations are added together.
- What about purchase returns?
- A return reduces the year's purchases from that seller. If it comes after the limit was crossed, the tax of that month comes down, shown as a minus figure: adjust it against the next deduction from the same seller. A row typed as Debit Note, Credit Note or Purchase Return is read as a return.
- Who has to deduct this TDS?
- A buyer whose own turnover was above ₹10 crore in the previous financial year, on goods bought from a seller resident in India. It does not apply where another TDS section covers the payment, or where the seller collects TCS on the goods. Where the seller has not given a PAN the rate is 5%, which the tool applies if you ask it to.
- When is each month's tax due?
- By the 7th of the next month, and by 30 April for March. The month-wise table shows the total to deposit for each month and its date.
- Can I see it quarter by quarter?
- Yes. Switch from By month to By quarter and the charts and the table show Q1 to Q4, with the total that goes into each quarter's TDS statement (Form 140; Form 26Q for years before 2026-27) and the date it is due: 31 July, 31 October, 31 January and 31 May. The Excel always has both the month-wise and the quarter-wise sheets.