Nonprofit report - account number sort order is incorrect

Susan1111 · ‎January 18, 2020

Hi there,

I use the nonprofit edition of the new QB for Desktop 2019. Right now I am attempting to create some nonprofit reports, specifically a Statement of Financial Position. Normally what happens is the display for the report sorts the accounts according to account number, in ascending order. Today I produced a report that lists a series of fixed asset accounts. However, the list is out of order, and one of the fixed asset accounts, just created today, is being listed at the top when (numerically and practically) it needs to be listed much further down on the report. It is as if QB has displayed the order from the most recently created accounts first, rather than according to account number. I have added a small snap shot below to let you see this un-ordered listing.

Can you advise as to how I can correct the sort order on this report?

Hopefully I have explained this well enough, but please let me know if you have any questions,

With regards,

Susan

BigRedConsulting · ‎January 18, 2020

Fix this by Resorting your chart of accounts to return it to its natural order:

Open the chart of accounts and pick Re-sort List from the Account button at the bottom of the window.

View solution in original post

AileneA · ‎January 18, 2020

Hi there, @Susan1111.

Thank you for reaching out to the Community.

Let me guide you on how to Re-sort List, Verify Data and Rebuild utility. The damage can often be repaired by resorting/rebuilding/verifying which puts a list back to its default order.

Here's how to Re-sort list:

From the Banking menu, select Write Checks/Checks.
Select in the Pay to the order of field then on the keyboard press Ctrl+L to open the master Name List.
Select the Include Inactive checkbox. Note that if there are no inactive names, the box will be grayed out.
Select the Name drop-down and select Re-sort List.
Select OK on the Are you sure you want to return this list to its original order? prompt.

To run Verify Data utility:

Select File at the top and choose Utilities.
Click Verify Data.
If there are issues found, you’ll be prompted to Rebuild Now.

Here’s how to run the Rebuild utility:

Click the File tab at the top.
Select Utilities from the drop down option.
Choose Rebuild Data.
Click Ok on Rebuild has completed.

After resorting, verifying and rebuilding data, we can close and reopen your file after revamp it.

For additional troubleshooting steps, please refer to this article: Fix data damage on your QuickBooks Desktop company file.

That should get you on the right track. Please let me know how that works. I'm here to provide any additional assistance if needed. Have a good one.

BigRedConsulting · ‎January 18, 2020

Fix this by Resorting your chart of accounts to return it to its natural order:

Open the chart of accounts and pick Re-sort List from the Account button at the bottom of the window.

Topics

Training

Community

Resources

Nonprofit report - account number sort order is incorrect