QuickBooks Online reconciliation won't balance? 10 causes and how to fix each
The difference won't go to $0.00, or the beginning balance doesn't match last month's statement. Almost every case comes down to one of these ten causes. Check them in this order.
First: which problem do you have?
| Symptom | Most likely causes |
|---|---|
| Beginning balance doesn't match the last statement's ending balance | #1 a previously reconciled transaction changed |
| Difference equals one transaction's amount | #2 missing, #3 duplicated, or #4 wrong period |
| Difference is divisible by 9 | #6 transposed digits |
| Difference is twice a transaction's amount | #7 wrong sign (deposit entered as a payment) |
| Many small differences on deposits | #5 card processor batches and fees |
1. A previously reconciled transaction was changed
If the beginning balance is off, someone edited, deleted, or un-ticked a transaction that was part of an earlier reconciliation. This is the most common cause, and the one to fix first, because every later month inherits it. Open the reconciliation history for the account and compare the last report with the current cleared balance. Then look for reconciled transactions dated in earlier periods but modified recently. The audit log (Settings ⚙ → Audit log) filtered to the account and date range usually shows who changed what. Restore the original entry rather than adjusting the new month.
2. A transaction is on the statement but not in QuickBooks
Bank fees, interest, returned deposits, wires, and transactions the feed missed. Compare the statement to QuickBooks line by line, or sort both by amount, and record what's missing.
3. A transaction was entered twice
The classic case is an invoice payment recorded manually (or via a payments app), and the same deposit later added from the bank feed instead of matched. Income ends up double-counted and the bank won't reconcile. Find pairs with the same amount a few days apart; delete or void the extra one, and link the deposit to the original payment.
4. A transaction belongs to a different period
A check written on the 30th that cleared on the 2nd belongs to next month's statement. Tick only what's on this statement, and check the ending date you typed matches the statement's.
5. Card processor deposits don't match the sales
Card processors deposit a net batch: several days of sales minus fees and refunds, as one amount. If each sale went into Undeposited Funds (or Payments to deposit), group them into a single bank deposit that matches the batch, and record the processor fee as a negative line on that deposit. Restaurants and retail clients produce most of this work.
6. Digits were transposed
$1,520 typed as $1,250 gives a difference of $270, which is divisible by 9. Whenever the difference divides evenly by 9, look for a swapped pair of digits.
7. A deposit was entered as a payment (or vice versa)
When the difference is exactly twice a transaction's amount, that transaction is almost always on the wrong side. Refunds from vendors and reversed charges are the usual suspects.
8. Transfers and card payments recorded on one side only
Moving money between two accounts the client owns should be a transfer, and paying the business credit card should be a credit card payment. When either is recorded as an expense or income, one account reconciles and the other never will, and the P&L is wrong too.
9. The transaction was posted to the wrong bank account
Clients with several accounts at the same bank, or a feed connected to the wrong account, produce entries that are correct in amount but sitting in the wrong register. One account shows a missing line, the other an extra one with the same amount.
10. It's in QuickBooks, but parked somewhere
Transactions categorized to Uncategorized Income/Expense or Ask My Accountant still count toward the bank balance, so they don't break the reconciliation, but they do break the P&L. Clear them as part of the same review; see cleaning up uncategorized transactions.
What not to do
- Don't finish with a difference. The adjustment entry hides the error and moves it to an equity or expense account.
- Don't edit reconciled transactions in old periods to make the current month balance. That changes reports the client may already have filed.
- Don't undo a whole reconciliation to fix one line, unless you plan to redo it. Accountant users can undo from the reconciliation history, but it un-ticks every transaction in that period.
Frequently asked questions
Why doesn't my beginning balance match in QuickBooks Online?
A transaction included in an earlier reconciliation was edited, deleted, or un-ticked after that reconciliation was finished. Compare the last reconciliation report with the current cleared balance and check the audit log for recent changes to older transactions.
What does it mean if the difference is divisible by 9?
It usually means two digits were swapped when an amount was typed, for example $1,520 entered as $1,250.
Should I force the reconciliation with an adjustment?
Avoid it. The adjustment entry makes the screen balance but leaves the actual error in the books, and future reconciliations inherit it.
How do I find a duplicated transaction?
Look for the same amount appearing twice within a few days, often a manually recorded payment plus the same deposit added from the bank feed instead of matched.