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

Thanking You

Rajatsolanki

[email protected]

Author Bio

Qualification: Student - CA/CS/CMA
Company: MGIRT & Co
Location: Bangalore, Karnataka, IN
Member Since: 05 Sep 2017 | Total Posts: 10
I am Rajat Solanki and Currently Studying CA and I am working at MGIRT & Co. Bangalore View Full Profile

My Published Posts

More Under Goods and Services Tax

21 Comments

  1. PUSHPENDRA PUROHIT says:

    May God bless You dear whoever write this article with images . I give a lot of thanks who assist these rare practical issues very easily . Thank you very much again

  2. om prakash says:

    No link is available for generating the Form 2A even after waiting for 20 mins. kindly help and suggest ways to generate Excel sheet of form 2A.

  3. venkatesh says:

    Link was given for few days initially but now the link is not available. Again the old procedure is being followed to download Jason and convert to excel. Grievance raised but no response yet.

  4. Satya says:

    few days it has worked.
    past 1 week it is not showing any download link, every time portal saying, you have downloaded so n so time, if you want this file, press below link, but there is no link appearing…
    we have raised grievence in portal, till now no response from them.

    now also json file link appearing.

  5. Sudhir says:

    No link is available for generating the Form 2A even after waiting for 20 mins. kindly help and suggest ways to generate Excel sheet of form 2A.

  6. vikas negi says:

    Portal is not generating the link while only message is reflecting that click on below link to download 2A return in excel format…thanks

Leave a Comment

Your email address will not be published. Required fields are marked *

Search Posts by Date

September 2021
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
27282930