Bank balances look wrong after moving from Self-Employed to QuickBooks Online
Switchers from QuickBooks Self-Employed or Sole Trader find Online bank balances that miss the statement; here is why the gap appears and how to true it.
One complaint keeps reaching us from users who moved from QuickBooks Self-Employed or Sole Trader to QuickBooks Online. The bank and cash figure on the new Balance Sheet bears no relation to the real account. The numbers are not corrupted. The gap has a known cause, and a known cure.
Two systems, one history
Self-Employed and Sole Trader are single-entry tools. They record money in and money out, which is enough for a Self Assessment, and they stop there. Assets, liabilities and equity are never formally separated.
Online runs on double-entry bookkeeping. Every transaction must touch at least two accounts, and the debit side always equals the credit side. That discipline is what supports fuller financial reporting.
Migration bridges the two by rebuilding your single-entry history inside the double-entry framework. The software invents the balancing entries that the old tool never captured. What you end up with is a cash line equal to the net total of every business transaction you recorded before the switch. It is a calculated figure, not a live read on any bank account.
A purchase told two ways
Picture a £20 stationery purchase paid from the business account. In the single-entry tool you enter the amount and pick a category, and the record is done. The Profit and Loss shows £20 of stationery expense.
Online asks one more question: how was it paid? The expense still rises by £20 on the Profit and Loss. A matching entry removes £20 from the bank account on the Balance Sheet. Debit equals credit, and the books balance.
Migration performs that second step for every historical transaction at once. Where the old records never said how a purchase was paid, the software parks the balancing side on a cash or bank line. If you had a bank account connected in the old tool, the balancing entries attach to that account. Either way, the opening cash figure is a net calculation rather than a statement balance.
Does the gap close on its own?
No, and this is the part that catches people out. The migrated cash figure is frozen at the moment of the switch. Bank feeds then layer real transactions on top of it, so the account keeps moving. The original difference between that figure and your true bank balance never changes. It persists as a constant, because routine entry never touches it. Waiting does not fix this.
Your Profit and Loss history is largely unaffected. The distortion lives on the Balance Sheet, which is why the P&L can look right while the bank line looks wrong.
Truing up the opening balance
The cure is a deliberate, one-off adjustment. Two routes are common.
The first is an opening balance adjustment. Compare the Balance Sheet cash figure with your bank statement balance on the switch date, and note the difference. Then post a journal entry, dated on or before that date, that moves the bank account to the statement figure. The offsetting side usually lands in an opening balance equity account. An accountant can reclassify that later into owner’s equity or retained profits if your reporting needs it.
The second route is reconciliation. Open the reconcile screen for the account and work against a real statement. The residual difference it surfaces is your migration gap. Accept an adjustment there and the software posts the correcting entry for you, resetting the baseline.
Before either route, note the pre-adjustment figures or take a backup. An entry dated wrongly simply re-creates the mismatch in a new shape, and a second hunt is harder than the first.
Keeping the figure honest afterwards
Connect the real bank account if you have not already, so new transactions flow in as they happen. Categorise them promptly and reconcile against each statement. With the opening balance corrected, the Balance Sheet line and the statement should agree at every step. Any future difference then means something real happened, rather than migration noise.
Seen this after your own move? Measure the gap against a statement first. Then let a journal entry or the reconcile routine do the repair, and the Balance Sheet becomes a figure you can trust again.