100% Free · No sign-up · Unlimited use

GSTR-2B Reconciliation Tool

Match your GSTR-2B against the purchase register to claim accurate ITC. Exact and probable invoice matching, instantly, right in your browser.

2B vs purchasesProbable matchesSupplier-wise viewExport to Excel

Updated August 2026

Import GSTR-2B

📁

Drag and drop files here, or click to select files

Only .json files are accepted

Import GSTR-2

📁

Drag and drop files here, or click to select files

Only .json and .xlsx files are accepted

Found this useful? Share it

What this GSTR-2B reconciliation tool does

2B vs purchases

Match GSTR-2B against your purchase register, invoice by invoice, for accurate ITC.

Probable matches

Exact invoice matching first, then partial matching to catch near matches automatically.

Export to Excel

Download matched, probable and unmatched entries as a clean Excel workbook.

Private & browser-only

All reconciliation runs locally in your browser — files are never uploaded to a server.

What this tool does

GSTR-2B is the static ITC statement and the basis for your input tax credit claim — this tool matches it against your purchases. It is generated on the 14th of each month on the official GST portal. Download the GSTR-2 Excel format.

  • Match GSTR-2B against GSTR-2 (purchases, credit & debit notes) to verify ITC.
  • Exact invoice matching first, then partial matching — e.g. VCRPL/23-24/326 in 2B matches 326 in purchases for the same GSTIN.
  • Matched data is shown in green, while unmatched data is shown in red.

How to use the tool

  1. 1Upload the JSON file(s) in the GSTR-2B section. You can upload more than one file.
  2. 2Upload the JSON or XLSX file(s) of your purchases in the GSTR-2 section. You can upload more than one file.
  3. 3Use the dropdown of 5 views: All Entries, Present in both, Probable Matches, Only in GSTR-2, or Only in GSTR-2B.
  4. 4Group by Supplier GSTIN or see a total summary.
  5. 5Filter by party from the dropdown, or by clicking any GSTIN in the supplier-wise view.
  6. 6Search by invoice number, GSTIN, amount or any other field.
  7. 7Click the Download Excel button to export the reconciliation.

How to download GSTR-2B JSON files from the GST portal

  1. 1Log in to the GST portal.
  2. 2Click on Return Dashboard.
  3. 3Select financial year, quarter and then month. To download the JSON for the whole quarter, select the last month of the quarter.
  4. 4Click the download button in the GSTR-2B section. If you selected the last month of the quarter, choose the required month or quarter section.
  5. 5Click "Generate JSON file to Download". The JSON file is generated and available for download within about 20 minutes. To download several JSON files at once, use a Chrome extension like TaxTribute GST Assistant or XLSDeal.

Frequently asked questions

What is GSTR-2B reconciliation?

GSTR-2B reconciliation is the process of matching your auto-drafted GSTR-2B statement against your purchase register, invoice by invoice. It confirms which purchases your suppliers have reported so you claim the correct input tax credit (ITC).

Why match GSTR-2B with purchases for ITC?

GSTR-2B is the static ITC statement and is the basis for claiming input tax credit. Matching it with your purchases ensures you claim ITC only for invoices that appear in 2B, and helps you follow up with suppliers on invoices that are missing or mismatched.

Does the tool show partial or probable matches?

Yes. The tool first matches on the exact invoice number, then does partial matching. For the same GSTIN, if an invoice is VCRPL/23-24/326 in GSTR-2B but only 326 in your purchases, it is still matched and shown under probable matches.

What file formats can I upload?

Upload the GSTR-2B JSON file downloaded from the GST portal, and your purchase register as JSON or XLSX. You can upload multiple files in each section, and download the GSTR-2 Excel format to structure your purchase data.

Is my GSTR-2B data safe?

Yes. All reconciliation happens locally in your browser. Your GSTR-2B and purchase files are never uploaded to or stored on any server, so your data stays private.

Can I export the reconciliation result to Excel?

Yes. After matching, click the Download Excel button to export the full reconciliation — matched, probable and unmatched entries — into an Excel workbook for your records or further review.

Can I claim ITC on a purchase invoice that is not in GSTR-2B?

Generally no. Under Rule 36(4), input tax credit can be claimed only on invoices that appear in your GSTR-2B. If a purchase invoice is missing, follow up with the supplier to report or amend it, then run the reconciliation again.

How do I match GSTR-2B with the purchase register in Excel?

Export your purchase register to Excel with the supplier GSTIN, invoice number, invoice date, taxable value and tax amounts, and download the GSTR-2 Excel format here if you need the column structure. Upload that workbook in the GSTR-2 section and your GSTR-2B JSON in the GSTR-2B section. The tool matches invoice by invoice and lists matched, probable and unmatched entries, which you can export back to Excel.

How do I reconcile GSTR-2B with books or Tally data?

Export the purchase register from Tally or your accounting software as an Excel file, arrange it to the GSTR-2 Excel format available here, and upload it alongside the GSTR-2B JSON. Matching runs on supplier GSTIN and invoice number, with partial matching for invoices your books record under a shortened number, so a Tally entry of 326 still matches VCRPL/23-24/326 in GSTR-2B.

How do I download a quarterly GSTR-2B?

GSTR-2B is generated monthly, including for taxpayers under the QRMP scheme — there is no single quarterly file. Download the statement for each of the three months from Returns Dashboard on the GST portal, then upload all three JSON files together in the GSTR-2B section here to reconcile the full quarter in one pass.

For CA & tax firms

Reconciling GSTR-2B across a full client book?

Reconciling one client here takes a minute. Finexo PMS is what keeps the other hundred and ninety-nine on schedule — every ITC task created, assigned and tracked to completion.

  • Monthly ITC and reconciliation tasks per client, auto-created
  • Assign to staff and track status in real time
  • Chase missing purchase registers over WhatsApp in bulk
  • Billing linked to completed reconciliation work
See Finexo PMS

Free trial · No card needed