Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

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


Published by

Rajat solanki
Category GST   Report

4 Likes   8 Shares   21054 Views