QuickBooks HelpQuickBooksHelpIntuit

Move your QuickBooks Desktop file to QuickBooks Online

by Intuit•207• Updated 4 days ago

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.

Let us help you move your data

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

To reach an expert, call 800-4INTUIT (800-446-8848) then select QuickBooks (option 2). When you’re asked what you need help with, say Help with migration. You’ll be directed to the correct team.

Move your data on your own

Note: The steps in this article are for QuickBooks Desktop Pro, Premier, and Enterprise. If you use QuickBooks Desktop for Mac, check out Move from QuickBooks Desktop for Mac to QuickBooks Online. For Accountants, we have an exclusive Batch Migration tool for you to use.

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 800-730-0605 to help you find the right solution or visit Quickbooks.intuit.com. 

Note: You have 90 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.

Check out the pre-move checklist for more info.

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

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

Check out the pre-move checklist for more info.

  1. Make sure QuickBooks is up-to-date.
  2. Mark any customers, vendors 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, vendors or employees. To delete unbilled charges, Go to Vendors then select Bills.
  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 to check. 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. 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.
  6. 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 Bank Feeds Center.
  7. 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. Make sure that Employee profile information (first, last name, SSN, Date of Birth, Hire Date and Address) are available and updated for all active employees.
    3. 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: Make sure to move your data at least a few days before your next payroll run. This will give you time to finish the setup for Online Payroll.
  8. If you use QuickBooks Desktop Payments:
    1. Your QuickBooks Online Account Admin email must have Admin level permissions on the QuickBooks Desktop Intuit account, for your QuickBooks Payments subscription to be moved to Online. See how you can provide the right permissions.
  9. If you use QuickBooks Time, contact us for help setting up your account in QuickBooks Online.

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

Important! If your QuickBooks Desktop version is 2021 or older or you don’t have access to QuickBooks Desktop, your only option to move to online is to use the web-based migration tool.
  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’lll 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. 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)
  6. If you use multi-currency in QuickBooks Desktop, you’ll have to select a home currency.
  7. 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/accounting to buy the right QuickBooks Online version for your company before starting migration.
  8. 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.  
  9. You’ll see your QuickBooks Online company names and subscriptions listed. Select the company you want to move your data to.
    1. If you do not see your QuickBooks Online company name and subscription listed, please call 800-730-0605.  
  10. 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.
  1. Select Agree, then Replace.
  2. Select Yes, go ahead and replace the data, then select Replace.

Use this option if:

  • you have QuickBooks Desktop 2021 or older or
  • you don’t have access to a QuickBooks Desktop installation.

Step 1: Open the online tool

  1. Select the link for your QuickBooks version:
    1. QuickBooks Pro/Premier
    2. QuickBooks Enterprise
    3. QuickBooks for Mac
      1. Convert your QuickBooks for Mac file to QuickBooks for Windows before you use the tool.
  2. Select Get Started, then sign in with your Intuit Account.
  3. 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.
      A picture of a company logo on a computer screen.
    2. Select Open to upload the file.
      • Alternatively, you can drag and drop your QuickBooks Desktop file to upload it.
        A desktop computer with a missing link.
    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.
      A computer keyboard with a picture of a person on it.
    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.
      A book with a picture of a computer screen.

Before you start using QuickBooks Online, check out the Move from QuickBooks Desktop to QuickBooks Online Resource Center where you can schedule a 1 hour call with one of our experts. We'll answer questions about your data move, show you around QuickBooks Online, and help you tackle everyday tasks.*

Next you can follow this list of what to setup in you new QuickBooks Online company.

  1. Connect your bank or credit card account.
  2. Create and send invoices to your customer.
    Note: If you track sales tax, set up location-based sales tax in QuickBooks first.
  3. Track your bills and learn how to pay them in QuickBooks.
  4. If you use payroll, follow this guide to set up and run your payroll in QuickBooks Online.
    Note: To view this, you'll need to sign in to QuickBooks Online.
  5. Get started with QuickBooks Online.

Let Us Teach You QuickBooks Online

Free Personalized Setup from QuickBooks Desktop Pro, Premier, Mac, or Plus (“Desktop”) to QuickBooks Online Simple Start, Essentials, Plus or Advanced (“QuickBooks Online”), or QuickBooks Desktop Payroll, Payments, or Time to QuickBooks Online Payroll, Payments, or Time is available to small business users and is subject to capacity. The Personalized Setup offer is eligible to Desktop customers that are migrating their data, as well as those customers who elect not to migrate their data, who are starting new QuickBooks Online accounts, and setting up QuickBooks Online. Personalized Setup is limited to a 1-hour session with a customer success product expert. Intuit reserves the right to limit the number of sessions and the length and scope of each session. Offers available for a limited time. Terms and conditions, features, support, pricing, and service options subject to change without notice.

QuickBooks Accountant Desktop PlusQuickBooks Desktop Enterprise DiamondQuickBooks Desktop Enterprise GoldQuickBooks Desktop Enterprise PlatinumQuickBooks Desktop Pro PlusQuickBooks 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.

More like this