cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
aconroy@conroyas
Level 2

QB online export list does not include chart of accounts

Hello, we have created a new company and want to import our chart of accounts from the old company. 

 

When I go to gear icon/export data/ (all dates are chosen) lists/  the chart of accounts is not an option. All I get is customers, vendors, and employees.

 

How do I access the export for the chart of accounts?

 

Thanks.

Solved
Best answer February 11, 2025

Best Answers
RheaMaeH
QuickBooks Team

QB online export list does not include chart of accounts

Thank you for reaching out regarding the export of your Chart of Accounts from QuickBooks Online, aconroy@conroyas. I appreciate you bringing this to our attention and understand your need to transfer important account information to your new company file. Let me walk you through some options that should help you export your Chart of Accounts effectively.

 

There are several alternative and effective methods to accomplish exporting the Chart of accounts. However, the standard export option under the gear icon in QBO does not directly include the Chart of Accounts as a selectable list. Here are the steps for those workarounds.

 

You can export via the Account List report. Here's how:

 

  1. Navigate Reports.
  2. In the Type report name here, enter Account List.
  3. Under the More actions dropdown, select Export to Excel.

 

Exporting each account from the Chart of Account menu:

 

  1. Go to Transaction and click Chart of Accounts.
  2. In the Action column, select Run report.
    Screenshot 2025-02-12 080116.png
  3. Click the More actions dropdown and tap Export to Excel.
    Screenshot 2025-02-12 080136.png

 

Please note you can only import the account list, account name, type and detail type, and the total balance. QBO's import function does not support the direct import of account balances. You'll need to enter the opening balances manually after importing the Chart of Accounts.

 

For a more comprehensive understanding of exporting various data types from QBO, refer to this helpful article: Export your QuickBooks Online data.

 

Once the report is exported, you can now import your data. For detailed instructions, visit this article: Import your Chart of Accounts to QuickBooks Online.

 

Additionally, if you no longer need an account but want to retain its historical data for reporting purposes, make it inactive.

Moreover, with how important accurately transferring your Chart of Accounts is and the complexity of setting up a new company file, I recommend taking advantage of our Assisted Live Expert. This personalized assistance can save you time, reduce potential errors, and give you peace of mind knowing that your new company file is set up correctly.

 

I hope these methods help you successfully export your Chart of Accounts. If you need further assistance or have additional questions, please don't hesitate to reply below. I'm dedicated to ensuring a smooth and efficient transition to your new company file.

View solution in original post

3 Comments 3
RheaMaeH
QuickBooks Team

QB online export list does not include chart of accounts

Thank you for reaching out regarding the export of your Chart of Accounts from QuickBooks Online, aconroy@conroyas. I appreciate you bringing this to our attention and understand your need to transfer important account information to your new company file. Let me walk you through some options that should help you export your Chart of Accounts effectively.

 

There are several alternative and effective methods to accomplish exporting the Chart of accounts. However, the standard export option under the gear icon in QBO does not directly include the Chart of Accounts as a selectable list. Here are the steps for those workarounds.

 

You can export via the Account List report. Here's how:

 

  1. Navigate Reports.
  2. In the Type report name here, enter Account List.
  3. Under the More actions dropdown, select Export to Excel.

 

Exporting each account from the Chart of Account menu:

 

  1. Go to Transaction and click Chart of Accounts.
  2. In the Action column, select Run report.
    Screenshot 2025-02-12 080116.png
  3. Click the More actions dropdown and tap Export to Excel.
    Screenshot 2025-02-12 080136.png

 

Please note you can only import the account list, account name, type and detail type, and the total balance. QBO's import function does not support the direct import of account balances. You'll need to enter the opening balances manually after importing the Chart of Accounts.

 

For a more comprehensive understanding of exporting various data types from QBO, refer to this helpful article: Export your QuickBooks Online data.

 

Once the report is exported, you can now import your data. For detailed instructions, visit this article: Import your Chart of Accounts to QuickBooks Online.

 

Additionally, if you no longer need an account but want to retain its historical data for reporting purposes, make it inactive.

Moreover, with how important accurately transferring your Chart of Accounts is and the complexity of setting up a new company file, I recommend taking advantage of our Assisted Live Expert. This personalized assistance can save you time, reduce potential errors, and give you peace of mind knowing that your new company file is set up correctly.

 

I hope these methods help you successfully export your Chart of Accounts. If you need further assistance or have additional questions, please don't hesitate to reply below. I'm dedicated to ensuring a smooth and efficient transition to your new company file.

aconroy@conroyas
Level 2

QB online export list does not include chart of accounts

The first method worked, thank you.

FateCandylaneT
QuickBooks Team

QB online export list does not include chart of accounts

That's great to hear, aconroy.

 

I'm glad to know the steps provided by my colleague helped you and that you were able to export lists of your Chart of Accounts. It's always our aim to ensure that you receive the support you need.

 

I'll keep this thread available if there's anything else you need further assistance with when managing accounts in your file. Please let us know in the comments below. Keep safe!

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us