QuickBooks migration · Post-conversion repair
Migrated to Online — and the balances are wrong?
When a QuickBooks Desktop to Online conversion leaves the numbers wrong — opening balances that shifted, reconciliations that no longer tie, AR or AP that doesn’t match the detail, inventory re-based onto a different costing method — Certified ProAdvisors diagnose exactly what broke and fix it, so the new file ties back to the Desktop numbers you trusted. You usually don’t need to redo the migration. Independent firm, not affiliated with Intuit Inc.
When balances are wrong after a QuickBooks Desktop to Online migration, the usual culprits are opening balances that didn’t convert correctly, dropped or duplicated transactions, reconciliation status that didn’t carry, AR/AP detail that converted as a summary instead of open invoices and bills, inventory re-based onto a different costing method, and retained earnings or equity that shifted because the conversion closed the books differently than Desktop did. One cause is structural, not a bug: Desktop uses weighted-average costing and QuickBooks Online uses FIFO only, so inventory asset and COGS legitimately change on conversion. Most other issues trace to data-integrity problems that existed in the Desktop file before conversion. The good news: this is fixable, and you usually don’t need to redo the migration.
Maintained by the Certified QuickBooks ProAdvisor team at TechBrot Inc., an independent firm — not Intuit’s software support. Not affiliated with Intuit Inc.
Wrong balances after migration, in five questions.
Why are balances wrong after migrating to Online?
Most common causes: opening balances that didn’t convert, dropped or duplicated transactions, reconciliation status that didn’t carry, AR/AP that converted as summary not detail, inventory re-based from weighted-average to FIFO, and shifted retained earnings. Usually traces to Desktop-file issues the conversion tool carried over silently.
Why did inventory change?
Because the method changes. QuickBooks Desktop uses weighted-average costing; QuickBooks Online uses FIFO only and it can’t be changed. Conversion re-bases inventory asset and COGS onto FIFO, so the value legitimately differs from Desktop. The fix documents and reconciles the change.
Can it be fixed?
Yes. A diagnostic compares the converted Online file to the original Desktop balances, isolates which accounts are off and why, then corrects opening balances, reconciliation, duplicates, and AR/AP/inventory until the file ties back to the Desktop numbers you trusted.
Do I have to redo the migration?
Usually not. If the data is in Online but balances are off, it’s correctable in place. A full re-migration is only needed when conversion dropped large portions of data or the file is corrupted. The diagnostic decides which path is faster and cheaper.
How much and how long?
Focused fix: $750–$2,500, a few days to a week. Broader repair across opening balances, reconciliation, AR/AP, and inventory: $2,500–$6,000 or more, one to three weeks. Fixed-fee after a diagnostic, usually scheduled within a day or two.
Certified QuickBooks ProAdvisor credentials
Both
sides of the conversion certified — QuickBooks Desktop and Online (Level 2)
L2
QuickBooks Online ProAdvisor tier (the highest)
Yearly
Annual Intuit re-certification
- Post-conversion repair spans both platforms — the Desktop file the numbers came from and the Online file they landed in. Every ProAdvisor is certified on both.
- Active QuickBooks Desktop, Enterprise, and Online (Level 2) certifications; Intuit’s public ProAdvisor directory lists active ProAdvisors for verification.
- Operational experience reconciling a converted file back to its Desktop baseline — not a script-reading queue.
Balances wrong after conversion, plainly.
When balances are wrong after a QuickBooks Desktop to Online migration, the usual culprits are opening balances that didn’t convert correctly, dropped or duplicated transactions, reconciliation status that didn’t carry, accounts-receivable and accounts-payable detail that converted as a summary instead of open invoices and bills, inventory re-based onto a different costing method, and retained earnings or equity that shifted because the conversion closed the books differently than Desktop did. A related miss is the sales-tax-liability balance, which can land off when the agency setup converts differently. Most of these trace to data-integrity problems that existed in the Desktop file before conversion — which the automated tool carried over without flagging.
One cause is structural rather than a bug: Desktop uses weighted-average costing and QuickBooks Online uses FIFO only, so the inventory asset and cost of goods sold legitimately change on conversion. The good news is that this is fixable, and you usually don’t need to redo the migration. A diagnostic compares the converted Online file against your original Desktop balances, isolates exactly which accounts are off and why, and corrects them — opening balances, reconciliation, duplicates, AR/AP, inventory — until the file ties back to the numbers you trusted. Fixed-fee against a written scope. Independent ProAdvisor firm — not affiliated with Intuit Inc.
The balance errors a conversion most often leaves behind.
If the numbers stopped tying after your migration, it’s almost always one (or several) of these — and each has a known fix.
Error 01 · Opening balances shifted.
QuickBooks Online starts your history differently than Desktop. If the Desktop file had unreconciled items, open undeposited funds, or balance-sheet accounts that weren’t reconciled to source, the conversion carries those discrepancies and surfaces them as opening balances that don’t match what you had.
Error 02 · Reconciliations no longer tie.
Reconciled status often doesn’t carry through conversion, so accounts that balanced to the penny in Desktop suddenly show drift against the same statements in Online — the cleared transactions are there, but the reconciliation that proved them is gone.
Error 03 · AR or AP doesn’t match the detail.
Open invoices and bills sometimes convert as a single summary balance instead of individual transactions — or payments get misapplied — so the aging report no longer matches the accounts-receivable or accounts-payable control account on the balance sheet.
Error 04 · Transactions duplicated or dropped.
Conversion can double-post some transactions and skip others, throwing off the profit-and-loss and the balance sheet in ways that aren’t obvious until you reconcile against statements and source documents.
Error 05 · Inventory re-based to FIFO.
Desktop uses weighted-average costing; QuickBooks Online uses FIFO only and the method can’t be changed. After conversion your inventory asset and cost of goods sold recalculate onto FIFO — a real, structural change from the Desktop valuation, not a glitch, but one that must be documented and reconciled.
Error 06 · Retained earnings or equity moved.
If the conversion closed prior years differently than Desktop did, retained earnings and the equity section can shift — making the balance sheet look wrong even when every underlying transaction is intact. Sales-tax-liability balances can move the same way when the agency setup converts differently.
How a ProAdvisor gets the numbers tying again.
The repair works back to a single standard: the converted Online file must tie to the Desktop balances you trusted before the move.
01 · Baseline comparison
We pull the original Desktop trial balance, Balance Sheet, and Inventory Valuation Summary and compare them line by line against the converted Online file — so we know exactly which accounts are off, and by how much, before touching anything.
02 · Opening balance correction
A correct, documented opening balance established for every affected account as of the conversion date, against the source trial balance — so the file has a trustworthy starting point to reconcile forward from.
03 · Reconciliation rebuild
Bank, credit-card, and balance-sheet accounts re-reconciled to statements so reconciled status and balances are real again, not inherited drift carried over from the Desktop file.
04 · Duplicate & dropped transaction fix
Double-posted transactions removed and missing ones reconstructed from source, so the profit-and-loss and balance sheet reflect what actually happened — the date-cutoff errors that strand a period get corrected here too.
05 · AR / AP re-establishment
Open invoices and bills rebuilt as individual transactions where they converted as summaries, so the aging reports tie back to the balance sheet and you can collect and pay accurately again.
06 · Inventory & equity reconciliation
The weighted-average-to-FIFO inventory change reconciled and documented against the pre-conversion valuation, and retained-earnings and equity tied to the Desktop basis — so your CPA sees exactly what changed and why.
From wrong numbers to a file that ties.
Prioritized, because wrong balances block every decision until they’re fixed. The diagnostic is usually scheduled within a day or two.
Balance diagnostic
A ProAdvisor compares the converted Online file against your Desktop baseline — trial balance, Balance Sheet, and key reports — isolates which accounts are wrong and why, and tells you whether an in-place repair or a re-migration is the right call. A written fixed-fee scope follows.
Typical: 1–3 business days
Correct & reconcile
Opening balances corrected against the source trial balance, reconciliations rebuilt, duplicates and dropped transactions resolved, AR/AP and inventory re-established, and the opening-balance-equity (OBE) account cleared — each fix worked back to the Desktop baseline rather than forced to a target number.
Typical: a few days to 3 weeks
Verify against baseline
The corrected Online file is re-compared to the Desktop trial balance and key reports. Every remaining difference is explained and documented — the FIFO inventory re-basing, for example, is a legitimate variance — and nothing is signed off until the file ties or each variance is justified.
Typical: 1–2 business days
Document & hand off
A written summary of every correction for your records and your CPA, plus an optional transition to monthly bookkeeping so the now-clean file stays clean. You leave with a file that ties to the numbers you trusted before the move.
Optional: ongoing engagement
Repair in place, or re-migrate? The honest answer.
| Factor | Repair in place | Re-migrate |
|---|---|---|
| When it applies | The data is in the Online file but balances are off | Conversion dropped a large portion of the data, or the file is fundamentally corrupted |
| What it fixes | Opening balances, reconciliation, duplicates, AR/AP, inventory — in place | A fresh conversion, often after the Desktop file itself is cleaned up first |
| Cost & speed | Faster and cheaper — the right answer for the large majority of cases | More time and cost; only worth it when an in-place repair won’t hold |
| How we decide | The diagnostic compares both files and recommends the path that actually fits | We say so plainly if that’s your situation, rather than billing a repair that won’t hold |
Repair in place (most cases)
When the data is in the Online file but balances are off, an in-place repair — opening balances, reconciliation, duplicates, AR/AP, inventory — is faster and cheaper than redoing everything. This is the right answer for the large majority of post-conversion balance problems.
Re-migrate (rare)
Only warranted when conversion dropped a large portion of the data, the file is fundamentally corrupted, or the Desktop file itself needs cleanup first. We’ll say so plainly if that’s your situation rather than billing an in-place repair that won’t hold.
The diagnostic decides
You don’t have to guess. The diagnostic compares the two files and tells you which path actually fits — and we recommend the one that’s faster and cheaper for your file, not the one that bills more.
Not sure which path your file needs?
A Certified ProAdvisor diagnoses the converted file against the Desktop baseline and scopes the fix in writing — $750–$6,000+ fixed-fee by area. Independent firm.
A Certified ProAdvisor who reads both files.
Diagnosing a balance error means reading the Desktop file the numbers came from and the Online file they landed in, then finding the gap between them. Every TechBrot repair is delivered by a Certified ProAdvisor credentialed on both platforms, reconciled back to the Desktop baseline, with every correction documented so your CPA can see exactly what changed. Independent firm — not Intuit, and not Intuit’s software support.
Both files
diagnosed against the Desktop file the numbers came from and the Online file they landed in
$750–$6,000+
fixed-fee scope by area, set after the diagnostic — never by the hour
Independent
Certified ProAdvisor firm — not Intuit, and not Intuit’s software support
Reviewed by the TechBrot Certified ProAdvisor team.
This page reflects how TechBrot diagnoses and repairs balance errors after a QuickBooks Desktop-to-Online conversion. It is maintained by the Certified QuickBooks ProAdvisor team at TechBrot Inc., an independent ProAdvisor firm, and reviewed for technical accuracy on opening balances, reconciliation, AR/AP, and the weighted-average-to-FIFO inventory change. TechBrot performs the repair and coordinates with your CPA, who files. Not affiliated with Intuit Inc. — QuickBooks is a registered trademark of Intuit Inc.
Wrong balances after migration: your questions.
Why are my balances wrong after migrating QuickBooks to Online?
Can wrong balances after a QuickBooks migration be fixed?
Do I need to redo the whole migration if balances are wrong?
Why did my opening balances change after conversion?
Why is my accounts receivable or accounts payable wrong after migrating?
How much does it cost to fix balances after a QuickBooks migration?
How long does it take to fix post-conversion balance errors?
Repair starts here
Get the numbers tying again.
Book a balance diagnostic. A ProAdvisor compares your converted file to the Desktop baseline, tells you exactly what’s wrong and why, and scopes the fix in writing — before any work begins. A focused fix typically runs $750–$2,500; a broader repair $2,500–$6,000 or more. Wrong balances get prioritized; the diagnostic is usually within a day or two.