Follow Us :

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

rajatsolanki1@yahoo.com

Author Bio

I am Rajat Solanki and Currently Studying CA and I am working at MGIRT & Co. Bangalore View Full Profile

My Published Posts

Section 43B – Most Important or dangerous provision of Finance bill 2023 Unnecessary complication in MCA V3 Portal Excel utility for GSTR 2A reconciliation GSTR 3B Payment and Offset liability, Old Rule or New Rule? GSTR 3B Payment and Offset liability as per 49A W.e.f 1.2.2019 ,Effect working capital? View More Published Posts

Join Taxguru’s Network for Latest updates on Income Tax, GST, Company Law, Corporate Laws and other related subjects.

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 Post by Date
March 2024
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031