Automatic GSTR-2B Consolidation Tool in Excel

Automatic GSTR-2B Consolidation Tool in Excel – One-Click Data Merge for Multiple Files

This Automatic GSTR-2B Consolidation Tool in Excel enables tax professionals and article trainees to merge multiple GSTR-2B Excel files instantly. By placing all downloaded files in one folder and entering the path into the tool, users can consolidate data across sheets, eliminate duplicates, and generate summary reports—all within seconds. Follow the simple procedure below to get started:

Steps to Use Automatic GSTR-2B Consolidation Tool in Excel:

1. Download GSTR-2B Excel files from the GST Portal.

2. Save all downloaded GSTR-2B Excel files in a single folder.

3. The tool can open multiple files—even from different GSTINs—consolidate the data into respective sheets, and generate a summarized report.

Important Notes for use of Automatic GSTR-2B Consolidation Tool in Excel:

1. Do not change the default name format of the downloaded GSTR-2B files (Format: MMYYY_GSTIN_DDMMYYY).

2. The tool will automatically ignore duplicate files.

Instructions for Using the Automatic GSTR-2B Consolidation Tool in Excel

1. The tool will not work in older versions of Excel. It has been tested in Excel 2019, 2021, and Office 365.

2. Save only the GSTR-2B Excel files to be consolidated in a separate folder.

3. Copy the folder path using Alt + D, then Ctrl + C, and paste it into the yellow cell C2 using Ctrl + V.

4. Click the “GSTR-2B” button or use Refresh All (Ctrl + Alt + F5) to consolidate the data.

5. The key feature of this tool is its speed — it consolidates data from all sheets within seconds.

(Republished with amendments)