Unadhi Guides

GSTR-6 sheet for CA firms: ISD credit distribution for October 2026 by 13 November (one row per invoice per unit, C1 = t1/T x C)

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 an Input Service Distributor (ISD) client. Tab 1 has one row per input-service invoice the ISD office received in October. Tab 2 has one row per unit (GSTIN) with its turnover for the relevant period. Tab 3 has one row per invoice per unit: by formula it works out each unit's share (C1 = t1/T × C), whether the unit gets CGST + SGST or IGST, and a check that nothing is over- or under-distributed. You also get a made-up example, a plan to Fri 13 November 2026 (GSTR-6 for October) and a WhatsApp message for clients.

Short answer (checked 24 Oct 2026): from 1 April 2025, an office of a business that receives tax invoices for input services (including reverse-charge services) for or on behalf of its other GSTINs under the same PAN must register as an ISD and distribute that credit (section 20(1) CGST Act, as substituted by the Finance Act 2024). Credit available in a month is distributed in the same month and reported in Form GSTR-6, due by the 13th of the next month, so 13 November 2026 for October 2026. A nil GSTR-6 is still required when there is nothing to distribute.

What the rules say

Tab "Inward": one row per input-service invoice received by the ISD

ColHeaderWhat goes in
ARefYour own number, for example INV-01
BSupplier GSTIN and nameFrom the invoice
CInvoice no. and dateMust be on or after the supplier's registration date
DServiceAudit fee, software, advertising, legal, rent of head office, and so on
EIGST (₹)From the invoice
FCGST (₹)From the invoice
GSGST/UTGST (₹)From the invoice
HEligible or ineligible"Eligible" / "Ineligible (17(5))" / "Ineligible (other)"
IUsed by"One unit" / "Some units" / "All units"
JReverse charge passed on by a same-State unit? (Y/N)For rule 39(1A) items
KTotal credit (₹)=E2+F2+G2
LDistributed in Tab 3 (₹)=SUMIFS(Distribution!K:K,Distribution!A:A,A2)+SUMIFS(Distribution!L:L,Distribution!A:A,A2)+SUMIFS(Distribution!M:M,Distribution!A:A,A2)
MCheck=IF(ABS(K2-L2)<=2,"OK",IF(L2>K2,"Over-distributed: fix","Not fully distributed")) (₹2 tolerance for rounding)

Tab "Units": one row per GSTIN under the same PAN

ColHeaderWhat goes in
AUnit GSTINIncluding units with only exempt supplies
BState or UTAs registered
COperational in current year? (Y/N)Only operational units share credit
DTurnover in relevant period (₹)FY 2025-26 turnover in that State, or the last quarter if the Explanation needs it
ESource of figureGSTR-3B totals, books, and so on

Tab "Distribution": one row per invoice per unit that uses the service

Name the cell with the ISD's State ISD_STATE (for example in a Settings tab).

ColHeaderWhat goes in
ARefSame as Tab 1, repeated for each unit that uses the service
BUnit GSTINTyped
CUnit State=VLOOKUP(B2,Units!A:B,2,FALSE)
DSame State as ISD?=IF(C2=ISD_STATE,"Y","N")
Et1 (unit turnover)=IF(VLOOKUP(B2,Units!A:C,3,FALSE)="Y",VLOOKUP(B2,Units!A:D,4,FALSE),0)
FT (total for this invoice)=SUMIFS(E:E,A:A,A2)
GShare=IF(F2=0,0,E2/F2) (for a "One unit" invoice, list only that unit, so the share is 1)
HIGST on invoice=VLOOKUP(A2,Inward!A:E,5,FALSE)
ICGST on invoice=VLOOKUP(A2,Inward!A:F,6,FALSE)
JSGST on invoice=VLOOKUP(A2,Inward!A:G,7,FALSE)
KIGST to unit=ROUND(G2*H2+IF(D2="N",G2*(I2+J2),0),0)
LCGST to unit=IF(D2="Y",ROUND(G2*I2,0),0)
MSGST to unit=IF(D2="Y",ROUND(G2*J2,0),0)
NEligible or ineligible=VLOOKUP(A2,Inward!A:H,8,FALSE) (goes to Table 5 eligible or ineligible column)
OISD invoice no. and dateIssued in October, marked "issued only for distribution of input tax credit"
PUnit told? (Y/N)So the unit's accountant expects the credit

Rounding can leave a rupee or two. Adjust it on the largest unit's row so the total distributed equals the credit available (rule 39(1)(b)).

Made-up example

Client Z has its head office registered as an ISD in Karnataka and units in Karnataka, Maharashtra and Telangana (same PAN). In October 2026 the head office receives an invoice for software used by all three units: CGST ₹9,000 + SGST ₹9,000, eligible. FY 2025-26 turnover: Karnataka unit ₹6 crore, Maharashtra ₹3 crore, Telangana ₹1 crore, all operational, so T = ₹10 crore.

UnitShareSame State?Gets
Karnataka60%YCGST ₹5,400 + SGST ₹5,400
Maharashtra30%NIGST ₹5,400
Telangana10%NIGST ₹1,800
Total100%₹18,000 = credit on the invoice (Check: OK)

Three ISD invoices go out in October and the lot is reported in GSTR-6 for October by Fri 13 November 2026. (Example names and figures only.)

Plan to 13 November

DateDo this
By 31 OctList every client with more than one GSTIN under one PAN. Check that each one whose head office buys common services (audit, software, advertising, legal) has an ISD registration.
Before 31 OctIssue October ISD invoices for credit available in October (rule 39(1)(a): same month).
1 to 5 NovCollect October input-service invoices and supplier notes, update FY 2025-26 turnover per unit, fill Tabs 1 to 3.
6 to 12 NovFix every "Not fully distributed" or "Over-distributed" row, enter Table 3, 6B, 5 and 8, check Table 4.
Fri 13 NovGSTR-6 for October due (nil return if nothing to distribute). Tell each unit its credit (column P).
By 20 NovUnits claim the distributed credit in their own GSTR-3B by the 20th.
Sun 13 DecGSTR-6 for November due (check the portal for any extension).

WhatsApp message to a client

"Hello [name], your head office ISD registration must distribute October's credit on common services (audit, software, advertising and similar) to your other GSTINs, and GSTR-6 for October is due by 13 November. Please send us all October invoices received at head office and each unit's FY 2025-26 turnover by 5 November. A nil return is needed even if there is nothing to distribute. 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.