Yes, you can migrate to QuickBooks Online, and the process is safer than most business owners expect. Use the Desktop export tool, the online migration tool, or (for accounting firms) the Accountant Batch Migration tool. Most small files finish in minutes, large files take hours, and payroll or inventory records often need manual review. Back up your file first, and let an accountant handle anything complex.
TL;DR:
- Files approaching 750,000 total targets in QuickBooks Pro and Premier often encounter migration issues, requiring file trimming or selective export.
- Large, payroll, or inventory-heavy files can take several hours to migrate, so scheduling during low-activity periods is advisable.
- Custom templates, memorized reports, and Desktop-specific add-ons do not transfer automatically and must be manually rebuilt in QuickBooks Online.
- Confirm your bank balances, contact details, and recent invoices match between Desktop and Online after migration to detect discrepancies early.
- Batch migration tools are suitable for firms with multiple clients but require verifying each file’s post-migration reports individually for accuracy.
Table of Contents
- Pre-Migration Checklist Before You Switch to QuickBooks Online
- How Do You Move Your Company File to QuickBooks Online?
- When Should Accountants Use the Batch Migration Tool?
- How Do You Verify Your Migration Worked Correctly?
- What Doesn’t Migrate Automatically to QuickBooks Online?
- How Big Can Your File Be, and How Long Does Migration Take?
- How KelliWorks Helps You Migrate to QuickBooks Online
- What I’d Tell a Business Owner Before They Hit “Export”
- Sources
Pre-Migration Checklist Before You Switch to QuickBooks Online
A rushed migration causes most of the headaches we see. Before you touch the export button, work through this sequence.
- Update QuickBooks Desktop to the latest release, then run File > Utilities > Verify Data to catch corruption before it travels with you into the new system.
- Back up your company file locally. Save it to a drive outside your QuickBooks folder so you have a clean restore point no matter what happens during the transfer.
- Switch to single-user mode. Migration tools cannot read a file that other users have open, and this step alone stops a surprising number of failed transfers.
- Reconcile every bank and credit card account and note the date you’re starting the migration. This becomes your reference point when you check totals later.
- Check your Total Targets by pressing F2. QuickBooks Pro and Premier files run into trouble as they approach roughly 750,000 total targets, while Enterprise files have more headroom.
- Decide how you’ll handle payroll and inventory before you export, since both require choices you cannot easily undo afterward.
Pro Tip: Run the F2 check even if your file feels small. A file with thousands of old, unused list entries can hit target limits long before the file size looks alarming.
How Do You Move Your Company File to QuickBooks Online?
Two paths get you there, depending on whether you’re starting from inside Desktop or from the browser.
From QuickBooks Desktop:
- Open your company file and go to Company > Export Your Company File to QuickBooks Online.
- Sign in with your Intuit account credentials when prompted.
- Choose whether to create a brand-new QuickBooks Online company or export into an existing one.
- Select what to bring over. You can move everything or choose specific lists and transaction types.
- If you carry inventory, set your inventory start date. This determines how QuickBooks Online begins calculating your stock values going forward.
- Submit the export and wait for confirmation.
From the online migration tool:
- Go to the QuickBooks migration tool in your browser and upload your company file.
- Sign in to the QuickBooks Online account you want to receive the data.
- Pick the destination company, whether that’s a new subscription or one already set up.
- Confirm your selections and start the transfer.
Intuit’s documented migration flow sends you an email once the process finishes, so you don’t need to sit and watch a progress bar. Once that email lands, QuickBooks Online will prompt you to “Complete your setup,” where you confirm your chart of accounts, connect bank feeds, and invite any team members.
Before you close the laptop and call it done, run a few quick checks:
- Confirm your bank balances match your Desktop reconciliation date.
- Open a handful of customer and vendor records to verify contact details carried over.
- Spot-check five or six recent invoices against their Desktop originals.
When Should Accountants Use the Batch Migration Tool?
Firms managing more than a handful of clients don’t need to migrate files one at a time. The Accountant Batch Migration Tool moves multiple client files from supported QuickBooks Desktop Accountant versions in one session.
- Confirm your Desktop Accountant version is supported before adding files to the queue.
- Prepare each file individually first: update, back up, and verify data the same way you would for a solo migration.
- Add files to your migration list, then start the batch from your Accountant Dashboard.
- Watch for files near the Total Targets threshold. These are the most likely to show discrepancies after conversion.
- Payroll data typically will not carry over in a batch move, so plan that separately for each client.
Even after a successful batch run, validate each client’s post-migration reports individually rather than assuming a clean batch means every file landed correctly.
How Do You Verify Your Migration Worked Correctly?
Confirming a migration succeeded takes ten minutes and saves you from discovering a mismatch three months later during tax season.
- Pull a Balance Sheet and Profit & Loss report in Desktop as of your migration date, then run the same two reports in QuickBooks Online for the identical period.
- Compare your Accounts Receivable and Accounts Payable totals side by side. These two areas surface mapping errors faster than any other report.
- Open your Chart of Accounts in QuickBooks Online and check that each account mapped to the correct type. Bank accounts occasionally land as “Other Current Asset” instead of “Bank,” which throws off your reports.
- Review your customer and vendor lists for completeness, and open a sample of invoices to confirm amounts match.
- If inventory quantities or values look off, recheck the start date you set during export. That single field drives every calculation from that point forward.
Pro Tip: Keep your Desktop backup open in a second window while you verify. Comparing numbers live, side by side, catches discrepancies faster than toggling between two closed files.
If totals don’t reconcile after a reasonable round of troubleshooting, that’s the moment to bring in an accountant rather than keep guessing. A resource like KelliWorks’ bookkeeping best practices guide walks through reconciliation habits that make this kind of check faster every month going forward.
What Doesn’t Migrate Automatically to QuickBooks Online?
Some parts of your Desktop file simply don’t make the trip. Custom templates, memorized reports, the audit trail, and most Desktop-only add-ons need to be rebuilt manually inside QuickBooks Online. Payroll history and past paychecks often don’t transfer cleanly either, so you’ll need to recreate payroll setup, export and import payroll reports, or work directly with your payroll provider to bring historical data forward.
Inventory carries its own wrinkle worth taking seriously. QuickBooks Online recalculates inventory using FIFO accounting starting on the date you specify during export. If Desktop had you on a different costing method, this shift can change how your cost of goods sold gets reported, and a genuine method change may require filing IRS Form 3115 and a conversation with a tax professional.
- Custom templates and memorized transactions
- Audit trail history
- Some payroll paycheck history
- Desktop-only third-party integrations (check with each vendor for a QuickBooks Online equivalent)
Rebuilding templates before you migrate, rather than after, cuts down significantly on the manual re-entry work waiting for you on the other side.
How Big Can Your File Be, and How Long Does Migration Take?
Press F2 in Desktop to find your Total Targets count before you commit to a migration date. Files creeping toward the Pro/Premier threshold often need trimming first.
- Condensing your file removes old, closed transactions to shrink target counts, but the process is irreversible, so back up and reconcile first.
- If condensing feels too risky, exporting only key lists or starting fresh in QuickBooks Online are safer alternatives.
- Small files typically migrate in minutes; larger files with heavy inventory or payroll history can take several hours.
- Schedule your migration during a low-activity stretch, ideally at a month or year boundary, so reconciliation stays simple on both sides.
How KelliWorks Helps You Migrate to QuickBooks Online
If your file is large, payroll-heavy, or carrying years of inventory history, a managed migration saves you from the reconciliation headaches described above.
Some professionals handle the parts of a QuickBooks Online migration that trip up most business owners: planning your file condense strategy, managing payroll and inventory transitions, reconciling accounts after the transfer, and configuring your new setup so reports match what you had in Desktop. An engagement typically starts with a review of your current file, moves into a migration plan tailored to your data, then covers execution and a full reconciliation pass once the transfer completes. Business owners running inventory-driven or payroll-heavy operations benefit most from having a second set of eyes on the FIFO and payroll caveats covered above.
If you’d rather hand off the technical risk than troubleshoot it yourself, our virtual accounting department page outlines exactly how we structure a migration engagement, and our guide on why businesses switch accounting firms can help you decide whether outsourcing the move makes sense for your situation. Reach out for a review of your file to receive advice on whether you need hands-on help or just a second opinion.
What I’d Tell a Business Owner Before They Hit “Export”
Migrations rarely fail because of QuickBooks. They fail because someone skipped the backup, ignored the reconcile step, or exported a live file mid-workday. My rule of thumb: test a small subset first, always migrate during a slow week, and never condense a file you haven’t backed up twice. DIY works fine for a clean, small file. The moment payroll history or multi-year inventory enters the picture, hire someone who has cleaned up a botched migration before, because rebuilding trust in your numbers costs more than the migration itself ever would.
— Kelli
Sources
- Move your QuickBooks Desktop company file to QuickBooks Online — Intuit
- How To Convert QuickBooks Desktop to Online in 7 Steps — Fit Small Business
