Short version: A converted file that balances to itself is not the same as one that ties to your Desktop reports. The conversion is a translation, and a handful of known behaviors, FIFO inventory recalculation, payroll landing as journal entries, and mismatches dumped into Opening Balance Equity, move your numbers in predictable ways. You find them by tying out the trial balance in order, biggest accounts first, and you're done when Opening Balance Equity hits zero and every remaining difference is explained.
The migration tool hands you a file that balances. Debits equal credits, the dashboard loads, everything looks fine. Then you compare it to the Desktop reports you ran on the way out, and the numbers don't match. This is the moment most migration guides skip, because Intuit's job ends when the file balances. Yours doesn't. A file that balances internally but doesn't tie to your prior books is a misstated file that happens to be arithmetically consistent.
Here's why it happens and the exact order I work to run it down.
The differences aren't random. They come from specific conversion behaviors, and knowing the mechanism tells you where to look.
| Mechanism | What moves |
|---|---|
| Inventory recalculated FIFO | If Desktop used average cost, inventory value and COGS both shift. Often the single largest difference. |
| Payroll as journal entries | Wages and payroll liabilities land as summarized JEs, not paychecks, so the splits between accounts can differ from Desktop. |
| Opening Balance Equity | The conversion parks anything it can't place here. A non-zero balance is the flag that something didn't land right. |
| Negative inventory | Items that ever went negative convert with wrong valuation, or fail outright. |
| A/R and A/P detail | Open invoices and bills convert, but partial payments, credits, and old applied items can shuffle the aging. |
| Sales tax payable | QBO's sales tax engine is different; the payable balance and item mapping need re-checking. |
| Undeposited Funds | In-transit receipts can double-count or strand if deposits weren't clean at the cutoff. |
| Item-to-account mapping | Items pointed at the wrong income or COGS account land those amounts in the wrong place. |
Don't chase the difference account by account at random. Work from the trial balance, largest variances first; most of the small ones vanish once the big accounts are right. Pull the Desktop trial balance as of the conversion date (on the same basis, accrual or cash, that you'll use in QBO) and the QBO trial balance at the same date, and put them side by side.
The controller's tell: Opening Balance Equity should be zero in a finished file. If there's a balance sitting in it, the conversion isn't done, no matter how good the dashboard looks.
The goal isn't a difference of exactly zero by luck. It's that every difference is identified and explained. A known FIFO recalculation, a rounding penny, a deliberate reclass, those are acceptable variances as long as they're documented. What's not acceptable is an unexplained difference, because an unexplained difference means something is misstated and you don't yet know what. Write down each variance, its cause, and the amount. That record is what makes the converted file trustworthy, and it's the thing an auditor, lender, or future you will ask for. If you do this across client files, the Conversion Tie-Out & Sign-Off workbook is the structured version: 26 areas, an automatic status against your tolerance, and a one-page sign-off.
Most of this traces back to the file you converted. Negative inventory, messy undeposited funds, unreconciled accounts, and bad item mappings all convert into bigger problems. Cleaning them up before you convert is a fraction of the work of untangling them after. For what does and doesn't come across in the first place, see what transfers from Desktop to Online, and if you haven't converted yet, the pre-flight below is the cheap insurance.
This is the exact work The Practical Controller does: tie out a converted file, find the variances, document them, and hand you books you can trust. If you'd rather run it yourself, the Conversion Tie-Out & Sign-Off workbook is the protocol in a spreadsheet. And if you haven't converted yet, the free Go/No-Go Diagnostic tells you what to clean up first.
Because the conversion is a translation, not a copy. Inventory is recalculated on FIFO, payroll comes across as journal entries rather than paychecks, and mismatches are parked in Opening Balance Equity. The file balances to itself, but it won't match your Desktop reports until you tie out the accounts the conversion changed.
It's the holding bucket QuickBooks uses during conversion and setup. In a correctly tied-out file it should end at zero. A non-zero balance after conversion is the clearest sign something didn't land where it belonged and still needs reclassing.
QBO recalculates inventory on FIFO from a chosen date. If Desktop used average cost, inventory valuation and COGS will shift. The difference is expected, but it must be identified, quantified, and documented, and a costing method change can carry tax consequences.
Start from the trial balance at the conversion date and compare Desktop to Online account by account. Work cash first, then A/R and A/P against the agings, then inventory and COGS, then payroll liabilities and wages, then sales tax, and finish by driving Opening Balance Equity to zero. Fix the biggest variances first.
A small, explained variance can be, like a rounding difference or a known FIFO recalculation. The standard is that every difference is identified and documented, not that the number is zero by accident. An unexplained variance is not acceptable; it means something is misstated.
General guidance for remediating a QuickBooks conversion, not accounting, tax, or legal advice. Inventory costing method changes in particular carry tax consequences; consult your tax preparer. Not affiliated with or endorsed by Intuit Inc. QuickBooks® is a registered trademark of Intuit Inc., used here descriptively only.
Practitioner guides on migration remediation and controller-grade books. One email per guide. Unsubscribe in a click.