What Data Doesn't Transfer When You Migrate QuickBooks Desktop to Xero
Not everything moves when you migrate QuickBooks Desktop to Xero. Here's exactly what data doesn't transfer and how to h...
Before you convert QuickBooks Desktop to QuickBooks Online, know exactly what does not transfer, from reports to templates, and how to save it first.
Most articles about switching to the cloud focus on what moves across. This one covers the opposite, because the surprises that ruin a conversion are almost always about what got left behind. When you convert QuickBooks Desktop to QuickBooks Online, a defined set of data simply does not come with it.
None of this is a bug. QuickBooks Online is a different product with a different structure, so some Desktop features have no home in it. The trick is knowing the list before you start, so you can save what you need rather than discover it is gone.
This is the category that catches accountants off guard.
Before you convert, export the reports you rely on to PDF or Excel. That way you keep a permanent copy of your reconciliation history and key custom reports even though they will not live inside the online file.
The formatting work you invested in Desktop does not carry over.
Custom invoice, estimate, and other form templates do not transfer, so plan to rebuild your branded layouts in QuickBooks Online. Price levels also do not come across, which matters if you use tiered customer pricing. Rebuilding these is straightforward, but only if you know to budget time for it.
Core inventory can transfer if you are on a QuickBooks Online plan that supports it, but some item-level detail does not.
Units of measure do not transfer. Manufacturer's part numbers and certain Desktop-only item fields do not transfer either. If your operations depend on these, note them before conversion and decide how you will record them in QuickBooks Online, which may mean using custom fields or a connected inventory app.
Payroll is a partial move. Employee records and current-year year-to-date totals transfer, but the fine detail does not.
Individual historical paychecks beyond current-year totals, QuickBooks Time timesheets, and pay item mappings do not carry over. Prior-year payroll detail stays in Desktop. Keep that company file as your payroll history record.
A few more things quietly do not transfer, and they are easy to forget:
There are also linkage quirks. Progress invoices can lose their connection to the original estimate, and open purchase orders may not show items already received. Review both after conversion.
The phrase "does not transfer" sounds alarming, but everything on this list still exists in your Desktop file. The goal is to preserve access to it, not to prevent an impossible transfer.
Do three things before you convert. Export your key reports and full reconciliation history to PDF or Excel. Keep a complete, secured backup of the Desktop company file. And make a short list of the custom templates and settings you will rebuild in QuickBooks Online. If the file contains employee or customer personal data, store those exports and backups securely, since privacy rules such as PIPEDA in Canada and the Australian Privacy Act expect reasonable protection of that information.
Then validate after conversion. Compare the trial balance, balance sheet, and profit and loss in both systems as of the same date. Matching numbers confirm your financial data converted correctly, even though the extras above stayed in Desktop.
Every QuickBooks Desktop to Online migration leaves some data behind. The difference between a smooth switch and a frustrating one is whether you knew the list in advance. Now you do, so you can save what matters before you start.
If you would rather have a team map all of this for you and confirm the financials tie out, WOW BookSwitch converts QuickBooks Desktop to QuickBooks Online for a flat $399 per file, with a free backup, validation against your trial balance, balance sheet, and profit and loss, and a 95% service-level guarantee. See the QuickBooks Desktop to QuickBooks Online service.