Unadhi Guides

GSTR-7 sheet for CA firms: GST TDS for October 2026 by 10 November (metal scrap buyers and government clients, invoice-wise)

Updated 24 Oct 2026 · Disclosure: the white-label calendar linked below is an Unadhi product (₹999/year). This guide is for information only, not professional advice.

What you get: a ready-to-copy Google Sheet layout for GST TDS. Tab 1 has one row per payment made by a deductor client (a metal scrap buyer, a government department, a local authority or a government agency). By formula it shows whether TDS applies, the CGST/SGST or IGST to deduct, the GSTR-7 due date (Tue 10 November 2026 for October), days left and a status. Tab 2 has one row per TDS credit for supplier clients, so nobody forgets to accept the credit. You also get a made-up example, a late-fee working column, a plan to 10 November and a WhatsApp message for clients.

Short answer (checked 24 Oct 2026): a person liable to deduct GST TDS under section 51 of the CGST Act deducts tax from payments to suppliers where the total value of supply under a contract exceeds ₹2,50,000 (excluding GST). It pays the tax and files Form GSTR-7 by the 10th of the following month, so 10 November 2026 for deductions made in October 2026. Since 10 October 2024 this includes any registered business buying metal scrap (Customs Tariff Chapters 72 to 81) from another registered person, which needs a separate TDS registration in Form GST REG-07. From the September 2025 return period, GSTR-7 is filed invoice-wise: invoice/document number, date and value for every entry.

What the rules say

Tab "GSTR-7": one row per payment made by a deductor client

ColHeaderWhat goes in
AClient (deductor)Name and TDS GSTIN (REG-07)
BWhy a deductorGovt dept / Local authority / Govt agency / Notified person / Metal scrap buyer
CSupplier GSTIN and nameFrom the invoice
DInvoice/document no.Only "/" and "-" as special characters
EInvoice dateDD/MM/YYYY
FInvoice value (₹)Including tax
GContract value excl. GST (₹)Total value of supply under the contract
HSupplier located outside our State? (Y/N)For the proviso
IPlace of supply outside our State? (Y/N)For the proviso
JTDS applies?=IF(G2<=250000,"No TDS: contract up to 2.5 lakh",IF(AND(H2="Y",I2="Y"),"No TDS: proviso","Deduct"))
KInter-State supply? (Y/N)Decides IGST or CGST + SGST
LTaxable amount paid or credited this month (₹)Excluding GST
MDate paid or creditedDecides the month of deduction
NIGST TDS=IF(AND(J2="Deduct",K2="Y"),ROUND(L2*2%,0),0)
OCGST TDS / SGST TDS (each)=IF(AND(J2="Deduct",K2="N"),ROUND(L2*1%,0),0)
PGSTR-7 due date=EOMONTH(M2,0)+10 (10 Nov 2026 for October)
QDays left=P2-TODAY()
RDate GSTR-7 filedFrom the ARN message
SDays late=IF(R2="",MAX(0,TODAY()-P2),MAX(0,R2-P2))
TCGST late fee (working figure)=MIN(S2*25,1000) per return, not per row. Add the State/UT part per your State's notification.
UStatus=IF(J2<>"Deduct","No TDS",IF(R2<>"","Filed",IF(Q2<0,"Late: interest and fee run",IF(Q2<=3,"File now","Collect invoices"))))

The late fee in column T is per return for the month, not per invoice. Keep it on one row per client per month, or work it out separately. It is a working figure only; the portal computes the real amount.

Tab "TDS credit": one row per credit for supplier clients

ColHeaderWhat goes in
AClient (supplier)Name and GSTIN
BDeductorGovernment buyer or metal scrap buyer, with its TDS GSTIN
CInvoice no., date, valueMust match what the deductor reported
DTDS expected (₹)From the deductor's payment advice
EShown in "TDS and TCS credit received"? (Y/N)Check after the 10th
FActionAccept / Reject (reason)
GForm filed? (Y/N)Credit reaches the cash ledger only after filing
HStatus=IF(E2="N","Chase deductor",IF(G2="Y","In cash ledger","Accept and file"))

Made-up example

Client Y, a registered foundry in Maharashtra, buys steel scrap (Chapter 72) from a registered dealer in Maharashtra under a ₹4,00,000 contract, taxable value excluding GST. On 18 October 2026 it pays ₹3,00,000 of the taxable value. Column J shows "Deduct" and K is "N", so it deducts ₹3,000 CGST and ₹3,000 SGST. GSTR-7 for October is due Tue 10 November 2026, and the tax is paid from the cash ledger while filing. If it files on 14 November, the working CGST late fee is 4 days × ₹25 = ₹100, plus interest on the TDS paid late. (Example figures only.)

Plan to 10 November

DateDo this
By 31 OctList every client that buys metal scrap from registered dealers or sells to government bodies. Check that each scrap buyer has a REG-07 TDS registration.
2 to 5 NovCollect all October payments with invoice number, date and value. Fill columns A to M.
6 to 9 NovCheck the formulas, deposit cash in the ledger, add invoices in Table 3, act on any rejected entries in Table 4, GENERATE SUMMARY.
Tue 10 NovGSTR-7 for October due. Record the ARN date in column R.
11 to 20 NovSupplier clients: accept the credit and file (Tab 2), before their own GSTR-3B by the 20th.
Thu 10 DecGSTR-7 for November due.

WhatsApp message to a client

"Hello [name], GST TDS for October 2026 must be filed in GSTR-7 by 10 November. Please send us every payment you made in October to suppliers (especially metal scrap purchases and contracts over ₹2.5 lakh) with the invoice number, date, value and payment date by 5 November. Thank you."

Related guides

Partner programme opening soon

Partner programme opening soon: join the free waitlist. Planned terms are 50% of each referred sale (75% once you have 5+ paying customers), single level, paid through Gumroad only from revenue received.

Sources

This sheet is a working aid, not professional advice. Due dates can be extended by notification; check the portal before you file. Checked on 24 October 2026. Spot an error? Write to mininglife7@gmail.com.

← All guides

Unadhi Guides are free, independent explainers. We correct errors as soon as we find them: write to mininglife7@gmail.com.