You finish the migration, and the first reconciliation in QuickBooks Online opens with a beginning balance you do not recognise. People have been asking about this in Intuit's own forums since 2019, so you are not the first. Before you start working around it, it is worth knowing what the move is supposed to do: a converted account should carry all the detail that was in Desktop. Some of what looks different afterwards is by design and documented. Some of it is documented nowhere at all. And some of it means something did not come across.
What came across, and what did not
Your reconciliation history is not one thing. It is two, and they behave differently.
The marks survive. Every reconciled transaction arrives in QuickBooks Online with an R in the cleared column, and every cleared one with a C. The register still knows what was reconciled and what was not.
The reports do not. Past reconciliation reports are on Intuit's own list of what does not transfer. The statement dates, the beginning and ending balances, who reconciled and when: that record stays in Desktop. Save those reports as PDFs before the move, because afterwards there is nowhere to regenerate them from.
What Intuit says should match, and what may not
Intuit's own expectation is narrower than people expect: accrual basis reports in QuickBooks Online will match your reports in Desktop, and cash basis reports may not. It does not say by how much, and it does not say why.
Inventory has two doors that open only one way
If you move inventory, you pick a FIFO start date during the migration, and Intuit recommends the first day after your last tax filing period, and after that date inventory transactions cannot be edited in Online.
The costing method is the other door. FIFO or moving average cost is chosen once and cannot be changed later, and a file that creates an inventory item before the choice is made is defaulted to FIFO with the option removed from settings.
Intuit says plainly that inventory values and cost of goods sold may be calculated differently, and that those reports may not match exactly after migration.
The beginning balance, and where the documentation stops
This is the part people get stuck on. Intuit documents how a beginning balance works in general: it should match the ending balance of your last reconciliation. When it does not, the usual causes are:
- A transaction changed after the fact, edited, deleted, voided, moved or unreconciled.
- An incorrect opening balance entered when the account was created.
- A transaction reconciled outside the normal flow.
- A bank feed transaction that was undone and sent back to pending.
What Intuit does not document there, or in the related articles, is any of that for an account whose history arrived by conversion. The reconcile article, the beginning-balance article and the opening-balance article are all written for accounts you set up yourself. None of them has a branch for a converted file. Meanwhile the question has been asked in Intuit's own forums from 2019 through 2024, and in a 2024 thread two members of Intuit staff proposed two different fixes.
So if your first reconciliation in Online opens with a number that does not tie back to your last Desktop reconciliation, the help centre will not tell you why. What is worth holding on to is the expectation: a converted account should carry all the detail that was in Desktop. A beginning balance that will not tie is a reason to find out what did not come across, not a number to paper over. What it should be for your accounts is a question for your accountant, who can see your books.
A checklist for the first reconciliation in Online
None of this is in Intuit's help centre as a procedure for a converted file. Each step is built from something Intuit does document, in an order that rules out the simple explanations first. One piece of mechanics makes it work: by Intuit's own account of the causes, marking a transaction R adds it to the beginning balance. The beginning balance is built from the R's.
- Find your last Desktop reconciliation report. Its statement date and ending balance are what the first reconciliation in Online should start from. If you didn't save it as a PDF, it is still in the Desktop file, so open that rather than work from memory.
- Compare the account's balance in both systems. Run the Balance Sheet on an accrual basis as of that statement date, in Desktop and in Online. If the account's balance already differs there, the gap came across in the move itself, and that is the thing to trace before anything about reconciling.
- Total the R's in Online. Filter the account's register by reconcile status and add up the transactions marked R, dated on or before the statement date. Every reconciled transaction should have arrived with an R, so that total should equal the Desktop report's ending balance. If it does not, the difference is a transaction whose amount, date or mark changed on the way over.
- Look at the C's in the same period. A transaction checked off in a Desktop reconciliation that was never finished arrives with a C, for cleared, not an R. A C does not count toward the beginning balance.
- Look at R's dated after the statement date. Intuit's own check: in the register, filter by reconcile status and look for any transaction marked R after your last completed reconciliation. Those were reconciled outside a reconciliation.
- Read the audit log. Go to Settings, then Audit log, filtered to the account. Online starts its own log on the day of the move, so anything deleted, voided or edited there in the reconciled period happened after the migration, and so did any bank feed transaction undone and sent back to pending.
- Then stop and take it to your accountant. Intuit's advice is to fix only a change made in error, and to check with your accountant before any correction that touches a reconciled period or an opening balance. That goes double for an adjusting entry posted only to make the number tie.
Two other things that change on the way over
Bank feed connections do not transfer, so every account has to be reconnected in Online before anything can be matched. And some transaction types arrive as something else:
- Item receipts become bills.
- Memorized transaction groups do not come across at all, because groups do not exist in QuickBooks Online.
None of that is an error, but a register that does not look the way you expect is easier to read once you know it.
When to bring in help
A clean file with a short history and no inventory is a reasonable thing to reconcile yourself. Years of history, inventory, or a beginning balance that will not tie are worth a second set of hands, and that is the kind of migration I do.
Ten Rivers Systems handles technical setup, configuration, and data migration only and does not provide accounting or tax advice. I am not an accountant or tax adviser. How you keep your books and what you owe stays between you and your own professionals.
Common questions
Do my past reconciliations carry over to QuickBooks Online?
Partly. Every reconciled transaction arrives with an R in the cleared column, and every cleared one with a C, so the register still knows what was reconciled. The historical reconciliation reports themselves do not transfer, so save them as PDFs before you migrate.
Why is the beginning balance wrong on my first reconciliation after migrating?
Intuit documents the usual causes for any account: a transaction edited, deleted, voided, moved or unreconciled after the fact, an incorrect opening balance when the account was created, a transaction reconciled outside the normal flow, or a bank feed transaction that was undone and sent back to pending. None of those articles covers an account whose history arrived by conversion. A converted account should carry all the detail that was in Desktop, so a balance that will not tie is worth tracing rather than working around. What it should be for your accounts is a question for your accountant.
Should my reports match Desktop exactly after the move?
Intuit says accrual basis reports will match and cash basis reports may not. Inventory is a separate case: QuickBooks Online may calculate inventory values and cost of goods sold differently, so those reports may not match exactly.
