Skip to main content
S
shelcondie
April 12, 2024
Question

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

  • April 12, 2024
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

R
RheaMaeH
April 12, 2024

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 field, type 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.

S
shortbg
November 2, 2024

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?

R
RhoiceW
November 2, 2024

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.

Terms & ConditionsAccessibility statement