GST Reconciliation Gap Finder
The GST Reconciliation Gap Finder compares your GSTR-2B Excel file with your purchase register, invoice by invoice, on supplier GSTIN and invoice number. You get matched invoices, value mismatches, probable matches, invoices missing in GSTR-2B (ITC at risk) and invoices missing in your books, with a supplier-wise follow-up list and an Excel report. It runs in your browser, so the files are never uploaded.
Use the free tool
Your files stay on your device. Everything is processed in your browser. Nothing is uploaded to ERPPlugs or anyone else, and no account is needed.
GSTR-2B (B2B invoices)
The Excel file downloaded from the GST portal for the return period, or a CSV with the same columns.
Purchase register from your books
Exported from TallyPrime, Zoho Books, Busy or Excel for the same period, one row per bill.
Differences up to the tolerance count as matched. The date window is used only when invoice numbers differ but the supplier and amount agree.
Add both files to see the reconciliation. No files handy? Click Use sample data in each box.
How the GST Reconciliation Gap Finder Works
- 1
Add your GSTR-2B and purchase register
Drop the GSTR-2B Excel file from the GST portal and your purchase register exported from TallyPrime, Zoho Books, Busy or Excel. Columns are detected automatically, including the two-row headers in the GSTR-2B file, and you can correct any column before matching.
- 2
Invoices are matched in your browser
Each bill is matched on supplier GSTIN plus invoice number, ignoring slashes, dashes, spaces and leading zeros. Leftovers get a second pass for invoice numbers typed differently, or the same supplier and amount within a few days, and are marked as probable matches for you to confirm.
- 3
Review the gaps and download the report
See ITC at risk, ITC in GSTR-2B that is not in your books, a supplier-wise list of whom to chase, and every invoice with the exact fields that differ. Download a multi-sheet Excel workbook or a CSV.
How to Reconcile GSTR-2B With Your Purchase Register
Get the two files ready
Download GSTR-2B for the month from the GST portal as an Excel file. Keep it as it is: the tool finds the B2B sheet and its two header rows on its own.
Export your purchase register for the same month. In TallyPrime, the purchase register can be exported to Excel; in Zoho Books or Busy, use the purchase or bills report. Make sure the export shows the supplier’s GSTIN and the supplier’s own invoice number, not only your internal voucher number.
- One row per bill works best. If your export lists tax by rate in several columns (for example IGST 12% and IGST 18%), add a total tax column and map it under "Total tax".
- Use "Check columns" under each file to confirm which column was picked for each field.
How to read the results
Start with the supplier-wise summary. It is sorted by ITC at risk, so the suppliers to call first are at the top, with the next step for each.
- Missing in GSTR-2B: the supplier has not reported the invoice in GSTR-1, or reported it with a different number or GSTIN. Ask them to file or correct it. If the note says the invoice was entered twice, remove the extra entry instead.
- Value mismatch: both sides have the invoice but taxable value or tax differs by more than the tolerance. The detail column shows each field and the difference.
- Probable match: likely the same invoice with a typing difference. Confirm and correct the invoice number or GSTIN in your books.
- Missing in books: the supplier reported an invoice you have not recorded. Check whether the bill was received and post it if it is genuine.
What this tool does not cover
It compares B2B invoices only. Credit and debit notes, amendments, import of goods and reverse charge eligibility are not checked separately, and it does not decide whether a credit is blocked under the GST law. Treat the output as a working list for your accountant or CA.
Frequently Asked Questions
Two files for the same return period. First, the GSTR-2B Excel file downloaded from the GST portal; the tool reads the B2B invoices sheet. Second, your purchase register with one row per bill, showing supplier GSTIN, supplier invoice number, date and either taxable value with IGST, CGST and SGST, or a total tax column. Excel (.xlsx) and CSV both work. Old .xls files need to be saved as .xlsx first.
Log in to the GST portal, open the Returns Dashboard, choose the financial year and month, and open GSTR-2B. From there you can download the statement as an Excel file. GSTR-2B is generated monthly, so download the period that matches the purchase register you are checking.
It first looks for the same supplier GSTIN and the same invoice number after removing spaces, slashes, dashes and leading zeros, so INV/0045/26-27 and INV-45/26-27 match. For invoices left over, it checks the same GSTIN with a similar invoice number, or the same GSTIN and amount with dates a few days apart, and the same invoice number and amount under a different GSTIN, which usually means a typo in the GSTIN. Those are shown as probable matches, never as confirmed ones.
The tolerance is the rupee difference ignored when comparing taxable value, IGST, CGST, SGST, cess and invoice value. It is ₹1 by default, so rounding differences do not show up as mismatches. You can raise or lower it, and the results update immediately.
It is the tax on invoices in your purchase register that do not appear in GSTR-2B, plus the extra tax you have booked where your books show more tax than GSTR-2B. Under the GST rules, ITC is generally available only when the invoice appears in GSTR-2B, so these are the suppliers to follow up with before you claim the credit.
No. The files are read and matched by JavaScript in your browser. Nothing is sent to ERPPlugs or any other server, and no sign-up is needed. Closing the tab clears the data.
Ready to eliminate manual data entry?
- Free consultation
- No commitment
- Tailored to your team
All product names, logos, and brands mentioned on this site are the property of their respective owners. ERPPlugs is not affiliated with, endorsed by, or sponsored by any of the third-party companies referenced. Use of these names is for identification purposes only and does not imply any association or endorsement.