Why a Migration Checklist Matters
Moving from QuickBooks Desktop to cloud accounting isn’t a simple file transfer. Your company file contains years of financial history, customer relationships, vendor records, and transaction data that your business depends on daily. A structured migration approach prevents data loss, minimizes downtime, and ensures your team can work productively from day one on the new platform.
Most migration problems stem from inadequate preparation rather than technical failures. Businesses that rush the process often discover missing transactions, broken integrations, or reconciliation discrepancies weeks after going live—when fixing issues becomes significantly more complex.
This checklist provides a systematic approach to migration, whether you’re moving to QuickBooks Online, Xero, Wave, or another cloud platform. For detailed comparisons of these alternatives, see our comprehensive QuickBooks Desktop alternatives guide.
Pre-Migration Checklist (2-4 Weeks Before)
1. Audit Your Current Setup
Before choosing a destination platform, understand what you’re actually using in QuickBooks Desktop:
| Assessment Area | What to Document |
|---|---|
| Features in use | Inventory tracking, job costing, sales orders, purchase orders, classes, locations |
| User count | Number of people who need access and their permission levels |
| Integrations | Connected apps, bank feeds, payment processors, payroll services |
| Custom reports | Reports you run regularly that may need recreation |
| File size | Total targets (Ctrl+1 in Desktop to check Product Information) |
Critical: QuickBooks Online has a 750,000 target limit for migration. If your file exceeds this, you’ll need to condense data or start fresh with opening balances.
2. Clean Up Your Data
Migration is the ideal time to address accumulated data issues:
- Reconcile all accounts: Complete bank and credit card reconciliations through the current date
- Clear undeposited funds: Process any pending deposits sitting in the Undeposited Funds account
- Write off old receivables: Address invoices that will never be collected
- Review chart of accounts: Merge duplicate accounts and inactivate unused ones
- Update customer/vendor records: Correct outdated contact information and remove duplicates
3. Coordinate with Your Accountant
Your accountant or bookkeeper should be involved early in the migration process:
- Discuss platform choice: Many accountants have strong preferences based on their workflow
- Align on timing: Avoid migrating during tax season or month-end close periods
- Plan for parallel access: Determine how your accountant will access the new system
- Review year-end implications: Consider whether migrating before or after fiscal year-end simplifies tax preparation
4. Create Comprehensive Backups
Before any migration work begins:
- Local backup: File > Back Up Company > Create Local Backup in QuickBooks Desktop
- Portable company file: Create a portable copy as a secondary backup
- External storage: Copy backups to an external drive or cloud storage (not just your computer)
- Export key reports: Save Balance Sheet, Profit & Loss, A/R Aging, and A/P Aging as PDFs for verification
Migration Week Checklist
5. Prepare Your QuickBooks Desktop File
In the days immediately before migration:
- Update QuickBooks Desktop: Help > Update QuickBooks Desktop to ensure compatibility
- Single-user mode: Switch to single-user mode and close all other QuickBooks sessions
- Verify data integrity: File > Utilities > Verify Data to check for file corruption
- Final reconciliation: Complete one last reconciliation to establish a clean cutoff date
- Print verification reports: Generate Balance Sheet and P&L dated as of your migration cutoff
6. Execute the Migration
The actual data transfer process varies by destination platform:
For QuickBooks Online:
- Use the built-in migration tool (Company > Export Company File to QuickBooks Online)
- Transfer typically completes in 15-30 minutes for files under 750,000 targets
- Historical transactions transfer automatically
- See Intuit’s official migration guide for detailed steps
For Xero or Wave:
- Export lists (customers, vendors, items, chart of accounts) as CSV files
- Import lists into the new platform
- Enter opening balances as of your cutoff date
- Consider hiring a migration specialist ($200-$500) for complex files
7. Verify Data Accuracy
Immediately after migration, compare key reports between systems:
| Report | What to Verify |
|---|---|
| Balance Sheet | Total assets, liabilities, and equity match |
| Profit & Loss | Year-to-date revenue and expenses match |
| A/R Aging | Outstanding customer balances match |
| A/P Aging | Outstanding vendor balances match |
| Bank balances | Account balances match reconciled amounts |
Document any discrepancies and resolve them before proceeding. Small rounding differences are normal; significant variances indicate migration issues that need attention.
Post-Migration Checklist (First 30 Days)
8. Reconnect Integrations
Cloud platforms don’t automatically transfer your connected services:
- Bank feeds: Reconnect each bank and credit card account
- Payment processing: Set up payment acceptance (Stripe, Square, PayPal)
- Payroll: Configure payroll service or connect to Gusto, ADP, etc.
- E-commerce: Reconnect Shopify, WooCommerce, or other sales channels
- CRM: Re-establish connections to Salesforce, HubSpot, or other tools
9. Configure User Access
Set up your team with appropriate permissions:
- Create user accounts: Add each team member who needs access
- Assign roles: Configure permission levels (admin, standard, reports-only)
- Enable two-factor authentication: Protect your financial data with 2FA
- Document access: Record who has access and their permission levels
10. Train Your Team
Budget adequate time for team adjustment:
- QuickBooks Online: 4-8 hours initial training; 2-3 weeks to normalize productivity
- Xero: 8-12 hours initial training; 4-6 weeks to normalize productivity
- Wave: 2-4 hours initial training; 1-2 weeks to normalize productivity
Focus training on daily workflows first (invoicing, expense entry, bank reconciliation) before addressing advanced features.
11. Run Parallel Operations (Optional but Recommended)
For businesses with low error tolerance, consider running both systems for 1-3 months:
- Enter transactions in both Desktop and the new platform
- Compare month-end reports to verify accuracy
- Identify workflow differences that need adjustment
- Build confidence before fully retiring Desktop
Common Migration Mistakes to Avoid
Migrating during busy periods: Tax season, fiscal year-end, and holiday rushes create pressure that leads to errors. Choose a quiet period for migration.
Skipping the backup: Even with cloud platforms, having a complete Desktop backup provides a safety net if migration issues arise.
Ignoring the 750,000 target limit: Files exceeding this limit require condensing or a fresh-start approach. Check your target count before attempting migration.
Rushing team training: Productivity drops temporarily after any software change. Budget realistic time for your team to learn new workflows.
Forgetting integrations: Bank feeds, payment processors, and third-party apps don’t transfer automatically. Plan time to reconnect each integration.
When to Get Professional Help
Consider hiring a QuickBooks ProAdvisor or migration specialist if:
- Your file exceeds 500,000 targets
- You use advanced features (inventory assemblies, advanced job costing, industry-specific editions)
- Your chart of accounts needs significant restructuring
- You’re changing accountants simultaneously
- Your business cannot tolerate any downtime or data discrepancies
Professional migration services typically cost $200-$1,000 depending on complexity, but can save significant time and prevent costly errors.
A successful migration sets the foundation for years of efficient cloud-based accounting. The time invested in proper preparation pays dividends in accurate data, smooth workflows, and confident financial management.