InterWeave Academy

QuickBooks Desktop → Online Migration Guide | InterWeave
Client Migration Document

QuickBooks Desktop
QuickBooks Online

A step-by-step guide to migrating your accounting data cleanly and safely — covering pre-migration prep, the transfer itself, post-cutover validation, and InterWeave integration reconnection.


01
Pre-Migration Preparation
Back up first, then clean up and confirm readiness before touching the migration tool.
1
Back Up the QBD Company File

Create a verified local backup (.QBB) before touching anything. Store it in a location outside the normal working directory — on a network drive or external storage. This is your permanent audit record and cannot be recreated after migration.

2
Verify Version Compatibility

QuickBooks Desktop 2020 or later migrates cleanly via Intuit's built-in export tool. Older versions must be upgraded to QBD 2020 at minimum before starting — the migration tool does not support end-of-life versions.

3
Check Data File Size

QBO has a target count limit of approximately 750,000 combined transactions, customers, and vendors. Before migrating, run the Company File Diagnostic in QBD:

  • Go to File → Utilities → Verify Data
  • Review the transaction count summary
  • If near or over the limit, archive historical data or consider a clean-start migration with opening balances only
4
Clean Up the Company File

A clean source file produces a clean migration. Before exporting, complete the following:

  • Merge duplicate customers, vendors, and accounts
  • Reconcile all bank and credit card accounts through the cutover date
  • Clear or write off old, uncleared transactions
  • Remove inactive items that are no longer needed
  • Run the Condense Data utility if file size is excessive
5
Back Up the QBD Company File (Again)

Create a second verified local backup (.QBB) after cleanup is complete — before initiating the export. Store it alongside your initial backup. Having a pre-export snapshot separate from your pre-cleanup snapshot protects you in both directions.

6
Identify What Will Not Migrate

Not everything transfers automatically. Plan for manual re-entry of the following after go-live:

  • Payroll history & settings — must be reconfigured in QuickBooks Payroll
  • Inventory assemblies — convert to simple inventory items before migrating
  • Custom invoice & estimate templates — will need to be rebuilt in QBO
  • Memorized reports — must be recreated manually
  • Fixed asset manager data
  • Loan manager records
7
Choose the Right QBO Subscription

Select the plan that matches your operational needs before provisioning the QBO account:

PlanBest ForKey Features
Simple Start / Essentials Very small businesses, solo operators Basic A/R, A/P, bank feeds
Plus Businesses tracking inventory, projects, or departments Inventory, project costing, class & location tracking
Advanced Larger teams needing custom roles or automation Higher user count, batch actions, custom fields, priority support
02
Running the Migration
Initiate the export from within QuickBooks Desktop and monitor through completion.
1
Initiate the Export from QuickBooks Desktop
  1. Open your QBD company file
  2. Go to Company → Export Company File to QuickBooks Online
  3. Sign in with (or create) your Intuit account
  4. Select or create the target QBO company
  5. Choose whether to include inventory (see warning below)
  6. Click Export — this takes 15 minutes to several hours depending on file size
Inventory Warning

Inventory migration is the most error-prone area of a QBD-to-QBO transfer. If you have complex inventory — assemblies, lot tracking, or multiple warehouse locations — consider migrating without inventory and manually re-entering opening balances and active items in QBO instead.

2
Monitor the Migration

Intuit sends a confirmation email when the export is complete. Do not close the QBD file during the transfer. If the migration fails partway through, Intuit support can run a clean re-import against a blank QBO company — do not attempt to retry against a partially populated company.

03
Post-Migration Validation
Verify data integrity, reconnect services, and lock the old file before going live.
1
Compare Financial Statements

Run all of the following in both QBD and QBO as of the cutover date. Every total must match before go-live:

  • Balance Sheet (as of migration date)
  • Profit & Loss (year-to-date through migration date)
  • Accounts Receivable Aging Summary
  • Accounts Payable Aging Summary
  • Trial Balance
2
Validate the Chart of Accounts

QBO may automatically rename or consolidate account types during migration. Verify:

  • All accounts are present and correctly typed
  • Opening balances match QBD exactly
  • Parent/sub-account relationships are intact
3
Review Customer & Vendor Lists

Check for duplicates, missing records, and unmapped payment terms or tax codes. Pay special attention to:

  • Customers with open balances
  • Vendors with open purchase orders
  • 1099 vendor flags — must be manually re-enabled in QBO
4
Reconnect Bank Feeds

QBO bank connections are not transferred and must be set up from scratch in the new instance:

  1. Go to Banking → Link Account
  2. Search for and connect each financial institution
  3. Set the start date to the day after your last reconciled period in QBD to prevent duplicate transactions
5
Re-enter Items That Did Not Migrate
  • Payroll: Reconfigure QuickBooks Payroll or reconnect your third-party provider
  • Recurring transactions: Recreate memorized templates in QBO
  • Invoice templates: Rebuild under Gear → Custom Form Styles
  • User access: Invite team members and assign roles under Gear → Manage Users
  • Third-party integrations: Reconnect all apps from the QBO App Store
6
Lock the Old QBD File

Once QBO is fully validated and live, set a closing date and password in QBD under Company → Set Closing Date. Archive the QBD file — do not delete it. It remains your permanent historical audit record.

04
InterWeave Integration Reconnection
Required for all customers using InterWeave SmartFlows, Payment Cloud, or ERP connectors.
InterWeave Customers Only

These steps apply if you use InterWeave integrations — Salesforce, Creatio, Sage, payment processors (Stripe, Authorize.net, Braintree, Square), or eCommerce connectors. Complete all steps in Phase 03 before beginning this phase.

1
Re-Authorize the QBO OAuth Connection

The QBO instance referenced by InterWeave changes on migration. A new OAuth token must be issued before any SmartFlow can sync:

  1. Log into the InterWeave Admin Panel
  2. Navigate to Connector Ecosystem → QuickBooks Online
  3. Click Reconnect and complete the Intuit OAuth authorization flow
  4. Confirm the new company name and Realm ID appear correctly
2
Remap Entity IDs

QuickBooks Online assigns new internal IDs to customers, vendors, and accounts upon migration. Any InterWeave field maps referencing QBD internal IDs must be verified and updated:

  • Run the Entity Sync Report from InterWeave for the QBO connector
  • Identify records flagged as Unmapped or Not Found
  • Update field mappings in the SmartFlow configuration for each affected flow
3
Test SmartFlow Triggers

After remapping, run end-to-end smoke tests for each active SmartFlow before resuming live operations:

  • Trigger a test transaction in the source system (e.g., Salesforce opportunity close or Creatio order)
  • Confirm the record creates correctly in QBO with the right accounts and amounts
  • Validate in both directions if bidirectional sync is active
4
Update Payment Cloud Configuration

If the client uses InterWeave Payment Cloud (Stripe, Authorize.net, Braintree, or Square) with QBO as the ledger target:

  1. Open the Payment Cloud Admin Panel
  2. Under Ledger Connections, select QuickBooks Online
  3. Re-authorize and remap income, fee, and refund accounts to the updated QBO Chart of Accounts
  4. Run a test payment end-to-end before enabling live transaction posting
Migration Readiness Checklist
Track your progress across all 22 migration milestones. Click any item to mark complete.
Overall Progress
0 / 22
Pre-Migration
Local backup (.QBB) created and stored securely off-site
QBD version confirmed (2020 or later)
Company file transaction count verified within QBO limits (750K)
All accounts reconciled through the cutover date
Duplicate customers, vendors, and accounts merged
Second backup (.QBB) created after cleanup, before export
Items that will not migrate documented and assigned for manual re-entry
Inventory strategy confirmed (migrate or manual re-entry)
QBO subscription selected and provisioned
Post-Migration
Balance Sheet matches between QBD and QBO
Profit & Loss matches between QBD and QBO
Chart of Accounts verified and corrected
Customer and vendor lists reviewed for accuracy
Bank feeds reconnected and start dates set
Payroll reconfigured in QBO
Recurring transactions recreated
User access and permissions configured
QBD closing date locked
InterWeave QBO OAuth re-authorized
InterWeave entity IDs remapped and validated
SmartFlow smoke tests passed
Payment Cloud accounts remapped and tested
InterWeave Accounting Resources

InterWeave has accounting resources that can assist you in this migration process, and with accounting validation once the migration has been completed. Please contact us at support@interweave.biz

Scroll to Top