Skip to guide
Practical guide

Build a cheque register that keeps the history

A blank CSV template, suggested status values and a worked example of recording a replacement.

Maintained by Ajay Kumar Maurya · Updated 11 October 2026

Download the blank structure

Download blank register CSVOpen or import it in your spreadsheet application. Set instrument references to text so leading zeros remain intact. The template is a record-keeping aid; it contains no private account details or customer payments.

This register is separate from the tool’s three-column printing worksheet. Do not upload the full register into the cheque workspace.

What each field records

ColumnSuggested use
Bank labelAn internal nickname, such as Office current account; avoid putting unnecessary full account details in a widely shared sheet.
Cheque referenceStore as text and preserve every character shown on the instrument.
Issue date / Date on chequeSeparate handover from the date written on the leaf.
Payee / AmountCopy from the final approved instruction.
StatusPrepared, issued, cleared, returned, cancelled, lost or replaced, as appropriate.
Cleared date / Bank referenceLink the statement evidence after reconciliation.
Related cheque referenceConnect an original and a replacement.
NotesApproval reference, exception reason or next action; do not store credentials.

Record a replacement without deleting the original

In a fictional example, reference DEMO-001 for ₹24,500 is reported lost. Its entry remains, with the date reported and the bank’s action reference. If a replacement DEMO-002 is approved, its row points back to DEMO-001. The old row is not erased or silently changed to the new reference.

Use a status and review note that reflect what has actually happened. A requested stop instruction and a bank-confirmed action are different stages.

Add simple review controls

Do not let a spreadsheet status overstate the evidence

Mark a payment cleared only when the bank evidence matches. Marking an item cancelled in the sheet does not cancel it at the bank. A blank row, zero amount or deleted record is not an adequate history for a spoiled or replaced leaf.

For the matching process, use the worked reconciliation example. For future-dated items, read the post-dated cheque guide.

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.

Internal Audit Controls for Corporate Cheque Registers

A properly structured Cheque Register is the primary financial ledger connecting operational accounting vouchers with official bank passbooks. External statutory auditors routinely inspect the Cheque Register to verify transaction authorization, cutoff dates, and post-balance-sheet presentations. Incorporating robust tracking columns ensures complete transparency:

Essential Register Field Accounting Function Audit Importance
Voucher Reference Number Links payment to underlying journal voucher Ensures 3-way matching with vendor invoice and PO
Cheque Leaf Serial Number Tracks physical leaf usage sequentially Identifies skipped or missing leaves during internal audits
Date of Issue vs Cheque Date Differentiates physical release date from maturity date Crucial for managing post-dated cheques and interest accruals
Beneficiary Legal Title Exact name written on payee line Prevents disbursement to unauthorized third parties or shell entities
Positive Pay Confirmation ID Bank PPS acknowledgment tracking number Proves compliance with mandatory clearing protocols for high-value payments
Bank Clearance Date Date debit appears on bank statement Forms the direct basis for monthly Bank Reconciliation Statements (BRS)

Defacing & Accounting for Spoiled or Cancelled Leaves

When a cheque leaf is damaged by printer jams or clerical errors, never discard the physical paper. Cut the signature corner completely off, deface the face of the leaf with a permanent red ink 'CANCELLED' stamp, and staple the spoiled leaf directly back onto the counterfoil inside the original cheque book. Enter the serial number into the register with status 'CANCELLED - PRINTER ALIGNMENT', accompanied by the finance manager's initials.