Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
shelcondie
Level 1

Can I export chart of accounts from one quickbooks online account to another?

 
3 Comments 3
RheaMaeH
QuickBooks Team

Can I export chart of accounts from one quickbooks online account to another?

Hello there, shelcondie. I'm here to assist you with exporting your Chart of accounts and importing them to other QuickBooks Online accounts. 

 

To export a Chart of accounts, you can run an Account List report and export it to Excel. To do this, follow these steps:

 

  1. Go to Reports.
  2. In the Find report by name fieldtype Account List.
  3. Click Export and select Export to Excel.

 

Once the report is exported, you can download a sample spreadsheet in Excel or CSV format. Here's a sample format:

 

 

Then, you can upload the spreadsheet to another company file you have. 

 

Here's how:

 

  1. Log in to QuickBooks Online.
  2. Go to the Gear icon.
  3. Click Import data under Tools.
  4. Select Chart of accounts.
  5. Browse and choose the file, then click Open.
  6. Select Next.

 

For more information, you can visit this link on how to import your Charts of Accounts in QBO.

 

Moreover, you can reconcile your accounts so they always match your bank and credit card statements.

 

I'm always here if you need further help to import your Chart of accounts in QuickBooks Online. I'll be around to assist. Take care always.

shortbg
Level 2

Can I export chart of accounts from one quickbooks online account to another?

When  run the Account List report, the Account Types show as Expenses and Income instead of Expenditures and Revenue. I created the chart of accounts as a non-profit, so it uses the terms Expenditures and Revenue. I want to export this and then import it into another non-profit. The non-profit is expecting account types of Expenditures and Revenue. Why does the report change the type?

RhoiceW
QuickBooks Team

Can I export chart of accounts from one quickbooks online account to another?

Thanks for reaching out here in the Community space, Short. I'd like to provide additional information about exporting data in QuickBooks Online (QBO).

 

When running an Account List report, exporting this report will not retain different terminology such as Expenditures and Revenue. The report is designed to reflect standard accounting terms such as Expenses and Income, which is likely why you are seeing that change.

 

I recommend sending feedback to our product developers to inform them about your request for changing the terminology when the names of the Chart of Accounts are modified. This way, our product engineers can consider adding this in future updates.

 

Here's how:

 

  1. Sign in to your QBO account.
  2. Click the Gear icon at the top, then Feedback.
  3. Enter your comments or product suggestions.
  4. Press Next.

 

Once you complete this, our designated team will review your input. You can track your future requests through the QuickBooks Online Feature Requests website.

 

Additionally, you can customize your reports in QBO for more detailed insights by adjusting various settings like columns, filters, and sorting options. You can also export your reports and lists to Excel or as a PDF for further analysis.

 

If you have any more questions or need further assistance, feel free to reach out. I'm here to help you. Take care.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us