Planning a Move from QuickBooks Online Back to QuickBooks Desktop
Planning to move from QuickBooks Online back to QuickBooks Desktop? Our engineers set out the two decisions that shape the job and how to settle them.
Moving a company from QuickBooks Online back to QuickBooks Desktop is a conversion, not an export you click through. Two decisions shape the whole job before a single transaction moves: the Desktop edition and release year you will run, and how much history comes across. Our engineers scope every migration around these two answers. Settle them early and the rest of the move is mechanics; leave them open and you are scheduling rework.
Which Desktop edition should you target?
Desktop editions are not interchangeable, and the door only opens one way. A file created in Enterprise cannot be opened in Pro or Premier afterward, so treat the edition choice as permanent. Match the edition to what the Online company actually uses today, not to what looks cheapest.
Look at the Online feature set honestly. Sales orders and units of measure live in Premier or Enterprise rather than in Pro, and the advanced inventory tools sit in Enterprise alone. Pro and Premier also cap the combined name and item lists at 14,500 entries, while Enterprise allows far more. A company that tracks stock across sites, or has grown its lists over a decade, usually lands better in Enterprise. Class and location tracking in Online generally comes across as class tracking, which every Desktop edition supports.
Which release year should you land on?
Pick the year you intend to keep. A Desktop company file upgrades forward and never back: once it has been opened in a given release year, an older version cannot read it. Converting into an older year because a spare licence is lying around usually means paying for the move twice. If escaping the subscription is part of the goal, settle the licensing question now rather than after the file exists. Our notes on moving a QuickBooks file onto a perpetual licence explain why the timing matters.
Should the full history come across?
Full history means every transaction since day one, with balances that build up naturally and every dormant customer and item intact. A date range means choosing a cutoff, carrying the balances at that date forward as opening balances, and leaving earlier years behind in the Online company.
Neither answer is wrong. Full history protects you in an audit and in comparative reporting, at the cost of a larger file and every list entry since the beginning. A date range keeps the new file lean, but it demands a clean cutoff and correctly aged open items on both sides of the date.
Where should the cutoff date sit?
A cutoff only works if the books on the Online side are complete through it. Reconcile every bank and credit card account up to that date before anything moves. Avoid a cutoff in the middle of a payroll quarter; quarter boundaries and fiscal year ends make cleaner seams. From the morning after the cutoff, new entries belong in the Desktop file only.
Settle these before anyone touches the data
Put the answers in writing before the conversion starts:
- Edition and release year, with a licence for every user who will open the file.
- History depth: everything, or a stated range with an exact cutoff date.
- The Online subscription stays active until the Desktop file has been checked and signed off.
- Key Online reports exported to PDF before any cancellation: balance sheet, trial balance, and A/R and A/P aging at the cutoff.
- A short list of features that have no Desktop equivalent, so nobody assumes they migrated.
A cancelled Online company stays readable for a limited period only, so take those PDFs while the subscription is live. These answers are also what any conversion provider asks for first; see our QuickBooks Online to Desktop conversion service page for how the job runs once they are fixed.
How do you know the plan worked?
The signs sit in comparisons, not in the absence of error messages. Run a balance sheet in both systems at the cutoff and check every account that was meant to come across. Compare the A/R and A/P aging summaries the same way. Confirm bank balances equal the reconciled statement figures. Then run Verify Data on the new file in single-user mode, from the File menu under Utilities, and confirm it passes. Finally, open the file on each workstation that will use it, in the edition and year you chose.
The gaps planning cannot close
Planning cannot create fields Desktop does not have. Automated Sales Tax and location tracking have no direct Desktop counterpart, and attachments rarely travel with the data. Multicurrency, FIFO inventory, and very large lists raise the difficulty further. When those are present, the export you can run yourself will drop data, and the remapping becomes specialist work. Our engineers have detailed what the built-in export misses when moving QuickBooks Online to Desktop, list by list. Know the gaps before the move, not after it.