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

By TrustSwitch: UK accounting data migration specialist
Last updated 10 November 2026
Canonical URL: https://trustswitch.co.uk/switching-software/accounting/qbd-to-qbo-conversion-failed

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.

---

## Key takeaways

- **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.

---

## 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](https://trustswitch.co.uk/migrations/qbd-to-qbo) service.

| Error Symptom or Message | Root Technical Cause | Safe Diagnostic Check | Why 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 Targets | Running 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` database | Run `File > Utilities > Verify Data` and inspect `QBWin.log` | Repeated *Rebuild Data* runs on a damaged live file can drop unlinked payments |
| **Export hangs at 90%–99% or times out** | Oversized audit trail, attached local documents, or multi-user lock conflict | Switch to Single-User Admin mode and copy `.QBW` to local SSD | Re-triggering exports into the same QBO company creates duplicate nominal entries |
| **VAT Control Account wrong after import** | UK Cash Accounting VAT, Flat Rate adjustments, or 1–2p line-level tax recalculation | Compare QBD VAT 100 liability report against QBO Balance Sheet | Filing your next MTD return on a drifted VAT balance breaches HMRC digital accuracy[3] |
| **Stock / Inventory Asset value misstated** | Negative stock quantities on historical dates converted into QBO FIFO layers | Run *Inventory Valuation Summary* in QBD and filter for negative on-hand | Manual stock adjustment journals distort historical Cost of Sales and gross margin |
| **Aged Debtors / Creditors disagree with TB** | Unapplied supplier credits or foreign-currency bills re-valued at import date | Compare *Aged Receivables Detail* against Balance Sheet Debtors | Cleaning 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](https://trustswitch.co.uk/data-security-compliance/data-migration/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](https://trustswitch.co.uk/switching-software/accounting/qbd-to-qbo-missing-data) 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](https://trustswitch.co.uk/migrations/qbd-to-xero). Upload your `.QBB` backup to [TrustSwitch](https://trustswitch.co.uk/onboarding?path=qbd-to-qbo) and let a dedicated UK ledger specialist deliver a £0.00 variance cloud account over a single weekend.

---

## Frequently Asked Questions

**Q: 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.

**Q: 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.

**Q: 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.

**Q: 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.

---

## References

1. Intuit QuickBooks UK Support: *QuickBooks UK Help & Desktop-to-Online transition guidance*. https://quickbooks.intuit.com/learn-support/en-uk Accessed 10 November 2026.
2. UK Legislation (legislation.gov.uk): *Companies Act 2006, Section 386: Duty to keep accounting records*. https://www.legislation.gov.uk/ukpga/2006/46/section/386 Accessed 10 November 2026.
3. HM Revenue & Customs (GOV.UK): *VAT Notice 700/22: Making Tax Digital for VAT (Digital record-keeping and digital links)*. https://www.gov.uk/government/publications/vat-notice-70022-making-tax-digital-for-vat Accessed 10 November 2026.
