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

Is there a way to create a report in Excel that separates the account numbers from the account description?

 
6 Comments
Highlighted
QuickBooks Team

Is there a way to create a report in Excel that separates the account numbers from the account description?

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. 

 

Here's how:

  1. Go to Reports in the left navigation panel. 
  2. Ensure that you're in the Standard page. 
  3. Scroll down to the For my accountant section, then choose Account List.
  4. Select Customize, expand the Rows/Columns options and click the Change columns link.
  5. Under the Select and reorder columns, put or remove the check marks to the boxes you need. 
  6. Click Run Report.

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! 

 

Highlighted
Level 1

Is there a way to create a report in Excel that separates the account numbers from the account description?

Is there a way to do this in the desktop version of Quickbooks?

Highlighted
Level 1

Is there a way to create a report in Excel that separates the account numbers from the account description?

Is there a way to do this in the desktop version?

Highlighted
QuickBooks Team

Is there a way to create a report in Excel that separates the account numbers from the account description?

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:

  1. Click Reports.
  2. Go to List.
  3. Choose Account Listing.
  4. Click Excel, then choose Create New Worksheet.
  5. Click Create new worksheet, then choose in new workbook.
  6. Click Export.

Check the screenshots for your reference.

 

 

 

Don't hesitate to reach out to us if you have other concerns. 

Highlighted
Level 1

Is there a way to create a report in Excel that separates the account numbers from the account description?

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. 

Highlighted
QuickBooks Team

Is there a way to create a report in Excel that separates the account numbers from the account description?

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:

  1. Go to the Reports menu, choose Accountant & Taxes.
  2. Click Trial Balance to open the report. report12a.JPG
  3. Select the Excel drop-down arrow and pick Create New Worksheet.
  4. Tick the in a new workbook option and then Export. report124.JPG

 

Once exported, let's now customize the report columns:

  1. Right-click any rows under the Debit column and choose Insert.
  2. Select Entire column and OKexport12.JPG
  3. From there, you'll see a new column between the accounts names and the debit column.
  4. Next, highlight the Account numbers/name column. export34.JPG
  5. Click the Data tab and hit Text to Columns.
  6. Choose Fixed with then Next. export56.JPG
  7. Drag the arrows to create a break line between Account numbers and Account names. 
  8. When finished, click Next and select Finishexport78.JPG

 

Then, you'll now have separate columns for the account numbers and account names of your Trial Balance report. 

export9.JPG

 

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.

Need to get in touch?

Contact us