CORAA

Bank Reconciliation Statement Format — BRS Template (Word)

A month-end BRS walking the balance per books to the balance per bank — with stale-cheque ageing, unmatched-entry ageing, a multi-account summary sheet, and a note on what the statutory auditor will test.

Free · CORAA original — SA-aligned
Updated 29 Jul 2026
Type
Month-end reconciliation working paper
Walk
Balance per books → balance per bank
Stale cheques
>3 months from cheque date (RBI, since 1 Apr 2012)
Audit linkage
SA 505 direct bank confirmations, year-end cut-off
Share this template
Engagement details
The client and period this document is for.
What’s inside

An excerpt from the template.

Bank Reconciliation Statement

Entity: ___ | Financial Year: ___ | Bank: ___ | Account no.: ___ | For the month of: ___

1. Reconciliation — Balance per Books to Balance per Bank

Working note: items that are genuine timing differences (cheques not presented, deposits in transit) reconcile without an entry; everything the bank has done that the books have not recorded (charges, interest, direct credits and debits) needs a journal entry in the books this month — the BRS is not a substitute for passing those entries.

↑ Excerpt only — the full template is what you download as Word
About this template

What you’re downloading, and when to use it.

This template follows the format published by the Institute of Chartered Accountants of India (ICAI) in the AASB Audit Working Paper Templates (June 2023), the authoritative reference for Indian statutory-audit documentation. Fill in your firm’s letterhead and the engagement details on the form above, click Download Word file, and you’ll get a fully formatted .docx ready to use.

Everything is generated in your browser and on a stateless API endpoint — no account, nothing stored on our servers. We’ll ask for a work email once before your first download so we can send you the file and the occasional relevant update; after that, downloads on this device are instant. Edit freely in Word, Google Docs or Pages before sending to your client.

Common questions

FAQs.

How is a bank reconciliation statement prepared?
Start from the balance per the books (the bank ledger), then adjust for every item one side has recorded and the other has not: add cheques issued but not yet presented, deduct deposits not yet credited by the bank, and adjust for bank charges, interest, and direct credits or debits the books have not yet recorded. The result should equal the balance per the bank statement. Timing differences reconcile without an entry; everything the bank has done that the books have not recorded needs a journal entry in the books that month.
When does a cheque become stale and how is it treated?
A cheque is valid for presentation for 3 months from its date — RBI reduced the validity period from 6 months to 3 months with effect from 1 April 2012, and the same applies to demand drafts, pay orders and banker's cheques. Once stale, the bank will not honour it, so it should come off the reconciliation: reverse the payment entry and write the amount back to the payee's liability account (the underlying debt is not extinguished), then reissue the cheque or settle by transfer.
What do statutory auditors check in bank reconciliations?
Three things principally. First, direct confirmations: under SA 505 the auditor obtains bank balance confirmations directly from the bank — covering balances, borrowings, deposits, guarantees and charges — and the year-end BRS must reconcile the books to that confirmed balance. Second, cut-off: year-end deposits in transit and unpresented cheques are traced into the first statement of the new year to test that they were genuine year-end items. Third, quality of the reconciliation itself: stale cheques written back, long-outstanding items investigated, and a BRS existing for every account including dormant ones.
What if an entry stays unreconciled for months?
Then it is no longer a reconciling item — it is an unexplained difference. Genuine timing differences clear within days or weeks; an entry aging past 3 months points to an unrecorded liability, a posting error, or in the worst case concealment such as teeming and lading. Trace it to source documents, resolve it in the books or with the bank, and document the resolution. The ageing table in this format exists precisely so these items surface every month instead of accumulating quietly.
Related templates

You might also need.

Ledger Scrutiny Checklist — Per-Ledger Working Paper Format
Free ledger scrutiny checklist and working paper format — opening tie-out, misposting and balance-direction ch
Stock Audit Report Template — Bank Lender Engagement
Free stock audit report template for CAs engaged by lender banks. Physical verification, aging, DP computation
Fixed Asset Register Format — Companies Act & Income-tax
Free fixed asset register format for Indian companies — dual depreciation per Companies Act Schedule II and In