GSTR 2A excel sorting issue

Return 514 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: 136 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  

Company
Featured 28 March 2026
Accountant

Ashok Amol & Associates

New Delhi

B.Com

View Details
Company
Featured 28 March 2026
CA Final

Ashok Amol & Associates

New Delhi

CA Final

View Details
Company
Featured 13 April 2026
GST CONSULTANCY

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 14 April 2026
GST CONSULTANT

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 19 March 2026
Article Assistant

Gupta Sachdeva & Co. Chartered Accountants

New Delhi

CA Final

View Details
Company
Featured 14 March 2026
Article Trainee

N N V Satish&co

Hyderabad

CA Inter

View Details
Company
Featured 14 March 2026
Associate CA

N N V Satish&co

Hyderabad

CA

View Details
Company
Featured 12 March 2026
Customer Relationship Executive

TAXLET

Calicut

B.Com

View Details