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:
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
2. In Rate tab Un-select “-” and “Blanks” to Get Only unique invoices
3. To Copy only the Unique Invoices Into New Sheet
Select all the data
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 rajatsolanki1@yahoo.com