Guide · Migration

How to migrate QuickBooks Desktop to Online – complete walk-through.

Intuit's QuickBooks Desktop wind-down is pushing most QBDT users to migrate to QBO. This guide covers the actual migration process: pre-migration preparation, running the conversion utility, post-migration cleanup, what transfers cleanly, and what needs rework.

Pre-migration

Pre-migration preparation (week before)

Skipping prep creates migration headaches. Investment before migration pays off 5x post-migration.

1. Update QBDT to the latest version

In QBDT: Help → Update QuickBooks Desktop. Install updates and restart. QBO conversion tool works best with latest QBDT version.

2. Run Verify Data utility

In QBDT: File → Utilities → Verify Data. Identifies corruption or errors in data file. If errors found, run Rebuild Data immediately after.

3. Clean up your data

  • Merge duplicate customer/vendor records
  • Mark inactive customers, vendors, accounts that won't carry forward
  • Resolve any negative inventory balances
  • Clear out old uncleared bank transactions (write off or reconcile)
  • Apply unapplied customer credits

4. Document your current setup

  • Screenshot custom reports (they won't transfer; rebuild needed)
  • Note custom templates (invoice, estimate, check templates)
  • Document user access and permissions
  • List integrations and their current configurations

5. Backup everything

In QBDT: File → Back Up Company → Create Local Backup. Store backup in multiple locations. This is your safety net if migration has issues.

6. Choose timing

Best times: fiscal year-end (cleanest), month-end (acceptable), start of quarter (acceptable). Worst times: mid-month, during tax filing season, during audit.

Migration steps

The actual migration process

Step 1: Create QBO account

Sign up for QBO at appropriate tier. Don't skimp here – if you know you'll need Plus or Advanced features, sign up for that tier rather than migrating twice. Downgrading after migration can cause data issues.

Step 2: Export from QBDT

In QBDT:

  • Open the company file you're migrating
  • Go to Company → Export Company File to QuickBooks Online
  • Follow the on-screen prompts
  • Accept the destination QBO account

The export uploads your data to Intuit's conversion servers. Depending on file size, can take 30 minutes to several hours.

Step 3: Monitor conversion

Intuit emails when conversion is complete (usually within 24–72 hours for small files, longer for complex files). Conversion may surface warnings or errors requiring attention.

Step 4: Initial verification

Log into QBO after conversion:

  • Check Trial Balance as-of migration date; compare to QBDT Trial Balance for same date. They should match.
  • Review AR aging; compare to QBDT AR aging
  • Review AP aging; compare to QBDT AP aging
  • Review fixed asset balances
  • Review bank balances and recent reconciliation status

Investigate any discrepancies before relying on the QBO data.

Post-migration

Post-migration cleanup

Rebuild what didn't transfer

  • Custom reports: rebuild in QBO using the report builder. Not all QBDT reports have direct QBO equivalents.
  • Memorized transactions: recreate as recurring transactions in QBO
  • Custom templates: recreate invoice/estimate templates in QBO's template designer
  • Custom forms: rebuild as applicable
  • Attachments: if QBDT had file attachments, may need to re-attach in QBO depending on conversion version

Reconnect integrations

  • Bank feeds: reconnect each bank account to QBO
  • Payroll: set up QBO Payroll or integrate external provider
  • Bill.com, Ramp, Expensify: reconnect and test sync
  • Shopify, Amazon, other commerce integrations
  • Time tracking tools

User setup

  • Invite users to QBO with appropriate permission levels
  • Note: QBO permissions work differently than QBDT; review carefully
  • Train users on QBO interface differences

Parallel run

For first month post-migration, many accountants run parallel: bookkeeping in QBO while keeping QBDT available for reference. Catches issues early. After month 1 looks clean, retire active QBDT use.

Retain QBDT access

Keep QBDT access for 6–18 months post-migration for historical reference. Historical audit requests, tax amendments, and legal discovery may need detailed QBDT records not fully captured in QBO migration.

When to hire help: small businesses under $1M revenue with clean QBDT files can often self-migrate with care. Businesses above that, or with complex inventory, multi-location, or heavy customization should hire a migration specialist. Cost $1,500–$8,000 typically; pays for itself by avoiding weeks of post-migration cleanup.

Related: QBDT vs QBO, QBO platform, offshore bookkeeping.

Related

Related pages

Have specific questions? Let's talk.

Book my call →