Business
GSTR-2B Reconciliation
Match your purchase register against GSTR-2B — the portal’s JSON or Excel — and see which input tax credit is safe to claim, which suppliers have not filed, what is in 2B but not in your books, and where the tax amounts differ. Runs in your browser; nothing is uploaded.
Privacy
Your file never leaves your device. It is read and converted by your own browser, so nothing is uploaded, queued or logged — which is what makes this safe for a client’s books.
Tips
- Download GSTR-2B from the portal as JSON (Returns → GSTR-2B → Download → Generate JSON) — it carries everything, including credit notes. The Excel download works too.
- The purchase register can be any spreadsheet with a supplier GSTIN, an invoice number, a date and the tax amounts; columns are matched by name and can be corrected.
- Invoice numbers are compared loosely: INV/2026/0417, inv-2026-0417 and 0417 are treated as the same document, and a date within five days is tolerated. The tolerance on tax is one rupee.
- "Only in books" is the sheet that costs money: those suppliers have not filed, so the credit is not available until they do. Chase them before the 3B is due.
- "Only in 2B" is credit you are entitled to and have not recorded — a missing purchase entry, or an invoice that went to a different branch.
Frequently asked questions
Which GSTR-2B formats are read?
The JSON the portal generates (with B2B, B2BA, CDNR and CDNRA sections) and the Excel it offers, using the B2B sheet. Credit notes reduce the supplier’s total and are matched separately.
How does matching work?
First on supplier GSTIN plus a normalised invoice number. Then, for what is left, on GSTIN plus the numeric tail of the invoice number with the date within five days and the taxable value within a rupee — which catches INV-0417 against 417. Anything still unmatched is reported on the side it appears.
Is the result the ITC I can claim in 3B?
The Matched sheet is the credit that is both in your books and filed by the supplier, which is the condition for claiming it. Whether a particular line is eligible — blocked credit under section 17(5), reverse charge, personal use — is still your call and your CA’s; the tool reconciles, it does not adjudicate.
Is any of this uploaded?
No. Both files are read and compared by your own browser, and the report is written there too. Nothing leaves your device.