Unadhi Guides

GST TCS for e-commerce sellers, October 2026: a GSTR-8 credit check and accept sheet for CA firms (operators file by 10 November)

Updated 25 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 finished Google Sheet layout with three tabs: "Oct TCS" (one row per client per e-commerce operator, with the expected 0.5% TCS formula, the difference against what the operator reported in GSTR-8, and an Accept / Check status formula), "Ledger" (when each client filed the TDS and TCS Credit Received statement and when the cash reached the electronic cash ledger), and "Open" (a FILTER of everything still pending), plus a made-up example, a 10 to 20 November plan and a WhatsApp message for sellers.

Short answer (checked 25 Oct 2026): e-commerce operators must file GSTR-8 for October 2026 by Tuesday 10 November 2026 (section 52(4) CGST Act: within ten days after the end of the month). TCS is 0.5% of the net value of taxable supplies (0.25% CGST + 0.25% SGST/UTGST, or 0.5% IGST) since 10 July 2024. Your seller clients do not get this money automatically: the records appear in Services > Returns > TDS and TCS Credit Received, the seller must accept or reject every record, and the accepted amount reaches the electronic cash ledger only after that statement is filed. If you want to use October TCS against the October GSTR-3B (due 20 November for monthly filers), file the statement first.

What the official sources say

Tab "Oct TCS": one row per client per operator

ColFieldWhat to enter or formula (row 2)
AClientTrade name
BClient GSTINFrom your client master
COperatorMarketplace name as shown on the portal
DOperator GSTINCopy from the TCS Credit Received summary (one GSTIN per state)
EGross sales via operator (Oct)From the operator's October settlement or tax report
FReturns via operator (Oct)Same report, returns in October
GNet value per client books=E2-F2
HExpected TCS=ROUND(G2*0.5%,2)
INet value shown by operatorFrom the portal record (GSTR-8 data)
JTCS shown by operatorIGST + CGST + SGST from the portal record
KDifference=J2-H2
LMatches GSTR-1 Table 14?Value the client reported in GSTR-1 Table 14 (supplies through operators who collect TCS) for this operator GSTIN; =IF(ABS(L2-G2)<=1,"Yes","Check") in a helper column
MStatus=IF(J2="","WAIT: operator GSTR-8 due 10 Nov",IF(ABS(K2)<=10,"ACCEPT",IF(K2<0,"CHECK: operator shows less","CHECK: operator shows more")))
NAction takenAccepted / Rejected / Left for next period, with date

The ₹10 tolerance in column M is our working rule for rounding across many orders, not a legal threshold. Change it to suit your clients. Reject only after you have checked the operator's report: a rejected record goes back to the operator and the credit waits until they amend it.

Tab "Ledger": one row per client

ColFieldWhat to enter or formula (row 2)
AClient GSTINSame as Oct TCS column B
BTCS accepted (₹)=SUMIFS('Oct TCS'!J:J,'Oct TCS'!B:B,A2,'Oct TCS'!N:N,"Accepted*")
CStatement filed onDate the TDS and TCS Credit Received statement was filed (DSC or EVC)
DSeen in cash ledger onDate you saw the credit in the electronic cash ledger
EGSTR-3B due=DATE(2026,11,20) for monthly filers; QRMP clients pay October by 25 November through PMT-06
FStatus=IF(B2=0,"NOTHING TO FILE",IF(C2="",IF(TODAY()>E2-3,"URGENT: file credit statement","OPEN: file after 10 Nov"),IF(D2="","FILED: check cash ledger","DONE")))

Tab "Open": what still needs work

=FILTER('Oct TCS'!A2:N,'Oct TCS'!M2:M<>"ACCEPT",'Oct TCS'!A2:A<>"") lists every row that is waiting or needs a check. Add a second FILTER on Ledger column F for anything not "DONE".

Made-up example (not a real client or marketplace)

Plan for 10 to 20 November

WhatsApp message to a seller client

"Hello, marketplaces must report October TCS by 10 November. Please send us your October settlement or tax report from each marketplace by Monday 9 November. We will check that each one collected 0.5% on your net sales and accept the credit on the GST portal so the money reaches your cash ledger before your October GSTR-3B on 20 November."

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 and portal behaviour can change; check the GST portal before you rely on them. The example business and marketplaces are made up. Checked on 25 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.