Loading...
Loading...
If you're spending hours every month matching invoices in Excel, this tool is for you. Upload your GSTR-2B and purchase register — we'll find every mismatch in seconds.
Since January 2022, ITC claims are restricted to what's available in GSTR-2B. That means if your supplier files their GSTR-1 late, the invoices don't show up in your GSTR-2B — and you can't claim that ITC until next month when they file.
The problem is that most businesses have hundreds or thousands of invoices per month. Manually matching them against GSTR-2B in Excel takes 5-10 hours for a mid-size business, more for larger ones. And if you miss a mismatch, you either lose valid ITC or claim excess — both create problems.
This tool does the matching in seconds. Upload both files and get a categorized list of: matched invoices, invoices in your books but missing from GSTR-2B, and invoices in GSTR-2B not in your books.
Your purchase register CSV should have these columns. Export from your accounting software or prepare manually:
| Column Name | Format | Example |
|---|---|---|
| Supplier GSTIN | 15-char text | 27AAAAA0000A1Z5 |
| Invoice Number | Text | INV-2024-001 |
| Invoice Date | DD/MM/YYYY | 15/03/2025 |
| Invoice Value (₹) | Number | 118000 |
| Taxable Value (₹) | Number | 100000 |
| IGST (₹) | Number | 18000 or 0 |
| CGST (₹) | Number | 9000 or 0 |
| SGST (₹) | Number | 9000 or 0 |
Matched Invoices
Invoice present in both GSTR-2B and your purchase register with matching values. ITC can be safely claimed for these.
In Your Books, Not in GSTR-2B
Your supplier hasn't uploaded this invoice in their GSTR-1 yet. You cannot claim ITC this month. Follow up with the supplier to file their returns.
In GSTR-2B, Not in Your Books
Supplier has filed this invoice in their GSTR-1 but you haven't recorded it in your purchase register. Verify if this is a genuine purchase — could be a credit note situation.
Value Mismatch
Invoice present in both but the amounts differ. Could be a data entry error. Verify the original invoice and correct either your register or raise dispute with supplier.
Download GSTR-2B from GST Portal
Login to gst.gov.in → Returns Dashboard → Select month → GSTR-2B → Download as Excel → Save as CSV.
Export your Purchase Register
From Tally, Zoho, QuickBooks or your accounting software, export the purchase register for the same month as CSV.
Upload Both Files Here
Upload purchase register in the left box and GSTR-2B in the right box. The tool reads them in your browser — nothing goes to any server.
Click Reconcile
The tool matches invoices by GSTIN + Invoice Number. Results show matched, missing, extra, and mismatched invoices.
Act on Mismatches
For missing invoices: follow up with suppliers. For extra credits: verify they are genuine. For value mismatches: check original invoices.