GSTR 2A excel sorting issue

543 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: 144 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

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
24 June 2026
Senior Account (VA Client Operations)

Karbon Business

Bengaluru

CA Inter

View Details
Company
ARTICLESHIP 04 June 2026
Article

Rakhecha & Co.

New Delhi

CA Inter

View Details
Company
12 June 2026
Accounts & Taxation Executive

Winshine Financial Services

Mumbai

CA Inter

View Details
Company
22 June 2026
Accountant

Global Image Technologies Private Limited

New Delhi

MBA

View Details
Company
ARTICLESHIP 20 June 2026
Articleship

RB KESHRI & CO

Mumbai

B.Com

View Details
Company
ARTICLESHIP 18 June 2026
Article Assistance

RB KESHRI & CO.

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 31 May 2026
Article Assistant

KPRS And Associates

New Delhi

CA Inter

View Details
Company
01 June 2026
Audit, Taxation & Compliance Executive

R P S K & Associates

Nashik

CA Inter

View Details