You have outgrown your office server. Your bookkeeper works from home. Your accountant wants real-time access. And you are tired of error -6190 -816 locking everyone out every other week. Moving from QuickBooks® Desktop to QuickBooks® Online (QBO) is the right call — but one wrong step during migration can corrupt your chart of accounts, lose your historical transactions, or strand your inventory data in an unusable format. This guide walks you through the entire Desktop-to-Online migration process: pre-migration cleanup, the conversion itself, post-migration verification, and what to do when things go wrong. We have performed hundreds of these migrations. If you want it done right the first time, call +1-888-550-4779. Fees apply.
What Is a QuickBooks® Desktop to Online Migration?
A Desktop-to-Online migration is the process of converting your QuickBooks® Desktop company file (.QBW) into a format that QuickBooks® Online can import and use. Intuit® provides a free conversion tool that extracts lists (customers, vendors, items, chart of accounts), transactions (invoices, bills, payments, journal entries), and settings from your Desktop file and reconstructs them in a new QBO company. The migration is not a simple file copy — it is a data transformation because Desktop and Online use different database architectures, different inventory methods, and different feature sets. Some data transfers perfectly. Some data requires manual reconstruction. Some data does not transfer at all.
Why Do Desktop-to-Online Migrations Fail or Produce Bad Results?
- File size exceeds limits: QuickBooks® Online has a 350MB or 350,000-target limit for converted files. Oversized Desktop files truncate during conversion.
- Inventory method incompatibility: Desktop uses average cost or FIFO (with Advanced Inventory). Online uses FIFO only for certain plans. Average cost inventory values recalculate incorrectly.
- Multi-currency not supported in all QBO plans: Desktop files with multi-currency enabled may fail to convert or lose foreign currency transactions.
- Corrupted Desktop file: A file with existing data damage passes damage into the Online version, creating phantom balances and broken links.
- Duplicate list entries: Desktop allows duplicate customer or vendor names with subtle differences. Online rejects duplicates, causing import failures.
- Unsupported features: Desktop features like fixed asset management, advanced reporting, payroll direct deposit setup, and custom form templates do not exist in Online.
- User permission complexity: Desktop's granular user permissions do not map to Online's role-based permissions, leaving some users with incorrect access.
- Attachment file size limits: Desktop attachments often exceed Online's 25MB per file limit, causing attachment loss during migration.
- Account number gaps: Desktop allows non-sequential or alphanumeric account numbers that Online restructures, breaking report filters.
⚠️ Warning: Always back up your Desktop file before attempting migration. The conversion process modifies source data and cannot be undone if it fails midway.
Step-by-Step Fix Guide
1 Pre-Migration Cleanup in QuickBooks® Desktop
Clean data migrates cleanly. Dirty data creates phantom balances, broken links, and missing records in QBO.
- Back up your Desktop company file to three locations: local external drive, cloud storage, and email to yourself. Label the backup with the date.
- Run File → Utilities → Verify Data. If errors appear, run Rebuild Data and verify again until clean.
- Condense old transactions if your file exceeds 300MB: File → Utilities → Condense Data. Remove transactions before a specific date, keeping list data intact.
- Merge duplicate customers and vendors: Lists → Customer/Vendor List, edit duplicates to match the primary name, and merge when prompted.
- Clean up your Chart of Accounts: inactivate unused accounts, ensure account numbers are sequential, and verify no account names contain special characters (&, #, %).
- Reconcile all bank and credit card accounts through your most recent statement. Unreconciled periods create reconciliation gaps in Online.
2 Export and Prepare the Desktop File for Conversion
The export process locks your file and uploads it to Intuit®'s conversion servers. Plan this during low-activity hours.
- Ensure all users are logged out of the Desktop file. Single-user mode is required for export.
- Go to Company → Export Company File to QuickBooks® Online. If this option is grayed out, your Desktop version is too old — you must upgrade to 2024 or newer first.
- Click Get Started and select whether to copy Inventory (if you have it) or start fresh in Online.
- Choose your target QBO region: United States, Canada, UK, or Australia. This cannot be changed later.
- Enter your existing Intuit® Account email (for an existing QBO subscription) or create a new one. The Desktop file will upload to Intuit®'s conversion servers.
- The upload time depends on file size and internet speed. A 200MB file takes 30–60 minutes on a standard broadband connection. Do not interrupt the upload.
3 Monitor the Conversion and Handle Errors
Conversion errors are common — knowing how to respond saves days of back-and-forth with Intuit® support.
- After upload, Intuit® sends a confirmation email. Click the link to check conversion status at quickbooks.intuit.com.
- Conversion typically takes 2–24 hours. You will receive a second email when complete.
- If you receive an error email, common causes include: file too large (reduce and re-upload), unsupported features detected (remove them in Desktop and retry), or corrupted lists (run Rebuild Data again).
- For inventory files: Intuit® converts average cost to FIFO by recalculating based on purchase order history. Review inventory valuations immediately after conversion.
- If conversion fails three times, contact Intuit® migration support or call +1-888-550-4779 for manual migration services. Fees apply.
4 Post-Migration Verification in QuickBooks® Online
Verification is non-negotiable. A single wrong balance in QBO propagates to every report, tax filing, and management decision.
- Log into your new QBO company and go to Reports → Balance Sheet Standard. Compare the ending balances to your Desktop Balance Sheet as of the conversion date. They must match exactly.
- Run Reports → Profit & Loss Standard for the current year-to-date. Compare to Desktop P&L. Investigate any variance over $1.00.
- Open Sales → Customers and verify customer count matches Desktop. Spot-check 5–10 customer records for correct contact info and open balance.
- Open Expenses → Vendors and repeat the customer verification process for vendors.
- Check Accounting → Chart of Accounts for correct account types, balances, and active/inactive status. Online sometimes reclassifies accounts.
5 Reconstruct What Did Not Transfer
Some Desktop features simply do not exist in Online. Reconstruction is manual but essential for operational continuity.
- Custom templates: Desktop invoice and estimate templates do not transfer. Recreate them in Settings → Custom Form Styles or use QBO's built-in templates.
- Fixed Asset Items: If you used Fixed Asset Manager in Desktop, export the depreciation schedule to Excel and manually create journal entries in Online.
- Payroll setup: Desktop payroll data (employee records, YTD totals, tax forms) does not transfer. You must set up QBO Payroll separately and enter opening balances.
- Attachments: Download attachments from Desktop via Doc Center, then re-upload to Online transactions. Online limits files to 25MB each.
- Memorized reports: Recreate favorite reports in Reports → Custom Reports. Online's report builder is different but more flexible.
6 Train Users and Decommission Desktop
A failed go-live is almost always a training failure, not a technical one. Invest time in user education before flipping the switch.
- Create user accounts in QBO for every Desktop user: Settings → Manage Users → Add User. Assign appropriate roles (Standard All, Standard No Access, Reports Only, etc.).
- Hold a 30-minute team training session covering: the QBO dashboard layout, creating invoices and bills, bank feed matching, and running reports.
- Set a "go-live" date where all new transactions occur in QBO only. Post the date in writing to all staff.
- Keep the Desktop file in read-only mode for 90 days as a reference archive. Do not enter new transactions.
- After 90 days, archive the Desktop backup to cold storage and cancel your Desktop subscription if applicable.
Prevention Checklist
Ensure a Smooth Migration
- Verify Desktop file integrity (Verify + Rebuild) before every migration attempt
- Condense files over 300MB to avoid conversion truncation
- Merge all duplicate list entries before export
- Reconcile all accounts through the most recent statement
- Document your inventory valuation method — expect FIFO recalculation
- Export a complete set of Desktop reports (Balance Sheet, P&L, A/R Aging, A/P Aging) before migration for comparison
- Verify QBO subscription tier supports all needed features (multi-currency, classes, locations, 1099s)
- Schedule migration during a low-activity period (weekend, month-end close completed)
Frequently Asked Questions
Need Expert Help with QuickBooks®?
Our independent technicians fix QuickBooks® issues remotely. Free diagnosis on every call.
📞 Call +1-888-550-4779 — Free Diagnosis⚠️ Disclaimer: InstantDesk Support is an independent, third-party technical support provider. We are not affiliated with Intuit Inc. or QuickBooks®. For free official support, visit quickbooks.intuit.com.