The QuickBooks Desktop to QuickBooks Online migration process allows businesses to move eligible accounting data from the Desktop version into a cloud-based QuickBooks Online company. Moving to Online can make it easier to access bookkeeping information from different locations, collaborate with accountants and team members, and work without relying on a locally stored company file.
However, migration should be planned carefully. QuickBooks Desktop and QuickBooks Online use different systems, so some features, terminology, and data can appear differently after the transfer. Before starting, you should prepare the company file, check its size, verify the data, and understand what will and will not move.
This guide explains how to prepare for migration, move your company file, handle common issues, and verify your accounting data afterward.
What Is QuickBooks Desktop to QuickBooks Online Migration?
QuickBooks Desktop to QuickBooks Online migration is the process of transferring an eligible QuickBooks Desktop company file into QuickBooks Online.
Instead of maintaining accounting information only on a local computer, your migrated company operates through QuickBooks Online. The Desktop and Online products are separate, meaning they do not continuously synchronize after the migration. Once you move your active bookkeeping to Online, new transactions should generally be recorded in the Online company rather than entering them separately in both versions.
Intuit currently provides two main ways to migrate:
Using the migration option within QuickBooks Desktop
Using the online migration tool to upload an eligible company file
The appropriate method depends on your Desktop version, company file, and circumstances.
Why Move QuickBooks Desktop to QuickBooks Online?
Businesses may choose QuickBooks Online when they want a cloud-based accounting environment.
Some commonly considered benefits include:
Accessing accounting information from supported devices
Collaborating with accountants and other users
Connecting bank and credit-card accounts
Reducing dependence on local servers
Accessing cloud-based bookkeeping tools
Using connected QuickBooks services and applications
Working with accounting data while away from the office
QuickBooks Online also provides browser-based access, while a desktop application is available for users who prefer a desktop-style experience.
What to Do Before QuickBooks Desktop to QuickBooks Online Migration
Preparation is one of the most important parts of the migration process. A clean and compatible Desktop company file can help reduce problems during the transfer.
1. Update QuickBooks Desktop
Before beginning, update QuickBooks Desktop to the latest available release for your version.
An outdated installation may not contain the latest migration improvements or requirements.
2. Create a Backup
Create a local backup of your original company file before starting.
Keep the backup in a secure location. This gives you a separate copy of your original accounting records if you need to review historical information later.
3. Check the Company File Size
QuickBooks uses a Total Targets count to determine company-file size for migration purposes.
To check it:
Open QuickBooks Desktop.
Press F2 or Ctrl+1.
Locate Total Targets in the Product Information window.
Confirm that the count is below the applicable migration limit.
Intuit currently states that the company file must have fewer than 4,000,000 Total Targets for the standard import process. Files exceeding the threshold need to be condensed before migration.
4. Verify Your Company Data
Before transferring the file, check whether it contains data problems.
In QuickBooks Desktop, go to:
File → Utilities → Verify Data
If QuickBooks identifies an issue, follow the appropriate repair process before attempting migration.
This step is useful because transferring a problematic company file can create additional complications during or after conversion.
5. Keep the Company File Locally
Your company file should be saved on the local hard drive before migration.
If the file is stored through a hosting service or cloud utility, you may need to obtain a local copy first. Intuit specifically recommends having the company file stored locally for the migration process.
6. Switch to Single-User Mode
Before exporting, confirm that QuickBooks Desktop is running in Single-User Mode.
Go to the File menu and check the user-mode option. If you see Switch to Multi-user Mode, the company is already in Single-User Mode.
How to Migrate QuickBooks Desktop to QuickBooks Online
Once your company file is ready, you can begin the transfer.
Step 1: Create or Open Your QuickBooks Online Account
First, sign in to your QuickBooks Online account or create a new one.
The QuickBooks Online company should be in the same country or region as your Desktop company, and you should have administrator access to both accounts.
Step 2: Open Your Desktop Company File
Launch QuickBooks Desktop and open the company file you want to migrate.
Make sure you have selected the correct company before beginning the export.
Step 3: Start the Migration
For eligible Pro or Premier versions, Intuit's current instructions direct users to the Company menu and then the migration/export option for QuickBooks Online.
Enterprise users have a different keyboard-based route to access the export window.
Follow the on-screen migration checklist and complete the required preparation tasks.
Step 4: Choose What to Transfer
Depending on your migration options, you may be able to choose between transferring all eligible company data or moving only lists and balances.
Lists can include:
Customers
Vendors
Employees
Chart of accounts
Items
If you select the full-company-data option, QuickBooks transfers the eligible accounting information according to its current migration rules.
Step 5: Sign In to QuickBooks Online
Sign in using the email address and password associated with your QuickBooks Online account.
Select the Online company where you want the Desktop data to be transferred.
Be especially careful if the Online company already contains information. Intuit notes that replacing existing Online data cannot be undone through the migration process, so verify the destination company before confirming the transfer.
Step 6: Start the Export
Select the export option to begin transferring your company file.
A progress indicator appears while QuickBooks processes the data. Migration time can vary according to the size and complexity of the company file.
Using the Online Migration Tool
An online migration tool is another option in certain situations.
For example, it can be useful if:
You do not currently have QuickBooks Desktop installed.
You are an accountant helping a client migrate.
You have an eligible Desktop company file but need to upload it through the online process.
Intuit's current online migration tool supports eligible .QBW, .QBB, and .QBM files. QuickBooks Desktop for Mac users need to create a Windows-compatible backup/company file for the applicable migration process.
The general process is:
Open the online migration tool.
Sign in to QuickBooks Online.
Select the company file.
Upload the file.
Follow the migration prompts.
Wait for the transfer to finish.
Open your Online company and review the converted data.
QuickBooks Payroll Migration Considerations
Payroll requires additional planning.
If you use QuickBooks Desktop Payroll, Intuit currently recommends running payroll before migration and waiting 2–3 business days after the payroll run so the information can sync.
Intuit also recommends completing the migration at least 7 business days before the next scheduled payroll to help avoid payroll-related delays. Employee information should also be reviewed before starting the migration.
Payroll data can have specific migration rules, so review the current Intuit requirements for your particular Desktop and Online setup.
What Data Moves to QuickBooks Online?
Many accounting records can transfer, but the exact result depends on the Desktop version, features used, and migration method.
Common information that may transfer includes:
Customers
Vendors
Employees
Chart of accounts
Products and services
Transactions
Invoices
Bills
Banking-related records
Payroll-related information where applicable
Historical accounting data
However, Desktop and Online do not have identical features. Some Desktop features have different Online equivalents, while others may not transfer in the same way. Intuit maintains a current comparison of features and data that move or do not move during migration.
QuickBooks Jobs After Migration
If your business uses jobs in QuickBooks Desktop, pay attention to how they should be represented in QuickBooks Online.
Intuit currently provides options for moving Desktop jobs into Projects or Sub-customers, depending on how you use the records.
Projects can be useful for job costing and profit tracking, while sub-customers may be appropriate when jobs are being used for independent billing.
Review your job structure before completing the migration so that your customer relationships and project tracking remain organized.
What Happens After Migration?
The migration is not finished simply because the data transfer completes.
You should review the Online company carefully before relying on it for everyday bookkeeping.
Start by comparing key financial reports between QuickBooks Desktop and QuickBooks Online.
Important reports include:
Profit and Loss
Balance Sheet
Accounts Receivable
Undeposited Funds
Account balances
Customer balances
Vendor balances
Intuit recommends comparing the Profit and Loss and Balance Sheet using an All Dates reporting period and an Accrual accounting method when checking the migrated data.
Common QuickBooks Desktop to QuickBooks Online Migration Problems
Company File Is Too Large
A company file with more than 4,000,000 Total Targets does not meet the current standard migration threshold.
In this situation, you may need to condense the company file before attempting the transfer. Intuit recommends creating a backup before condensing and provides a dedicated process for reducing the target count.
Company File Has Data Errors
Data inconsistencies can interfere with migration.
Run Verify Data and address identified problems before trying again.
Migration Destination Contains Existing Data
Be careful when selecting an existing QuickBooks Online company.
According to Intuit's current migration instructions, replacing existing Online data is not reversible through the migration process. Verify the company name and destination before confirming.
Desktop and Online Look Different
It is normal for some features, terminology, and account details to appear differently after migration. QuickBooks Desktop and Online do not use identical interfaces or feature structures.
How to Make QuickBooks Desktop to QuickBooks Online Migration Easier
Before starting your migration, use this checklist:
Update QuickBooks Desktop.
Create a complete local backup.
Verify the company file.
Repair data problems if necessary.
Check Total Targets.
Condense the file if it exceeds the applicable limit.
Save the company file locally.
Use Single-User Mode.
Review payroll information.
Confirm the correct QuickBooks Online company.
Review feature differences.
Compare financial reports after migration.
Following these steps can make it easier to identify problems before they affect your accounting workflow.
Frequently Asked Questions
Can I migrate QuickBooks Desktop to QuickBooks Online?
Yes. Eligible QuickBooks Desktop company files can be moved to QuickBooks Online using the Desktop migration process or the applicable online migration tool. The requirements depend on the Desktop version and company file.
Does QuickBooks Desktop sync with QuickBooks Online after migration?
No. QuickBooks Desktop and QuickBooks Online are separate products and do not continuously synchronize. After migration, your active bookkeeping should be maintained in the Online company if that is where you have moved your operations.
How many targets can a QuickBooks Desktop file have?
Intuit currently states that the standard migration process requires fewer than 4,000,000 Total Targets. A file above that threshold needs additional preparation before migration.
Can I keep my original QuickBooks Desktop file?
Yes. The original Desktop company file remains separate from the QuickBooks Online company. Keeping a secure backup is recommended so you retain access to the original records.
How long does QuickBooks Desktop to QuickBooks Online migration take?
The time depends on the size and complexity of the company file and the migration method. Larger or more complex files can take longer to process.
What should I check after migration?
Compare important financial reports and review customers, vendors, accounts, transactions, payroll, inventory, and other business-specific information. Intuit recommends comparing key reports such as Profit and Loss and Balance Sheet after migration.
Conclusion
The QuickBooks Desktop to QuickBooks Online migration process provides a way to transfer eligible Desktop accounting data into a cloud-based QuickBooks Online company. A successful migration starts with preparation: update the software, back up the company file, verify the data, check the Total Targets count, and make sure the file is stored locally.
After the transfer, take time to compare financial reports and review important accounting records. Because Desktop and Online have different features and workflows, some information may appear differently after conversion.
Migration requirements can change as Intuit updates its products and tools, so check the latest official requirements before beginning your transfer.
