Skip to guide
Practical guide

Reconcile your cheque register with the bank statement

Use instrument references, amounts and status changes to explain the difference between issued and cleared payments.

Maintained by Ajay Kumar Maurya · Updated 11 October 2026

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

  1. Find the statement entry using the cheque or transaction reference.
  2. Compare the amount and account with the issued record.
  3. Investigate a reference that is missing, duplicated or associated with a different amount.
  4. Mark an item cleared only after matching the statement evidence.
  5. 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 dateAmount
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

ExceptionWhat to investigate
Outstanding issueConfirm delivery, intended presentation date and whether a replacement was requested.
Returned chequeKeep the return reason and bank correspondence. Do not relabel it cleared or delete its history.
Lost or replaced chequeLink the original and replacement references, and retain the bank’s action or acknowledgement.
Cancelled leaf appears on statementEscalate promptly; compare the physical record, authority and bank details.
Amount differsTrace 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.

Scope: The office procedures on this page are suggestions for review and record keeping. Confirm account-specific instructions with your bank. The Positive Pay and CTS guide links to RBI material. For a payment dispute, obtain advice appropriate to the facts.

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: