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

What Data Does NOT Migrate from QuickBooks Desktop to Online? (UK Audit List)

When moving from QuickBooks Desktop (QBD) to QuickBooks Online (QBO) using Intuit’s native converter, core double-entry transactions transfer if your file is under 350,000 targets, but 10 critical elements: including historical bank reconciliation reports, file attachments, sales orders, custom invoice templates, memorised reports, and live bank feeds: do not convert automatically.

£0.00 Trial Balance Guarantee Flat UK Tiers: £245 · £395 · £595 + VAT 48–72h or Weekend Cutover
Book Verified QBD → QBO Switch →
In this guide (8 sections)
  1. Why QuickBooks Online Is Not a 1-to-1 Clone of QuickBooks Desktop
  2. Complete Matrix: What Transfers vs What Drops
  3. Four Critical Items Every UK Finance Team Must Protect Before Switching
  4. Pre-Export Safety Checklist

Key Takeaways

Quick Summary
Reconciliation PDFs drop
Cleared statuses carry across, but historical month-end Bank Reconciliation Summary PDFs do not: always export them into your Golden Copy pack before switching.
Sales Orders have no QBO object
QuickBooks Online does not have a native Sales Order ledger object; open sales orders must be converted to Estimates or Invoices prior to cutover.
Multi-currency rounding risk
Historical FX bills and invoices can re-evaluate at slightly different decimal rounding in QBO, throwing off historical Trial Balances without specialist adjustment.
Payroll YTD journals
Historical Desktop payslips convert as plain accounting entries rather than active employee YTD tax records: plan payroll transitions on a clean UK tax month (6th of the month).
Custom branding & feeds
Custom DOCX/layout invoice templates and PSD2 Open Banking connections always require a 30-minute post-handover setup in QBO.
TrustSwitch Post-Migration Audit Dashboard verifying complete ledger parity
Knowing exactly what transfers automatically versus what requires pre-export archiving prevents HMRC audit gaps.

Why QuickBooks Online Is Not a 1-to-1 Clone of QuickBooks Desktop

QuickBooks Online (QBO) is built on a completely separate cloud database architecture from legacy QuickBooks Desktop (QBD)[1]. Even when your company file sits below Intuit’s 350,000-target ceiling and completes an export without crashing (see Fixing QBD to QBO Conversion Errors), several desktop data objects have no equivalent inside QBO or drop silently during unassisted transfers.

Understanding what converts automatically, what requires specialist ledger mapping, and what must be archived in your offline Golden Copy backup prevents unpleasant surprises during your first HMRC VAT return or year-end statutory audit.

Complete Matrix: What Transfers vs What Drops

Data Element in QuickBooks DesktopNative Intuit Tool BehaviourTrustSwitch Verified Migration Behaviour
Chart of Accounts & Sub-AccountsTransfers up to 5 sub-account levels; detail types often default genericallyMapped cleanly with verified QBO Account & Detail Types (see CoA Mapping Guide)
Historical Invoices, Bills & CreditsDrops or requires destructive Condense Data above 350,000 targets100% of itemised multi-year invoices, bills & allocations migrated with zero condensing
Historical Bank Reconciliation PDFsDoes NOT migrate (transactions mark as R cleared, but past PDF reports drop)Cleared status + £0.00 closing bank balance verified; export past PDF summaries to Golden Copy
Sales OrdersDoes NOT migrate (QBO has no Sales Order transaction type)Open Sales Orders flagged in pre-flight so you convert to Estimates or Invoices cleanly
Local File Attachments (Attach folder)Dropped by desktop exporterExport local Attach directory into your company’s 6-year Golden Copy archive
Custom Invoice & Statement LayoutsDoes NOT migrate (different PDF layout engine)Part of the 30-minute post-handover setup inside QBO Custom Form Styles
Memorised Reports & BudgetsMemorised report layouts and multi-year budgets dropUnderlying Class/Location tags preserved so QBO reports rebuild in minutes
Multi-Currency Historical RoundingFX exchange recalculations frequently cause small GBP Trial Balance driftHome-currency GBP equivalents locked and reconciled to £0.00 variance
UK PAYE / Payroll HistoryHistorical payslips arrive as accounting entries, not live RTI tax cardsAccounting journals reconciled; start active QBO Payroll cleanly on the 6th of a tax month
Live Bank Feeds (Open Banking)Cannot transfer OAuth tokens across platforms[3]Re-authenticated by mandate holder in ~15 mins post-handover (see Bank Feed Checklist)

Four Critical Items Every UK Finance Team Must Protect Before Switching

1. Historical Bank Reconciliation Summary Reports

Inside QuickBooks Online, migrated historical bank transactions carry a reconciled (R) marker, which keeps your opening bank balance accurate. However, the month-by-month Previous Reconciliation Discrepancy & Summary PDFs generated inside QuickBooks Desktop do not copy across[1]. Before retiring your desktop machine, export your last 6 years of month-end Bank Reconciliation PDFs to satisfy HMRC VAT and statutory audit enquiries[2].

2. Open Sales Orders & Stock Assemblies

QuickBooks Desktop Premier and Wholesale/Manufacturing editions rely heavily on Sales Orders and Inventory Assemblies. Because QuickBooks Online uses Estimates and Purchase Orders without a middle Sales Order ledger state, any unfulfilled open Sales Orders at cutover must be exported to a status list or converted into Estimates prior to taking your Friday 17:00 GMT backup.

3. Multi-Currency & UK VAT Control Account Drift

If your company invoices or pays overseas suppliers in USD or EUR, QuickBooks Online’s cloud FX engine can round historical home-currency conversions by fractions of a penny differently from Desktop. Over several years of trading, those penny differences break your opening Retained Earnings and VAT Control Account. At TrustSwitch, our UK specialist locks historical GBP values so your closing QBD Trial Balance and opening QBO Trial Balance match to £0.00.

4. UK Payroll Cutover Timing

Never attempt to migrate mid-pay-run. While historical wage and HMRC PAYE/NIC liability journals migrate cleanly as part of your general ledger, live UK RTI employee tax codes and P11 year-to-date tables should transition cleanly either on 6 April (start of the UK tax year) or immediately after submitting an FPS/EPS at month-end using P11 YTD starter figures.

Pre-Export Safety Checklist

Before turning off QuickBooks Desktop, save these five benchmark PDFs alongside your .QBB file (see How to Export Your Chart of Accounts from QBD):

  • Trial Balance (Accrual basis, all dates up to cutover date)
  • Balance Sheet & Profit and Loss (Standard + prior-year comparative)
  • Aged Debtors Detail & Aged Creditors Detail as of cutover date
  • VAT 100 Liability & Exception Reports for the last 4 quarters
  • Bank Reconciliation Summary PDFs for every active bank and credit card account

Want a zero-downtime transition where every penny of your historical ledger is checked before Monday morning? Explore our managed QuickBooks Desktop to QuickBooks Online route or review our Weekend Migration Timeline.

80/20 Honest Division of Migration Labour between TrustSwitch and Client
The 80/20 rule: 100% of double-entry financial history is verified; bank feed MFA and branding take ~30 minutes.

Frequently Asked Questions

Do unpaid customer invoices and supplier bills migrate properly?
With a verified migration, yes: open Accounts Receivable invoices and Accounts Payable bills are reconstructed with exact customer/supplier links and aged due dates so you can match incoming bank payments immediately.
What happens to attachments saved inside QuickBooks Desktop?
Intuit’s built-in desktop exporter drops local document attachments linked via the Desktop Doc Center. Always archive your local `Attach` folder alongside your `.QBB` Golden Copy backup before decommissioning your Windows server.
Will my historical VAT returns change in QuickBooks Online?
Unassisted imports sometimes recalculate VAT on old credit notes or flat-rate entries. TrustSwitch locks historical tax amounts so your VAT control account matches your submitted HMRC VAT 100 returns to £0.00.
Should I switch mid-payroll year in the UK?
Your general ledger can move any weekend, including mid-year, with £0.00 variance. For UK PAYE/RTI payroll specifically, most Chartered Accountants recommend either starting QBO Payroll on 6 April or bringing forward clean P11 year-to-date figures at the start of a new tax month.
£0.00 Trial Balance Guarantee · 48–72h or Weekend Cutover

Protect Every Penny of Your Historical Trial Balance

Don’t find out three months later that multi-currency rounding or dropped credit notes broke your opening balances. Get a specialist-verified QBD to QBO handover.

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