n-How to Fix Reconciliation Discrepancies in QuickBooks Online
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.
How to actually find what's causing it
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.
Why this eats so much more time than reconciling itself
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.
What we've built on top of QuickBooks reconciliation
Duplicate detection before reconciliation day
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.
Beginning balance verification
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.
What's the actual recurring cause of your discrepancies?
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.
Spending more time hunting a discrepancy than actually reconciling?
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