Bank Reconciliation Statement: Format, Steps and Example

Bank reconciliation is the controlled comparison of an organisation's cash-book or ledger records with the bank statement for the same account and period. The purpose is to identify, explain, and resolve differences through evidence and authorised procedures. It is one form of reconciliation; securities, payments, and trade teams use related ideas with different records.

Bank reconciliation process

1. Confirm the bank account, statement period, currency, opening balance, and ledger cut-off.
2. Compare deposits, withdrawals, transfers, fees, interest, and other entries using references and dates.
3. Separate timing differences from missing, duplicate, incorrect, or unauthorised records.
4. Trace unmatched items to source documents, payment confirmations, journals, or the bank statement.
5. Prepare the reconciliation with clear explanations, ageing, owner, and supporting evidence.
6. Post or escalate only through the organisation's approved accounting and control process.
7. Review the closing position and confirm that unresolved items are followed up in the next cycle.

Common differences

• Deposits recorded in the cash book but credited by the bank later.
• Payments issued by the organisation but not yet presented or cleared.
• Bank charges, interest, or direct debits not yet recorded in the ledger.
• Errors in amount, account, date, reference, or duplicate entry.
• Transfers recorded on one side before the other account or statement updates.

Fictional example

A cash book shows a customer receipt of INR 20,000 on 31 March, but the bank statement shows it on 1 April. The analyst checks the payment reference and cut-off, records the item as a supported timing difference, and confirms that it clears in April. If the statement also shows a bank fee absent from the ledger, that is investigated and posted only with the required approval.

Read the broader reconciliation in finance guide

Learn the accounting cycle and debit-credit basics

Check the trial balance format before reconciling ledger cash

Explore reconciliation analyst careers

Controls and quality checks

A good reconciliation has a defined owner, frequency, preparer and reviewer where required, clear source records, documented explanations, ageing, escalation, and evidence of review. Equal totals do not by themselves prove that the correct account, date, amount, or supporting document was used.

Explore finance operations training topics

Read ICAI study material for bank-reconciliation learning

A practical bank reconciliation format

A useful reconciliation schedule makes the comparison reproducible. Record the account, period, currency, source files, opening balance, closing balance, control total, prepared date, reviewer, and status. For each difference, capture the reference, date, amount, description, classification, evidence checked, owner, expected resolution date, and closure note. The format should help a reviewer understand the conclusion without relying on the preparer's memory.

Common differences and the appropriate next question

• Timing difference: when should the item appear in the other record, and does the next period clear it?
• Bank fee or interest: is there statement evidence and an authorised posting process?
• Missing transaction: which source or interface should have delivered the record?
• Duplicate: which identifier, amount, and status show that one record is repeated?
• Amount or date variance: which approved source is authoritative for the field?
• Unidentified item: what evidence and escalation are required before any correction?

Worked bank reconciliation example with statement and cash-book balances

Worked example (all figures are fictional): at the same cut-off, the cash book is INR 47,300 and the bank statement is INR 48,950. The cash book includes a customer deposit of INR 6,500 that the bank has not yet credited and an issued payment of INR 8,000 that has not yet cleared. The statement shows a bank fee of INR 200 and interest credit of INR 350 that are not yet in the cash book.

Reconcile the statement side

• Bank statement closing balance: INR 48,950.
• Add the deposit in transit recorded in the cash book but not yet credited by the bank: INR 6,500.
• Subtract the issued payment not yet presented to the bank: INR 8,000.
• Adjusted bank balance: INR 48,950 + INR 6,500 - INR 8,000 = INR 47,450.

Update the cash-book side through the approved process

• Cash-book closing balance: INR 47,300.
• Record the statement-supported bank fee when authorised: subtract INR 200.
• Record the statement-supported interest credit when authorised: add INR 350.
• Adjusted cash-book balance: INR 47,300 - INR 200 + INR 350 = INR 47,450.

The adjusted balances agree at INR 47,450. The deposit and uncleared payment remain timing items to follow up; the fee and interest are book-side entries that need the entity's normal evidence, posting, and review controls. If a reference, cut-off, amount, or status cannot be verified, leave the item open, document what is known, and route it to the authorised owner instead of forcing the totals to agree.

Blank bank reconciliation worksheet

Use the blank CSV worksheet to record both closing balances, each signed adjustment, evidence, owner, next check and final difference. Start with fictional figures for practice. Recalculate both adjusted balances and leave unsupported differences open for review.

Preview the blank bank reconciliation worksheet (CSV)

What to include in the reconciliation note

• Account and statement period, the cash-book cut-off, source versions, currency, and opening and closing balances.
• Each difference, its amount, explanation, source evidence, owner, ageing, and expected next check.
• Which items are timing differences and which require an authorised accounting entry or escalation.
• The adjusted-balance calculation and reviewer or approval evidence required by the organisation.

Reconciliation control checklist

1. Use the correct account, period, currency, and source version.
2. Confirm the opening balance and explain movement to the closing balance.
3. Separate expected timing items from unexplained exceptions.
4. Assign ownership and ageing to every open item.
5. Retain evidence and approvals for any authorised adjustment.
6. Review the final schedule and confirm the next-period treatment.

How to review a completed reconciliation

A reviewer can test whether the schedule is complete, whether the control total is supported, whether every open item has an owner and ageing, and whether the conclusion follows from the evidence. They can also check that adjustments are authorised, that timing items are expected to clear, and that the next-period or next-run treatment is documented. This review mindset helps a learner understand why a reconciliation is a control rather than only a spreadsheet exercise.

Questions for an operations interview

• What records would you compare for a bank reconciliation?
• How would you distinguish a timing difference from a missing entry?
• What would you include in an escalation note?
• When would you ask for approval before posting or correcting?
• How would you verify that the break is actually closed?