← Back to blog

Bank Reconciliation Discrepancies: Causes and How to Fix Them

October 31, 2026
Bank Reconciliation Discrepancies: Causes and How to Fix Them

A bank reconciliation discrepancy is any difference between your book balance and your bank statement balance that you cannot explain with a known item. Most come from a short list of causes: outstanding checks, deposits in transit, unrecorded bank fees or interest, data entry mistakes, duplicates and, occasionally, a bank error or fraud. This guide shows how to sort timing differences from real errors, trace what is left, and correct it without plugging the gap.

Amcfo
Bring Your Books Back Into Balance
AmCFO provides bookkeeping and QuickBooks support to help businesses stay financially organized and make sense of their financial records.
Explore bookkeeping support

TL;DR

  • Start by separating timing differences (outstanding checks, deposits in transit) from true errors. Timing items clear on their own; errors need a correcting entry.
  • Check the opening balance first. A reconciliation that starts from the wrong number never ends right.
  • Use the size of the difference as a clue: half the difference suggests a wrong-side entry, and a difference divisible by 9 often points to a transposed number.
  • Never force the books to balance with a plug entry. Leave an unresolved difference open, document what you checked, and escalate it.
  • Reconcile every month, and report suspected bank errors or unauthorized transactions right away, since deadlines vary by account type.

Table of Contents

What a discrepancy actually is

A reconciliation compares two records of the same cash: your general ledger and the bank's statement. OpenStax explains that differences commonly arise because one side knows about a transaction before the other does. You write a check today and the bank learns of it when the payee cashes it. The bank deducts a fee today and you learn of it when the statement arrives.

That gives you two kinds of difference:

  1. Timing differences. Both records are right, just not at the same moment. They resolve themselves.
  2. Errors and unrecorded items. One record is wrong or incomplete. Someone has to fix it.

Every reconciliation problem comes down to deciding which kind each unmatched line is. The rest of this article is a method for doing that quickly.

The IRS advises businesses to reconcile checking accounts monthly, so that cash balances are verified, the books reflect all bank charges, and errors in bank statements, checkbooks or journals get corrected. A monthly rhythm also keeps the pile of unmatched items small enough to trace.

The common causes, in the order to check them

CauseWhat you seeIs it an error?What to do
Outstanding checkRecorded in books, not yet on statementNo, timingDeduct from the bank-side balance; confirm it clears next month
Deposit in transitRecorded in books, not yet on statementNo, timingAdd to the bank-side balance; confirm it posts
Bank fees, interestOn statement, not in booksUnrecorded itemRecord a journal entry in your books
Funds collected by the bankDeposit on statement, not in booksUnrecorded itemRecord the receipt and its source
Transposed or mistyped amountBook and bank amounts differ on one lineYes, yoursCorrect the book entry
Duplicate entrySame transaction twice in booksYes, yoursDelete or void the duplicate
Bank errorStatement amount wrong or item not yoursYes, the bank'sDocument and notify the bank

OpenStax lists this same set: outstanding checks, deposits in transit, bank fees, errors by the business or the bank, interest and funds collected by the bank. Work down the table. The first two rows explain most month-end gaps, and the next two explain most of what remains.

Step 1: Confirm the starting point

Before hunting individual transactions, check that this month's opening balance equals last month's approved closing position. A changed opening balance usually means someone edited, deleted or backdated a transaction in a closed period. Recommended reconciliation procedures include checking that current opening balances connect to prior approved closing positions.

This is also the step that most often explains a stubborn difference that repeats month after month. If last month was forced to balance, this month inherits the plug. Continuity of cash records matters just as much when a closing checklist ties each period's starting balance to the last and nothing carries over unexplained.

Then confirm the ending balance you typed in matches the statement exactly. A single transposed digit here creates a discrepancy that no amount of transaction matching will solve.

Step 2: Separate timing from error

Go through every unmatched line and assign it a status.

Outstanding checks reduce your book balance when you write them but do not reduce the bank's balance until the payee cashes them, so they are deducted on the bank side of the reconciliation. Deposits in transit raise your book balance when recorded but are absent from the statement until the bank posts them, so they are added on the bank side. OpenStax sets out this treatment of both items.

The Washington State Auditor's guidance notes that month-end deposits or checks may show up in the next month's bank activity because they have not yet cleared or been deposited by the other party.

The discipline is to tie every "timing" label to an expected clearing event. Reviewers should push back on an explanation that just says timing with no expected clearing event. In practice:

  • A check written on the 28th and unpaid on the 31st is plausible timing.
  • A check that has been outstanding for four months is not. It may be lost, voided, or a stale item that needs follow-up with the payee.
  • A deposit "in transit" for more than a few business days deserves a call to whoever made it.

The next month's statement is your proof. If an item you called timing has not cleared by then, reclassify it as something to investigate.

Step 3: Use the size of the difference

If timing items and known bank charges are handled and your books still differ from the bank, the amount of the remaining difference is a diagnostic clue. Texas A&M's accounting guide recommends calculating the difference, dividing it by two to detect wrong-side or wrong-sign errors, and also checking the undivided difference for omitted items.

Here is how that works:

  • Difference of $240, and a $120 item exists. You may have entered a $120 deposit as a $120 payment, or the reverse. Reversing the side moves the balance by twice the amount, so half the gap equals the item.
  • Difference of $240, and a $240 item exists. A transaction was likely left out entirely in one record.
  • Difference divisible by 9. Look for a transposition, such as $540 entered as $450 (a $90 gap).
  • Difference of a round figure like $1,000. Look for a dropped zero or a missing round-number deposit.

These are leads, not proofs. Confirm each against the source document before you correct anything.

Step 4: Trace both directions

If the clues don't surface the cause, trace systematically. Start with the bank statement and find each line in your ledger. Then start with the ledger and find each line on the statement. Recommended procedures call for tracing unmatched bank and ledger lines in both directions because each direction catches what the other misses: the first finds unrecorded bank activity, the second finds entries that never reached the bank.

When a checkbook and statement still disagree, the IRS suggests that you refigure the running balances, compare deposit totals with cash receipt records, and check individual check amounts against disbursement journals to locate recording errors.

A few places to look when you are stuck:

  • Merchant and payment processor deposits. Processors usually deposit net of fees and batch many sales into one payout, so the bank amount rarely equals the sales total. For online stores, a clean ERP integration runbook shows how order and payout data should line up with what lands in the bank.
  • Transfers between your own accounts. One leg is recorded and the other is missing or dated in a different month.
  • Payroll. Taxes and net pay may leave the account on different days than the payroll journal assumes.
  • Voided and reissued checks. The original may still be counted as outstanding.
  • Bank feed duplicates. Importing a feed and entering the same item manually creates doubles.

Step 5: Correct the books, not the number

What you do next depends on the finding.

  • Unrecorded bank item (fee, interest, a deposit the bank collected): record it in the books with the proper account and description.
  • Your own error: correct or reverse the original entry. Do not stack an offsetting entry on top of it.
  • Bank error: do not adjust your books to match the bank. Your records stay correct, the reconciliation lists the item as a reconciling item, and you notify the bank.
  • Timing item: no entry at all.

The temptation at 11 p.m. on close day is a "miscellaneous" or "reconciliation discrepancies" entry that makes the zero appear. Don't. The recommended practice is to classify differences, document what you checked and what evidence you need next, and leave unresolved differences open for escalation rather than force a balance. A small plug that goes unexamined can hide a duplicate payment, a missing deposit or worse. If you need the full walkthrough, our guide to five steps to bank reconciliation, IRS ready covers the process end to end.

A simple log, one line per open item, is enough:

  1. Date and amount of the item
  2. Which record it appears in (bank, books, or both)
  3. Your classification (timing, unrecorded, error, unknown)
  4. What you checked
  5. What evidence you need next, and who owns it
  6. Date resolved

When the bank may be at fault

Bank errors are uncommon but real: an amount posted wrong, a deposit credited to another account, a check paid twice. First rule out your own mistake by comparing the bank's image or detail against your source document. Then gather the statement, the item image and your records, and contact the bank in writing.

Speed matters, and the rules differ by account type. For consumer accounts, federal Regulation E says an institution need not follow its error-resolution procedures for a notice received more than 60 days after the statement showing the error. Business accounts generally are not treated like consumer accounts, and your deposit agreement and state law set the window, often much shorter for electronic debits. So read your account agreement, and report anything suspicious as soon as you see it, not at quarter end. If you suspect fraud rather than a simple error, involve your bank's fraud team, and an attorney or forensic accountant if the amounts are significant.

When the bank may be at fault

Finding the discrepancy report in QuickBooks Online

QuickBooks Online has a report built for this. Per Synder's walkthrough, you open Reports, search for Reconciliation Discrepancy, and choose the account. It lists transactions that were changed or deleted after a reconciliation was completed, which is the usual reason an opening balance no longer matches.

Use it alongside these checks:

  1. Confirm the beginning balance equals the prior statement's ending balance.
  2. Verify the ending balance and statement date you entered.
  3. Look for transactions edited or deleted after the last reconciliation.
  4. Look for duplicates created by bank feeds plus manual entry.
  5. Check for transactions dated outside the statement period.

If the account has been touched for months and nothing ties, repairing individual entries can take longer than a structured cleanup. Our guide to cleaning up your books fast covers the steps, the time and the costs.

Perspective: what we see in messy reconciliations

Most of the reconciliations that land on our desk are not hard because of one big error. They are hard because of many small ones, left to accumulate over several months, and a plug entry somewhere that nobody remembers making. The fix is rarely clever. It is going back to the last reconciliation that was genuinely clean and rebuilding forward, one month at a time.

Perspective: what we see in messy reconciliations

We also see owners treat reconciliation as a compliance chore, when it is the cheapest control a small business has. It tells you whether the cash number on your dashboard is real, whether a vendor was paid twice and whether someone is touching money they should not. We pair every accounting engagement with experienced fractional CFO oversight, so unusual items get a second look, not just a matching exercise.

Our advice: reconcile monthly, keep one person from both writing checks and reconciling when you can, and never accept "timing" without a clearing date. For more habits like these, see our bank reconciliation best practices.

— Angelica

When to get help

You probably don't need outside help for a $40 timing difference. You probably do if any of these apply:

  • The same difference has carried forward for several months.
  • Opening balances keep changing after periods are closed.
  • You have multiple accounts, processors or entities to tie out.
  • You suspect fraud or repeated duplicate payments.
  • The person who reconciles is also the person who approves payments.

AmCFO's bookkeeping and accounting team handles monthly reconciliations, QuickBooks setup and cleanup, and payroll support, with fractional CFO oversight when you need to understand what the numbers mean for your business. We serve both for-profit and non-profit organizations, and we scope work to what you need, without the cost of a full-time executive.

Amcfo

To hand off reconciliations or clean up a backlog, see our accounting and bookkeeping services. If the larger problem is cash visibility and planning, our fractional CFO services are built for that. For a broader look at how the pieces fit, read how bookkeeping works for business or our explainer on accounts reconciliation for finance teams.

A quick monthly routine that prevents most problems

  1. Reconcile within a few days of receiving the statement, while memory is fresh.
  2. Record bank fees and interest as soon as you see them.
  3. Date and enter checks and deposits in the month they happen.
  4. Review the outstanding list and chase anything older than 60 to 90 days.
  5. Tie the opening balance to last month's approved close.
  6. Have someone other than the check writer review and sign.
  7. Keep the statement, reconciliation report and open-items log together. Our financial records checklist shows how to organize them.

FAQ

How do you find a discrepancy in a bank reconciliation?

First confirm the opening balance and the ending balance you entered. Then list timing items, trace every unmatched line in both directions, and use the size of the difference as a clue. Half the difference points to a wrong-side entry, and a difference divisible by 9 suggests a transposition.

Is an outstanding check a discrepancy?

No. It is a timing difference, because your books show the payment and the bank has not yet processed it. You deduct it from the bank-side balance, and it should clear in a following period. If it stays outstanding for months, investigate it.

Should I record a journal entry to make the reconciliation balance?

Only when it corrects a specific, documented item such as an unrecorded fee. A generic plug entry hides the cause. If you cannot explain a difference, leave it open, document what you checked and escalate.

How long do I have to report a bank error?

It depends on the account and the type of transaction. Consumer accounts get a 60-day window under federal rules, but business accounts are generally governed by your deposit agreement and state law. Report suspected errors or unauthorized items as soon as you find them.

Can I run a reconciliation discrepancy report in QuickBooks Online?

Yes. Search for Reconciliation Discrepancy in the Reports menu and select the account. It shows transactions changed or deleted after a reconciliation was finished, a common cause of opening balance problems.

Sources