CA Loan Bajaj Finserv
CA Final Online Classes
CA Classes

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

Now Export GSTR 2A to Excel for Reconciliation

Rajat solanki 
on 13 August 2018


Firstly How to Download from GST Portal ?

Login in the GST portal > Click on Return Dashboard > Month > Auto Drafted GSTR2A >

Click on Download

Here You'll find the new option to Download as Excel >Click on Generate Excel File

We'll have to Wait for 20 minutes to Generate the file>After That again Click on Generate and Click on “Click Here to Download Excel ”

You'll Find the Excel sheet like the as Below:

GSTR 2A To Excel For Reconciliation photo 1

As you can see in the Picture there are duplicate available for each Invoices in Bold and we Want Unique Invoices in Each Row

To Correct the formatting

1. Select all DATA in Sheet and add a Filter

GSTR 2A To Excel For Reconciliation photo 2

2. In Rate tab Un-select “-” and “Blanks” to Get Only unique invoices

GSTR 2A To Excel For Reconciliation photo 3

3. To Copy only the Unique Invoices Into New Sheet

Select all the data

GSTR 2A To Excel For Reconciliation photo 4

Press Alt+; and Ctrl+C to copy only the filter Data and Ctrl+V in New sheet or You can verify in the same sheet but the total will not work correctly in filtered sheet while reconciliation

Errors: we can't do it on merged cell so Unmerge the cells

I hope this will provide you a method to easily reconcile Inputs in Gst

The author can also be reached at

Tags :

Category GST
Other Articles by -
Rajat solanki 

Report Abuse





Do you have any Tax Queries