toolsgstr2b-reco
GSTR-2B reconciler
Purchase register vs 2B, in your browser. Remembers what you already checked.
1 · Purchase register
Tally or Excel export with supplier GSTIN, invoice no, taxable value and tax columns.
2 · GSTR-2B
The Excel downloaded from the GST portal. The B2B sheet is picked automatically.
IN SHORT
Filingo's GSTR-2B reconciler matches a purchase register against GSTR-2B (the portal's Excel or JSON) and sorts every invoice into matched, amount mismatch, probable match, only in books, or only in 2B, with a supplier-wise summary in Excel. It is free and unlimited, handles invoice numbers written in different formats, and runs entirely in the browser, so no invoice data is uploaded.
STEP BY STEP
How it works
- Export the purchase register from Tally or your accounting software to Excel.
- Download GSTR-2B from the GST portal as Excel or JSON and drop both files here.
- Review the five buckets: matched, amount mismatch, probable match, only in books, only in 2B. Download the Excel with a supplier-wise summary.
GOOD TO KNOW
Common questions
- What if the invoice number is written differently in my books?
- Numbers are compared twice: exactly, and then ignoring punctuation and leading zeros, so INV/0012/25-26 matches inv-12-25-26. If the supplier and amounts agree but the number is different, it appears under Probable match.
- Does it handle the portal's Excel as downloaded?
- Yes. It finds the B2B sheet and reads the two-row merged header. If a column is not found you can point to it yourself.
- Is the data uploaded?
- No. Both files are read in your browser. Only if you choose to tick a client on Firm Desk is a one-line note saved, never the invoices.
- Are credit notes included?
- Not yet. Only B2B invoices are compared in this version.