GSTR 2A excel sorting issue

Return 338 views 3 replies

I am facing sorting issue in GSTR 2A downloaded. As per attached screenshot I want only party wise bill number details and i don't want total row of invoice wise total. Currently i am deleting all rows containing total of invoices on a particular date. But it is really frustrating to delete rows when entries are on a higher side. Please suggest how can i prepare my GSTR2A in which i will get party wise details only and not total row of invoice.


Attached File : 1249273 20200227155213 2a query.jpg downloaded: 94 times
Replies (3)

I got one solution to filter I row

Go to custom sort in excel and sort the whole data on I Row. All the bold lines will go down. the delete those and start working
Sorted

8820448170


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register