- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
Thank you for reaching out regarding the export of your Chart of Accounts from QuickBooks Online, aconroy@conroya
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:
- Navigate Reports.
- In the Type report name here, enter Account List.
- Under the More actions dropdown, select Export to Excel.
Exporting each account from the Chart of Account menu:
- Go to Transaction and click Chart of Accounts.
- In the Action column, select Run report.
- Click the More actions dropdown and tap Export to Excel.
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
The first method worked, thank you.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
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!