Multi GSTIN reconciliation single PAN Excel

Reconciling multi-GSTIN purchase registers under a single PAN requires segregating purchase data by state registration, cross-matching distinct person transfers, and verifying each branch GSTR-2B independently. Multi-state businesses often face duplicate ITC claims and wrong-GSTIN bookings when head-office invoices are claimed across branches. Consolidating branch registers in Excel with structured recipient tags ensures compliance with statutory ITC limits under Rule 36(4).

Businesses operating across state lines under a single Permanent Account Number (PAN) hold distinct Goods and Services Tax Identification Numbers (GSTINs) for each operational state. In accounting enterprise resource planning (ERP) platforms, centralized procurement teams frequently record invoices without strict state allocation, leading to tax credit misallocation or duplicate claims across returns. Proper multi-GSTIN reconciliation aligns each branch purchase register directly with its corresponding portal statement.

Distinct person rules under Section 25(4) and cross-branch supplies

Under Section 25(4) of the CGST Act, a person who has obtained or is required to obtain more than one registration, whether in one State or Union territory or more than one State or Union territory, is treated as distinct persons in respect of each such registration. Consequently, each state branch is an independent taxable entity for Input Tax Credit (ITC) entitlement and filing obligations.

In addition, entry 2 of Schedule I read with Rule 138 and Rule 55 of the CGST Rules establishes that inter-state transfers of goods or services between distinct persons constitute taxable supplies even when made without consideration. When a warehouse in Maharashtra transfers stock to a branch in Karnataka, the sending GSTIN must issue a regular tax invoice charging Integrated Goods and Services Tax (IGST). The receiving Karnataka branch cannot claim ITC on internal transfer memos: it must match the transaction against the inward IGST appearing in its Karnataka GSTR-2B, exactly as required for third-party vendors under Section 16(2)(aa) of the CGST Act.

Common mistake: Centralized accounting teams frequently post an invoice addressed to the Maharashtra GSTIN into a combined national purchase register, subsequently claiming the ITC in Karnataka's GSTR-3B return. Under Section 16(2)(aa) and Rule 36(4), credit is restricted strictly to the GSTIN appearing on the tax invoice and reflected in that specific GSTIN's GSTR-2B. Claiming another branch's credit invites scrutiny under Rule 88D intimation in Form DRC-01C.

Branch-wise purchase register consolidation in Excel

To run multi-GSTIN reconciliation efficiently in Excel without enterprise software overhead, maintain a standardized data pipeline. Combining data from SAP, Tally, or Zoho requires explicit tagging of the recipient GSTIN before running lookup formulas.

  1. Extract branch purchase registers: Export purchase registers for each state GSTIN separately, ensuring columns include Recipient GSTIN, Supplier GSTIN, Supplier Name, Invoice Number, Invoice Date, Taxable Value, IGST, CGST, and SGST.
  2. Download branch GSTR-2B Excel files: Download the monthly GSTR-2B zip or Excel package from the GST Portal Returns Dashboard for every registered branch. The official GSTR-2B Excel includes B2B, B2BA, CDNR, and CDNRA tables.
  3. Build a consolidated PAN register: Append branch sheets into a master Excel workbook. Create a composite key column using the formula: =Recipient_GSTIN & "_" & Supplier_GSTIN & "_" & Clean_Invoice_No to distinguish identical invoice numbers received across different state units.
  4. Cross-match inter-branch distinct person invoices: Verify that outward GSTR-1 filings from Branch A match inward entries in Branch B's GSTR-2B. Eliminate internal transfers from commercial vendor balances.

Worked example: resolving cross-branch misallocations

Consider Alpha Logistics Private Limited, holding two registrations under single PAN AAACA1234A: Maharashtra branch (27AAACA1234A1Z5) and Karnataka branch (29AAACA1234A1Z1). For September 2026, Alpha Logistics records four inward transactions in its consolidated books totaling ₹3,00,000 taxable value and ₹54,000 tax.

During reconciliation against the respective GSTR-2B files downloaded on the 14th of October 2026, Alpha Logistics identifies distinct allocation discrepancies:

Invoice Supplier Book Recipient Taxable (₹) Tax (₹) GSTR-2B Status Recon Finding
INV-101 27BBBBB0000B1Z2 27AAACA1234A1Z5 (MH) 1,00,000 18,000 In MH 2B (₹18,000) Eligible in MH GSTR-3B
INV-102 29CCCCC0000C1Z4 29AAACA1234A1Z1 (KA) 50,000 9,000 In KA 2B (₹9,000) Eligible in KA GSTR-3B
INV-103 27DDDDD0000D1Z6 29AAACA1234A1Z1 (KA) 1,00,000 18,000 In MH 2B (₹18,000) Billed to MH; booked in KA
ST-045 27AAACA1234A1Z5 (MH) 29AAACA1234A1Z1 (KA) 50,000 9,000 In KA 2B (₹9,000) Valid distinct person stock transfer

Detailed analysis of invoice INV-103 reveals that vendor 27DDDDD0000D1Z6 invoiced Maharashtra (27AAACA1234A1Z5) with CGST ₹9,000 and SGST ₹9,000. However, the Bangalore accounts team entered it in the Karnataka purchase register. If Karnataka claims this ₹18,000 in Table 4(A)(5) of its GSTR-3B, Karnataka faces an ITC mismatch notice under Rule 88D because the invoice is absent in Karnataka's GSTR-2B. Simultaneously, Maharashtra would under-claim eligible credit by ₹18,000. Excel consolidation reveals this exact variance by comparing the Recipient GSTIN in books against the GSTR-2B recipient file.

Calculation of correct ITC entitlement for September 2026:

Maharashtra GSTR-3B Table 4(A)(5) eligible ITC: ₹18,000 (INV-101) + ₹18,000 (INV-103 reallocated) = ₹36,000.

Karnataka GSTR-3B Table 4(A)(5) eligible ITC: ₹9,000 (INV-102) + ₹9,000 (ST-045 inter-branch supply) = ₹18,000.

Step 1: Export branch registers → Step 2: Tag Recipient GSTIN → Step 3: Match against branch GSTR-2B → Step 4: Reconcile inter-unit stock transfers

Preventing duplicate ITC across branches

Duplicate ITC claims in multi-GSTIN companies typically occur when centralized service vendor bills (such as cloud hosting, national advertising, or shared legal counsel) are copied across multiple branch ledgers. Under Section 20 of the CGST Act, shared services received by a central office on behalf of distinct persons must be distributed through an Input Service Distributor (ISD) registration rather than through parallel direct bookings.

For cross-reference of branch reconciliation strategies and handling multi-state setups, consult our guide on GSTR-2B reconciliation for multiple GSTINs.

Frequently asked questions

Can an entity claim ITC on an invoice billed to its Maharashtra branch in its Karnataka GSTR-3B?

No. Under Section 25(4) of the CGST Act, separate state registrations under the same PAN are treated as distinct persons. Inward tax credit can only be claimed by the specific GSTIN appearing as the recipient on the tax invoice and reflected in that GSTIN's GSTR-2B.

How should inter-state stock transfers between distinct persons be handled in reconciliation?

Under Schedule I para 2 and Section 25(4) of the CGST Act, inter-branch transfers between distinct persons are treated as supplies. The supplying branch must issue a tax invoice with IGST, and the receiving branch must verify the invoice in its GSTR-2B before availing ITC.

Check your branch GSTR-2B files instantly

Drop your branch GSTR-2B Excel files and purchase registers into gstr2bmatch.in to identify mismatches and wrong-GSTIN bookings. Your GSTR-2B and purchase register files are read in your browser and never uploaded to any server.

Reconcile GSTR-2B →

Last checked: 27 October 2026. Sources: CBIC Tax Information Portal, GSTN Returns User Guide.