If you're having an issue with account reconciliation and your opening balance is correct, this article is designed to help you identify the cause.
(For help with reconciling when your opening balance is not correct, see Make an incorrect reconcile opening balance match the bank statement.)
If you have unreconciled transactions from previous periods in QuickBooks Online which have appeared on your bank statement in the past but your opening balance matches, then one or more of these old transactions have already been accounted for (duplicated and marked with an R).
You need to identify the transactions to fix this issue:
Transactions with Adjust or Adjustments in the Memo column and the letter R in the Clr column may be causing the issue. Adjustments were made when a previous reconciliation did not balance, and an adjustment was put in to take the place of an actual transaction that was either missing or duplicated.
If there are no adjustments once the historical transactions have all been resolved and the report correctly reflects the opening balance, you should be able to continue your reconciliation.
When reconciling, you have to enter the ending balance which comes from your bank statement. It's imperative that this balance is entered accurately.
If your opening balance and ending balance are correct and the difference does not equal 0, then the error lies in the transactions that have been check-marked.
Double-check the following:
If the total of the adjustments equals the amount of the outstanding historical transactions, you can delete the adjustments and manually reconcile the historical transactions in the register.
To manually reconcile a transaction, select Edit from the register and add the letter R in the check mark column.
If the transactions are all correctly check marked and the ending balance is correct, then the opening balance must be incorrect. If this is the case, see My reconcile opening balance is wrong. How do I make it match my statement?.
Accounts connected to online banking have additional features to assist with reconciliation.