Perimattic
Free Tool

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.
Rows of colourful ring binders holding records on office shelves

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.

1

GSTR-2B (B2B invoices)

The Excel file downloaded from the GST portal for the return period, or a CSV with the same columns.

2

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 It Works

How the GST Reconciliation Gap Finder Works

  1. 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. 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. 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.

Guide

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.

FAQ

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.

ERPPlugs

Ready to eliminate manual data entry?

Start a 7-day free trial and see results in 5 minutes. No credit card required. Works with TallyPrime, Zoho, SAP and more.
  • 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.