cancel
Showing results for 
Search instead for 
Did you mean: 
Sialea19
Level 3

Account List Report - no longer includes Account Numbers!

I would like to know, why on earth the "new and improved" Account List has NO account numbers on it!  When you go into the Chart of Accounts (where you can add/inactivate accounts) you can only print the COA to a PDF.  To get it into Excel, you have to run the Account List report.  However, this new/modern view strips the report of the Account number with NO option to add it back in!  We NEED the account number to show up on the account list!  Even better would be able to see parent account if there's a parent/sub-account relationship.  Still without that, I would by happy to have the ACCOUNT NUMBER as a default to the report like it used to be.  Now there's not even an option to add it.  What use is an account list if there's no account numbers??!!  Another "great idea" that someone thought they had, but is completely the opposite of the needs of the user.  (Like the modern report for Trx drill down. . . )  Someone needs to stop making changes to QBO that are counterproductive to the users and accountants.

8 Comments 8
RCV
QuickBooks Team
QuickBooks Team

Account List Report - no longer includes Account Numbers!

This isn't the kind of situation we want you to experience, Sialea19.

 

If your QuickBooks Online (QBO) account is updated to the new experience, we need to turn on the account numbers feature. This is off by default. Here's how to enable it:

 

  1. Go to the Gear icon on the top menu and select Account and settings.
  2. Select the Advanced tab.
  3. Tap the Edit ✎ in the Chart of accounts section.
  4. Turn on Enable account numbers. If you want account numbers to show in reports and transactions, select Show account numbers.
  5. Press Save and then Done.

 

Then we can assign the account numbers. Let me guide you on how:

 

  1. Go to the Gear icon, then select Chart of accounts (Take me there).
  2. Click ✎ Batch edit above the Action column.
  3. In the Number column, add account numbers.
  4. Once you’re done, press Save.

 

To see your accounts’ numbers, go to the Chart of accounts) and select Settings ⚙ above the Action column. Make sure Number is checked. Now you can quickly find accounts using the numbers you assigned to them, whether you're searching in Chart of Accounts or adding a transaction.

 

If the same thing happens, we can log in to your account using an incognito browser. Private browser prevents saving cache and cookies that sometimes cause errors when running frequently visited websites. Here are the useful shortcut keys you can use to access one:

 


 

  • Ctrl+ Shift + N for Google Chrome A63.PNG
  • Ctrl + Shift + P for Mozilla Firefox A64.PNG and Microsoft Edge A65.PNG
  • Command + Shift + N for Safari A66.PNG

 

 

If it works, return to your default browser and clear its cache. Every so often the cache becomes overwhelmed with older data which can potentially cause viewing and performance issues. Clearing it will refresh the system, and you'll be able to work with a clean slate. Switching to another compatible one to help rectify the issue.

 

Lastly, I've also included a couple of references below for ideas to help organize your chart of accounts:

 

 

If you have any further questions about managing your accounts in the Chart of Accounts in QBO, feel free to reach out. I'll be here to help you out. You have a good one. 

jcapone
Level 1

Account List Report - no longer includes Account Numbers!

Even with Account numbers enabled and show account numbers selected in settings, the modern report for account list doesn't show the account numbers.  They become available when you switch back to the classic view.

AlverMarkT
QuickBooks Team

Account List Report - no longer includes Account Numbers!

Thank you for performing the steps suggested by my colleague, @jcapone.

 

I'm here to assist in displaying the account number when generating the Account List report in the modern view and to ensure that your feedback on the modern view is heard.

 

First, I suggest switching back to Classic View as it provides the most helpful experience for drilling down transactions.

 

Next, the Account Numbers in the Account List report's modern view aren't displayed by default. To display the Account Numbers and save it as a custom report, here are the steps:

 

  1. In the Account List report, select Columns.
  2. Click on the Edit tab.
  3. Scroll down and select Chart Of Accounts.
  4. Put a checkmark on the Account No.
  5. Select the Reorder tab.
  6. Scroll down and drag the Account No. header upwards for visibility.
    a. The header titles in the Reorder tab are organized from left to right in the report.
  7. Name the report and select Save.


 

Furthermore, I recommend submitting your feedback and overall experience of the modern view, as it is essential that the software accommodates the business needs of its users.  

 

  1. In your QBO account, go to the Gear icon.
  2. Select Feedback.
  3. Enter your comments or product suggestions.

 

For future reference, let me add this guide on closing your previous fiscal year and preparing for the new one in QBO: Year-end guide for QuickBooks Online.

 

You're always welcome in the QuickBooks Community should you have further concerns about navigating the modern view display in QBO. Take care.

Sialea19
Level 3

Account List Report - no longer includes Account Numbers!

Account numbers for ALL of my clients is enabled.  The problem is the Dev has created an "Enhanced report" which has now removed the account number column from the Account List report.  As accountants, the Account List report is USELESS without the account number column!!  I was teaching a new client how to use QBO.  We turned on account numbers, set up her Chart of Accounts and then I showed her that if she wanted to export her COA she had to do so NOW before the "enhanced report" was the only option.  Had to show her how to "Switch to Classic" view.  When I explained that she cannot export her COA into excel from the Chart of Accounts window and the only option was to do it now using the classic report, her reply is "Well that is stupid".  Yes!!  She hit the nail on the head.  It is stupid that an account list has no account numbers.  It is stupid that the Chart of Accounts cannot be exported into Excel and can only be viewed/printed in PDF.  Come on QuickBooks.  Stop making your software less and less user friendly!!!  Maybe let some accountants on the team to help out and explain what is really useful. 

Sialea19
Level 3

Account List Report - no longer includes Account Numbers!

Unfortunately there is limited time for us to be able to switch to classic view.  That is only a temporary solution, and it is sad that an Account List report would NOT include account numbers!

Sialea19
Level 3

Account List Report - no longer includes Account Numbers!

THERE IS NO OPTION TO "EDIT".  ONLY OPTION IS TO "REORDER" THE COLUMNS!!!

 

Please specify if different types of roles have the option to Edit or just Reorder the reports.  ALL roles should be able to modify the reports as necessary.  The fact that this report excludes the account numbers by default is mind-blowing!!  Any chart of accounts should have a numeric system and the fact that QB does not turn on numbering by default and have a default numbering system is ludacris.  Without a numbered COA, QB is setting up customers for failure and messy financial reporting.  It's why companies like mine spend countless hours fixing clients books.

MJoy_D
Moderator

Account List Report - no longer includes Account Numbers!

Thank you for sharing your experience. I understand how important it is to have the account number column in this report, especially for accountants, @Sialea19

 

To include the Account # column, you can customize the report by clicking on the Switch to Classic View button. From there, you can export it to Excel. 

 

If you're allowed to access the reports section on the account, you can edit and reorder the report in the Modern View. To export the report in the Modern View, click on the Export/Print button, and select the option to Export to Excel

 

Moreover, I suggest sharing your thoughts about the report's modern view. You can do this by following these steps:

 

  1. Go to the Gear icon and select Feedback
     feedback.JPG
  2. Provide your product suggestion.
  3. Click on Next to submit feedback.

 

You can also check out this article for more information on how to submit feedback: How do I submit feedback?. Additionally, I recommend checking our Feedback page for timely updates.

 

To learn more about running, printing, emailing, and exporting reports, check out this reference: Run reports in QuickBooks Online. Lastly, if you want to apply multiple filters to customize your report, see this article: Customize reports in QuickBooks Online

 

We're always looking for ways to improve QBO and make it more user-friendly, so I appreciate your feedback. Let me know if there's anything else I can do to help by leaving a reply below. Have a great rest of the week!

Sialea19
Level 3

Account List Report - no longer includes Account Numbers!

Attached print screen is for a client where I have ADMIN access, yet there is NO option to Edit the report, only Reorder existing columns.  I have also looked into this on another client with Accountant access and still NO option to Edit the report.  You cannot provide a solution to which users DO NOT have access to!  Maybe in the QB corporate world you have access to Edit the report, we as users DO NOT.  Please see attached print screen of my report following the instructions you propose above.  You will notice the only option I have under Columns is "Reorder".

Need to get in touch?

Contact us