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: 153 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
Featured 21 September 2026
Consultant - Reporting

Finrep Advisors LLP

Mumbai

CA

View Details
Company
17 September 2026
Chartered Accountant

Dass Gupta & Associates

Gurgaon

CA

View Details
Company
08 September 2026
Audit Executive

Thammana & Associates

Srikakulam

B.Com

View Details
Company
09 September 2026
Chartered Accountant

Aviv Global Private Limited

Ahmedabad

CA

View Details
Company
ARTICLESHIP 04 September 2026
Accounts Executive

Hema Yashwanth & Associates

Chennai

B.Com

View Details
Company
08 September 2026
Semi-Qualified Assitant

Subrahmanyam & Sivudu CA Firm

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 21 September 2026
CA Article Assistant

KK & Company Chartered Accountant

Pune

CA Inter

View Details
Company
26 September 2026
Chartared Accountant

pushpganga ventures

Pune

CA

View Details