Move your QuickBooks Desktop file to QuickBooks Online

Learn how to import your QuickBooks Desktop company file into QuickBooks Online.

When you move from QuickBooks Desktop to QuickBooks Online, you can let us help you move or you can move your data on your own. Select the method that works best for you to learn more.

Check out all the benefits you get when you move to QuickBooks Online.

Let us help you move your data

Our experts can move your data with you and answer questions at no additional cost.

If you need help finding the right solutions for your unique business needs, contact us.

Move your data on your own

Note: The steps in this article are for QuickBooks Desktop Pro, Premier, and Enterprise.

• Step 1: Subscribe to QuickBooks Online
• Step 2: Get your desktop file ready
• Step 3: Move your QuickBooks Desktop file to QuickBooks Online
• Step 4: Get ready to use QuickBooks Online

Step 1: Subscribe to QuickBooks Online

Make sure you’ve researched and signed up for a QuickBooks Online subscription before you start to move your data.  Need a consultation to help pick the right plan for your needs? Call 1-888-829-8589 to help you find the right solution or visit Quickbooks.intuit.com/ca/. 

After you subscribe to QuickBooks Online, watch and follow the steps below:

Note: You have 60 days from the time you create your QuickBooks Online account to move your data. If you’re not sure how old your company is, sign in to QuickBooks Online. Then, refresh this page for personalized info.

Step 2: Get your desktop file ready

Check out the pre-move checklist (available in English only) for more info.

1. Make sure QuickBooks is up-to-date.
2. Mark any customers, suppliers or accounts that are no longer in use, as inactive. This will streamline the data that’s moved to Online and prevent data issues.
3. Delete or void, unbilled charges and unbilled time associated with inactive accounts, customers, suppliers or employees.
4. Make sure your company file isn't too big to export.
   1. Each transaction in your file has links or targets to every other entry related to it. For example, an invoice has a target for the customer and each item, account, estimate, sales tax, and payment it touches.
   2. Total targets need to be less than 1.2M for data to move to QuickBooks Online. Press Ctrl + 1 or F2 on your keyboard. If you’re over 1.2M targets, you can try to condense your data. You can also enter your customer opening balances in a new QuickBooks Online file.
   3. Learn what does and doesn’t move to QuickBooks online.
5. If you use online banking or import bank transactions
   1. Make sure to categorize and reconcile bank and credit card statements/transactions, go to Banking select Bank Feeds then Set up Bank Feed for an Account.
6. If you use QuickBooks Desktop Payroll:
   1. Make sure to terminate or deactivate any employees that are no longer working for you and haven't been paid in the current year.
   2. Make sure that Employee profile information (first, last name, SIN, Date of Birth, Hire Date and Address) is available and updated for all active employees.
   3. Make sure to wait 2-3 days after you've run payroll to move your data. This will ensure all your paycheque info transfers over to QuickBooks Online. Then make sure to move your data before your next payroll.
7. If you use QuickBooks Time, contact us for help setting up your account in QuickBooks Online.

Step 3: Move your QuickBooks Desktop file to QuickBooks Online

You have two options to move your data on your own. Select the tool that works best for your company.

• Migration tool built into QuickBooks Desktop
• Web-based migration tool

Web-based migration tool

Note: Check out Learn how features and data move from QuickBooks Desktop to QuickBooks Online article to see what moves to QuickBooks Online.

Step 1: Open the online tool

1. Select the link for your QuickBooks version (available in English only):
   1. QuickBooks Pro/Premier
   2. QuickBooks Enterprise
2. Select Get started, then sign in with your Intuit Account.

Step 2: Upload your company file

Follow these steps to upload your company file.

1. Select Select File then browse to the supported QuickBooks Desktop file you want to move.
   Note: You can only upload one file at a time.
2. Select Open to upload the file.
   1. Alternatively, you can drag and drop your QuickBooks Desktop file to upload it.

3. Once your file is uploaded, we’ll auto-update it to the latest version of QuickBooks Desktop. Next, you'll see an option to move to QuickBooks Online.

4. Next, you'll see an option to move to QuickBooks Online.
5. Follow the on-screen instructions to guide you through the move to QuickBooks Online.

6. If your books fail to update to QuickBooks Desktop or move to QuickBooks Online, contact customer support.

Migration tool built into QuickBooks Desktop

Copy your company file to QuickBooks Online

If you use advanced features (such as advanced reporting and advanced inventory), start fresh so that all your data will move to QuickBooks Online. If you want to use these features in Enterprise, learn about cloud-enabled QuickBooks Desktop Enterprise.

1. Sign in as an admin in QuickBooks Desktop.
2. Export your QuickBooks Desktop company
   1. In QuickBooks Desktop Pro and Premier, go to Company, then select Export Your Company File to QuickBooks Online.
   2. In QuickBooks Desktop Enterprise, press CTR + 1 to open the Product information window. Then press CTRL + B + Q then select OK.
3. Select Get started.
4. You’ll see a screen that says "Let’s bring your data to QuickBooks Online". Select how you want to move your data:
   1. Bring all of your company data.
   2. Bring only lists and balances. (This option is helpful if you have a large file and don’t want to bring over every individual transaction.)
5. Select Continue.
6. If you have inventory, you can:
   1. Select Yes, track inventory using FIFO then select a starting date.
   2. Select No, don’t move inventory. You can move your inventory manually later.
   3. (Scope to include KB)
7. If you use multi-currency in QuickBooks Desktop, you’ll have to select a home currency.
8. You will be asked if you have a QuickBooks Online account.
   1. If you do, select Yes, sign me in then select Continue.
      Note: This is the account you created when you purchased your QuickBooks online solution in Step 1 Subscribe to QuickBooks Online.
   2. If you have not selected a QuickBooks online solution, you can select No, I need to create one. This will create a QuickBooks Online Advanced trial company. We recommend you go to Quickbooks.intuit.com/ca/ to buy the right QuickBooks Online version for your company before starting migration.
9. On the next screen, you will be asked to sign in. Sign in using the same user ID and password associated with your QuickBooks Online subscription.  
10. You’ll see your QuickBooks Online company names and subscriptions listed. Select the company you want to move your data to.
11. Select Continue, then select Export. You will see a progression bar as your data is moved over to QuickBooks Online.
    Note: If you already have data in a QuickBooks Online account, QuickBooks will ask if you want to replace the existing data, follow the below steps.
12. Enter Agree in the text field, then select Replace.
13. Select Yes, go ahead and replace the data, then select Replace.

Step 4: Get ready to use QuickBooks Online

With your company all set up, let's get you started with QuickBooks Online.

Next you can follow this list of what to set up in your new QuickBooks Online company.