№024 · GST tools
Merge GSTR-2B Excel files
Keep one running workbook of your GSTR-2B data. Drop your merged file (or start fresh) and the GSTR-2B Excel files from the portal, for any months and states. B2B, B2BA and B2B-CDNR rows come across with the State and GSTR-2B Month filled in; a month you load again replaces its old rows instead of doubling them.
Loading the Excel reader…
How to use GSTR-2B Merger
- 1Optional: choose your existing merged GSTR-2B workbook.
- 2Add the GSTR-2B Excel downloads exactly as they come from the portal, and name the state for each GSTIN once.
- 3Check the state × month grid, then merge and download.
Questions people ask
What if the portal changes the GSTR-2B Excel layout?
Each sheet is checked for the expected columns. If they moved, that sheet is skipped and flagged rather than putting values in the wrong columns.
Do I have to type the state names every time?
No. They are remembered for each GSTIN; signed-in members keep them on their account, so they work on any device.
Are the tax totals shown for checking?
Yes. The IGST, CGST and SGST of B2B invoices are totalled per file so you can tick them against the ITC Available summary on the portal.