LIMITED TIME OFFER get 90% off for 6 months
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about connecting your bank and credit cards in QuickBooks Online
stay-clyngwyn-co
Level 1

Can I copy my current account structure into a new company on quickbooks

I have an additional subscription and want to copy over my current structure to the new company
4 REPLIES 4
ShangY
QuickBooks Team

Can I copy my current account structure into a new company on quickbooks

Yes, you can copy your current account structure to a new company. I'll provide the steps for you, stay. 

First, export your data from one company to another. Here's how:

 

  1. From the Gear icon, choose Export data.
  2. set the date range on the Reports tab.
  3. Turn the switch on or off to remove or add items from the Reports and Lists.
  4. Once done, Export to Excel

 

To export non-posting transactions, you may refer to this article and proceed to the Export non-posting transactions and attachments section: Export reports, lists, and other data from QuickBooks Online.

 

After that, log in to your new company and import the data. Here's how:

 

  1. From the Gear icon, choose Import data.
  2. Choose from the drop-down list you wish to import.
  3. Click on Import and select an import method.
  4. Select Upload.
  5. Follow the on-screen steps.

 

Additionally, to keep your accounts organised and easy to find, you can turn on account numbers. Check out this article: Use account numbers in your chart of accounts in QuickBooks Online.

 

If you have further questions or concerns about exporting your account structures to a new company in QuickBooks, please don't hesitate to add a reply on this thread. We're always here to help. Have a good one.

Deity Alpha
Level 7

Can I copy my current account structure into a new company on quickbooks

@stay-clyngwyn-co 

You can purchase a 3rd party migration service. Another option, you can use a migration tool.

https://get.transactionpro.com/qbo

 

James100
Level 1

Can I copy my current account structure into a new company on quickbooks

while this appears simple - in practice the tools aren't very useful. For example: i exported the customer list, and then when to upload the customer list. As the exported excel file was in a report, the field mapping did not correlate. This effectively means you need to manually cleanse/intervene when in reality if you are simply copying the master data from one company to another company the master data fields should be the same.

I also can't find a simple way to export the Chart of Accounts and then import.

Surely Quickbooks can have a file export that mirrors their file import structure?

 

 

 

Carneil_C
QuickBooks Team

Can I copy my current account structure into a new company on quickbooks

QuickBooks Online (QBO) has an option to export your customer list and chart of accounts into an Excel file, James100. This way, you'll be able to import it back to QBO seamlessly.

 

When our exported file corresponds to the QBO file structure, we can seamlessly import it back without manual adjustments. If you export the customer data from the Reports page, we have various options of file formats to choose from. Ensure to select the Export to Excel option so that it matches the format when importing it back.

customer 1.png

 

On the other hand, if you export the list directly from the Customers page, ensure you save the file type as an Excel type.

customer 2.png


With regards to your Chart of Accounts (COA), we have ways of exporting it. You can use the General ledger as it is also a comprehensive record of all your accounts. Here's how:

 

  1. Go to the Gear icon and choose Export data.
  2. Select General Ledger from the Reports tab.
  3. Click Export to Excel.

 

Otherwise, open each account from your COA and export it from there.


customer 3.png

Ping me a reply if you need further help with managing your files in QBO. We're determined to help you succeed, James100.

Need to get in touch?

Contact us