QuickBooks is a widely used accounting solution that helps businesses manage financial transactions, payroll, invoices, expenses, inventory, and other accounting activities. Many businesses that currently use QuickBooks Desktop are considering moving to QuickBooks Online to access their financial information from anywhere and simplify their accounting workflows.
Moving from QuickBooks Desktop to QuickBooks Online allows users to manage business finances through a cloud-based platform without depending on a single computer. However, migrating accounting data requires proper preparation to avoid missing transactions, data inconsistencies, and unexpected migration errors.
In this article, we will explain how to move from QuickBooks Desktop to QuickBooks Online, discuss the benefits of migration, outline the preparation requirements, and provide step-by-step instructions for transferring company data successfully.
What Does Moving from QuickBooks Desktop to QuickBooks Online Mean?
Moving from QuickBooks Desktop to QuickBooks Online means transferring your existing company information, accounting records, customer details, vendor information, and other supported data into the cloud-based QuickBooks Online platform.
QuickBooks provides built-in migration options that allow users to transfer their company files without manually recreating all their accounting records.
Depending on your requirements, you can choose to transfer:
- All supported company data, including transaction history.
- Customer and vendor information.
- Chart of accounts.
- Employee information.
- Products and services.
- Account balances and other supported financial records.
You can also choose to migrate only lists and balances if you prefer to start with a simpler accounting setup.
Benefits of Moving from QuickBooks Desktop to QuickBooks Online
Before starting the migration, it is helpful to understand why businesses choose QuickBooks Online.
1. Access Accounting Data Anywhere
QuickBooks Online allows users to access business financial information through an internet-connected device. You do not need to work exclusively from the computer where QuickBooks Desktop is installed.
2. Automatic Software Updates
QuickBooks Online receives product updates automatically, reducing the need for manual software installations and upgrades.
3. Improved Collaboration
Multiple authorized users can access the same company data based on their assigned permissions. This makes collaboration between business owners, employees, and accountants easier.
4. Automated Bank Transactions
Users can connect supported bank and credit card accounts to download transactions automatically, making financial tracking and reconciliation more convenient.
5. Mobile Accessibility
QuickBooks Online offers mobile access, allowing users to send invoices, review transactions, and manage certain accounting activities while away from the office.
6. Reduced Desktop Infrastructure
Since QuickBooks Online is cloud-based, businesses do not need to maintain the same local software infrastructure required for QuickBooks Desktop.
Things to Consider Before Moving from QuickBooks Desktop to QuickBooks Online
Before beginning the migration process, prepare your company file and review your accounting information.
1. Choose the Right QuickBooks Online Subscription
Select a QuickBooks Online subscription that supports your business requirements.
Consider the following factors:
- Number of users required.
- Inventory management needs.
- Payroll requirements.
- Reporting capabilities.
- Accountant access.
- Advanced accounting features.
Make sure your QuickBooks Online account is registered in the same country or region as your QuickBooks Desktop company.
2. Update QuickBooks Desktop
Install the latest available release supported by your QuickBooks Desktop version.
To update QuickBooks:
- Open QuickBooks Desktop.
- Select Help.
- Choose Update QuickBooks Desktop.
- Open the Update Now tab.
- Click Get Updates.
- Restart QuickBooks after the update finishes.
3. Create a Company File Backup
Creating a backup is one of the most important steps before migration.
Follow these instructions:
- Open QuickBooks Desktop.
- Select File.
- Choose Back Up Company.
- Select Create Local Backup.
- Choose a secure backup location.
- Complete the backup process.
Keep the original company file and backup until you have verified the migrated information.
4. Verify and Rebuild Company File Data
Damaged company file data can cause migration problems.
To verify your company file:
- Open QuickBooks Desktop.
- Select File.
- Navigate to Utilities.
- Select Verify Data.
- Follow the instructions displayed on the screen.
If QuickBooks identifies data damage, use Rebuild Data after creating a backup.
5. Check Company File Size
QuickBooks provides a file-size check before migration.
- Open your company file.
- Press F2 or Ctrl+1.
- Locate the Total Targets count in the Product Information window.
Intuit’s current migration guidance specifies a limit of fewer than 4 million targets for the standard migration process. If your file exceeds this limit, you may need to condense the company file before proceeding.
6. Prepare Payroll and Banking Information
If you use QuickBooks Desktop Payroll, review employee information and payroll records before migrating.
Also:
- Run payroll before migration when required.
- Plan the migration well ahead of your next payroll date.
- Reconcile bank and credit card transactions.
- Clear pending bank-feed transactions.
- Save a copy of your Sales Tax Liability report.
Intuit recommends planning payroll migration carefully, including allowing time for payroll setup and processing before the next payroll deadline.
How to Move from QuickBooks Desktop to QuickBooks Online
QuickBooks provides different methods for migrating company data. You can use the migration tool inside QuickBooks Desktop or the online migration tool.
Method 1: Use the QuickBooks Desktop Migration Tool
This is a convenient method if QuickBooks Desktop is already installed on your computer.
Follow these steps:
Step 1: Open QuickBooks Desktop
- Launch QuickBooks Desktop.
- Sign in to your company file as the administrator.
- Make sure the company file is open.
Step 2: Open the Migration Tool
- Navigate to the Company menu.
- Select Move to QuickBooks Online.
- Choose Export Your Company File to QuickBooks Online.
- Click Get Started.
Step 3: Select the Data You Want to Transfer
QuickBooks provides different migration options.
- Bring all your company data: Transfers supported company information, including lists and transaction history.
- Bring only lists and balances: Transfers customer, vendor, account, employee, and item information with current balances.
Choose the option that best matches your business requirements and click Continue.
Step 4: Sign In to QuickBooks Online
- Select Yes, sign me in.
- Enter your QuickBooks Online login credentials.
- Complete any requested account verification.
- Select Continue.
Step 5: Select Your QuickBooks Online Company
Choose the QuickBooks Online company where you want to transfer your Desktop data.
If you already have an existing company with data, QuickBooks may ask whether you want to replace it.Important
Replacing existing QuickBooks Online company data with Desktop data cannot be undone. If you need to preserve existing information, select a new or empty QuickBooks Online company instead.
Step 6: Complete the Migration Checklist
QuickBooks displays a checklist of tasks that must be completed before transferring your company file.
- Review the migration requirements.
- Resolve any identified issues.
- Complete the required preparation tasks.
- Select Continue.
Step 7: Export Your Company File
- Review the migration settings.
- Confirm your selected QuickBooks Online company.
- Click Export.
- Wait for the migration process to finish.
- Keep the migration window open until QuickBooks confirms that it is safe to close.
You will receive an email notification when the company data is available online.
Method 2: Use the QuickBooks Online Migration Tool
You can also migrate your company file through the online migration tool without having QuickBooks Desktop installed.
This option is useful if you have a company file but no longer have access to the Desktop application.
Step 1: Open the Online Migration Tool
- Access Intuit’s official QuickBooks migration tool.
- Click Get Started.
- Sign in using your QuickBooks Online account credentials.
Step 2: Upload Your Company File
Select the company file you want to migrate.
The online migration tool supports these file formats:
.QBW– QuickBooks company file..QBB– QuickBooks backup file..QBM– QuickBooks portable file.
Select your file and wait for the upload to complete.
Step 3: Sign In to Your Desktop Company File
Follow the instructions displayed by the migration tool.
Enter your QuickBooks Desktop administrator credentials when requested.
Step 4: Select Migration Preferences
Choose whether you want to transfer all supported company data or only lists and balances.
Review the available migration options carefully before proceeding.
Step 5: Complete the Migration
Follow the remaining instructions and confirm the destination QuickBooks Online company.
Wait until the migration process finishes. QuickBooks will display a confirmation message when your company is online.
The online migration tool supports eligible QuickBooks Desktop files from 2011 onward. Older files may require additional preparation.
Method 3: Move from QuickBooks Desktop for Mac
QuickBooks Desktop for Mac also provides a migration option for supported versions.
For QuickBooks Desktop for Mac 2020 and newer:
- Open QuickBooks Desktop for Mac.
- Open your company file.
- Select File.
- Choose Export.
- Select To QuickBooks Online.
- Click Get Started.
- Select Bring all your company file data or Bring only lists and balances.
- Sign in to your QuickBooks Online administrator account.
- Select your destination company.
- Click Export.
Wait until QuickBooks displays the successful migration confirmation.
What Data Transfers from QuickBooks Desktop to QuickBooks Online?
Not every QuickBooks Desktop feature or data element transfers exactly as it appears in the Desktop application.
The migration process transfers supported information, but some features may require manual setup or adjustments.
| Data or feature | Migration considerations |
|---|---|
| Customers | Customer information transfers |
| Vendors | Vendor information transfers |
| Chart of Accounts | Supported account information transfers |
| Transactions | Supported transaction history transfers |
| Employees | Employee information transfers |
| Products and Services | Supported item information transfers |
| Inventory | Requires appropriate inventory setup |
| Payroll | May require additional migration and setup |
| Bank Feeds | Bank connections need to be reconnected |
| Custom Reports | May require rebuilding |
| User Permissions | May require reviewing and configuring |
The exact results depend on the Desktop version, selected migration option, and supported QuickBooks Online features.
Common Problems When Moving from QuickBooks Desktop to QuickBooks Online
Sometimes, users encounter errors during the migration process. Understanding these issues can help prevent unnecessary delays.
1. QuickBooks Migration Failed Unexpectedly
This problem may occur because of damaged company files, unsupported file formats, or migration interruptions.
Solution: Verify your company file, update QuickBooks Desktop, and create a fresh backup before retrying the migration.
2. Company File Is Too Large
Large company files may exceed the supported migration limits.
Solution: Check the Total Targets count and condense the company file if necessary.
3. QuickBooks Online Account Not Found
Users may be unable to locate their destination company during migration.
Solution: Verify that you are signing in with the correct Intuit account and that you have administrator access.
4. Migration Gets Stuck
The migration process may take longer when transferring large or complex company files.
Solution: Maintain a stable internet connection and avoid closing the migration window prematurely.
5. Missing Transactions After Migration
Some information may not transfer exactly as expected.
Solution: Compare financial reports from QuickBooks Desktop and QuickBooks Online to identify discrepancies.
How to Verify Data After Moving to QuickBooks Online
Completing the migration does not mean the process is entirely finished. You should verify the transferred accounting information before continuing regular business operations.
Follow these steps:
- Sign in to QuickBooks Online.
- Open the migrated company.
- Review the Chart of Accounts.
- Check customer and vendor information.
- Review invoices and bills.
- Compare transaction records.
- Check payroll information, if applicable.
- Reconnect your bank and credit card accounts.
- Review inventory quantities and values.
- Verify financial reports.
Compare Important Financial Reports
Compare the following reports in both QuickBooks versions:
- Profit and Loss Statement.
- Balance Sheet.
- Accounts Receivable Aging.
- Accounts Payable Aging.
- Sales Tax Liability.
- Inventory Valuation Summary.
Use the same reporting dates and accounting methods when comparing reports. Intuit also recommends checking your migrated data before adding new transactions to QuickBooks Online.
Frequently Asked Questions (FAQs)
1. Can I move from QuickBooks Desktop to QuickBooks Online without losing data?
Yes, you can transfer supported company information using Intuit’s migration tools. However, some features and data may require additional configuration, so always verify the migrated information.
2. How long does it take to migrate QuickBooks Desktop to QuickBooks Online?
Migration time depends on company file size, transaction history, internet speed, and data complexity. Larger company files generally require more time.
3. Can I migrate QuickBooks Desktop Enterprise to QuickBooks Online?
Eligible Enterprise company files can be migrated using the supported migration workflow. However, some Enterprise-specific features may not be available in QuickBooks Online.
4. Can I migrate QuickBooks Desktop to QuickBooks Online without installing Desktop?
Yes. You can use the online migration tool to upload an eligible company file without installing QuickBooks Desktop.
5. Will my QuickBooks Desktop company file be deleted after migration?
No. The migration process copies your company data to QuickBooks Online. Your original Desktop company file remains separate, so keep it and its backup until you have verified the migration.
6. Is QuickBooks Desktop the same as QuickBooks Online?
No. QuickBooks Desktop is installed locally or accessed through a hosted environment, whereas QuickBooks Online is a cloud-based accounting platform. Their features, interfaces, and workflows differ.
7. How long do I have to migrate my QuickBooks Desktop data?
According to Intuit’s current guidance, the migration window is generally 90 calendar days when you sign up yourself or 180 calendar days when your accountant signs up for you. Check your account’s applicable deadline.
Conclusion
Moving from QuickBooks Desktop to QuickBooks Online can help businesses improve accessibility, simplify collaboration, and manage accounting activities through a cloud-based platform.
However, successful migration requires proper preparation, including updating QuickBooks Desktop, backing up company files, verifying financial data, and reviewing migration requirements.
You can use the built-in QuickBooks Desktop migration tool, the online migration tool, or the supported Mac migration option to transfer your company information.
After completing the migration, carefully compare financial reports, verify transactions, and reconnect services that require additional setup.
Following these steps will help make your transition from QuickBooks Desktop to QuickBooks Online more organized, reliable, and secure.
