QuickBooks Migration Tool: The Complete Expert Guide

You've decided to move from QuickBooks Desktop to QuickBooks Online. You open the built-in QuickBooks Migration Tool, follow the prompts, and wait. Then it fails—or it "succeeds," but your Balance Sheet doesn't match and payroll data is missing.

The QuickBooks Migration Tool is Intuit's built-in utility for converting Desktop company files to QuickBooks Online, accessed via Company > Export Company File to QuickBooks Online . It moves core data automatically, but it does not fix bad data, does not migrate everything, and does not verify accuracy.

As a QuickBooks ProAdvisor, I've guided hundreds of Desktop-to-Online migrations. The core lesson: the migration tool moves data, not guarantees. This guide explains how to use the QuickBooks Migration Tool correctly—and how to fix it when it fails. 

What Is the QuickBooks Migration Tool?

The QuickBooks Migration Tool is Intuit's built-in converter that exports core data from your QuickBooks Desktop company file (.QBW) and imports it into a QuickBooks Online company .

How to launch it: In QuickBooks Desktop, ensure you've updated to the latest version, then go to Company > Export Company File to QuickBooks Online .

Data the Migration Tool handles:

Data the Migration Tool does NOT migrate:

• Custom report templates and memorized reports
• Price levels and custom fields
• User permissions
• Bank feed connections
• Historical payroll data (requires manual entry)
• Attachments and audit trail

Critical Preparation Before You Migrate

The migration tool moves data. It does not fix bad data. This is the most important principle in the entire process. 

Clean Your QuickBooks Desktop File

1. Run Verify Data: Go to File > Utilities > Verify Data to check for data integrity issues.
2. Run Rebuild Data: If errors are found, go to File > Utilities > Rebuild Data to repair the file.
3. Verify again after rebuild to confirm the file is clean.

Check the File Size Limit

1. Critical limit: QuickBooks Desktop files exceeding 350,000 targets cannot be migrated with the built-in tool.
2. How to check: Press F2 (or Ctrl+1) in QuickBooks Desktop to view Product Information, then look for Total Targets.
3. If you exceed 350,000 targets: Clean up inactive customers, vendors, and items, or use Intuit's "Do it for me" conversion service.

Reconcile All Accounts

Reconcile every bank and credit card account to confirm balances before migration. Unreconciled accounts create post-migration verification problems.

Complete Outstanding Payroll and Tax Tasks

Finish all payroll runs and tax payments before migrating. The migration tool does not automatically convert historical payroll data—you'll need to manually enter year-to-date figures for each employee.

Print Key Reports for Verification

Print these reports from QuickBooks Desktop before migration:

• Balance Sheet Standard (All Dates, Accrual basis)
• Profit & Loss Standard (All Dates, Accrual basis)
• Payroll Details Report (All dates)

You'll use these to verify the migration succeeded.

Step-by-Step: Using the QuickBooks Migration Tool

Step 1: Switch to Single-User Mode

Go to File > Switch to Single-User Mode. The migration tool requires single-user mode.

In QuickBooks Desktop, go to Company > Export Company File to QuickBooks Online.

If you don't see this option, update QuickBooks Desktop via Help > Update QuickBooks Desktop.

Sign in with your Intuit account and select the QuickBooks Online company to receive the data.

Important: Do not create a new QuickBooks Online company here—it generates an additional subscription.

If importing inventory (2016 or later), enter an "as of" date. Use the first day following your company's last tax filing period to avoid needing amended tax returns.

Migration time varies by file size. You'll receive a confirmation email when complete. 

"QuickBooks Migration Failed Unexpectedly" Error Fix

If migration fails with "Migration Failed Unexpectedly," work through these fixes in order.

Fix 1: Verify and Rebuild Data

The most common cause is company file corruption.

1. In QuickBooks Desktop, go to File > Utilities > Verify Data.
2. If errors are detected, go to File > Utilities > Rebuild Data.
3. Backup when prompted.
4. Retry the migration.

Fix 2: Update QuickBooks Desktop

Outdated versions cause compatibility failures.

1. Go to Help > Update QuickBooks Desktop.
2. Click Update Now, then Get Updates.
3. Restart QuickBooks and retry migration.

Fix 3: Move File to Local Drive

Network drives or cloud-synced folders cause access conflicts.

1. Locate the company file folder.
2. Copy the file to a local C: drive folder.
3. Retry migration from the local location.

Fix 4: Disable Antivirus and Firewall Temporarily

Security software can block the migration tool from reaching Intuit servers.

1. Temporarily disable third-party antivirus real-time protection.
2. Temporarily disable Windows Firewall.
3. Retry migration.
4. Re-enable both immediately after.

Fix 5: Run as Administrator

Insufficient permissions block migration.

1. Close QuickBooks.
2. Right-click the QuickBooks icon.
3. Select Run as Administrator.
4. Retry migration.

Fix 6: Run Migration Tool in Compatibility Mode

OS conflicts can cause failure.

1. Find the migration tool's .exe file.
2. Right-click > Properties.
3. Go to the Compatibility tab.
4. Check Run This Program in Compatibility Mode.
5. Select Windows 8 or Windows 7.
6. Click Apply, then OK.

Post-Migration Verification: Do Not Skip This Step

Migration "completion" does not mean migration "accuracy." This is the most common false assumption.

Compare Financial Reports

1. Open QuickBooks Online and run the Balance Sheet and Profit & Loss reports.
2. Set dates to All Dates and basis to Accrual.
3. Compare line-by-line against the Desktop reports you printed before migration.
4. Accrual basis reports should match. Cash basis reports may not match due to calculation differences.

Watch for Suspense Accounts

The migration tool may route sales tax liabilities to Suspense accounts. Review each Suspense account, delete migrated tax payments, and recreate them in the QuickBooks Online Sales Tax Center.

Verify Payroll Data

The migration tool does not automatically convert historical payroll data. Manually enter year-to-date payroll figures for each employee. Cross-reference against the Desktop Payroll Details Report.

Check Bank Reconciliation Status

Bank reconciliation history does not transfer. You must reconcile from scratch in QuickBooks Online.

Real-World Example: Fixing a Failed Migration for a Retail Client

A retail client attempted to migrate from QuickBooks Desktop Premier to QuickBooks Online. The migration failed three times with "Migration Failed Unexpectedly." Their file had 280,000 targets.

Diagnosis: The company file had internal data corruption from a power outage, and the file was stored on a OneDrive sync folder causing access conflicts.

Steps Taken:

1. Ran Verify Data—detected 12 corrupted records.
2. Ran Rebuild Data to repair the corruption.
3. Copied the file from OneDrive to a local C: drive.
4. Disabled antivirus temporarily.
5. Ran migration as Administrator.
6. Migration completed successfully.

Result: Total resolution time: 45 minutes. The client avoided a costly professional conversion service.

Lesson: File corruption and network storage are the two most common causes of migration failure. Addressing both resolves most cases. 

Frequently Asked Questions

What is the QuickBooks Migration Tool?
It's Intuit's built-in converter for moving QuickBooks Desktop data to QuickBooks Online, accessed via Company > Export Company File to QuickBooks Online.

Does the migration tool move payroll data?
No. Historical payroll data does not transfer automatically. You must manually enter year-to-date figures for each employee.

Why does the migration tool fail unexpectedly?
Common causes: corrupted company file, outdated QuickBooks version, file exceeding 350,000 targets, network storage location, or antivirus interference.

Will my Balance Sheet match after migration?
Accrual basis reports should match. Cash basis reports may not. Also, watch for Suspense accounts created by sales tax rerouting.

Can I migrate a file over 350,000 targets?
No, the built-in tool cannot handle files exceeding 350,000 targets. You need Intuit's "Do it for me" service or third-party migration tools.

Should I keep my Desktop file after migrating?

Yes. Keep it in read-only mode for at least one full fiscal year for historical reference and audits. 

Conclusion

The QuickBooks Migration Tool is the starting point for Desktop-to-Online migration, not the finish line. It moves core data, but does not clean bad data, does not migrate payroll history, and does not verify accuracy. Success requires: cleaning your Desktop file before migration, verifying Balance Sheet and P&L accuracy after migration, and manually rebuilding payroll and bank reconciliation data.

When migration fails or data doesn't match, expert help saves days of manual cleanup.

Need to migrate QuickBooks Desktop to Online and want it done right? Call our Data Service Team at +1-(888)-718-7888 for expert migration support and get your books cloud-ready.