QuickBooks Online vs Desktop

Desktop is legacy software now. Almost nobody adopts it new; the businesses still on it are there because they have always been there, and inertia is cheaper than a migration until suddenly it is not.

The operational gap shows up the moment somebody outside the business needs the numbers:

On an engagement where we have read access to an online ledger, we work through the material ourselves in a couple of days and come back with a short list of specific follow-ups. Where the business is on desktop, the same work becomes a queue of extract requests, and every round trip costs days that usually come out of an exclusivity period. We have waited weeks for general ledgers on deals where access was not available.

None of which makes desktop unworkable. Where a company has a controller or a CFO who knows the file, the extracts arrive and the work proceeds, and there are reports that come out of the desktop product perfectly well. We have pulled payroll detail from a desktop file when the online one could not produce it. The difference is not capability, it is how many people have to be in the loop before a question gets answered.

This is the part worth knowing before you pick a date, and it is the reason we say move during a quiet period rather than mid-deal.

A migration does not produce trustworthy numbers on day one. On one business that went live on the online platform in April, the figures did not settle until around September or October. In the months between, balances simply did not make sense: receivables showing a few thousand dollars in a month where that was implausible, totals that could not be reconciled to anything. By the following Q1 the books were clean and accurate. But that left roughly two quarters of history that nobody could rely on.

If those two quarters fall inside the period a buyer or lender is examining, you will be explaining them rather than relying on them. Plan the cutover so the ramp lands somewhere harmless.

The single most time-consuming problem we hit on a post-migration business is not the migration itself. It is that the old and new systems often hold their data on different accounting bases.

We reviewed a business where the desktop extracts came out on a cash basis while the new online books were accrual, with tax returns on cash as well. So the same periods existed in multiple places, in multiple bases, and none of the totals agreed. Establishing why they disagreed, rather than assuming something was wrong, became the bulk of the work.

That is a reconciliation exercise, not an error, but nobody had flagged it. See cash vs accrual accounting for why the two views diverge so widely.

The second half of the trap is history. Where the old system holds the general ledger detail for the earlier part of a year and the new one holds the rest, a proof of cash run across a normal calendar year becomes very difficult, because you are chasing money through two different accounting softwares. On one engagement we shifted the twelve month window forward so it sat cleanly inside a single system rather than straddling the switch. Where a figure genuinely had to be traced across the boundary, it meant pulling the old desktop file, the new online file and the bank statements together to find where the amount had landed.

So if you migrate, record which basis each system holds, export a full general ledger from the old system in a workable format before access lapses, and keep it. The answer to a request for pre-migration periods cannot be that you switched it off.

A less obvious consequence of a switch is that the transaction detail often thins out on the other side.

We have reviewed post-migration ledgers where deposits post with no customer attached, just an amount, where the previous system had carried a proper description. In one case the business corrected it on one side of its revenue the following year and left the other side as it was, so half the file could be attributed and half could not. Nothing about that is dishonest, and it is usually nobody’s decision, just a default nobody revisited. It still means a buyer cannot tell who paid you, and the work of establishing that falls to somebody at your expense.

Whatever you move to, check after the cutover that customer and vendor names are still landing on transactions. It is a small settings question with a disproportionate effect later.

Worth knowing, because it shapes what good looks like regardless of which product you are on. On the first management call, alongside questions for the owner about how the business runs, whoever handles the accounting gets asked how they run the file: how journal entries are made, whether adjusting entries are manual, who performs the reconciliations and whether they are actually being done, and who has access to the bank.

None of those answers depend on the software. What the software changes is how quickly the answers can be checked. It is also worth knowing that complexity, not size, drives how heavy this gets: a single profit and loss sitting in one QuickBooks file is a straightforward engagement whether the business is small or substantial, whereas operations spread across many entities and countries is a different exercise entirely.

Stay on desktop only if you have a genuine feature dependency you have actually tested against the online version, and no transaction, financing or lender review on the horizon.

Move to online if any of these are true: you need an accountant or advisor in the file, you operate from more than one location, you are heading toward a sale or a raise, or you are simply tired of emailing a file around.

Where a business is on desktop and something is coming, our advice is a clean cut across rather than an extended dual-running arrangement. Running both indefinitely is how you end up with two sets of books that disagree and no one sure which is authoritative. Run them in parallel briefly to prove the new file reconciles, then close the old one and keep it readable.

We are not a software reseller and we take no position on the vendor. Our role is the accounting integrity around the move: mapping the chart of accounts, reconciling closing balances to opening balances, documenting which basis each system held, running the first closes in the new file, and making sure the transition is explainable rather than a gap. System migration covers the wider process, and accounting records in due diligence covers what a buyer will ask of whatever you end up on.