Complete GST lifecycle on one platform Complete GST lifecycle on one platform
Hyper-automation Hyper-automation
Smart reports & recon Smart reports & recon
Accurate filing Accurate filing

Guide to Download GSTR 2A in Excel

By AJ

|

Updated on: Dec 23rd, 2023

|

3 min read

social iconssocial iconssocial iconssocial icons

GSTR-2A 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.
 

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 recon 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.

GSTR 2A

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

gstr 2a

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.
 

gstr 2a

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.

gstr 2a

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.
 

gstr 2a

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.
 

Related Articles

GSTR 2A : Details, Return Filing, Format

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

About the Author

DVSR Anjaneyulu, known by the name AJ, I've got a vast experience in accounting, finance, taxes and audit. I'm always keen to simplify laws for the readers and learn about the Indian finance ecosystem. I also love listening to music, travelling, and, most importantly, conversing with people to better understand the world.. Read more

CONTENTS

Clear offers taxation & financial solutions to individuals, businesses, organizations & chartered accountants in India. Clear serves 1.5+ Million happy customers, 20000+ CAs & tax experts & 10000+ businesses across India.

Efiling Income Tax Returns(ITR) is made easy with Clear platform. Just upload your form 16, claim your deductions and get your acknowledgment number online. You can efile income tax return on your income from salary, house property, capital gains, business & profession and income from other sources. Further you can also file TDS returns, generate Form-16, use our Tax Calculator software, claim HRA, check refund status and generate rent receipts for Income Tax Filing.

CAs, experts and businesses can get GST ready with Clear GST software & certification course. Our GST Software helps CAs, tax experts & business to manage returns & invoices in an easy manner. Our Goods & Services Tax course includes tutorial videos, guides and expert assistance to help you in mastering Goods and Services Tax. Clear can also help you in getting your business registered for Goods & Services Tax Law.

Save taxes with Clear by investing in tax saving mutual funds (ELSS) online. Our experts suggest the best funds and you can get high returns by investing directly or through SIP. Download Black by ClearTax App to file returns from your mobile phone.

Cleartax is a product by Defmacro Software Pvt. Ltd.

Company PolicyTerms of use

ISO

ISO 27001

Data Center

SSL

SSL Certified Site

128-bit encryption