Accounting & Bookkeeping Practices: Migrate 10+ client ledgers with partner volume pricing.
Open Partner Portal →
By TrustSwitchUK accounting data migration specialist
5 min read

QuickBooks Desktop to Online Conversion Failed? UK Troubleshooting & Fix Guide

Native QuickBooks Desktop to QuickBooks Online conversions most commonly fail because the company file exceeds Intuit’s 350,000-target ceiling, contains broken database links inside the .QBW file, or hits UK VAT and multi-currency validation conflicts. Do not run Intuit’s Condense Data utility to force an export through, as condensing permanently strips itemised historical invoice lines required for 6-year HMRC compliance checks.

£0.00 Trial Balance Guarantee Flat UK Tiers: £245 · £395 · £595 + VAT 48–72h or Weekend Cutover
Rescue My QBD → QBO Migration →
In this guide (5 sections)
  1. Why Does Intuit’s Built-In QuickBooks Desktop Exporter Fail?
  2. 1. Hitting the 350,000 Total Targets Ceiling (F2 Check)
  3. 2. Resolving "Problem Checking Your Company File" Safely
  4. 3. Silent Post-Conversion Failures: UK VAT, Multi-Currency & Missing Data
  5. Stop Retrying Into a Corrupted Cloud File

Key Takeaways

Quick Summary
Press F2 first
Open QuickBooks Desktop and press F2 (or Ctrl+1) to inspect Total Targets; any file above 350,000 targets will be rejected by Intuit’s built-in exporter.
Never condense blindly
Intuit’s Condense Data utility deletes historical line-item invoices and replaces them with summary monthly journals, destroying audit drill-down.
Verify before rebuilding
Run File > Utilities > Verify Data before Rebuild Data on a duplicate copy: never on your only master .QBW file.
UK VAT & Flat Rate traps
Historical Cash Accounting VAT codes and compound tax items frequently fail validation or create penny-rounding drift in QBO.
Negative stock blockers
Desktop files carrying negative stock quantities on historical dates will misstate inventory valuation in QBO FIFO layers unless remediated.
Managed rescue option
TrustSwitch extracts directly from your .QBB backup with zero target ceiling for £245–£595 + VAT, reconciled to £0.00 trial balance variance.
TrustSwitch Client Portal tracking QuickBooks Desktop backup verification and cloud import
Uploading a read-only .QBB Golden Copy bypasses Intuit’s 350,000-target desktop export ceiling.

Why Does Intuit’s Built-In QuickBooks Desktop Exporter Fail?

Intuit’s native "Export Company File to QuickBooks Online" utility[1] works reliably for small, recent company files, but regularly aborts, times out, or produces an out-of-balance ledger on established UK businesses with three or more years of trading history. Nearly every conversion failure traces back to one of six structural blockers: exceeding the 350,000-target limit, underlying .QBW index corruption, UK VAT scheme conflicts, negative stock layers, multi-currency home adjustments, or locked network permissions.

Before attempting destructive workarounds on your master ledger, identify your exact failure mode in the diagnostic table below, or move straight to our managed QuickBooks Desktop to QuickBooks Online Migration service.

Error Symptom or MessageRoot Technical CauseSafe Diagnostic CheckWhy DIY Workarounds Backfire
"Your file is too large to export"File exceeds 350,000 Total Targets (individual transaction lines + list items)Press F2 (or Ctrl+1) in QBD to view Total TargetsRunning Intuit’s Condense Data permanently deletes historical invoice line items[2]
"There was a problem checking your company file"Broken transaction pointers or orphaned journal links inside the .QBW databaseRun File > Utilities > Verify Data and inspect QBWin.logRepeated Rebuild Data runs on a damaged live file can drop unlinked payments
Export hangs at 90%–99% or times outOversized audit trail, attached local documents, or multi-user lock conflictSwitch to Single-User Admin mode and copy .QBW to local SSDRe-triggering exports into the same QBO company creates duplicate nominal entries
VAT Control Account wrong after importUK Cash Accounting VAT, Flat Rate adjustments, or 1–2p line-level tax recalculationCompare QBD VAT 100 liability report against QBO Balance SheetFiling your next MTD return on a drifted VAT balance breaches HMRC digital accuracy[3]
Stock / Inventory Asset value misstatedNegative stock quantities on historical dates converted into QBO FIFO layersRun Inventory Valuation Summary in QBD and filter for negative on-handManual stock adjustment journals distort historical Cost of Sales and gross margin
Aged Debtors / Creditors disagree with TBUnapplied supplier credits or foreign-currency bills re-valued at import dateCompare Aged Receivables Detail against Balance Sheet DebtorsCleaning up thousands of unlinked AR/AP open items manually takes weeks

1. Hitting the 350,000 Total Targets Ceiling (F2 Check)

Total file size in megabytes is rarely what stops QuickBooks Desktop from converting; Total Targets is the real gatekeeper. Inside QuickBooks Desktop, every customer, supplier, item, and individual split line on every historical invoice, bill, or cheque counts as one target. A UK wholesaler or agency raising 150 multi-line invoices a month will cross 350,000 targets in four to five years.

Why you must avoid Intuit’s Condense Data tool: When you exceed 350,000 targets, Intuit’s help prompts suggest running File > Utilities > Condense Data to delete closed historical transactions and replace them with summary monthly journal entries. For a UK limited company, condensing creates an immediate statutory headache: under Section 386 of the Companies Act 2006[2] and HMRC VAT Notice 700/22[3], you must preserve underlying transaction details for 6 years. Condensing strips customer names, invoice numbers, and VAT breakdowns from your cloud ledger, forcing you to maintain an old Windows PC just to answer historic audit queries.

The non-destructive fix: TrustSwitch bypasses Intuit’s 350,000-target desktop exporter entirely. By extracting directly from a read-only .QBB Golden Copy backup and pacing structured cloud batches, we migrate 3–6 years (£395 + VAT) or 7–10+ years (£595 + VAT) with every invoice line intact.

2. Resolving "Problem Checking Your Company File" Safely

If File > Utilities > Verify Data reports "QuickBooks detected that your data has lost integrity", never run Rebuild Data directly on your only live server file.

  1. Have all staff log out and switch to Single-User Mode (File > Switch to Single-user Mode).
  2. Save two separate .QBB backups (File > Back Up Company > Create Local Backup) onto an encrypted local drive.
  3. Restore a test copy into a local folder, run File > Utilities > Verify Data, and review QBWin.log (press F2, then F3 > Open File > QBWin.log) to see whether the error is a minor list sort index or a broken payment link.
  4. Run Rebuild Data on the test copy only, then compare the before-and-after Trial Balance to the penny to confirm Rebuild did not silently drop out-of-balance lines.

3. Silent Post-Conversion Failures: UK VAT, Multi-Currency & Missing Data

Even when Intuit’s progress bar reaches 100% and emails a "Congratulations" message, never allow your team to start raising live invoices until you run three mandatory reconciliation checks:

  • Trial Balance Tie-Out: Run a Trial Balance on Accrual basis as of your cutover date in both QBD and QBO. Every single Balance Sheet account and Retained Earnings figure must match to £0.00.
  • Aged Debtors & Creditors Tie-Out: Confirm open customer and supplier sub-ledgers match your Balance Sheet control accounts.
  • What Never Moves Natively: Review our companion breakdown of What Data Does NOT Migrate from QuickBooks Desktop to Online so you export your historical Bank Reconciliation PDFs before retiring your desktop server.

Stop Retrying Into a Corrupted Cloud File

If an automated attempt has already half-populated your new QuickBooks Online company with broken balances, do not enter new transactions on top of it. Within the first 60 days of a QBO subscription, an clean purge/reset allows a fresh start: or you can consider moving to Xero instead via our QuickBooks Desktop to Xero route. Upload your .QBB backup to TrustSwitch and let a dedicated UK ledger specialist deliver a £0.00 variance cloud account over a single weekend.

TrustSwitch £0.00 Trial Balance Verification Protocol for QuickBooks Desktop rescues
Independent backup extraction preserves line-item detail without running Intuit’s destructive Condense Data utility.

The True Cost of a "DIY" Migration

Native migration tools are free, but the manual cleanup is not. Calculate your hidden costs below based on UK averages (Bookkeeper: £35/hr, Dual Licensing).

2000
Low VolumeHigh Volume
48
1 Year (12 mo)6 Yrs (Statutory)10+ Years (Inception)
2

Time spent running old and new systems simultaneously.

Estimated DIY Cost
£900
Bookkeeper Cleanup (22 hrs @ £35/hr)£770
Dual Licence Overlap (2 mo @ £65/mo)£130
Self-serve tool benchmark (Movemybooks 4 yrs w/ extra-year fees):~£320 + VAT
Statutory Archive (3–6 Yrs HMRC) Save ~£505
£395 + VAT

Full double-entry transaction migration, custom nominal mapping, and £0.00 trial balance guarantee in 48–72h or scheduled Friday 5 PM to Monday 8:30 AM weekend cutover.

Frequently Asked Questions

How do I check my Total Targets in QuickBooks Desktop?
Open your company file in QuickBooks Desktop and press F2 (or Ctrl+1) to open the Product Information window. Look at the "Total Targets" figure in the File Information box. Every transaction header, split line, invoice row, and list entry counts as a target.
Why is Intuit’s Condense Data utility risky for UK companies?
Condensing removes closed historical transactions and replaces them with summary journal entries. Under the Companies Act 2006 (Section 386) and HMRC VAT Notice 700/22, you must retain granular transaction records for 6 years: meaning you would still have to keep a separate Desktop installation just to inspect old invoices.
What if the native migration succeeded, but my Trial Balance in QBO is wrong?
Do not enter new live transactions on top of an out-of-balance QBO file. Purge the newly created QBO company (available within 60–90 days of setup) or start a clean QBO shell, and run a specialist-verified migration from your original pre-export .QBB Golden Copy.
Can TrustSwitch convert a QuickBooks UK file with 10+ years of history?
Yes. Our Complete Archive tier (£595 + VAT flat) converts 7 to 10+ years of full transactional history from .QBB backups without condensing, delivered in 48–72 hours or over a single weekend.
£0.00 Trial Balance Guarantee · 48–72h or Weekend Cutover

Export Failed or Exceeded 350,000 Targets? Stop Forcing It.

Upload your read-only .QBB backup to our encrypted UK vault. We extract all historical years without condensing and verify your QBO Trial Balance to £0.00 discrepancy.

Essential (≤2 Yrs): £245 + VATStatutory (3–6 Yrs): £395 + VATInception (7–10+ Yrs): £595 + VAT