Bank Reconciliation Errors: 5 Red Flags Your Books Are Lying to You

Reconciling your bank account is supposed to be the moment of truth. Once a month, your books and your bank statement sit down, compare notes, and either agree or they do not.

Done right, reconciliation catches duplicates, missing deposits, bank errors, and fraud while the trail is still warm. Done wrong, it does something sneakier: it makes broken books look official. That green checkmark in QuickBooks feels like proof. Sometimes it is just paint over the crack.

These are the five bank reconciliation errors we see most when a new client hands us their “reconciled” books, plus the five-minute check for each one:

• A reconciliation that only balances because of an adjustment
• Uncleared transactions from months ago
• A bank feed balance that never matches the actual bank
• Deposits that do not match what the bank received
• A last-reconciled date from another season

1. The reconciliation only balances because of an adjustment

QuickBooks has a button for when your reconciliation will not tie out. It offers to record the difference to an account called Reconciliation Discrepancies and call the whole thing done. That button is not a fix. It is a confession.

A plug entry means somebody could not find the difference and buried it instead. Do that a few months in a row and small mysteries compound into a number nobody can explain, sitting in an account nobody looks at.

Five-minute check: search your chart of accounts for Reconciliation Discrepancies and run a report on it. Anything in that account this year deserves a real explanation. “It was only $40” is how it starts.

2. Uncleared transactions from months ago

Open your last reconciliation report and look at the uncleared list. A check from November that never hit the bank. A deposit that has been “pending” since spring. Those are not patient transactions. They are usually duplicates, entered once by hand and once by the bank feed, or payments recorded in the books that never actually went out the door.

The damage is quiet. Your books show cash you do not have, or show vendors as paid when the money never moved. And a check that truly never cleared is not trivia either. In most states that money eventually belongs to the unclaimed property office, not to your checking account.

Five-minute check: pull the uncleared transactions on your latest reconciliation report. Anything older than 60 days needs an answer, not a shrug.

3. The bank feed balance never matches the actual bank

At the top of the banking screen, QuickBooks shows two numbers: the bank balance and the balance “in QuickBooks.” On any given day they will differ a little, and that is fine. Timing is real. But if the gap is large, persistent, and growing, something structural is wrong: transactions sitting unposted in the feed for months, duplicates stacking up, or someone “reconciling” to the register instead of the statement.

Five-minute check: compare the two balances and ask what explains the difference. If the honest answer is “nobody knows,” that is the flag.

4. Deposits do not match what the bank received

This is the big one for anyone who takes cards. Your POS says you sold $3,000 on Tuesday. The bank shows a $2,912 deposit on Thursday, because the processor took its fee and batched the settlement. If your books record $3,000 as the deposit, you now have revenue that does not tie to the bank, processing fees hiding inside sales, and an Undeposited Funds account quietly turning into a black hole.

Restaurants feel this worst: daily sales, tips, batched card settlements, and merchant fees all landing on different days. But every business with a card reader has some version of it, and it quietly distorts both your revenue and the sales tax you file on top of it.

Five-minute check: look at Undeposited Funds. Anything sitting in it older than a week means deposits are not being matched. Then take one normal month and compare recorded sales to actual bank deposits. The difference should be exactly fees and timing, and you should be able to say so out loud.

5. The last reconciliation was months ago

Bank feeds have convinced a lot of owners that their books are current. Transactions flow in every day, everything looks alive, so surely it is fine. But auto-added is not verified. The feed can duplicate, miss, and miscode all on its own, and it happily will. The feed keeps your books busy. It does not make them right.

Five-minute check: open Reports, then Reconciliation Reports, and look at the last reconciled date on every bank and credit card account. More than one month behind on any of them is a flag. More than three is a cleanup job.

One red flag is a chore. Five is a pattern

Any one of these can happen to careful people. Several of them together mean nobody is actually verifying your books against reality, and that is how owners end up profitable on paper and overdrawn in real life.

Reconciliation is not a standalone chore either. It is step one of a real month-end close, the boring ritual that turns your numbers into facts. We wrote out the whole process here: Monthly Bookkeeping Close Checklist: 8 Steps.

And if you ran the five checks and found three flags and a knot in your stomach, take a breath. It is a cleanup, not a catastrophe. We do these every week, and we have seen worse. Probably.

If reconciliation errors are only part of the problem, how to fix messy books covers the full cleanup, in order.