cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

Custom SOCF Report account order has changed?

I have a custom SOCF report which we run monthly and upload into excel. The COA are arranged numerically as of last months run all the way back to 2015. Today when I run the exact custom report the COA are not in the same order . Something has changed in QB and now all of the accounts are out of order. What can I do to get this report to be the same as it was? 

6 Comments
Highlighted
QuickBooks Team

Custom SOCF Report account order has changed?

Thanks for posting to the Community, @RobynK-2020.

 

Since the account numbers are arranged all the way back to 2015 numerically, this feature may have turned off in the Advanced settings. That's why the SOCF report account order has changed.

 

You can turn it on again by following these steps:

  1. Go to Settings ⚙ and select Account and Settings.
  2. Select the Advanced tab.
  3. Select Edit ✎ in the Chart of accounts section.
  4. Select Enable account numbers.
  5. Select Save and then Done.

 

Once done, you can go back and run the customized SOCF report and review the arrangement of accounts.

 

Additionally, there are multiple ways of sorting COA in QBO. We can arrange them by name, type, payee, or currency. We can hover over any column header. Then, click the TYPE header to sort (▲ or ▼) or switch from ascending to descending order.


Besides, you can Sort the total of SOCF report to ascending and descending manner.

 

I've added some articles that will help keep your COA more organized.

The first article includes how to change an existing account into a subaccount.

 

Feel free to place a comment and tag me (@Jovychris_A) if you need further assistance. I'm always around to help. Take care!

Highlighted
Level 1

Custom SOCF Report account order has changed?

Thanks For responding @Jovychris_A .

 

This doesn’t change anything. Something has changed within QB. The account numbers have always reported out in order and now they are not in numerical order in the report. I checked the setting as suggested but account numbers were checked already so nothing changed when I re-ran the report. 

Robyn 
Highlighted
QuickBooks Team

Custom SOCF Report account order has changed?

Hi RobynK-2020. Thanks for coming back. It sounds like you may be experiencing a browser issue. This can usually be fixed by using an incognito window. To do so in Google Chrome follow these steps:

  1. Select the 3 dots in the top right corner 
  2. Select New Incognito Window 

Now try sorting the report how you'd like. If it works, go ahead and head over to the article on clearing cache in QuickBooks Online to get a quick guide on how to fix it going forward. Let me know if you run into anything else I'll be here to help.  

Highlighted
Level 1

Custom SOCF Report account order has changed?

@Steve_C 

Thanks for responding but this is a custom report that we've been running for 5 years with no changes. The default sort has always sorted the COA numerically by account number. This month when we ran the exact same custom report only changing the end date, the accounts are out of order and we don't know why. We shouldn't have to do an additional exercise in sorting for a custom report that hasn't changed in 5 years. Something has changed in QB and we are trying to understand why. This report feeds into a company model we have used to present historical information as well as forecasting. Interestingly enough. The P&L  and BS reports come out just fine. It's the SOCF report that has now changed the order of accounts causing issues.

Highlighted
QuickBooks Team

Custom SOCF Report account order has changed?

I appreciate the details a lot, @RobynK-2020.

 

The number format may have caused this issue in COA, that's why it sort out of order when customizing the SOCF report.
 

In this case, I'd suggest changing the numbering format to sort the NUMBER column in their respective manner. Firstly, make sure to take note of the account numbers associated with each name in your COA.

 

For example, you can put 01 instead of 1 to rectify the order on the NUMBER column when sorting.

 

Here's how:

  1. Go to the Accounting menu and then select Chart of Accounts.
  2. Click the Pencil icon/Batch edit beside the Printer icon.
  3. Please take note of the numbers assigned for each account and then remove them.
  4. Click Save.

 

Once done, you can then assign the numbers associated with each account. Ensure the format will look like this: 01, 02, 03, 04...10,11 ,12, and so on.

 

Let me show you how:

  1. In your COA, click Pencil/Batch edit.
  2. Enter the assigned numbers for each account in the NUMBER column.
    2.PNG
  3. Select Save.

 

Once done, you can check this by toggling the sort button▼ beside NUMBER header.

 

If the issue persists, please reach our Customer Care Support. They have tools to pull up your account and investigate it further. You can follow these steps:

  1. Go to Help on the top right.
  2. Click Contact Us.
  3. Please type a short description of your query and then hit Let's talk.
  4. Choose to Start a chat or Get a callback.

 

Please don't hesitate to notify me if you need more help. I'll keep my notifications open. Stay safe and well!

Highlighted
Level 1

Custom SOCF Report account order has changed?

@Jovychris_A 

 

I really appreciate your responses but I don't understand why I would have to go through this pretty intensive exercise on a custom report that hasn't changed in 5 years. Our two other reports run with no issue using the same COA Numbers and they come out ordered with no issue. We have over 300 accounts in QB and manually changing each one in QB could then upset the other two reports. Thai doesn't make sense. Again, did something change in QB to cause this? 

 

Need to get in touch?

Contact us