Verified · 29 Sept 2026
GSTR-2B Reconciliation Tool – Match Purchases
Load your purchase register (CSV) and GSTR-2B (portal JSON or CSV). We match every invoice by supplier GSTIN and invoice number, and tell you what to claim, chase and correct.
✓ Verified against official notifications · 29 Sept 2026 · How we verify →
1. Your purchase register
Export from Tally, Zoho Books or Excel as CSV.
2. GSTR-2B (B2B section)
Download GSTR-2B from the portal as Excel or JSON.
FY 2026-27 · GST 2.0 slabs (5% / 18% / 40%) from 22 Sept 2025 · interest on net cash only (s.50 proviso, CBIC Circular 26/2022)Verify on gst.gov.in →Share on WhatsApp
For estimation only. This calculator applies the rules as we understand them on 29 Sept 2026. It is not legal or tax advice. Verify with the official notification or consult a Chartered Accountant / labour-law professional before filing or changing payroll.
Did this tool give you the right answer?
How to use it
- On the GST portal, open Returns Dashboard, pick the period and download GSTR-2B. The JSON file loads directly. If you prefer Excel, save the B2B sheet as CSV.
- Export your purchase register for the same period as CSV from Tally, Zoho Books or Excel.
- Load both files. If your column headers are unusual, pick the GSTIN and invoice number columns once; the tool remembers them in this browser for next month.
- Review the four buckets and export the result to share with suppliers or your CA.
What each bucket tells you to do
| Bucket | Meaning | Action this month |
|---|---|---|
| Matched | Same GSTIN, invoice number and values in both | Claim the ITC and accept the invoice in IMS |
| Books only | You booked it; the supplier has not reported it | Hold the ITC and send the supplier the list |
| GSTR-2B only | The supplier reported it; you have no entry | Book it if genuine, or reject it in IMS |
| Value mismatch | Found in both, but taxable value or tax differs beyond your tolerance | Claim the lower figure and ask for an amendment |
Why most mismatches are not real
In a typical month, most unmatched rows come from how the invoice number was typed. “INV/2026/045”, “inv-2026-45” and “2026/45” can all be the same bill. The tool upper-cases numbers, strips separators and ignores leading zeros before matching, which clears the first two. The third still needs a human, because the prefix is missing altogether.
The other frequent cause is a wrong GSTIN in your books, often the supplier's branch in another state. The PAN inside both GSTINs is the same, so search the unmatched rows by the middle ten characters to find them.
Setting a tolerance
A tolerance of ₹1 absorbs rounding on individual invoices without hiding real errors. Raise it to ₹10 only if your supplier rounds tax per line item rather than per invoice. Anything larger will mark real differences as matched.
For the full monthly routine, including the IMS steps and the 30 November ITC deadline, read the step-by-step reconciliation guide.
Official sources
Frequently asked questions
Is my data uploaded anywhere?
No. Files are read and matched entirely in your browser. Nothing is sent to our servers unless you choose to save the summary to your dashboard.
How are invoices matched?
On supplier GSTIN plus invoice number. Invoice numbers are normalised — upper-cased, separators removed and leading zeros ignored — so “INV/001” matches “inv-1”.
Can I use a Tally or Zoho export?
Yes. Export the purchase register as CSV. Column headers such as “GSTIN”, “Invoice No”, “Taxable Value”, “IGST”, “CGST” and “SGST” are detected automatically.
What does ‘value mismatch’ mean?
The invoice exists in both, but the taxable value or tax differs by more than your tolerance. Claim the lower figure and ask the supplier to amend.