When your quickbooks reconciliation not matching is the message on the screen, the instinct is to start clicking — but the fastest fix is a checklist, worked in order of likelihood. Most mismatches come from one of five causes: outstanding items, a wrong statement date, an edited or deleted transaction, a duplicate, or a bank error. They are not equally likely, and checking them in the wrong order wastes an afternoon. This guide works through them from most common to rarest, and explains how a balance-checked statement file prevents most of them in the first place.
One thing before you start: do not force the reconciliation with an adjustment entry just to make the difference zero. An adjustment hides the cause instead of fixing it, and the same difference will reappear next month, larger and harder to trace. Find the cause first. The checklist below takes most people under half an hour, and it works whether the difference is two cents or two thousand dollars.
QuickBooks Reconciliation Not Matching: Start with the Beginning Balance
Open the reconciliation screen and look at the beginning balance first. It should equal the ending balance of your last successful reconciliation. If it does not, stop everything else: a transaction in a period you already closed has changed. QuickBooks keeps a reconciliation discrepancy report and a reconciliation change report precisely for this — the change report lists every transaction that was modified, deleted, or unreconciled after the fact, with the date it changed and who changed it.
A wrong beginning balance almost always traces to an edited reconciled transaction: someone changed an amount, a date, or an account on a transaction that was already reconciled, or deleted a reconciled transaction entirely. The fix is to restore the original transaction from the audit log, not to adjust the current month. If you use an accountant, they can unreconcile a single transaction; if you do it yourself, use the discrepancy report to find the exact amount, then correct that one transaction and re-run the reconciliation. Our quickbooks reconciliation not matching hub page links the full reconciliation guides, and if the problem turns out to be a transaction you need to reverse, see our guide on how to undo a reconciliation in QuickBooks Online.
Check for Edited, Deleted, or Unreconciled Transactions
If the beginning balance is right, the difference lives in the current month. The most common cause is a transaction that was edited after you started: a payment re-categorized to a different account, a deposit split into two lines, or a bill marked paid twice. QuickBooks marks reconciled transactions with an R in the register, and any transaction whose status changed from R back to C or blank is a suspect. Filter the register for the statement period and sort by the reconciled status column — the changed lines stand out immediately.
Deleted transactions are the quieter version of the same problem. A deleted deposit or payment removes its amount from your books but not from the bank statement, and the difference equals exactly the deleted amount. Search for the missing amount: take the difference shown on the reconciliation screen and search the register for a transaction of that exact value. A two-cent difference points to a rounding or fee issue; a round-number difference points to a missing transaction. The audit log shows deletions with the date and user, so a quick check there usually names the culprit.
QuickBooks Reconciliation Not Matching Because of Duplicates
Duplicates are the second most common cause, and they are almost always a workflow problem rather than a software bug. The classic pattern is a bank feed that imports a transaction, and then a file import or a manual entry that adds the same transaction again. The amounts are identical, the dates are a day or two apart, and the reconciliation is off by exactly the duplicate's amount — twice the amount if both copies were reconciled, once if only one was.
Find them by sorting the register by amount within the statement period and looking for pairs: same amount, same or adjacent dates, similar payees. Our free QBO cleanup checker automates this — upload a QBO or CSV export and it flags same date-and-amount pairs, near duplicates, and exact matches before you import anything. Once you find a duplicate, decide which copy to keep: usually the reconciled or matched one, and exclude or delete the other. Do not delete a reconciled duplicate without checking the reconciliation status first — deleting the wrong copy breaks a closed period, and you are back to the beginning-balance problem above. For the payout side of the same issue, our Stripe payout reconciliation guide explains how connector apps create the same overlap.
When the Bank Side Is the Problem
After outstanding items, edits, and duplicates, two causes remain. The first is the statement date: reconciling against a statement that ends on the 30th when your books run to the 31st, or vice versa. One day of transactions is enough to throw the balance off by thousands, and the fix is simply to reconcile to the right ending date. Always confirm the statement ending date on the reconciliation screen matches the statement you downloaded.
The second is a genuine bank error: a deposit credited to the wrong account, a fee charged in error, a transaction posted twice by the bank itself. These are rare, but they happen, and the evidence is your statement file. If the statement shows a charge you never made, call the bank and dispute it — federal rules give you 60 days from the statement date for electronic errors. And the preventive step that catches all of this early: import a balance-checked statement file. When you convert your bank PDF to QBO or CSV with the running balance intact, you can verify the file's ending balance against the statement before you import — if they agree, the file is clean, and most of the causes above never reach your books.