Unadhi Guides

GSTR-1 for October 2026 by 11 November: a Table 12 HSN (B2B and B2C) and Table 13 documents sheet for CA firms

Updated 26 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 that gets every client's October 2026 GSTR-1 past the Table 12 and Table 13 checks before 11 November. Tab 1 holds HSN rows split into B2B and B2C, with a formula that flags codes shorter than the client must report (4 or 6 digits, from FY 2025-26 turnover). Tab 2 ties the Table 12 totals back to the B2B and B2C values in the other GSTR-1 tables, one row per client. Tab 3 is a Table 13 document log (series, from, to, cancelled, net issued). Tab 4 filters the clients still open. You also get a made-up example, a plan for 2 to 11 November and a WhatsApp message for clients.

Short answer (checked 26 Oct 2026): monthly GSTR-1 for October 2026 is due by Wednesday 11 November 2026. Since the May 2025 return period (GSTN Phase 3), HSN codes in Table 12 can only be picked from a dropdown, Table 12 has separate B2B and B2C tabs, and the B2B tab cannot be empty when B2B supplies appear elsewhere in the return. Clients with aggregate turnover up to ₹5 crore in the previous year report at least 4 digits; above ₹5 crore, 6 digits. Table 13 (documents issued) is mandatory: the portal stops you at summary stage if it is blank. The value checks between Table 12 and the other tables were announced in warning mode; GSTN said Phase 4 would be "communicated in due course", and we found no Phase 4 advisory, so check the portal before you rely on that.

What the portal checks

Tab "HSN rows": one row per client, per HSN, per B2B or B2C

ColHeaderWhat goes in it
AClientTrade name
BTabDropdown: B2B or B2C
CHSN / SACCode from the client's sales register (format the column as plain text so leading zeros stay)
DDigits needed=VLOOKUP(A2,'Clients'!A:C,3,FALSE)
EDigits OK?=IF(LEN(C2)>=D2,"OK","SHORT: need "&D2&" digits")
FUQCUnit, e.g. NOS, KGS; OTH for services
GQuantityFrom the register
HRate (%)Tax rate for this row
ITaxable value (₹)From the register
JIGST (₹)From the register
KCGST (₹)From the register
LSGST/UTGST (₹)From the register
MCess (₹)From the register, 0 if none

Tab "Clients": column A client, column B FY 2025-26 aggregate turnover (₹), column C =IF(B2>50000000,6,4). Fill column B once a year from last year's returns.

Tab "Tie-out": one row per client

ColHeaderWhat goes in it
AClientSame name as the other tabs
BB2B value in other tables (₹)Taxable value you will report in the B2B tables listed above (from the draft GSTR-1 or the books)
CB2B in Table 12 (₹)=SUMIFS('HSN rows'!I:I,'HSN rows'!A:A,A2,'HSN rows'!B:B,"B2B")
DB2B difference=ROUND(B2-C2,0)
EB2C value in other tables (₹)Taxable value in the B2C tables listed above
FB2C in Table 12 (₹)=SUMIFS('HSN rows'!I:I,'HSN rows'!A:A,A2,'HSN rows'!B:B,"B2C")
GB2C difference=ROUND(E2-F2,0)
HShort HSN codes=COUNTIFS('HSN rows'!A:A,A2,'HSN rows'!E:E,"SHORT*")
ITable 13 done?=IF(COUNTIFS('Docs'!A:A,A2)>0,"Yes","No")
JGSTR-1 filed onFrom the ARN, blank if not yet filed
KStatus=IF(J2<>"","FILED",IF(AND(B2>0,C2=0),"STOP: B2B tab empty",IF(I2="No","STOP: fill Table 13",IF(OR(H2>0,D2<>0,G2<>0),"CHECK: fix before 9 Nov","READY"))))

"9 Nov" in the status is our working rule (two days before the due date), not a legal date. A small rounding difference can be fine; a large one usually means an invoice went into the wrong tab or a credit note was left out.

Tab "Docs": Table 13, one row per document series

ColHeaderWhat goes in it
AClientSame name
BNature of documentDropdown: invoices for outward supply, credit notes, debit notes, delivery challans, receipt vouchers, refund vouchers, payment vouchers, and so on
CSr. no. fromFirst number used in October, e.g. INV/26-27/0412
DSr. no. toLast number used in October
ETotal numberCount of documents in the range (from the register)
FCancelledCount cancelled
GNet issued=E2-F2
HMatches register?=IF(G2=COUNTIFS('Register'!A:A,A2,'Register'!B:B,B2,'Register'!C:C,"Active"),"OK","CHECK") (only if you paste the invoice register into a tab called Register)

Keep one row per series. A client with a separate series for each branch or for e-commerce sales needs one row for each, because serials must run in order within a series (rule 46 asks for a consecutive serial number of up to 16 characters).

Tab "Open": who is not ready

Use =FILTER('Tie-out'!A2:K,'Tie-out'!K2:K<>"FILED",'Tie-out'!K2:K<>"READY"), then sort so "STOP" rows come first. Add columns for who chases the client and the date they promised the sales register.

Made-up example (not a real client)

Client "Sample Hardware" had FY 2025-26 turnover of ₹6.2 crore, so Clients!C shows 6. Its October sales register has 3 HSN codes. One row was entered as 7318 (4 digits): column E shows "SHORT: need 6 digits", so you change it to the 6-digit code from the register. B2B taxable value in Table 4A is ₹18,40,000 and the B2B rows in Table 12 add up to ₹18,10,000: a ₹30,000 difference, traced to one credit note left out of the HSN rows. B2C value ₹2,60,000 matches. Table 13 has two rows (invoices 0412 to 0517 with 2 cancelled, so 104 net; credit notes 0031 to 0033). After the fix the status reads READY and the return is filed on 10 November.

Plan for 2 to 11 November

WhatsApp message to a client

"Hello, GSTR-1 for October is due on Wednesday 11 November. The GST portal now needs every HSN code picked from its list, split into B2B and B2C sales, and a list of invoice numbers used and cancelled. Please send your October sales register with HSN, unit and quantity, and the numbers of any cancelled invoices or credit notes, by Monday 2 November so we can file by the 9th."

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. Portal checks can change without a new notification; look at the GST portal's latest advisories before you rely on this. Checked on 26 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.