Merge GSTR-2B
Upload as many months of GSTR-2B as you have across one or more financial years and this tool merges every invoice, credit/debit note, ISD credit, and import document into one downloadable Excel workbook, sorted chronologically and split into Regular ITC, RCM ITC, ISD ITC, and Import ITC sheets.
Upload your GSTR-2B files
Do not rename the files; the tool reads the period directly from each file's own "Read me" sheet, not the filename.
Drag & drop GSTR-2B Excel files here
or click to browse · .xlsx only · multiple files supported
Merge summary
| Sheet | Documents | Integrated Tax (₹) | Central Tax (₹) | State/UT Tax (₹) | Cess (₹) |
|---|
Verify against your ITC comparison file
Upload the "Tax liability and ITC Comparison" file you can download from the GST portal, and this tool will check your merged totals against GSTN's own figures where a like-for-like comparison exists.
Drag & drop the ITC comparison Excel file here
or click to browse · .xlsx only · one file
Comparison with GSTN's ITC comparison file
| Check | Integrated Tax (₹) | Central Tax (₹) | State/UT Tax (₹) | Cess (₹) |
|---|
Amended invoices are netted into their original period before this comparison runs, so a supplier amendment won't show up as a false mismatch here.
If you still see a difference above, a common cause is timing: GSTR-2B is regenerated on demand and can reflect supplier amendments made after your ITC comparison file was last generated. For an exact match, re-download both files on the same day.
What this GSTR-2B merge tool does
Merge multiple months GSTR 2B
Upload GSTR-2B Excel files for as many months as you have — across one or more financial years — and get one combined workbook back.
Split by ITC category
Unlike a plain file combiner, this tool separates every document into Regular ITC, RCM ITC, ECO ITC, ISD ITC, and Import ITC — the same categories GSTN itself uses — so your data is ready to use, not just stacked together.
Proper handling of Amendment Invoices in GSTR 2B
When a supplier amends an invoice, this tool replaces the original with the corrected figures automatically, so amended invoices are never counted twice.
100% browser-based
Everything runs on your own device. Your files are never uploaded to any server.
Uses of this tool
GSTR-2B is your auto-drafted statement of input tax credit, generated from what your suppliers have filed. Since the GST portal only lets you download one month at a time, reconciling ITC for a full financial year means manually opening and combining up to 12 separate files. This tool does that for you:
- Merge GSTR-2B for a full financial year, or any custom range of months, into one file
- See every invoice, credit/debit note, ISD credit, and import document in one place, correctly categorized
- Get amended invoices automatically corrected — no manual cross-checking against prior months
- Prepare a clean, invoice-wise ITC register for GSTR-9/9C working papers, without spreadsheet formulas
How to use the Merge GSTR 2b tool
- Download your GSTR-2B Excel file for each month you need from the GST portal (see steps below).
- Drag and drop all your downloaded files into the upload box above — file names and upload order don’t matter.
- The tool reads each file’s own period automatically and shows you what it found.
- Click “Download merged GSTR-2B” to get one Excel file with all five ITC-category sheets.
How to download GSTR-2B Excel files from the GST portal
- Log in to the GST portal and go to Returns Dashboard.
- Select the financial year and month, then choose GSTR-2B.
- Click “Download Excel” — the file is generated and ready to download.
- Repeat for each month you need, then upload them all here together.
Frequently asked questions
Is this tool free?
Yes — no sign-up, no limits. Everything runs in your browser, so your GSTR-2B data is never uploaded to any server.
How is this different from just combining files in Excel?
This tool doesn’t just stack rows — it categorizes every document into Regular, RCM, ECO, ISD, or Import ITC automatically, and nets amended invoices against their originals so figures aren’t double-counted.
Can I merge GSTR-2B across two financial years?
Yes. Upload files from any months you have, regardless of financial year, and the tool merges them chronologically.
What happens to amended invoices?
When a supplier amends an invoice, the corrected figures replace the original automatically, with a flag showing when it was amended — so nothing is counted twice.
Is my GSTR-2B data safe?
Yes. All processing happens locally in your browser. Nothing is uploaded to or stored on any server.
Can this tool merge GSTR-2B JSON files too?
No — this tool works with the GSTR-2B Excel format downloaded from the portal.
