Business
Leesa Wing
If you are planning to move your accounting data from QuickBooks Desktop to the cloud, understanding how to migrate QuickBooks Desktop to QuickBooks Online can help you prepare your company file and avoid common transfer problems. QuickBooks provides migration options that can move eligible company data from Desktop to Online.
The migration process involves preparing the Desktop company file, checking its data, selecting the appropriate migration method, transferring the information, and reviewing the results in QuickBooks Online. This guide explains the process in simple steps and answers common questions users search for when moving their accounting data.
QuickBooks Desktop to QuickBooks Online migration is the process of moving eligible accounting data from a QuickBooks Desktop company file into QuickBooks Online.
QuickBooks Online operates independently from QuickBooks Desktop. After migration, your ongoing bookkeeping is performed in QuickBooks Online rather than through a continuous synchronization between the two products.
Depending on your QuickBooks Desktop version and situation, you may be able to use the Quickbooks migration tool inside QuickBooks Desktop or an online migration tool.
Before starting the transfer, prepare your company file carefully. A clean and updated file can reduce problems during the migration.
First, create or access your QuickBooks Online account.
Make sure your QuickBooks Online account is in the same country or region as your QuickBooks Desktop installation. You should also have administrator access to both the Desktop company file and the Online account.
Pay attention to the account-age window. Current Intuit guidance states that customers generally have 90 calendar days to move their data when they sign up themselves, while accountant-created accounts can have a 180-day window.
Open QuickBooks Desktop and install the latest available release for your version.
Using an updated version helps ensure that the migration tools and file-preparation features are available before you begin the transfer.
Before making significant changes to your accounting data, create a local backup of your original company file.
Keep the backup in a secure location. Having the original file available gives you a reference point if you need to compare information after migration.
QuickBooks uses a Total Targets count to determine whether a Desktop company file falls within the migration limits.
To check it:
If the file exceeds the limit, Intuit recommends condensing the company file before attempting the migration.
Files with very large target counts can also take longer to migrate and may have greater risks of discrepancies, particularly with inventory.
Before you migrate, check whether the company file contains data problems.
In QuickBooks Desktop:
If QuickBooks identifies data issues, use Rebuild Data where appropriate and then verify the company file again.
This step is important because transferring a company file with unresolved data problems can make troubleshooting after migration more complicated.
The Desktop company file should be available on your local computer before you begin the migration.
If the file is stored in a hosted or cloud environment, you may need to obtain a local copy first. Intuit specifically recommends having the company file stored locally for the migration process.
Before starting the migration, make sure QuickBooks Desktop is operating in Single-User Mode.
You can check this from the File menu. If the menu shows an option to switch to Multi-User Mode, QuickBooks is already in Single-User Mode.
This ensures that the company file is prepared correctly for the export process.
If you are searching for how to convert QuickBooks Desktop to QuickBooks Online, the actual process is essentially a migration or data-transfer process rather than a simple software conversion.
For supported Desktop versions such as Pro or Premier, you can start the process directly from QuickBooks Desktop.
Follow these general steps:
QuickBooks displays a progress indicator while the data transfer is processed.
If the destination QuickBooks Online company already contains data, pay close attention to the migration prompts.
The current migration process can ask you to confirm replacement of existing Online data. Intuit states that replacing the existing data cannot be undone, so review the destination company carefully before confirming.
Some users have a Desktop company file but do not currently have QuickBooks Desktop installed. In that situation, an online migration tool may be available.
The online tool can work with supported QuickBooks Desktop files, including:
Intuit's current guidance states that the online migration tool can be used with supported Desktop files from version 2011 or later. QuickBooks Desktop for Mac users may need to create a Windows-compatible backup before uploading the file.
The general process is:
The exact data transfer can depend on the Desktop version, Online product, company file configuration, and the features being used.
Some features do not work exactly the same way in QuickBooks Online as they do in QuickBooks Desktop. Therefore, you should not assume that every Desktop feature will have an identical Online equivalent.
After the migration, review important areas such as:
Payroll requires additional planning.
If you use QuickBooks Desktop Payroll, verify employee information before beginning the migration. Intuit recommends running payroll and waiting 2–3 business days before moving the data so paycheck information has time to synchronize.
Intuit also recommends completing the migration at least 7 business days before the next scheduled payroll to allow time for review and preparation.
Finishing the data transfer does not mean the process is complete.
After migration, compare important financial information between QuickBooks Desktop and QuickBooks Online.
Run comparable reports in both products and review the results.
Pay particular attention to:
Intuit recommends comparing financial reports after the migration to confirm that the copied data is accurate.
Your banking setup may require additional review after migration. Check connected financial accounts and confirm that transactions are downloading and categorizing correctly.
If your company uses inventory, examine quantities and values carefully. Large company files can have greater migration complexity around inventory, so this area deserves additional attention.
Confirm that the appropriate employees, accountants, and administrators have access to the QuickBooks Online company.
Users may encounter problems when the company file is not prepared correctly or when the file exceeds migration requirements.
Common situations include:
A company file with more than 4,000,000 targets does not meet the standard migration threshold. Condensing the file may reduce its target count.
If Verify Data identifies problems, rebuild the company file before attempting the migration.
The available migration options can vary depending on the QuickBooks Desktop version and company file. Make sure Desktop is updated and that you are signed in with the required administrator permissions.
Payroll data may require additional time after the last payroll run. Waiting the recommended 2–3 business days can help ensure recent payroll information is ready for migration.
If the QuickBooks Online destination already has information, carefully review the replacement warning before proceeding. A replacement action cannot be undone.
Use this checklist before starting:
Yes. Eligible QuickBooks Desktop company files can be moved to QuickBooks Online using the available Desktop migration tool or online migration tool. Eligibility and available options depend on the Desktop version and company file.
The migration time depends on the size and complexity of the company file. Larger files can require more time to process.
QuickBooks currently requires the Total Targets count to be below 4,000,000 for the standard migration process. A file exceeding that threshold may need to be condensed before migration.
No. QuickBooks Online and QuickBooks Desktop are independent products. After moving your data, ongoing bookkeeping takes place in QuickBooks Online rather than through continuous synchronization with Desktop.
Yes. Verifying the company file before migration can identify data issues that should be addressed before transferring the information.
Understanding how to migrate QuickBooks Desktop to QuickBooks Online is important before moving an active company file. The safest approach is to prepare the Desktop file first, create a backup, verify the data, check the Total Targets count, confirm payroll timing, and choose the appropriate migration method.
Whether you are searching for how to move QuickBooks Desktop to QuickBooks Online, how to convert QuickBooks Desktop to QuickBooks Online, or information about QuickBooks Desktop to Online migration, the preparation steps are largely the same: make the Desktop file ready, transfer the eligible data, and carefully compare your accounts and reports after the move.