Bank Statement Reconciliation Guide

Apply the same closing date to both records

Set both sides to the statement's closing date. Activity beyond that cutoff belongs in a later reconciliation, even when online banking already displays it.

Pair incoming and outgoing entries using supporting context

Dates alone are insufficient for matching; compare figures and identifying details. Weekends, settlement delays, and deposit batches commonly move posting dates.

Record unresolved timing items in a separate schedule

Checks that have not cleared and deposits still in transit belong on the reconciliation, not in altered statement data.

Reconciliation exception log

Keep a separate exception row open for each difference until evidence shows clearance or correction.

Identity

Link the relevant statement row and ledger entry with the date, amount, and matching reference.

Difference type

Classify the issue as timing, fee, interest, return, duplicate, omission, incorrect value, or unresolved.

Required action

Assign responsibility for obtaining support, recording an adjustment, or contacting the bank.

Closure evidence

Cite the later statement, receipt, correction posting, or institutional response that closes the exception.

Enter adjustments only after confirming them from evidence

Books may need updates for statement fees, interest, returned items, or direct debits not previously entered. Cite the statement and keep its reference with the adjustment.

Keep a reconciliation schedule

The reconciliation schedule should expose book and bank balances, deposits and payments still outstanding, items found in only one record, errors, and the adjusted totals. For each difference, record its date, value, explanation, evidence reference, and expected clearing period.

Move open timing differences into the next period and confirm their eventual clearance. Once an item ages, investigate whether it is a stale check, failed deposit, duplicate record, or incorrect book entry rather than assuming normal timing.

Age exceptions from their original date rather than the latest review. A multi-period outstanding payment may be stale, cancelled, misposted, or cleared elsewhere. Preserve original value, payee, reference, expected clearance, owner, last action, and next deadline, then record eventual clearance, reissue, book reversal, or approved open status.

Age timing items across periods. A deposit in transit from the final day of the month may be ordinary when it clears on the next business day. The same item remaining open several statements later needs a different status and investigation. Keep the original date, expected clearing window, most recent evidence, owner, and next action. This prevents old items from being copied forward as routine differences and makes the reconciliation useful for detecting stale checks, failed deposits, duplicated entries, or activity posted to another account.

Let control totals identify which record needs attention

When the statement proves its own movement but disagrees with the books, review ledger entries and cutoff treatment. When extracted rows fail to reach the printed closing balance, correct the extraction before any ledger comparison.

For row-level matching in a spreadsheet or ledger, export a reviewable bank statement CSV and retain the original descriptions.

If the closing difference remains after matching rows, follow the bank statement balance mismatch checklist before creating an adjustment.

Sources for this decision

External-rule controls rely on these references. Keep the evidence that supports each resolved exception.

IRS Publication 583, Starting a Business and Keeping Records