Bank Reconciliation Differences: A Month-End Investigation Guide

A zero difference is the result, not the explanation

A bank reconciliation can balance and still contain a problem. A duplicate payment can remain on the outstanding list, while an unsupported deposit in transit can conceal missing cash. The useful question is whether every reconciling item has an explanation and evidence that another accountant can follow.

This guide uses a fictional single-currency operating account and ordinary cash receipts and payments. It does not address restricted cash presentation, foreign exchange, or the recognition rules for complex transactions. The investigation sequence and review checklist are suggested operating practices. The government sources cited below illustrate reconciliation controls; their jurisdiction-specific deadlines are not requirements for every business.

1. Establish exactly what you are reconciling

Save the period-end bank statement and the general ledger cash activity used for the reconciliation. Record the entity, account, currency, period, and export time. If the ledger changes during review, regenerate the reconciliation or explain the movement from the saved balance to the final balance.

Before searching individual transactions, check that the opening balance agrees to the prior approved reconciliation and that the closing ledger balance agrees to the trial balance. A wrong account, incomplete export, or mismatched date range can produce hours of unnecessary matching.

• Use the statement closing balance rather than today's online available balance.
• Bring forward the prior outstanding-item list, including original dates and references.
• Check that bank-feed imports and manually entered transactions have not both recorded the same activity.

2. Build both sides of the reconciliation

Assume the October 31 bank statement shows $48,250 and the cash ledger shows $49,180. The initial $930 difference is not an entry to post. Investigation identifies a $3,600 deposit recorded in October that the bank credited on November 2, and $2,450 of issued checks not yet cleared at October 31. The statement also contains a $95 service fee and $15 interest credit missing from the ledger. Finally, a supplier payment of $1,270 was entered in the ledger as $1,720.

The bank-side timing adjustments and book-side corrections lead to the same $49,400 balance. All figures are illustrative and use one currency; no tax component is assumed.

Do not post the $3,600 deposit or $2,450 checks a second time. In this example they are already correctly recorded in the ledger; they explain timing on the bank side.

3. Post only supported book corrections

For the example, the fee entry is debit bank charges expense $95 and credit cash $95. The interest entry is debit cash $15 and credit interest income $15. Review the underlying statement and confirm neither item has already been posted elsewhere before recording them.

The supplier-payment correction depends on the original entry. Assume the erroneous posting was debit accounts payable $1,720 and credit cash $1,720, although the approved payment and invoice were $1,270. Correct the $450 excess with debit cash $450 and credit accounts payable $450. Use the accounting system's correction workflow so the supplier subledger and control account stay aligned; a direct control-account journal may leave them inconsistent.

Attach the approved payment, bank transaction, original posting reference, and correction reference. Then rerun the cash ledger and verify $49,400. If the original posting hit an expense account instead of accounts payable, investigate that posting rather than copying this correction mechanically.

4. Investigate the items that still do not match

Work from a list of unmatched items rather than repeatedly scanning the entire statement. Match reference, amount, counterparty, and date together. Equal amounts alone do not establish that two transactions are the same payment.

Utah's State Auditor emphasizes investigating old outstanding items and reviewing unresolved transactions even after bank activity has been matched.[1] New York's guidance similarly calls for investigating deposits absent from the statement and checking subsequent posting.[2] Use subsequent clearing as evidence of timing, while retaining the transaction's actual period-end status.

5. Keep an exception log that survives the next close

Copy the following fields into your reconciliation workbook. Preserve the original transaction date so aging remains meaningful. Choose escalation dates based on the expected settlement process and risk; a universal 30-day rule is unsuitable for every type of transaction.

For an old check, establish whether the payment remains owed before cancelling or reversing anything. Stale-check and unclaimed-property treatment can depend on jurisdiction and circumstances. Assign the accounting or legal follow-up explicitly instead of writing off a liability solely because the check is old.

6. Give the reviewer a decision-ready package

The preparer's explanation should let the reviewer reproduce the conclusion without an oral walkthrough. Keep the reconciliation, source balances, outstanding-item detail, correction support, and final ledger together. A sign-off should identify the version reviewed, not merely confirm that a file exists.

If an unexplained difference remains, record it openly with its owner and escalation. The controller should assess the effect on reporting under the organization's policies and applicable framework. Do not relabel an unexplained difference as a timing item or create an unsupported balancing entry.

• Confirm the statement and ledger cover the same account, currency, and cutoff.
• Recalculate both adjusted balances and tie the final cash balance to the trial balance.
• Inspect support for material or unusual reconciling items, including their subsequent clearing where available.
• Check that proposed corrections were approved and posted, and that relevant subledgers agree.
• Compare outstanding items with last month; investigate repeated items and changed dates.
• Document unresolved issues and the reporting decision rather than signing off an unsupported conclusion.
• Record preparer and reviewer names, dates, and the final version reviewed.

• Fit reconciliation work into your month-end close checklist
• Organize preparation and review handoffs

Sources and scope

Published November 5, 2026 by Ledgerly Close. Sources checked November 5, 2026. Examples and the exception-log design are original illustrative teaching material. The sources below concern US government entities; this article does not extend their legal requirements or deadlines to private businesses or Canadian entities.

• [1] Utah Office of the State Auditor: Bank Reconciliation
• [2] New York State Comptroller: Bank Account Reporting and Reconciliations