GST Reconciliation Software: How to Match GSTR-2B With Your Purchase Register

Prateek Agarwal·19 June 2026·Updated 27 June 2026·9 min read

GSTR-2B reconciliation means matching every purchase invoice in your books against the GSTR-2B statement on the GST portal, line by line, so you only claim the Input Tax Credit (ITC) that your suppliers have actually reported. It matters because, as of 2026, ITC that doesn't appear in your GSTR-2B is at real risk of being disallowed — reconciliation is how you protect the credit before you file GSTR-3B.

I've run this exercise for hundreds of GST clients, and it's the single task where a careless month quietly costs a business real money. Below is exactly how I do it — manually first, so you understand the logic, then how GST reconciliation software takes the grind out of it.

What is GSTR-2B, and why match it to your purchase register?

GSTR-2B is a static, auto-drafted ITC statement the GST portal generates for you each month, built from what your suppliers filed in their GSTR-1, GSTR-5 and similar returns. "Static" is the key word: once it's generated for a tax period, it doesn't change — so the figure you reconcile against today is the same figure an officer sees later. That stability is exactly why the department leans on it.

Your purchase register is the other side of the story: every inward invoice you've booked in your accounting software. Reconciliation is simply asking, invoice by invoice, "does what I've recorded match what my supplier reported to the government?"

The practical reason this matters: in the current GST regime you can broadly only claim ITC that is reflected in your GSTR-2B, and even then only when the Section 16 conditions are met — you hold a valid tax invoice, you've received the goods or services, the supplier has actually paid the tax to the government, and you pay the supplier within the prescribed period. If an invoice is in your books but missing from 2B, that credit is not safe to take yet. Reconciliation is how you catch those gaps every single month.

GSTR-2A vs GSTR-2B — don't confuse them

GSTR-2A is the dynamic statement — it keeps updating as suppliers file or amend, even for old periods. GSTR-2B is the static snapshot for a period. For deciding how much ITC to claim in a given month, GSTR-2B is the reference document. GSTR-2A is still useful for investigating why something changed, but your monthly claim should be driven by 2B.

How to reconcile GSTR-2B with your purchase register: step by step

Here's the workflow I follow for every client, whether by hand in Excel or inside reconciliation software. The logic is identical — software just does steps 4 and 5 in seconds instead of an afternoon.

  1. Download GSTR-2B from the GST portal. Log in, go to Returns Dashboard, select the tax period, and download GSTR-2B as JSON or Excel. Do this only after the supplier filing window for the month has closed, so the statement is complete.
  2. Export your purchase register from your books. Pull all inward (purchase) invoices for the same period from your accounting software, with GSTIN, invoice number, invoice date, taxable value and the tax breakup (IGST / CGST / SGST).
  3. Standardise both datasets. This is where reconciliations live or die. Clean up the supplier GSTIN, the invoice number (strip stray spaces, slashes and leading zeros), the invoice date format, the taxable value and the tax amounts so the two sheets speak the same language.
  4. Match on a composite key. Match each line using GSTIN + invoice number + invoice date + taxable value + tax. A safe match clears on GSTIN and invoice number with values within a small tolerance; anything that only partly agrees gets flagged rather than auto-matched.
  5. Categorise every result. Bucket each line into matched, mismatch, in-2B-not-in-books, in-books-not-in-2B, or probable match. Then act on each bucket (see the table below). The categories are the whole point — the matched lines need no work; the exceptions are where your ITC is at stake.

If you want to sanity-check the tax maths while you reconcile, our free GST calculator and GST ITC set-off calculator are handy for confirming the IGST/CGST/SGST split and how the eligible credit will be utilised in GSTR-3B.

GSTR-2B reconciliation result categories and what to do

After matching, every invoice falls into one of these buckets. This table is the heart of the exercise — print it, and your juniors will know exactly what action each line needs.

CategoryWhat it meansAction to take
Matched Invoice appears in both 2B and your books with the same GSTIN, number and values. Nothing — this ITC is safe to claim (assuming Section 16 conditions are met).
Mismatch (value/tax differs) Same invoice in both, but taxable value or tax amount disagrees. Investigate the difference. If your booking is wrong, correct it; if the supplier reported wrong, ask them to amend in their next GSTR-1.
In 2B but not in books Supplier reported an invoice you haven't recorded (or have booked under a different number). Check whether you missed booking the purchase, or it's a duplicate/wrong GSTIN at the supplier's end. Book it if genuine.
In books but not in 2B You've recorded the purchase, but the supplier hasn't filed (or filed late), so it's absent from this 2B. Hold the ITC — don't claim yet. Follow up with the supplier to file. It should appear in a later period's 2B.
Probable / partial match Likely the same invoice, but invoice number formatting or a rounding difference stops a clean auto-match. Eyeball it, confirm it's the same document, and accept the match manually.

How GST reconciliation software automates this

Doing this by hand for a client with 40 invoices is fine. Doing it for a client with 4,000 — or doing it across your whole portfolio in the few days before the GSTR-3B deadline — is where good GST reconciliation software earns its keep. The features that actually save time:

  • Fuzzy matching on invoice formats. Suppliers write invoice numbers inconsistently — "INV/2026/001", "INV-2026-1", "0012026". Software normalises these and matches the underlying document instead of failing on punctuation.
  • Rounding tolerance. A one- or two-rupee gap from rounding shouldn't break a match. Tools let you set a tolerance so genuine matches don't pile up in the exceptions list.
  • Automatic categorisation. The five buckets above are filled in instantly, with totals, so you immediately see how much ITC is matched versus at risk.
  • Bulk vendor follow-up. For every "in books but not in 2B" line, the better tools generate vendor-wise lists or reminders so you can chase the suppliers who haven't filed — in bulk, not one email at a time.

Finexo offers a free GSTR-2B & Purchases reconciliation tool as part of its set of free GST utilities (alongside the GST Calculator and the ITC Set-off Calculator), so you can run this match without paying for a separate reconciliation product — see Finexo's tools for CA practices. If you're weighing a full compliance stack rather than a single utility, I compared the broader options in the best GST software for CA and tax practitioners in 2026.

Common GSTR-2B reconciliation pain points (and how to handle them)

Most "mismatches" aren't fraud or disallowed credit — they're data hygiene. These are the recurring culprits I see every month:

  • Invoice number formatting. The same invoice booked as "A-101" by you and reported as "A101" by the supplier reads as two different documents to a strict match. This is the single biggest source of false mismatches; fuzzy matching solves most of it.
  • Rounding differences. A few paise or rupees of difference in tax because of rounding at the line versus invoice level. Set a tolerance and move on.
  • Wrong GSTIN. The supplier reported your invoice against another GSTIN of yours, or against the wrong party entirely. The invoice then never shows in your 2B — you must get them to amend it.
  • Supplier filed in a later period. Very common with quarterly (QRMP) suppliers. The purchase is real and the credit is legitimate, it just lands in a later month's 2B. Track these so you claim them when they appear rather than losing them.
  • Timing of download. Pull 2B too early and late-filing suppliers won't be in it. Reconcile after the filing window closes for the period.

Across a portfolio, the hardest part isn't reconciling one client — it's remembering which clients you've reconciled this month and which still have vendors to chase. That's a tracking problem, not a tax one. Finexo PMS (CA practice management, from Rs 5,999/year) is what we use to see, at a glance, which clients still need their GSTR-2B reconciliation done before the GSTR-3B deadline — so nothing slips in the last-week rush.

Bottom line

GSTR-2B reconciliation is non-negotiable as of 2026: your claimable ITC is effectively capped by what's in your static GSTR-2B, so matching it to your purchase register every month is how you keep credit safe and avoid disallowance. Do it after the filing window closes, standardise your data, categorise every exception, and chase the suppliers who haven't filed. Software removes the drudgery — fuzzy matching, rounding tolerance and bulk follow-up turn an afternoon into a few minutes — but the discipline of doing it monthly is what actually protects the money.

Frequently Asked Questions

What is the difference between GSTR-2A and GSTR-2B?

GSTR-2A is a dynamic statement that keeps updating as suppliers file or amend their returns, even for past periods. GSTR-2B is a static, auto-drafted ITC statement generated once for each tax period and does not change afterwards. For deciding how much Input Tax Credit to claim in a given month, GSTR-2B is the reference document; GSTR-2A is mainly useful for investigating why a figure changed.

Can I claim ITC that is not in my GSTR-2B?

Generally no. As of 2026, your claimable Input Tax Credit is effectively limited to what appears in your GSTR-2B, and even then only when the Section 16 conditions are met — you hold a valid invoice, have received the goods or services, the supplier has paid the tax, and you pay the supplier in time. If an invoice is in your books but missing from 2B, hold the credit and follow up with the supplier rather than claiming it.

How often should I reconcile GSTR-2B with my purchase register?

Every month, before you file GSTR-3B. Because GSTR-2B is static and drives your monthly ITC claim, reconciling once a month lets you catch missing or mismatched invoices while you can still chase suppliers and adjust your claim. Leaving it to year-end means months of accumulated mismatches and lost time chasing suppliers who may no longer cooperate.

When should I download GSTR-2B for the most accurate match?

Download GSTR-2B after the supplier filing window for the tax period has closed, so the statement is complete. If you pull it too early, suppliers who file late — especially quarterly QRMP suppliers — won't appear, and you'll see false 'in books but not in 2B' exceptions. Since 2B is static once generated for the period, waiting for the window to close gives you the figure that matters.

Why does an invoice show as a mismatch when the amounts look right?

Most false mismatches come from data formatting, not real errors. The same invoice number written as 'A-101' by you and 'A101' by your supplier reads as two documents to a strict match, and small rounding differences in tax can break an otherwise-valid match. Reconciliation software handles these with fuzzy matching on invoice numbers and a configurable rounding tolerance, so genuine matches don't clog your exceptions list.

Do I need paid software to reconcile GSTR-2B?

Not necessarily. You can reconcile manually in Excel by downloading GSTR-2B, exporting your purchase register, standardising the data and matching line by line. For low invoice volumes that works fine. Finexo also offers a free GSTR-2B and Purchases reconciliation tool among its free GST utilities. Paid software becomes worthwhile when you handle high invoice volumes or a large client portfolio and need fuzzy matching and bulk vendor follow-up.

Related Articles