How to Reconcile Bank Statement?

Bank reconciliation means proving that the book balance agrees with the bank statement after supported timing items and book adjustments. It is a core completeness control because it can reveal missing, duplicate, incorrect, or unauthorized transactions.

Categorising transactions tells you where money went. Reconciling tells you whether you have all of it.

What it actually proves

Your book balance and your bank balance should agree once you account for legitimate timing differences. Where they do not, something is missing, duplicated, or wrong, and the reconciliation is what surfaces it.

A business that categorizes transactions without reconciling lacks an independent proof that the recorded cash activity and statement are complete and connected.

The process

• Start with the closing balance on the bank statement for the period
• Match every transaction in your books to a transaction on the statement
• Add back deposits recorded in your books that have not yet cleared the bank
• Deduct payments recorded in your books that have not yet cleared
• Compare the adjusted figure to your book balance
• Investigate any difference until it is zero

Accounting software may suggest matches from a bank feed, but the preparer still must use the complete statement, verify opening and ending balances, review unmatched items, and preserve the final reconciliation.

Legitimate timing differences

• Payments issued and not yet presented
• Deposits made and not yet credited
• Card transactions authorized but not settled

These can explain a difference when supported and should be monitored until they clear. Other items require investigation.

Why it will not clear

Transactions on the statement not in your books

Examples include bank fees, interest, automatic payments, unrecorded direct debits, and returned items. Verify the source and approved accounting treatment before posting.

Transactions in your books not on the statement

Duplicated entries, a payment recorded twice, or an amount entered incorrectly. Also transactions recorded against the wrong bank account.

Amount differences

Transpositions are the classic. If the difference is divisible by nine, suspect two digits swapped. A difference equal to twice a transaction usually means the sign is wrong.

The opening balance is wrong

If the prior period remains approved and unchanged, begin with activity after that cutoff. If the account has no reliable reconciliation history, establish and support the opening position before moving forward.

Do not force it

Posting an unexplained adjustment solely to make the reconciliation clear defeats the control. Identify the underlying transaction, obtain approval, and retain support for any correcting entry.

How often

Set a cadence based on transaction volume, fraud risk, reporting deadlines, cash sensitivity, and available controls. Complete a formal reconciliation for each reporting period and use more frequent monitoring when risk warrants it.

Reconcile everything, not just the bank

Credit cards, loans, and merchant accounts also need reconciliation to external records. For loans, compare ending principal, payments, interest, fees, draws, and other changes with the lender statement.

Gather a complete evidence set

Use the full bank statement for the exact period, the general-ledger cash detail, the prior completed reconciliation, deposit records, payment records, and support for transfers, fees, interest, returned items, and other adjustments. Confirm the statement account number and closing date.

Verify that the current opening statement balance follows the prior closing statement and that the book opening balance follows the prior approved reconciliation. If either continuity check fails, resolve the earlier issue before treating the current period as complete.

Separate bank and book adjustments

Bank-side timing items are transactions already recorded in the books but not yet reflected by the bank, such as supported outstanding payments or deposits in transit. Book-side adjustments are statement items not yet recorded correctly in the ledger, such as fees, interest, returned deposits, or entry errors.

Do not place a book error on the bank side to avoid correcting the ledger. Post an approved entry with evidence, then refresh the reconciliation. Each reconciling item should exist on only one side.

Use the reconciliation equation

One common presentation starts with statement ending balance, adds deposits in transit, subtracts outstanding payments, and adjusts for any verified bank errors to reach adjusted bank balance. The book balance is then adjusted for valid bank-originated items and book errors. Adjusted bank and adjusted books should agree.

The exact screen layout may differ by software, but the proof is the same. Preserve both the statement balance and book balance, not just a zero difference displayed by the application.

Illustrative worked example

As an illustrative example, suppose the statement ends at $25,000. A supported $2,000 deposit is in transit and a supported $1,500 payment remains outstanding, producing adjusted bank cash of $25,500. If the ledger also reaches $25,500 after recording a bank fee already shown on the statement, the reconciliation explains the difference.

The figures are not a benchmark. The value is the traceable bridge from two original balances to one supported adjusted balance.

Investigate unmatched items

Search by exact amount and date, then by combined amounts, net settlements, transposed digits, duplicate entries, signs, wrong bank accounts, and cutoff. Compare merchant deposits with settlement reports rather than expecting gross sales to match net cash.

Do not assume a difference divisible by nine proves a transposition or that twice an amount proves a sign error. Those are search clues only. Resolve the actual transaction and keep its evidence.

Review old outstanding items

An outstanding payment may be valid, void, duplicated, lost, stale, or recorded against the wrong account. A deposit in transit may be timing, a processor hold, a missing deposit, or a posting error. Investigate items that remain open beyond their expected clearing pattern.

Do not delete or redate an old item solely to clear the reconciliation. Follow the organization’s policy and applicable banking, unclaimed-property, legal, and accounting requirements.

Treat bank feeds as input, not proof

A feed can accelerate entry and matching, but it does not replace the independently issued statement or the general ledger. Feeds can begin late, duplicate activity, group settlements, omit check images, or be disconnected.

Restrict who can create rules, merge payees, exclude transactions, or change opening balances. Review automated postings and keep the reconciliation report after the period is closed.

Add preparation and review controls

Record preparer, reviewer, date, statement period, book balance, adjusted bank balance, difference, open items, entries posted, and follow-up owners. A reviewer should inspect old items, unusual payees, manual payments, transfers, bank-detail changes, large or unusual adjustments, and activity around period end.

Where staffing permits, separate payment initiation, approval, release, recording, and reconciliation. Where it does not, use independent review with direct bank evidence and transaction-level detail.

Completion checklist

• Complete statement and prior reconciliation are retained
• Opening balances roll forward correctly
• Every statement transaction is matched or explained
• Book adjustments are posted with evidence
• Timing items are supported and dated
• Adjusted bank equals adjusted books
• Old items have owners and actions
• Preparer and reviewer sign-off is retained

Retain the close package

Keep the complete statement, ledger detail, reconciliation report, outstanding-item list, posted entries, supporting schedules, preparer and reviewer evidence, and follow-up log. Protect the approved period from unauthorized changes and rerun the reconciliation if a later entry affects it.

Document any reopened period, the reason, approval, changed transaction, and effect on previously issued reports. This preserves a reproducible cash balance instead of a screen that merely showed zero once.