Bank reconciliation not matching? Common causes and how to fix them

A bank reconciliation that will not match is frustrating, but it is rarely a mystery once you work through it in order. For Texas small businesses, a difference between the bank balance and the book balance usually comes down to timing, a duplicate or missing entry, a categorisation slip, or a simple amount error. The fix is seldom to force the numbers to agree. It is to find the specific item that explains the difference, correct it in the right place, and leave a clear trail.

This guide explains the most common causes, a step-by-step checking order you can follow, and when it makes sense to ask for help rather than keep adjusting entries.

What a bank reconciliation is meant to prove

Reconciliation compares two records of the same money: your bank statement and your accounting records. When both are complete and correct, they should agree after allowing for items that have not yet cleared the bank, such as outstanding checks and deposits in transit. A mismatch does not automatically mean money is missing. It means one record contains something the other does not, or the same item is recorded differently in each place.

Common causes when a reconciliation does not match

1. Outstanding checks and deposits in transit

Checks written near month-end may not have cleared by the statement date, and deposits made late in the month may still be in transit. These are normal timing differences, not errors, provided each item clears in a later statement. The problem arises when an old outstanding item is no longer valid, has been reissued, or was recorded twice.

2. Duplicate transactions

Duplicates often appear after a bank feed imports a transaction that was already entered manually, after a payment is recorded once as a bill payment and again as an expense, or after a deposit is entered for both a customer payment and a bank transfer. Even one duplicate can throw the whole reconciliation off by exactly that amount, which makes duplicates a good first place to look.

3. Missing transactions

Bank fees, interest, automatic payments, card charges, and refunds sometimes appear on the statement before they are entered in the books. A missing fee is easy to overlook because it is small, but several missing items together can create a confusing difference. Review the full statement, not only the large transactions.

4. Bank errors and reversed items

Banks occasionally post an incorrect amount, duplicate a charge, or reverse a transaction. Do not assume the statement is always right. If the books support a different amount and the supporting document agrees with the books, contact the bank and keep a note of the reference, date, and person you spoke with while the item is being checked.

5. Timing differences and cut-off errors

A transaction dated in one month but cleared in the next, a payment recorded on the wrong date, or a month-end deposit split across two statements can all create a temporary difference. These items should resolve in the following period. If the same difference repeats month after month, it is more likely a recording error than timing.

6. Categorisation and account errors

Recording a payment to the wrong bank or credit card account, posting an owner payment as a business expense, or assigning a receipt to the wrong income category will not change the total cash in the bank, but it will change which account reconciles. Check the account first: many mismatches are simply in the wrong account, not missing altogether.

7. Amount, sign, and transposition errors

A payment entered as a deposit, a decimal point in the wrong place, or two digits swapped can produce a difference that is hard to spot by eye. If the difference is divisible by nine, a transposed figure is a common possibility worth checking. Also check for a transaction entered with the wrong sign, such as a refund recorded as a sale.

8. Starting balance problems

If a previous month was never fully reconciled, or an old reconciled transaction was later edited or deleted, the opening balance for the current month will be wrong and every later reconciliation will struggle. In that case, fixing the current month alone will not work. The earlier period needs to be reviewed first.

A step-by-step checking order

Work in this order, and stop as soon as the difference is explained. Changing several things at once makes it harder to know what actually fixed it.

1. Confirm the statement period, ending balance, and bank account. Reconciling the wrong account or the wrong dates is a common starting mistake.
2. Check the opening balance against the previous reconciled balance. If it does not agree, review the prior period before going further.
3. Compare the statement line by line with the books, marking each cleared item. Note every item that appears in only one record.
4. Sort the unmatched items into timing items, duplicates, missing entries, and amount differences. Timing items should be left as outstanding; the others need correction.
5. Search for the exact difference. Look for a single transaction for that amount, a duplicate of that amount, or two items that together equal it.
6. Check for a half-difference. A transaction entered at twice its amount, or a sign error, can show up as double the difference.
7. Review recent edits to reconciled transactions, deleted entries, and bank feed rules. A rule that posts similar transactions to the wrong account can repeat the same error.
8. Correct the specific entry, with a note explaining the change, then re-run the reconciliation. Do not post a generic adjustment just to make the balance agree.

Fixes that create bigger problems

Avoid deleting a reconciled transaction to force a match, backdating entries without supporting documents, or posting an unexplained adjustment to a suspense account and leaving it there. Each of those steps may make one month appear to reconcile while hiding the real item, which then reappears in a later review, a tax return preparation, or a lender request. If an item cannot be explained from the statement and supporting documents, leave it visible and documented until it can be.

When to ask for help

Consider getting outside help if the difference spans several months, the opening balance does not agree with the prior reconciliation, reconciled transactions keep changing, or you are repeatedly posting adjustments to make months balance. The same applies if bank and credit card reconciliations are falling behind while the business is still growing. In those cases, a structured review can identify whether the issue is a single error, a feed or categorisation rule, or an earlier period that needs correction.

For Texas businesses that use QuickBooks, Ledger Bureau offers QuickBooks Reconciliation support to work through unmatched items, check prior periods, and bring bank and card accounts up to date. Ongoing record-keeping can be supported through Bookkeeping services, so reconciliations are completed regularly rather than left until a difference becomes difficult to trace.

This article provides general information about bookkeeping processes only. It is not tax or legal advice, and specific situations should be reviewed with a qualified professional where needed.

Request a free consultation

If your bank reconciliation is not matching and you would like a second pair of eyes on the difference, request a free consultation with Ledger Bureau. Tell us which account and month are affected, and whether the difference is new or has carried forward, so the conversation can start with the right information.