Follow this step-by-step guide to download GSTR-2A in Excel from the GST Portal. Essential for reconciling ITC and verifying supplier filings.
GSTR-2A is an automatically generated statement containing input tax credit (ITC) information. This statement shows all purchases made by a taxpayer in a specific period, based on filings from their suppliers. The data in GSTR-2A is automatically populated from the GSTR-1 returns submitted by these suppliers. Currently, taxpayers can only download GSTR-2A on a monthly basis, or if it contains more than 500 invoices. Businesses registered under GST should reconcile their GSTR-2A data with their purchase records to claim the full eligible ITC. Manual reconciliation of GSTR-2A with purchase data can be time-consuming; an automated reconciliation tool can simplify this process.
Steps for Downloading GSTR-2A in Excel Format
Step 1: Access the GST portal using your assigned username and password to log in.
Step 2: After a successful login, navigate to and select the ‘Returns Dashboard’ option.
Step 3: Choose the specific month and financial year for which you intend to download the GSTR-2A in Excel format. Then, locate and click the ‘Download’ tab, which is found within the ‘Auto Drafted details’ section.
Step 4: On the subsequent screen, click the ‘Generate excel file to download’ button to initiate the download in Excel format. Alternatively, you can select the ‘Generate JSON file to download’ button to obtain the file in JSON format. If the Excel option is chosen, the portal may take approximately 20 minutes to process your request.
Step 5: Once the processing is complete, a link titled ‘Click here to download Excel, File 1’ will appear directly below the ‘Generate excel file to download’ button. Click this link to download your file.
Step 6: The requested file will be downloaded from the portal as a zipped folder. Ensure your system has software compatible with .rar or .zip files to decompress it. Finally, unzip the Excel file to access and use your GSTR-2A data.
Need help with GST filing & compliance?
FylFlix experts file your GST returns accurately, claim 100% of eligible ITC and keep you penalty-free — CA-led, AI-reconciled.
Frequently Asked Questions
To view your GSTR-2A summary, log into the GST portal, go to the ‘Returns Dashboard,’ select the relevant tax period, and access the summary from the auto-drafted information section.
To open a GSTR-2A JSON file in Excel, you can upload it to an online JSON-to-Excel converter or use an offline utility compatible with Excel 2010 or newer versions for conversion.
For downloading GSTR-2B in Excel for an entire year, use the GST portal to select your GST number and the relevant period, then download the data and export the yearly report in Excel format.
To download all GST returns filed simultaneously, use the GST portal’s functionalities to download individual returns for the desired period.
FAQs on Downloading GSTR-2A
- What is GSTR-2A?
An auto-generated statement of Input Tax Credit on your purchases, populated from your suppliers’ GSTR-1 filings. Reconcile it with your purchase records to claim full ITC – see our guide on ITC discrepancies and DRC-01C. - How do I download GSTR-2A in Excel?
Log in to the GST portal, open the Returns Dashboard, select the month and year, go to Auto-drafted details, click Download, choose ‘Generate excel file to download’, then download and unzip the file. - How long does the Excel download take?
The portal can take around 20 minutes to process an Excel request; a ‘Click here to download’ link appears once it is ready. - Can I download GSTR-2A in JSON instead of Excel?
Yes. Choose ‘Generate JSON file to download’ and convert it to Excel using an online converter or an offline utility (Excel 2010 or newer). - How often can GSTR-2A be downloaded?
On a monthly basis, or when it contains more than 500 invoices.
