Index

How to Download GSTR 2A in Excel from GST Portal - Step-by-Step Guide

Q: How do I get my GSTR 2A summary?

Log in to the GST portal, go to the 'Returns Dashboard, select the relevant tax period, and download the GSTR-2A summary from the auto-drafted information section for GSTR-2A summary download.

Q: How to open GSTR-2A json file in excel?

Upload the JSON file to an online JSON-to-Excel converter or use offline utility software compatible with Excel 2010 and above to convert and then open it in Excel for opening a GSTR-2A JSON file in Excel.

Q: How do I download GSTR-2B in Excel for full year?

Use platforms like Clear GST by selecting your GST number, the relevant period, download data from the GST portal, and then export the yearly report in Excel format for downloading GSTR-2B in Excel for the full year.

Q: How to download all GST returns filed at once?

To download all GST returns filed at once, use Clear GST solution to automate downloading GSTR-2A in Excel simultaneously from the GST portal.

By AJ

GSTR-2A is a dynamic auto-drafted statement of input tax credit (ITC). It reflects all the purchases made by a taxpayer during a particular period, as filed by its suppliers. The details appearing in GSTR-2A are auto-populated from the GSTR-1 filed by all the suppliers of a taxpayer. Currently, a taxpayer can download GSTR-2A month-wise only and where there are more than 500 invoices in GSTR-2A.

The GST registered businesses must reconcile GSTR-2A and the purchase data to claim the maximum eligible Input Tax Credit (ITC). A taxpayer has to reconcile the downloaded GSTR-2A data with their purchase data manually, which is time-consuming. Instead, using a automated reconciliation software or tool will make this task easier.

Step-by-Step Process to Download GSTR-2A in Excel Format

Step 1: Log in to the GST portal with your username and password.

Step 2: After logging, select ‘Returns Dashboard’ as shown below.

Step 3: Select the month & financial year for which you want to download GSTR-2A in excel. Click on the ‘Download’ tab appearing in the ‘Auto Drafted details’ box.

Step 4: On the screen that appears, click on the button- ‘Generate excel file to download’ to download the file in excel format.

Alternatively, click on the button “Generate JSON file to download” to download the file in JSON format. Once you select this option, the portal will take around 20 mins to process your request for GSTR-2A in excel.

Step 5: Once processed, you will see a link ‘Click here to download Excel – File 1’ right below the button ‘Generate excel file to download’. Click on this to download the file.

Step 6: The requested file will be downloaded from the portal in a zipped folder. Make sure that your system has .rar,.zip software to unzip the file. Lastly, unzip the excel file to use GSTR-2A data.

How Does Clear Help?

Clear GST software comes with an inbuilt feature of advanced reconciliation, enabling you to download GSTR-2A data across different months or for an entire year in a single click. It has the intelligence to auto-identify matches between purchase registers and GSTR-2A to suggest matches. You can define your own customer matching rules and error tolerance to identify ‘invoice match’. Also, you can eliminate filing errors and save your money with our GST platform that is 3x faster and detects 100% ITC with AI-powered reconciliations.

Matching & Reconciliation under GST – Importance & Procedure

Guide to reconcile GSTR 2A and Purchase data using ClearTax Advanced Recon tool

Comparison of GSTR-3B vs GSTR-2A : Importance & Report