Importing Data From Old Quickbooks Account

Hello gstephenson, 

Sometimes it's necessary to import data from the old account to the new one. I'll be happy to give you a hand so you can seamlessly transfer your data. QuickBooks is an easy-to-use program that makes it simple to navigate and get your work done faster. 

In order to transfer data between two accounts, you'll have to export the data from the old account to the new one. Here are some helpful articles that'll help you export your data from the old account:

• Export Data out of QuickBooks Online
• Export reports, lists, and other data from QuickBooks Online

Once you've exported your data, you can import it into the new account. Here's the data you can import into QuickBooks:

• Bank Data
• Customers
• Suppliers
• Chart of Accounts
• Products and Services
• Invoices
• Journal Entries
• Bills

I encourage you to check out these helpful articles which show you how to import your data into the new account:

• Import multiple invoices at once
• Import journal entries in QuickBooks Online
• Move your lists to QuickBooks Online
• Import your bills in QuickBooks Online

It's vital your account balances are matching. Depending on what's causing the balance difference between the old and the new account, I encourage you to go through your transactions and accounts to make sure your info is matching up. Once you've transferred the data and all transactions are matching, the balance should also be the same. 

Let me know if this info helps by leaving a comment below. I'll be a message away in case you need further assistance. 

@gstephenson 

Utilize a migration tool for certain transaction types (e.g Sales Receipt, Bill Payments, Checks)

https://transactionpro.grsm.io/qbo

How about the chart of accounts aspect? I have more accounts in the old profile, so when I transfer the data will it populate those chart of accounts in the new profile or can I match it with the account it belongs to in the new profile?

Hi there gstephenson, 

QuickBooks Online has the
feature to export and import your chart of accounts in order to help minimize
the time spent during the initial setup of your books. I can provide some
clarification on how you can set that up.

The way you can go about exporting your Chart of Accounts from QuickBooks Online is
to navigate to Accounting in the left menu, then choosing Chart of Accounts. You'll be able to see an option to Run Report in the upper left corner and once you click on it you should see a report with all your accounts. You can then select on the Export button located above the report and next to the Print Icon. You'll want to choose to export it to an Excel file in order to be able to import it into your new QuickBooks account.

The next step would be to import your Chart of accounts into your new QuickBooks Online subscription. This can be accomplished by following the steps in this article about how to Import your chart of accounts to QuickBooks Online. The accounts that are in your Excel sheet but not yet created in your Chart of Accounts will be generated for you automatically.

When choosing to import your Chart of Accounts from an Excel or .csv file, the accounts that are already existing in your QuickBooks Online account will not be able to be imported. After the step where it asks you to map each column of your file to the field in QuickBooks, those accounts will appear in a red box, saying that the import for these lines has failed. If you want to add an opening balance to those accounts, you can follow the steps outlined in this article to Enter an opening balance for an account in QuickBooks Online.

I hope this information helps you get back on track with the setup of your books. If you have any more
questions feel free to reach out. I've got your back!