GSTR-2B vs Purchase Register Reconciliation in Excel

Last updated: 27 June 2026 · Reflects IMS-driven ITC rules for 2026.

To reconcile GSTR-2B with your purchase register in Excel, build a match key of GSTIN + invoice number in both files, then use VLOOKUP (or XLOOKUP) to flag each invoice as Matched, Missing in 2B, Missing in books, or Tax mismatch. Only invoices that appear in GSTR-2B give you Input Tax Credit, so this reconciliation is what protects your ITC every month.

Key takeaways

GSTR-2B is your ITC statement — a static, auto-drafted list of inward invoices your suppliers reported, generated on the 14th of each month.
Match on GSTIN + invoice number, not on amount, because amounts can legitimately differ by rounding.
XLOOKUP/VLOOKUP tells you which invoices are in 2B but not your books, in your books but not 2B, or in both with different tax.
Only matched invoices give ITC. "Missing in 2B" means your supplier hasn't reported it — chase them.
Under IMS (2026), you accept/reject each invoice before 2B is generated, so reconciliation now starts even earlier.
Claim ITC by the Section 16(4) deadline: the 30th November following the financial year, or the annual-return date, whichever is earlier.

Fact box. GSTR-2B is an auto-drafted, static input-tax-credit statement generated monthly (around the 14th). It tells you the ITC the system considers available; you may only claim credit on invoices that appear in it. (Source: GSTN; CBIC ITC rules.)

Why reconcile GSTR-2B against your purchase register?

Because your books and the portal rarely agree on their own. A supplier may forget to upload an invoice, file it late, type a wrong invoice number, or report a different tax amount. Each gap is money: an invoice in your books but not in 2B is ITC you cannot claim yet.

Reconciliation finds four situations:

Matched — same invoice in both, same tax. Claim it.
In 2B, not in books — you may have missed booking a purchase, or it isn't yours.
In books, not in 2B — supplier hasn't reported; ITC on hold.
In both, tax differs — investigate the figure before claiming.

How do I set up the two files in Excel?

Put GSTR-2B on one sheet and your purchase register on another, with identical key columns. In each, build a match key in a helper column:

=TRIM(GSTIN) & "|" & TRIM(InvoiceNo)

Using GSTIN plus invoice number as a combined key avoids false matches when two suppliers use the same invoice number. Clean both sides first — TRIM removes stray spaces, and UPPER standardises the GSTIN so "abcde" and "ABCDE" don't miss.

How do I match invoices with VLOOKUP or XLOOKUP?

In the purchase register, look up each key in the GSTR-2B sheet. XLOOKUP is cleanest:

Status   =IF(ISNA(XLOOKUP(Key, TwoB!Key, TwoB!Key)), "Missing in 2B", "In 2B")
2B Tax   =XLOOKUP(Key, TwoB!Key, TwoB!TotalTax, 0)
Tax diff =Books_Tax - [2B Tax]

Then in the GSTR-2B sheet, do the reverse lookup against the purchase register to catch invoices that are in 2B but not in your books. Flag a tax mismatch where the key matches but Tax diff is larger than your rounding tolerance (say ₹1).

Fact box. Under the Invoice Management System (IMS), from the October 2025 period recipients must Accept, Reject or keep Pending each B2B invoice before GSTR-2B is generated; only accepted (or deemed-accepted) invoices flow into 2B and become eligible ITC. IMS was reported as mandatory for all registered taxpayers from April 2026 — check the latest GSTN advisory for the current effective date, as implementation timelines have shifted in successive notifications. (Source: GSTN IMS advisory.)

How do I summarise the result?

Add a COUNTIF dashboard so you see the month at a glance:

Bucket	Formula	Action
Matched	`=COUNTIF(Status,"In 2B")`	Claim ITC
Missing in 2B	`=COUNTIF(Status,"Missing in 2B")`	Chase supplier
Missing in books	reverse-lookup count	Book or reject
Tax mismatch	`=COUNTIFS(...)`	Verify amount

Total the matched-invoice tax to get the ITC you can safely claim in this period's GSTR-3B.

When is the deadline to claim the ITC?

Reconcile every month, but the hard cutoff for any financial year's ITC is Section 16(4): the earlier of the 30th November following that year, or the date you file the annual return. After that, the credit is permanently lost.

How Ankeshan helps: Ankeshan imports your GSTR-2B and matches it to your purchase register inside Excel, colour-coding matched, missing and mismatched invoices and totalling the claimable ITC — no manual VLOOKUP each month. It's launching soon; join the waitlist.

Frequently asked questions

What is GSTR-2B? A static, auto-drafted statement of your inward (purchase) invoices as reported by suppliers, generated monthly around the 14th. It shows the Input Tax Credit the system treats as available.

What's the difference between GSTR-2A and GSTR-2B? GSTR-2A is dynamic and keeps updating; GSTR-2B is static for the period, which is why it's used as the fixed basis for claiming ITC.

Why is an invoice missing from my GSTR-2B? Usually because the supplier hasn't uploaded it, filed late, or reported it under a wrong GSTIN. You generally cannot claim ITC until it appears.

Can I claim ITC that isn't in GSTR-2B? As a rule, no — ITC is restricted to what appears in 2B. Follow up with the supplier to get the invoice reported.

What is the last date to claim ITC for a year? The earlier of 30 November following the financial year or the date of filing the annual return, under Section 16(4).

Sources

GSTN: GSTR-2B and Invoice Management System (IMS) advisories — gst.gov.in.
CBIC: Section 16(4) time limit to claim ITC — cbic-gst.gov.in.

General information, not professional advice. Verify on the official portal for your case. Reviewed by a Chartered Accountant; last updated 27 June 2026.