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:
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!
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.
I'm trying to figure out how to separate the account number and account name when I export a trial balance to excel in QuickBooks desktop. This tip above in the comments doesn't seem to apply to the trial balance.
I'm here to provide steps so you can have a separate column for the account numbers on the Trial balance report, @jackiechan1.
First, let's export the report to Excel, here's how:
Once exported, let's now customize the report columns:
Then, you'll now have separate columns for the account numbers and account names of your Trial Balance report.
Here's a handy article that you may visit to guide you in filtering data and personalizing your report inside QuickBooks: Customize reports. This also includes steps on how to send and print reports.
Let me know how it goes and leave a reply below if you have further concerns about customizing your reports. I'm always right here to help, @jackiechan1. Have a good one.
Is there a way to put a trial balance in excel using Quickbooks Online that has the account numbers and account description in separate columns? And I don't mean doing it manually in excel with text to columns. I mean within Quickbooks Online. Or is there a software limitation?