How to Transfer QuickBooks Desktop to Online

Moving your company data from QuickBooks Desktop to QuickBooks Online is one of the most significant transitions a small business can make. When done correctly, the migration preserves your customer lists, vendor records, chart of accounts, and transaction history while giving your team anywhere, anytime access to your books. This guide covers every step of the process, the data that transfers successfully, and the common problems to watch for before and after migration. Steps verified on QuickBooks Desktop Pro 2022 and 2023 running on Windows 10 and Windows 11.

What Transfers When You Move from Desktop to Online?

Understanding exactly what moves -- and what does not -- is the most important step before you begin. Migrating with incorrect expectations leads to data gaps that are difficult to fix after the fact.

What Transfers Successfully

• Chart of accounts -- your full account list including account numbers
• Customers, vendors, and employees -- contact details, balances, and transaction history
• Products and services -- your items list with descriptions and prices
• Open and paid invoices -- including invoice history going back several years
• Bills and payments -- open bills and payment records
• Bank and credit card accounts -- account names and opening balances
• Journal entries -- standard journal entries carry over intact
• Classes and locations -- if you use them in Desktop, they transfer to Online

What Does Not Transfer

• Reconciliation history -- your reconciliation reports are not migrated. This means you will need to re-reconcile from scratch in QuickBooks Online unless you preserve PDF copies of your Desktop reconciliation reports before migrating.
• Budgets -- budgets created in Desktop cannot be imported. You must rebuild them manually in QuickBooks Online using the Budgeting tool.
• Custom user roles and permissions -- Desktop uses a different permission structure than Online. All users will need to be re-invited with new roles in QuickBooks Online.
• Custom fields (beyond three) -- QuickBooks Online supports up to three custom fields per list. If you have more in Desktop, only the first three are imported.
• Audit logs -- the full transaction audit trail from Desktop is not carried over.
• Memorized transactions -- recurring transaction templates must be recreated in QuickBooks Online as recurring transactions.
• Pending (uncleared) invoices marked as printed -- clear or delete these before migrating to avoid import errors.

Before You Start

Completing these pre-migration checks prevents the most common import failures.

Check Your File Size and Target Count

QuickBooks Desktop company files are subject to two limits for migration:

• File size: Files larger than 200 MB need to be condensed before import using QuickBooks' built-in condense tool (File > Utilities > Condense Data)
• Target count: Your company file must have fewer than 350,000 targets total. Press F2 in QuickBooks Desktop to open the Product Information window, which displays your current target count under the File Information section.

If your target count exceeds 350,000, you will be offered the option to migrate lists only (customers, vendors, items) rather than full transaction history.

Update QuickBooks Desktop to the Latest Release

An outdated Desktop installation will not display the export option.

1. Open QuickBooks Desktop
2. Go to Help > Update QuickBooks Desktop
3. Click the Update Now tab
4. Select Get Updates
5. After the download completes, close QuickBooks and reopen it
6. When prompted, click Install Now to apply the update

Do not proceed until all updates are fully installed. The export menu item will not appear in an outdated version.

Back Up Your Company File

Before any migration, create a local backup of your Desktop company file.

1. Go to File > Back Up Company > Create Local Backup
2. Choose a location outside your QuickBooks folder (an external drive or a separate folder on your desktop works)
3. Complete the backup wizard and confirm the backup file was created

Keep this backup until you have fully verified your QuickBooks Online data.

Complete All Open Reconciliations

Because reconciliation history does not transfer, finish reconciling all bank and credit card accounts in Desktop before migrating. Once you start the import, any unreconciled periods will need to be reworked entirely in QuickBooks Online.

Step-by-Step Migration Process

Step 1: Prepare Your Desktop Company File for Export

1. Open QuickBooks Desktop
2. Press F2 to open the Product Information window and record your target count and file location
3. Go to File > Utilities > Copy Company File for QuickBooks Online
4. Enter a name for the exported file and choose a save location you can easily find (your desktop works well)
5. Click Save and wait for QuickBooks to prepare the file

This creates a separate copy of your company file formatted for import into QuickBooks Online. Your original Desktop file is not modified.

Step 2: Sign In to QuickBooks Online

1. Go to quickbooks.intuit.com and sign in to your QuickBooks Online account
2. If you do not yet have a QuickBooks Online subscription, start a trial -- your 60-day import window begins from the date you first sign up

When you first sign in to a new QuickBooks Online account, you will see a setup wizard. You can import your Desktop data at this stage or skip the wizard and import from the settings later.

Step 3: Start the Import

1. In QuickBooks Online, click the Gear icon (Settings) in the upper right
2. Select Import Data from the Tools section
3. Choose QuickBooks Desktop
4. Click Browse and navigate to the copy of the company file you created in Step 1
5. Select the file and click Open
6. Review the import summary screen, which shows what data will be migrated
7. Click Import to begin the process

The import screen will display a message confirming that QuickBooks will email you when the process is complete. Do not close the browser tab or log out during the upload.

Step 4: Wait for the Import to Complete

The import typically takes between 1 and 24 hours depending on the size of your company file. You will receive an email at the address associated with your QuickBooks Online account when the import finishes.

Do not attempt to enter data into QuickBooks Online while the import is running. Any data entered before the import completes will be overwritten.

Step 5: Verify Your Data After Import

Once you receive the confirmation email, log in to QuickBooks Online and run these verification checks before using the account for live transactions.

1. Run a Balance Sheet in QuickBooks Online (Reports > Balance Sheet) and compare the totals to a Balance Sheet you printed from QuickBooks Desktop on the day of migration
2. Run a Profit and Loss statement for the current year and compare it to the same report from Desktop
3. Check your customer balances -- open the Customer list and spot-check a few accounts with known balances
4. Verify your bank accounts -- confirm that account balances match what you had in Desktop

If you find discrepancies, do not start entering new transactions until the differences are resolved. Contact QuickBooks support for assistance reconciling mismatched data.

Common Problems and How to Fix Them

Import Option Does Not Appear

If the Copy Company File for QuickBooks Online option is missing from the File > Utilities menu, QuickBooks Desktop has not been updated. Return to Help > Update QuickBooks Desktop and apply all available updates, then restart QuickBooks.

For QuickBooks Enterprise users: the same option appears under File > Utilities > Export to QuickBooks Online.

File Is Too Large to Import

If your file exceeds 200 MB, use the condense tool to reduce its size.

1. Go to File > Utilities > Condense Data
2. Follow the wizard to remove old transaction detail (the wizard keeps all running balances)
3. After condensing, check the file size again in the Product Information window (F2)

Note that condensing removes detailed transaction history for older periods. Preserve reports or exports of historical data before condensing if you need them for reference.

Import Fails Partway Through

If the import fails mid-process, sign out of QuickBooks Online and sign back in. Your 60-day import window allows you to re-upload the company file as many times as needed. The most recent import always replaces any previous data.

Common causes of mid-import failures include:

• A network interruption during file upload
• Pending invoices in a printed state that were not cleared before export
• Special characters in account names or customer names (remove them from Desktop before re-exporting)

Data Discrepancies After Import

If your Balance Sheet or Profit and Loss totals in QuickBooks Online do not match your Desktop reports, the discrepancy usually comes from one of these sources:

• Opening balance entries: QuickBooks Online may create an opening balance entry that affects account totals
• Sales tax: Desktop and Online handle sales tax differently, which can cause apparent discrepancies in liability account balances
• Multi-currency: If you use multiple currencies in Desktop, the import may convert some transactions at different rates

Work through each discrepancy account by account before entering new data.

Setting Up QuickBooks Online After Migration

Once your data is verified, complete these setup tasks before your team starts using QuickBooks Online.

Re-Invite Your Team

All users from QuickBooks Desktop must be re-invited to QuickBooks Online.

1. Go to Settings > Manage Users
2. Click Add User
3. Assign each user a role (Standard User, Custom Role, Company Admin, or Time Tracking Only)
4. Send the invitation

Roles in QuickBooks Online work differently from Desktop permissions. Review each user's access level carefully before sending invitations.

Recreate Recurring Transactions

Memorized transactions from Desktop do not transfer. To recreate them in QuickBooks Online:

1. Find a transaction of the type you want to recur (invoice, bill, or expense)
2. Open it and click Make Recurring at the bottom of the form
3. Set the schedule, start date, and end conditions
4. Save the recurring template

Connect Your Bank Accounts

QuickBooks Online's bank feed connects your bank accounts directly for automatic transaction import. To connect:

1. Go to Transactions > Bank Transactions
2. Click Connect Account
3. Search for your bank and follow the prompts to authenticate

Bank feeds are one of the primary advantages of QuickBooks Online over Desktop. Setting them up immediately after migration saves significant manual entry time.

Rebuild Your Budgets

Budgets must be recreated manually in QuickBooks Online.

1. Go to Settings > Budgeting
2. Click Add Budget
3. Select the fiscal year and budget type (Account, Customer, or Class)
4. Enter your budget figures account by account

When to Call Support

Contact QuickBooks support phone number if:

• The import option does not appear after updating to the latest QuickBooks Desktop release
• Your import fails repeatedly despite removing known problem items
• Data discrepancies remain after comparing reports account by account
• Your target count exceeds 350,000 and you need guidance on migrating lists separately
• You are beyond the 60-day import window and need to discuss options for migrating to QuickBooks Online after the window has closed