GSTR-2B ⇆ purchase register · free · in-browser
Free GSTR-2B reconciliation tool: find the ITC your 2B is blocking.
Match your purchase register against GSTR-2B and see what is missing, mismatched, or stuck in IMS Pending - with the rupee figure for each.
GSTR-2B
GST Portal → Returns → GSTR-2B. Excel (.xlsx) or JSON.
Purchase register
Zoho Books, Busy ERP, Tally, or any Excel / CSV sheet.
| Bucket | Invoices |
|---|---|
| Likely IMS Pending - ITC blocked | - |
| In books, missing from 2B | - |
| Value mismatch | - |
| In 2B, not in books | - |
| Matched | - |
- 01
Download GSTR-2B for the month from the GST Portal - the Excel or the JSON.
- 02
Export your purchase register from Zoho Books, Busy, Tally or your own sheet.
- 03
Read the report. Five buckets, rupee totals, a supplier-wise list, and a CSV or Excel file for your CA.
How did reconciliation go?
What comes back
Every invoice lands in one bucket. The two totals at the top are the money you can still recover before you file GSTR-3B.
| Bucket | Supplier | Invoice no. | Tax (books) | Tax (2B) |
|---|---|---|---|---|
| E | Shree Vinayak Traders | SVT/2025/0841 | ₹18,000 | - |
| E | Patel Industrial Supplies | PIS-26-00312 | ₹11,340 | - |
| C | Mehta Packaging Works | MPW/0094/25 | ₹9,720 | - |
| B | Rajesh Enterprises | RE-26-1108 | ₹4,500 | ₹4,860 |
| A | Global Tech Components | GTC/2026/0217 | ₹27,000 | ₹27,000 |
| A | Durga Electricals | DE-3344 | ₹5,400 | ₹5,400 |
Six of a few hundred rows. The real report lists every invoice and exports to CSV or Excel.
- E Likely IMS Pending
- The supplier filed GSTR-1, but the invoice is stuck as Pending on your IMS dashboard. ITC is blocked until you accept it and recompute GSTR-2B.
- C Missing from 2B
- In your books, but the supplier GSTIN does not appear in your GSTR-2B at all. The supplier has most likely not filed GSTR-1.
- B Value mismatch
- Found in both files, but the tax differs by more than ₹1, or it sits under a different head (IGST in one file, CGST and SGST in the other). Check the figures before filing GSTR-3B; a wrong head needs the supplier to amend.
- D Only in 2B
- In GSTR-2B but not in your purchase register - a bill to add to your books, or a supplier error to query.
- A Matched
- Invoice number and tax agree within ₹1, head by head (IGST, CGST, SGST, cess) when your register has those columns. The credit is clean to claim in GSTR-3B Table 4A.
Why “Pending” invoices block your input tax credit
Most reconciliation tools lump IMS Pending in with unfiled invoices. This one keeps them apart, because the fix is different.
Under the GST Invoice Management System, invoices filed by your suppliers in GSTR-1 flow to your IMS dashboard. Marking an invoice Pending feels neutral - it is not. Pending invoices are left out of your GSTR-2B and do not auto-populate Table 4A of your GSTR-3B. The credit stays blocked until you act.
How each IMS action flows through
| Your action on IMS | In GSTR-2B? | ITC |
|---|---|---|
| No action (default) | Yes - deemed accepted | Available in Table 4A |
| Accepted | Yes | Available in Table 4A |
| Pending | No | Blocked |
| Rejected | No | Not claimed; supplier is notified |
To unblock the ITC in bucket E
- Log in to the GST Portal at
gst.gov.in. - Go to Services → Returns → Invoice Management System (IMS) Dashboard.
- Find the invoices flagged in bucket E (filter by supplier GSTIN).
- Check the goods or services were received, then change the status to Accept.
- Click Recompute GSTR-2B before filing GSTR-3B. The ITC then auto-populates Table 4A.
This tool can only flag invoices that are absent from the GSTR-2B you downloaded. IMS Pending is the most common reason, but a supplier who has not filed is also possible - confirm on your live IMS dashboard before you decide anything.
Full guide: IMS Pending and how to unblock ITC →How GSTR-2B reconciliation protects your business ITC
Reconcile purchase registers against GSTR-2B before filing GSTR-3B to prevent mismatch notices and claim full eligible tax credit.
Under Section 16(2)(aa) of the CGST Act and Rule 36(4), you can only claim Input Tax Credit (ITC) that appears in your auto-generated Form GSTR-2B. When a vendor delays filing GSTR-1, your credit gets blocked. This free browser tool cross-checks your purchase register against GSTR-2B to catch discrepancies before filing.
What this reconciliation tool does
The tool matches purchase transactions against GSTR-2B into five buckets:
- Matched (Bucket A): Invoices where GSTIN, invoice number, and tax agree within one rupee. Safe for GSTR-3B Table 4(A)(5).
- Value mismatch (Bucket B): Invoices with tax differences or wrong tax heads (IGST instead of CGST/SGST).
- Missing from GSTR-2B (Bucket C): Purchases in your books where the vendor has not filed GSTR-1.
- Only in GSTR-2B (Bucket D): Invoices filed by vendors that are missing from your books.
- Likely IMS Pending (Bucket E): Invoices filed by vendors but marked Pending on your IMS dashboard.
It computes rupee ITC at risk, groups missing credits by vendor, formats follow-up notes, and exports working papers to Excel or CSV.
Who this tool is for
Built for tax accountants, finance teams, and business owners reconciling monthly purchase registers against GSTR-2B before filing GSTR-3B. Whether using Tally Prime, Zoho Books, Busy ERP, or spreadsheets, it runs without software installs or logins.
How to use it in 4 quick steps
- Download GSTR-2B from GST Portal: Download your GSTR-2B in Excel or JSON format from gst.gov.in. See our GSTR-2B generation timeline guide for cut-off dates.
- Export purchase register: Export your register from your accounting software. If using Tally, see our Tally Prime reconciliation guide, or use standard exports from Zoho Books and Busy ERP.
- Drop files into the tool: Select or drop both files above. Matching runs entirely in your browser. Your spreadsheets never leave your device.
- Review matched invoices and export: Check missing bills, copy follow-ups, and export using our GSTR-2B reconciliation Excel format. Read how to use a GSTR-2B reconciliation tool.
Frequently asked questions
- Does my data get uploaded to any server?
- No. File parsing and invoice matching run entirely inside your browser. Spreadsheets never leave your device.
- Can I upload GSTR-2B Excel directly, or do I need JSON?
- You can use either. The tool accepts standard GSTR-2B Excel (.xlsx) downloads from the GST Portal as well as JSON exports.
- Does this tool work with Zoho Books and Busy exports?
- Yes. It automatically detects column headers from Zoho Books and Busy ERP, and supports custom column mapping for Tally.
- What is the difference between GSTR-2A and GSTR-2B?
- GSTR-2A is dynamic, while GSTR-2B is static and governs ITC claims under Section 16(2)(aa). See our guide on GSTR-2A vs GSTR-2B differences.
- How does this compare to desktop software?
- Paid software requires subscriptions and complex setup. This tool provides instant reconciliation without installation. See our GSTR-2B reconciliation software guide.