Upload GSTR-2B Excel files for as many months as you have, across one or more financial years. Every invoice, credit / debit note, ECO, ISD and import document is merged into one workbook, sorted chronologically and split into Regular, RCM, ECO, ISD and Import ITC. Supplier amendments (B2BA, CDNRA, ECOA, ISDA) replace the original document so nothing is counted twice. Processed entirely in your browser — no data is uploaded to any server. Free tool by CA Jatin Karda & Co., Nagpur.
or click to select one or more .xlsx files from your computer
Browse Files| # | File Name | Period | Status |
|---|
The GST portal lets you download only one month of GSTR-2B at a time. This tool combines any number of monthly files into one workbook, categorised the way GSTN categorises ITC, so it is ready for invoice-wise ITC registers and GSTR-9 / 9C working papers.
| Sheet | Source tables | Contents |
|---|---|---|
| Summary | All | Document count and tax totals per sheet, files read, checks |
| Regular ITC | B2B, B2BA, B2B-CDNR, B2B-CDNRA | Invoices and notes where reverse charge = No |
| RCM ITC | B2B, B2BA, B2B-CDNR, B2B-CDNRA | Invoices and notes where reverse charge = Yes |
| ECO ITC | ECO, ECOA | Documents reported by e-commerce operators u/s 9(5) |
| ISD ITC | ISD, ISDA | Credit distributed by Input Service Distributors |
| Import ITC | IMPG, IMPGSEZ | Bills of entry (imports and SEZ) |
| Amendment Log | B2BA, CDNRA, ECOA, ISDA, IMPG | Every replacement: original vs revised tax, and whether the original was found |
| Files Read | — | Period detected and tables merged for each file |
When a supplier amends a document, the portal shows the revised details against the original. The tool finds the original in your uploaded months (supplier GSTIN + document number + date), removes it and keeps the revised document in the original month, flagged with the month of amendment. If the original month was not uploaded, the revised figures are kept as reported and the row is flagged so you can check it.
Can I merge JSON files? No — only the Excel format downloaded from the portal is supported.
Does it work across financial years? Yes. Upload any months; they are merged chronologically.
Is my data safe? Yes. Nothing is uploaded or stored; everything runs in your browser.
Why do totals differ from the portal comparison report? GSTR-2B is regenerated on demand, so supplier amendments made later can change figures. Re-download all files on the same day for an exact comparison.