QuickBooks HelpQuickBooksHelpIntuit

Move your QuickBooks Desktop file to QuickBooks Online

by Intuit128 Updated a day ago

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

Prepare and move your company file to QuickBooks Online. Enjoy a more flexible, secure, and up-to-date platform for your books when you move to QuickBooks Online.

Call our sales consultants at 800-730-0605 to find the right solutions for your unique business needs.

Note: Contact QuickBooks Time support if you have it with your QuickBooks Desktop account. Do this to integrate it with your new QuickBooks Online account.

Watch or follow the steps to get it done:

To watch more how-to videos, visit our video section.

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.

  1. Make sure QuickBooks is up-to-date.
  2. Make sure your company file isn’t too big to export.
    1. Total targets need to be less than 750,000 for it to be converted to QuickBooks Online. Press Ctrl+1 or F2 on your keyboard to check. If you’re over 750,000 targets, you can try to condense your data. You can also import lists and balances. Or, you can begin using QuickBooks Online without importing any of your information from QuickBooks Desktop.
      Note: Import your data from QuickBooks Desktop before working in QuickBooks Online. Any work completed in QuickBooks Online will be deleted during the import process if it was done before importing your data.
    2. Learn what does and doesn’t move to QuickBooks online.
  3. Print a copy of your sales tax liability report. You'll need it to enter adjustments after your move.
    1. Go to Reports, then select Vendors & Payables
    2. Select Sales Tax Liability.
    3. From the Dates ▼ dropdown, select All.
    4. From the Print ▼ dropdown, select Save as PDF.
    5. Choose the folder you want to save it in, name the file, and then select Save.
  4. If you use QuickBooks Desktop Payroll:
    1.  Terminate or deactivate any employees that no longer work for you and haven't been paid in the current year.
    2. Wait 2–3 days after you've run payroll to move your data. This will help ensure all your paycheck info transfers over to QuickBooks Online. Then, move your data before your next payroll.

Note: If your QuickBooks version is 2020 or older, you can move your data to QuickBooks Online with an online tool.

  1. Download and install the latest updates for QuickBooks Desktop before you copy your data to QuickBooks Online.
  2. Before you make any changes, backup your QuickBooks Desktop company file.
  3. Verify and rebuild data in QuickBooks Desktop before you switch to QuickBooks Online.
  4. Copy your company file to QuickBooks Online:
    1. Sign in as an admin in QuickBooks Desktop.
    2. Go to Company, then select Export Your Company File to QuickBooks Online.
    3. Select Get started.
    4. Sign in as an admin to your QuickBooks Online compan.
    5. Select the company you want to replace with your company file.
    6. Select Continue, then select Export.
    7. If you track inventory in QuickBooks Desktop:
      1. Select Yes to bring them over, then enter the as-of date.
        Note: Use the first day after your last tax filing period as your inventory start date.
      2. Select No if you want to set up new items later in QuickBooks Online.
      3. Note: If you already have data in a QuickBooks Online account, QuickBooks will ask if you want to replace the existing data.
  5. Enter Agree in the text field, then select Replace.
  6. Select Yes, go ahead and replace the data, then select Replace.

Step 1: Update QuickBooks Desktop

Download and install the latest updates for QuickBooks Desktop before you copy your data to QuickBooks Online.

Step 2: Backup your company file

Before you make any changes, backup your QuickBooks Desktop company file.

Step 3: Verify and rebuild your company data

Verify and Rebuild Data in QuickBooks Desktop before you make the switch to QuickBooks Online.

Step 4: Copy your company file to QuickBooks Online

If you use advanced reporting and advanced inventory, start fresh so 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. On your keyboard, press Ctrl + 1 to open the Product Information window.
  3. Press Ctrl + B + Q, then select OK to display the export window, then select Get started.
  4. Sign in as an admin to your QuickBooks Online company.
  5. Select the company you want to replace with your company file.
  6. Select Continue, then select Export.
  7. If you track inventory in QuickBooks Desktop:
    1. Select Yes to bring them over, then specify the as of date.
      Note: Use the first day after your last tax filing period as your inventory start date.
    2. Select No if you want to set up new items later in QuickBooks Online.
      Note: If you already have data in a QuickBooks Online account, QuickBooks will ask if you want to replace the existing data.
  8. Enter Agree in the text field, then select Replace.
  9. Select Yes, go ahead and replace the data, then select Replace.

You can move your QuickBooks Desktop for Mac file to QuickBooks Online. If you encounter issues during the transfer, contact QuickBooks Desktop support for help.

You can also watch this webinar:

To watch more how-to videos, visit our video section.

QuickBooks Desktop Accountant PlusQuickBooks Desktop ProQuickBooks Enterprise DiamondQuickBooks Enterprise GoldQuickBooks Enterprise PlatinumQuickBooks Online AdvancedQuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple Start

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.