Cash Book & Bank Reconciliation: Records, Errors & Reconciliation

What is a Cash Book?

A cash book is a subsidiary book that records all cash transactions (receipts and payments) of a business in a chronological order. It is part of the double-entry system and helps track cash inflows and outflows efficiently.

Types of Cash Books

classDiagram
    class CashBook {
        +Single-column
        +Double-column
        +Petty cash book
    }
    Single-column --> "Records only cash transactions"
    Double-column --> "Records cash + bank transactions"
    PettyCash --> "Records small cash expenses"

Single-Column Cash Book

• Records only cash transactions (no bank entries).
• Format:

  Date | Particulars | L.F. | Amount (NPR)
  ---- | ----------- | ---- | -------------
  

Double-Column Cash Book

• Records both cash and bank transactions (cash receipts/payments + bank deposits/withdrawals).
• Format:

  Date | Particulars | L.F. | Cash (Dr/Cr) | Bank (Dr/Cr)
  ---- | ----------- | ---- | ------------- | -------------
  

Petty Cash Book

• Used for small cash expenses (e.g., stationery, minor repairs).
• Operates on the imprest system (fixed float amount).
• Example:

  Date | Particulars | Voucher No. | Amount (NPR)
  ---- | ----------- | ----------- | -------------
  

In the Real World

1. eSewa (Nepal) – Uses a double-column cash book to track mobile payments and bank transfers for utility bills, ensuring accurate reconciliation between user transactions and bank records.
2. Khalti (Nepal) – Maintains a petty cash book for small merchant transactions (e.g., change given to customers) to prevent discrepancies in daily cash handling.
3. Hotel Everest (Kathmandu) – Uses a double-column cash book to record both cash receipts from guests and bank deposits, ensuring transparency in financial reporting.

Bank Reconciliation Statement (BRS)

A Bank Reconciliation Statement is prepared to identify differences between:

• Hotel’s cash book records (what the business thinks is in the bank).
• Bank statement (what the bank actually records).

Why is BRS Needed?

• Errors (e.g., unrecorded cheques, bank charges).
• Timing differences (e.g., cheques in transit, uncleared deposits).
• Fraud detection (unauthorized transactions).

Steps to Prepare BRS

1. Start with the bank balance (as per the bank statement).
2. Add items not yet recorded in the cash book (e.g., interest credited by the bank).
3. Subtract items recorded in the cash book but not yet cleared by the bank (e.g., outstanding cheques).
4. Adjust for errors (e.g., bank charges not yet recorded).

Worked Example: Hotel Himalaya (Kathmandu)

Given:

• Cash Book Balance (31 Dec 2023): NPR 500,000
• Bank Statement Balance (31 Dec 2023): NPR 480,000
• Discrepancies:
  • Unrecorded bank interest: NPR 5,000
  • Uncleared cheque issued to supplier: NPR 15,000
  • Direct deposit from a guest (not recorded in cash book): NPR 20,000
  • Bank charges (not recorded): NPR 2,000

Solution:

flowchart TD
    A["Bank Statement Balance: 480,000"] --> B["+ Unrecorded Interest: 5,000"]
    B --> C["+ Direct Deposit: 20,000"]
    C --> D["- Bank Charges: 2,000"]
    D --> E["- Uncleared Cheque: 15,000"]
    E --> F["Adjusted Balance: 500,000"]

Bank Reconciliation Statement (BRS) for Hotel Himalaya

Conclusion: The adjusted balance matches the cash book balance, confirming accuracy.

Common Errors & Adjustments

Exam Tip

• Always start with the bank statement balance (not cash book).
• Use a table format for BRS (as shown above).
• Common exam questions:
  • Prepare a BRS from given discrepancies.
  • Identify errors in a cash book.
  • Explain why a BRS is necessary.
• Key formula:

  Adjusted Bank Balance = Bank Statement Balance ± Unrecorded Items ± Errors
  

Comparison: Cash Book vs. Bank Statement

Final Checklist for BRS

1. Verify all transactions in the cash book.
2. Check for uncleared cheques (issued but not yet presented).
3. Confirm deposits in transit (recorded in cash book but not yet in bank statement).
4. Adjust for bank errors (e.g., incorrect debits/credits).
5. Ensure final balance matches the adjusted cash book balance.