Moving accounting data from one QuickBooks environment to another can feel complicated, especially when your company file contains years of transactions, customer records, vendors, payroll information, inventory, and customized settings. The QuickBooks Migration Tool is designed to simplify this process and help users transfer supported QuickBooks data without manually rebuilding their books.
QuickBooks migration can mean different things depending on your situation. You may be moving QuickBooks Desktop to a new computer, transferring QuickBooks Desktop data to QuickBooks Online, or moving QuickBooks Online data back to QuickBooks Desktop. Each process has different requirements and limitations.
According to Intuit’s current guidance, QuickBooks Desktop users can use built-in or online migration options to move supported company files to QuickBooks Online. Intuit also provides a Desktop Migration Tool for transferring QuickBooks Online data to QuickBooks Desktop.
What Is the QuickBooks Migration Tool?
The QuickBooks Migration Tool is a collection of Intuit-supported methods for transferring QuickBooks company data between supported QuickBooks products or computers.
The exact migration process depends on what you are trying to accomplish:
QuickBooks Desktop to another computer
QuickBooks Desktop to QuickBooks Online
QuickBooks Online to QuickBooks Desktop
QuickBooks Desktop for Windows to Mac
Multiple QuickBooks Desktop company files to QuickBooks Online
For example, when moving a QuickBooks Desktop company file to another computer, Intuit recommends creating a backup and restoring it on the new computer. QuickBooks Desktop users can also use the Migrator Tool when the appropriate conditions are met.
Why Use the QuickBooks Migration Tool?
Migration tools can save significant time compared with manually entering accounting information into a new company file.
A successful migration can help transfer supported information such as:
Company information
Customers and vendors
Chart of accounts
Transactions
Employees
Items and services
Banking information
Certain payroll information
Historical accounting records
However, not every QuickBooks feature or piece of data necessarily transfers exactly as it appears in the original product. You should always review your converted company after migration.
Intuit recommends comparing financial reports after a migration, particularly when moving data between QuickBooks Online and QuickBooks Desktop.
QuickBooks Desktop to QuickBooks Online Migration
One of the most common reasons people search for the QuickBooks Migration Tool is to move from QuickBooks Desktop to QuickBooks Online.
The current Intuit process allows eligible users to migrate their Desktop company file using the migration tool built into QuickBooks Desktop or an online migration tool.
Before You Start
Prepare your company file before beginning the migration.
Update QuickBooks Desktop to the latest available release.
Sign in as the company administrator.
Create a backup of your company file.
Verify that the company file is stored locally when required.
Run Verify Data and rebuild the file if QuickBooks identifies data problems.
Check the size and target count of your company file.
Review payroll information if payroll is being migrated.
Make sure the QuickBooks Online account is ready to receive the data.
Intuit currently states that Desktop files being migrated to QuickBooks Online must meet applicable file-size and target-count requirements. The current guidance identifies a limit of fewer than 4,000,000 targets for the standard migration process.
How to Use the QuickBooks Migration Tool
The exact menu names can vary according to your QuickBooks Desktop version, but the general process is:
Step 1: Open Your Company File
Launch QuickBooks Desktop and open the company file you want to migrate.
Sign in with the appropriate administrator credentials.
Step 2: Open the Migration Option
Look under the Company menu for the migration or export option.
For supported Pro and Premier versions, Intuit’s current process includes an option similar to Migrate this company file to QuickBooks Online.
Step 3: Prepare the Company File
QuickBooks may display a personalized checklist before allowing the migration to continue.
Complete the recommended preparation tasks and correct any company-file problems.
Step 4: Choose What to Transfer
Depending on the migration method, you may have the option to transfer all available company data or only selected lists and balances.
If you want your historical transactions available in the new QuickBooks company, carefully review the migration choices before continuing.
Step 5: Sign In to QuickBooks Online
Sign in using the administrator credentials associated with your QuickBooks Online account.
Choose the appropriate QuickBooks Online company.
Be extremely careful if the destination company already contains accounting data. Intuit warns that replacing existing QuickBooks Online data can be irreversible.
Step 6: Start the Migration
Select the appropriate export or migration option and allow QuickBooks to transfer the company data.
Migration time depends on the size and complexity of the company file.
Avoid closing QuickBooks or interrupting the process unless the software specifically instructs you to do so.
Moving QuickBooks Online Data to QuickBooks Desktop
Migration can also work in the opposite direction.
Intuit provides a Desktop Migration Tool that can export supported QuickBooks Online data and import it into QuickBooks Desktop. QuickBooks Desktop must be installed and open during the migration process.
The general process is:
Open QuickBooks Online.
Go to the appropriate export or migration area.
Download or launch the migration tool.
Make sure QuickBooks Desktop is installed and open.
Allow QuickBooks Online to communicate with the Desktop application.
Confirm the data transfer.
Wait for the migration to complete.
Open the resulting QuickBooks Desktop company file.
Compare important reports between the two versions.
Large migrations may take considerable time, so avoid interrupting the process.
Moving QuickBooks to a New Computer
You don’t necessarily need a full cloud migration if your goal is simply to move QuickBooks Desktop to another computer.
Intuit recommends creating a backup company file on the original computer, transferring that backup to the new computer, and restoring it there.
A basic workflow is:
Old computer → Create backup → Transfer backup → Install QuickBooks → Restore backup → Verify data
If you use payroll, Intuit recommends downloading the latest payroll tax table after moving the company file.
What Can Cause QuickBooks Migration Problems?
Migration problems can occur for several reasons, including:
Damaged company files
Unsupported QuickBooks versions
Incorrect administrator permissions
Large company files
Network or internet interruptions
Existing data in the destination company
Unsupported features or transactions
Payroll synchronization problems
Outdated QuickBooks Desktop releases
Security software blocking communication
Incorrect QuickBooks Online account credentials
Before migrating, it is important to make sure the source company file is healthy.
If you encounter company-file problems before migration, you can use QuickBooks Tool Hub to troubleshoot supported QuickBooks Desktop issues. Accounts Confidant’s guide explains how the utility can help with company-file, network, installation, and program problems.
How to Check Your Data After Migration
Never assume that a migration is successful simply because the transfer finishes.
Perform a post-migration review.
Balance Sheet
Profit and Loss
Accounts Receivable
Accounts Payable
Bank accounts
Customer balances
Vendor balances
Inventory quantities
Open invoices
Unpaid bills
Employee information
Payroll records
Sales tax information
Reconciled accounts
Run comparable reports in the original and migrated company. Intuit specifically recommends comparing reports, including Profit and Loss reports, when verifying migrated data.
For additional guidance on getting QuickBooks Desktop installed and ready on your computer, see the QuickBooks Desktop download guide.
QuickBooks Migration Tool vs. Manual Data Entry
Using a migration tool is generally more efficient than manually recreating years of accounting information.
Migration Method
Best For
Main Advantage
QuickBooks Migration Tool
Supported QuickBooks conversions
Faster automated transfer
Backup and Restore
Moving Desktop to another computer
Preserves a Desktop company file
Manual Entry
Small amounts of information
Useful when only limited data is needed
Accountant-assisted migration
Complex company files
Professional review and troubleshooting
For businesses with complicated payroll, inventory, multiple company files, or extensive historical data, professional assistance can reduce the risk of missing important information.
Tips for a Safe QuickBooks Migration
Follow these best practices before starting:
Always create a backup first.
Update QuickBooks before migration.
Check your company file for errors.
Review the destination company carefully.
Do not overwrite existing data unless you are certain.
Keep your original company file until verification is complete.
Compare financial reports after migration.
Review payroll and inventory separately.
Give large migrations enough time to finish.
Get professional assistance if the company file is complex.
Final Thoughts
The QuickBooks Migration Tool can make moving accounting data significantly easier, but migration should never be treated as a simple file-copy operation. The correct procedure depends on whether you’re moving QuickBooks Desktop to another computer, converting Desktop to QuickBooks Online, or transferring QuickBooks Online information back to Desktop.
Preparing the company file, creating a backup, checking compatibility, and verifying financial reports after the transfer are essential steps for protecting your accounting information.
If your migration is failing because of company-file errors, installation problems, or other QuickBooks Desktop issues, resolve those problems before attempting the transfer again.
Frequently Asked Questions
What is the QuickBooks Migration Tool used for?
The QuickBooks Migration Tool is used to transfer supported QuickBooks data between QuickBooks products or computers. The available migration process depends on the source and destination versions.
How do I use the QuickBooks Migration Tool to move QuickBooks Desktop to Online?
Open your supported QuickBooks Desktop company file, select the migration option, complete the preparation checklist, sign in to QuickBooks Online, choose the destination company, and start the export. Always back up and verify your data first.
Can I migrate QuickBooks Desktop to a new computer?
Yes. For a move to another computer, you can create a QuickBooks backup, transfer it to the new computer, install QuickBooks Desktop, and restore the backup.
Can I move QuickBooks Online data back to QuickBooks Desktop?
Yes. Intuit provides a Desktop Migration Tool for exporting supported QuickBooks Online data into QuickBooks Desktop. QuickBooks Desktop needs to be installed and open during the migration.
Does the QuickBooks Migration Tool transfer everything?
No. Migration capabilities depend on the QuickBooks products, versions, file type, and specific data involved. Some features or data may have conversion limitations, so you should compare the source and destination company after migration.
Why is my QuickBooks migration taking so long?
Migration time depends on factors such as company-file size, data complexity, internet connection, and the amount of information being transferred. Large migrations can take significantly longer than small company files.
Can I migrate a damaged QuickBooks company file?
A damaged or inconsistent company file can cause migration problems. It is better to verify and repair the company file before attempting migration. If necessary, use appropriate QuickBooks Desktop diagnostic tools or consult a QuickBooks professional.
Should I back up QuickBooks before using the Migration Tool?
Yes. Creating a backup before migration is one of the most important precautions. A backup gives you a recovery point if something goes wrong during preparation or transfer.
How do I know if my QuickBooks migration was successful?
Compare important financial reports between the original and migrated company. Check the Balance Sheet, Profit and Loss, accounts receivable, accounts payable, bank accounts, inventory, customers, vendors, and payroll information.
Can I migrate QuickBooks Desktop without losing historical transactions?
Supported QuickBooks Desktop-to-Online migration methods can transfer historical accounting data, but the exact data transferred depends on the migration method and supported features. Review the migration options carefully before starting.
What should I do if QuickBooks Migration Tool is not working?
First, update QuickBooks, verify the company file, confirm administrator access, check your internet connection, and review the migration requirements. If the company file has errors, resolve those issues before trying the migration again.
Is the QuickBooks Migration Tool free?
Intuit provides migration functionality as part of supported QuickBooks products and migration workflows. However, your QuickBooks subscription or destination product may have its own pricing and eligibility requirements.
Can I migrate multiple QuickBooks company files at once?
Yes, eligible QuickBooks Desktop Accountant users can use Intuit’s Accountant Batch Migration Tool to move multiple company files to QuickBooks Online. The current tool supports up to 50 client company files under its stated eligibility requirements.
How many company files can the Accountant Batch Migration Tool move?
The current Accountant Batch Migration Tool can migrate up to 50 client company files, provided the files and QuickBooks versions meet Intuit’s requirements.
Should I use a professional for QuickBooks migration?
Professional help can be valuable when dealing with large company files, complicated payroll, inventory, multiple businesses, damaged data, or a migration where financial accuracy is critical. A professional can also help compare reports and identify discrepancies after the transfer.
Leave a Reply