GSTR 2A excel sorting issue

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: 162 times
Replies (3)
Quick Summary
This discussion addresses a common issue faced when downloading GSTR 2A reports in Excel: unwanted invoice total rows. The user is seeking an efficient method to extract only party-wise bill number details, avoiding the tedious manual deletion of total rows. A potential solution involving custom sorting in Excel to isolate and remove these total lines is mentioned.

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
ARTICLESHIP 14 November 2026
Articleship Assistant

B Thejas and Associates

Bengaluru

CA Foundation

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
Featured ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details
Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
ARTICLESHIP 18 November 2026
Articled Assistant

A.Singhi & Co

Kolkata

CA Inter

View Details
Company
31 October 2026
Accountants

sankaran and krishnan

New Delhi

B.Com

View Details
Company
24 October 2026
CA Industrial Trainee

Fytomax Nutrition Private Limited

Aurangabad

CA Inter

View Details
Company
ARTICLESHIP 17 November 2026
Vacancy for Articleship

Promptitude Accounting Services Private limited

Bengaluru

B.Com

View Details