Follow Us:

Instructions to consolidate GSTR-2A

1. You can use this tool by using Microsoft Excel version 2016, 2019, 2021 or Office 365

2. Save only GSTR-2A Excel workbooks without changing Name i.e.,(GSTIN_MMYYYY_R2A.Xlsx) on your computer but not on google drive,one drive, etc.

3. Copy that folder location (alt+d)(ctrl+c) then paste this on yellow cell then click on GSTR-2A To consolidate first 5 GSTR-2A in a folder

Access Denied! Only Regstered Users Can Download The File "GSTR-2A Consolidation Tool". Register Here or Login

Author Bio

⮚ Developed multiple automation tools and authored professional articles across GST, Income Tax, and Customs domains, collectively exceeding 200,000+ views on TaxGuru contributing to knowledge-sharing and process efficiency within the CA community ⮚ Designed and implemented automati View Full Profile

My Published Posts

Automatic GSTR-2B Consolidation Tool in Excel BOE pdf to Excel (HSN wise) Conversion and consolidation tool 26AS text to Excel Converter Tool GSTR-2A/2B vs Books Reconciliation Tool TDS payment challan PDF to Excel conversion and consolidation Tool View More Published Posts

Join Taxguru’s Network for Latest updates on Income Tax, GST, Company Law, Corporate Laws and other related subjects.

4 Comments

    1. Gadamsetty manideepak says:

      Hi sir,
      Make sure all the following below mentioned points before using this tool

      1.EXCEL version shall be 2016,2019,2021or office 365

      2.save all excel workbooks in a separate folder in desktop not in cloud (eg.google drive,one drive,e.t.c.,)

      3. Copy that folder location (alt+d)(ctrl+c) then paste this on yellow cell then click on GSTR-2A
      To consolidate first 5 GSTR-2A in a folder

Leave a Comment

Your email address will not be published. Required fields are marked *

Sponsored
Ads Free tax News and Updates
Search Post by Date
January 2026
M T W T F S S
 1234
567891011
12131415161718
19202122232425
262728293031