A reconciliation discrepancy almost always comes from one of four things: a transaction entered twice, a transaction missing from QuickBooks entirely, a beginning balance that doesn't match last month's ending balance, or a bank feed error that duplicated or dropped something. Run the Reconciliation Discrepancy report first; it usually points straight at the transaction that changed. Here's how to track down each kind.
1. Pull up the Reconciliation Discrepancy report. You'll find it in the Reports search bar. It lists any transaction that was added, deleted, or changed after it was already reconciled, along with the amount it's off by. This is the fastest path to the cause if the discrepancy showed up after a previously clean reconciliation.
2. Check the beginning balance first. If this month's beginning balance doesn't match the ending balance you reconciled to last month, nothing downstream will line up no matter how carefully you check off transactions. This is the single most common cause and the easiest to miss, because it's not in the list of transactions at all, it's the starting number.
3. Look for duplicates. Run the account register and sort by amount or date. A transaction that got entered manually and then also pulled in through the bank feed is the classic duplicate: same amount, same date, twice.
4. Look for anything missing. Compare your statement line by line against what's checked off in QuickBooks. A bank fee, an interest charge, or a transaction the bank feed silently skipped is easy to miss because there's nothing in QuickBooks flagging its absence.
5. Check for a bank feed matching error. Sometimes the bank feed matches a downloaded transaction to the wrong existing entry instead of creating a new one, which can silently alter an amount that used to be correct. Open the transaction and check its history if the numbers look right but the discrepancy persists.
6. Fix the actual transaction, then re-reconcile. Once you've found the duplicate, the missing entry, or the wrong beginning balance, correct it directly rather than forcing the reconciliation to balance by adjusting the ending difference. For the mechanics of reconciling itself, start to finish, see our walkthrough on how to reconcile an account in QuickBooks.
Checking off transactions that already match takes minutes. Finding the one duplicate or missing entry in a list of hundreds, with no indicator pointing you at it directly, is a different kind of work entirely, and it's the part that actually eats an afternoon.
It gets worse the more systems feed into the account. A duplicate caused by a payment processor and a manual bank feed both recording the same deposit is a different hunt than a straightforward data entry mistake, and the more sources there are, the more likely two of them disagree with each other.
The part worth automating isn't the reconciliation screen, it's the cross-checking that happens before you ever get there: matching what every connected system says happened against what the bank actually shows, so a discrepancy gets flagged the day it occurs instead of thirty days later during the monthly reconcile.
Transactions coming in from a payment processor or POS get checked against the bank feed as they arrive, so a duplicate gets caught and flagged the day it happens instead of surfacing as an unexplained difference weeks later.
A quick automated check confirms this period's beginning balance matches last period's reconciled ending balance before anyone starts checking off transactions, catching the single most common cause of a discrepancy before it wastes anyone's time.
Tell us which systems feed your bank account and what usually goes wrong, and we'll tell you if it can be caught automatically before reconciliation day.
Tell us where your transactions actually come from, a bank feed, a processor, a manual entry, and we'll tell you whether the mismatches can be caught automatically before they turn into a discrepancy at all. And if reconciliation isn't your real time sink, that's fine too, we automate whatever's manual anywhere in the business.
Let's talk →If an accountant is connected to the account, they can undo an entire reconciliation at once through their Accountant Tools. Without that access, you have to unreconcile transactions one at a time from the account register. Only do this once you know what actually caused the discrepancy; undoing and redoing without finding the cause just reproduces the same mismatch.
That's usually the easiest case to fix: it means one transaction is either missing, duplicated, or entered for the wrong amount. Search the register for that exact amount around the statement date before assuming the cause is anything more complicated.
Yes. A bank feed can occasionally match an imported transaction to the wrong existing entry, or import the same transaction twice after a connection hiccup. These show up as a discrepancy that wasn't caused by anything a person typed in, which is why checking the bank feed itself is worth doing before assuming someone made a data entry mistake.
From the account's reconciliation history (Transactions, then Reconcile, then History by account), open the reconciliation you want and choose the print or PDF option. It's a good habit after a reconciliation that gave you trouble, so you have a clean record of what matched at the time.