Connect with and learn from others in the QuickBooks Community.
It's nice to see you in the Community, DEP6!
Yes! There's a way to create an excel report which separates the account numbers and descriptions. I'm here to show you how it's done in QuickBooks Online.
You can run and customize the Account List report prior to exporting it to an excel file. This will show the details and balance for each account in your Chart of Accounts.
Once done, click the Export icon and select Export to Excel (see screenshots below).
For more details about modifying reports, check out this article:
How to customize reports
You're all set! This should give the information and format you need.
If you have other questions in mind, let me know by leaving a comment and I'll get them answered for you. Have a great day!
Is there a way to do this in the desktop version of Quickbooks?
Is there a way to do this in the desktop version?
Yes, you can do this in QuickBooks Desktop, Allisonc.
The Account Listing report will provide a different column for the account number.
Follow these simple steps:
Check the screenshots for your reference.
Don't hesitate to reach out to us if you have other concerns.