Start with three separate records
A printing worksheet says what you intended to prepare. A cheque register records the physical instrument and its status. The bank statement shows entries posted to the account. None of these records should be assumed to contain all the information in the others.
Choose a statement cut-off date and preserve a copy of the register used for that review. Keep the bank label, instrument reference, payee, issue date, amount, status and any replacement reference available to the reviewer.
Match more than the cheque number
- Find the statement entry using the cheque or transaction reference.
- Compare the amount and account with the issued record.
- Investigate a reference that is missing, duplicated or associated with a different amount.
- Mark an item cleared only after matching the statement evidence.
- Keep unmatched issues on an outstanding list with an owner and a next action.
If the statement does not show a usable instrument reference, use the bank’s transaction detail or ask for clarification. A coincidentally identical amount is not sufficient evidence of a match.
A worked balance example
The following figures are fictional. They illustrate the review, not a real bank account.
| Item at the review date | Amount |
|---|---|
| Cash-book balance before review | ₹80,000 |
| Bank-statement balance | ₹99,500 |
| Two issued cheques not yet presented | ₹12,000 + ₹8,000 = ₹20,000 |
| Bank charge on statement, not yet recorded in cash book | ₹500 |
For this example, subtract the outstanding issues from the bank balance: ₹99,500 − ₹20,000 = ₹79,500. Record the reviewed bank charge in the books: ₹80,000 − ₹500 = ₹79,500. The two adjusted balances now agree. The actual accounting entries should follow your accountant’s method and supporting documents.
Give exceptions their own status
| Exception | What to investigate |
|---|---|
| Outstanding issue | Confirm delivery, intended presentation date and whether a replacement was requested. |
| Returned cheque | Keep the return reason and bank correspondence. Do not relabel it cleared or delete its history. |
| Lost or replaced cheque | Link the original and replacement references, and retain the bank’s action or acknowledgement. |
| Cancelled leaf appears on statement | Escalate promptly; compare the physical record, authority and bank details. |
| Amount differs | Trace the approved payment, printed record and actual debit before adjusting the books. |
Close a review without hiding unresolved items
Save the reconciled statement period, the explanation of differences, the reviewed charge entries and the outstanding list. Record who prepared and reviewed the reconciliation. An unresolved item should move to the next review with a clear history, rather than disappear because a new spreadsheet was started.
The register template guide explains a downloadable blank structure. Keep that register separate from the three-column printing upload.
Mathematical Foundation of Bank Reconciliation Statements (BRS)
A Bank Reconciliation Statement reconciles the mathematical variance between the cash book balance maintained by an organization and the bank passbook statement balance issued by the bank. Timing differences in cheque clearing represent the single largest cause of balance discrepancies:
| Transaction Scenario | Cash Book Impact | Bank Passbook Impact | BRS Adjustment Direction |
|---|---|---|---|
| Cheques Issued but Not Yet Presented | Already debited (reduced balance) | Not yet debited (higher balance) | Add back to Cash Book Balance |
| Cheques Deposited but Not Yet Cleared | Already credited (higher balance) | Not yet credited (lower balance) | Deduct from Cash Book Balance |
| Direct Bank Debit (Charges, Interest, NACH) | Unrecorded until statement review | Already deducted by bank | Deduct from Cash Book Balance |
| Direct Customer Deposits (RTGS / NEFT) | Unrecorded until statement review | Already credited by bank | Add to Cash Book Balance |
Worked Example: Monthly Corporate BRS Schedule
Consider an enterprise accounting desk closing accounts at month-end:
- Balance as per Cash Book (Bank Column): ₹12,50,000
- Add: Cheques issued to suppliers but unpresented:
- Cheque #401021 (Steel Supplier): ₹2,10,000
- Cheque #401022 (Logistics Freight): ₹85,000
- Less: Cheques received and banked but uncredited:
- Cheque #112004 (Customer Receivable): -₹1,40,000
- Reconciled Balance as per Bank Statement: ₹14,05,000 (Matches bank statement passbook exactly).