cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How do I change the account order on the Profit and Loss report?

When I generate a Profit and Loss (Standard or Detail) report, the order of accounts appears random - it's not by account number, alphabetical by name, or any other pattern I can see.  In the Standard report, if I click on the header for the amount column (ie "Jan-Dec '14"), I can change the sort order so the accounts are listed by total, either largest first or smallest first.  In the Detail report, I can also sort within the accounts by clicking on the other header columns.  However, I have found no way of sorting the accounts by account number.  Is there a way of doing this?

Solved
Best answer 12-10-2018

Accepted Solutions
Established Community Backer ***

This is a Basic List Management tool and applies to any l...

This is a Basic List Management tool and applies to any list in QB. When the report is wrong, it indicates the list is wrong.


Open the Chart of Accounts and use View menu > re-Sort list. This allows QB to put it back into Alpha order. This will fix the report.


Oh, sorry: For Mac, I think it is one of your Control/Command menu functions. Open Write Check, click on the account dropdown, try Ctl/Cmd L.

7 Comments
Established Community Backer ***

This is a Basic List Management tool and applies to any l...

This is a Basic List Management tool and applies to any list in QB. When the report is wrong, it indicates the list is wrong.


Open the Chart of Accounts and use View menu > re-Sort list. This allows QB to put it back into Alpha order. This will fix the report.


Oh, sorry: For Mac, I think it is one of your Control/Command menu functions. Open Write Check, click on the account dropdown, try Ctl/Cmd L.

Established Community Backer ***

Edit>resort list with your chart of accounts open.

Edit>resort list with your chart of accounts open.
Established Community Backer ***

;)

;)
Not applicable

Thanks, that fixed it for me

Thanks, that fixed it for me
Community Explorer **

I love the internet. Thanks for this!

I love the internet. Thanks for this!
Community Contributor *

OMG thank you!!

OMG thank you!!
Not applicable

Thank you!!!!!  This has been bothering our directors and...

Thank you!!!!!  This has been bothering our directors and board for a long time!!!

Need to get in touch?

Contact us