Free GSTR-2B Reconciliation Tool
Match your GSTR-2B against your purchase register in a minute, and get the exceptions, the ITC bridge and an Excel working paper.
- Nothing is uploaded. Your files are read by this browser tab only.
- Works offline. Once the page has loaded, switch off the internet: it still works.
- Free. No sign-up, no limits.
How it matches
- Possible duplicates first. The same supplier GSTIN, document type and invoice number twice in the books: the first is kept, the rest are listed as possible duplicates.
- GSTIN and invoice number exactly as written.
- GSTIN and cleaned invoice number. The financial year, prefixes, slashes and leading zeros are removed,
so
INV-412matchesINV/0412, andDW-88matchesDW/0088/25-26. The GSTIN must agree, so invoice 1047 from two suppliers is never cross-matched. - Cleaned number and value, but a different GSTIN, with dates within 7 days. These are almost always a GSTIN typo in the vendor master and are shown as mismatched, not matched.
Each pair is then compared column by column: within the tolerance it is matched; beyond it, it is a mismatch with the reason. Separately, it flags GSTINs that fail the check digit, ledger heads that suggest blocked credit under section 17(5) (motor car, club, food, gifts, insurance and so on) and rows where the 2B says ITC is not available.
Every books row and every 2B row ends up in exactly one list, and the summary proves it: row counts and totals tie back to both files, and an ITC bridge walks from ITC as per books to ITC as per GSTR-2B.
What it does not do
- It doesn't decide eligibility. A clean match is not proof that ITC is available: check section 16 conditions (invoice in hand, goods received, payment within 180 days), section 17(5), and the time limit in section 16(4).
- It doesn't read amendment sheets, import of goods (IMPG) or ISD credits.
- It is a working aid, not a filing tool. Review the result as you would a junior's working paper.
Try it on practice data first
The free AI for CAs Bonus Pack includes a practice purchase register and GSTR-2B for a made-up company with 15 planted traps, and an answer key. This tool gets every one of them: 348 matched, 3 within tolerance, 5 mismatched, 1 in books only, 2 in 2B only, 1 duplicate and 5 flags, with both files tied out. The GSTR-2B reconciliation guide explains the method, and Chapter 14 of the book shows how to have an AI write the same reconciliation as a script you own and can change.