Bank Reconciliation & Cash Management: Statements, Errors & Controls

Core Concepts

1. Definitions & Purpose

classDiagram
    class BankStatement {
        +Issued by bank monthly
        +Shows transactions from bank's perspective
        +Includes deposits, withdrawals, fees, interest
    }
    class CashBook {
        +Maintained by business
        +Records cash receipts/payments
        +May miss bank-side entries
    }
    class BankReconciliation {
        +Process to match both records
        +Identifies errors/omissions
        +Ensures accuracy of cash balance
    }
    BankStatement --> BankReconciliation : "Input 1"
    CashBook --> BankReconciliation : "Input 2"

Why reconcile?

• Discrepancies arise due to:
  • Timing differences (e.g., cheques not yet cleared).
  • Errors in recording (e.g., transposed figures).
  • Bank charges/interest not yet entered in cash book.
  • Outstanding cheques or deposits in transit.

Key Terms:

2. How Bank Reconciliation Works

Step-by-Step Process

1. Start with the bank statement balance (as per bank’s records).
2. Add items in the cash book but not in the bank statement:
   • Deposits in transit.
   • Interest earned (if not yet credited).
3. Subtract items in the bank statement but not in the cash book:
   • Outstanding cheques.
   • Bank charges/NSF cheques.
4. Adjust for errors (e.g., incorrect entries in either book).
5. Verify the adjusted balance matches the cash book balance.

Visual Trace Example: Assume Kathmandu Retail Shop has:

• Cash book balance (31 Ashwin 2081): Rs 38,000
• Bank statement balance: Rs 42,000
• Discrepancies found:
  • Deposits in transit: Rs 5,000
  • Outstanding cheques: Rs 3,000
  • Bank charges (unrecorded): Rs 2,000

flowchart TD
    A["Bank Statement Balance: Rs 42,000"] --> B{"Adjustments?"}
    B -->|"Yes"| C["Add: Deposits in Transit (+5,000)"]
    C --> D["Subtract: Outstanding Cheques (-3,000)"]
    D --> E["Subtract: Bank Charges (-2,000)"]
    E --> F["Adjusted Balance: Rs 42,000 - 3,000 - 2,000 + 5,000 = Rs 42,000"]
    F --> G{"Cash Book Balance: Rs 38,000"}
    G -->|"Mismatch?"| H["Error in Cash Book: Rs 4,000 unrecorded"]
    H --> I["Reconciled: Both now match Rs 42,000"]

Correction Entry (if cash book is wrong):

Dr. Bank Charges A/c       Rs 2,000
Dr. Outstanding Cheques A/c Rs 3,000
    To Cash Book Overstatement A/c Rs 5,000

(Note: The Rs 5,000 deposit in transit is not journalized; it’s just an adjustment to reconcile.)

3. Common Reconciliation Items

Table: Reconciliation Items & Journal Entries

4. Cash Management Techniques

Petty Cash System

Purpose: Handle small, frequent cash expenses (e.g., stationery, transport). Process:

1. Imprest System: Fixed float (e.g., Rs 10,000) is given to the petty cashier.
2. Vouchers: All expenses are supported by receipts/vouchers.
3. Replenishment: When the float is low (e.g., Rs 2,000 left), the petty cashier submits vouchers for reimbursement.

Example:

• Imprest amount: Rs 10,000
• Expenses paid:
  • Stationery: Rs 1,500
  • Transport: Rs 2,000
  • Miscellaneous: Rs 500
• Remaining cash: Rs 6,000
• Replenishment entry:

  Dr. Stationery A/c       Rs 1,500
  Dr. Transport A/c        Rs 2,000
  Dr. Miscellaneous A/c    Rs 500
      To Petty Cash A/c     Rs 4,000
  Dr. Petty Cash A/c        Rs 4,000
      To Bank A/c           Rs 4,000
  

Internal Controls for Cash

5. Real-World Applications

In the Real World

1. eSewa & Khalti (Digital Payments)

   • Idea Used: Bank Reconciliation for Digital Wallets
   • How? When you transfer Rs 5,000 from your bank to eSewa, the bank deducts it immediately, but eSewa credits your wallet only after clearing. The discrepancy is reconciled when the transaction appears in your bank statement.

2. Daraz (E-Commerce Orders)

   • Idea Used: Outstanding Cheques & Deposits in Transit
   • How? When a customer pays via bank transfer for an order, Daraz records the sale immediately (cash book). However, the bank may take 1–2 days to credit Daraz’s account. This creates a "deposit in transit" that must be reconciled.

3. Nepal Rastra Bank (NRB) Inspections

   • Idea Used: Internal Controls & Reconciliation
   • How? NRB conducts surprise audits to check if banks (e.g., NMB, Standard Chartered) are properly reconciling cash books with bank statements. Non-compliance leads to penalties.

4. Pathao Drivers (Cash Handling)

   • Idea Used: Petty Cash & Imprest System
   • How? Pathao drivers use a small cash float (e.g., Rs 2,000) for change. At the end of the day, they submit receipts for reimbursement, ensuring no cash is misused.

6. Worked Example: Full Reconciliation

Scenario: Kathmandu Electronics has the following records for 30 Chaitra 2082:

• Cash book balance: Rs 120,000
• Bank statement balance: Rs 135,000
• Discrepancies:
  1. Cheque No. 101 for Rs 15,000 issued to a supplier but not yet presented to the bank.
  2. Deposit of Rs 20,000 on 29 Chaitra not yet credited by the bank.
  3. Bank charged Rs 1,200 for ATM usage (not recorded in cash book).
  4. Interest earned on savings account: Rs 800 (not recorded).
  5. A customer’s cheque for Rs 5,000 was returned NSF.

Step 1: Adjust Bank Statement Balance

Bank Statement Balance: Rs 135,000
Add: Deposits in Transit (+20,000) = Rs 155,000
Less: Outstanding Cheques (-15,000) = Rs 140,000
Less: Bank Charges (-1,200) = Rs 138,800
Add: Interest Earned (+800) = Rs 139,600
Less: NSF Cheque (-5,000) = Rs 134,600

Step 2: Compare with Cash Book

• Adjusted Bank Balance: Rs 134,600
• Cash Book Balance: Rs 120,000
• Difference: Rs 14,600 (unrecorded in cash book)

Step 3: Journal Entries for Adjustments

1. Bank Charges:
   Dr. Bank Charges A/c       Rs 1,200
       Cr. Bank A/c           Rs 1,200

2. NSF Cheque:
   Dr. Customer A/c          Rs 5,000
       Cr. Bank A/c           Rs 5,000

3. Interest Earned:
   Dr. Bank A/c              Rs 800
       Cr. Interest Income A/c Rs 800

Step 4: Reconciled Balance

• Cash Book + Adjustments: Rs 120,000 (original) + Rs 1,200 (charges) + Rs 5,000 (NSF) - Rs 800 (interest) = Rs 125,400 (Note: The Rs 20,000 deposit and Rs 15,000 cheque are not journalized; they’re just reconciled.)

Correction Needed: The cash book is understated by Rs 14,600. The missing entry is likely:

Dr. Bank A/c       Rs 14,600
    To [Unidentified Income/Expense] A/c Rs 14,600

7. Common Errors & Their Rectification

Example of Error Rectification:

• Error: A cheque of Rs 20,000 issued to a supplier was recorded as Rs 2,000.
• Rectification:

  Dr. Supplier A/c       Rs 18,000
      Cr. Bank A/c         Rs 18,000
  

8. Exam Tip

How to Score Full Marks

1. Always start with the bank statement balance and adjust it first.
2. Use a table to list all discrepancies (like the one above).
3. Show calculations step-by-step—examiners love clarity.
4. For journal entries:
   • Only pass entries for items not in the cash book (e.g., bank charges, NSF cheques).
   • Never journalize deposits in transit or outstanding cheques.
5. Common pitfalls:
   • Forgetting to adjust for interest earned or bank charges.
   • Treating deposits in transit as income (they’re not—just timing differences).
   • Ignoring NSF cheques (they reduce the bank balance).
6. Real-world twist: In exams, assume the business is Kathmandu-based (e.g., "a retail shop in Thapathali") to make answers relatable.

Sample Exam Question & Answer: Q: The bank statement of Newa Traders shows Rs 80,000, but the cash book shows Rs 75,000. Discrepancies:

• Deposit in transit: Rs 5,000
• Outstanding cheques: Rs 3,000
• Bank charges: Rs 1,000
• NSF cheque: Rs 2,000

A:

1. Adjusted Bank Balance: Rs 80,000 + 5,000 (deposit) - 3,000 (cheques) - 1,000 (charges) - 2,000 (NSF) = Rs 80,000 - 6,000 = Rs 74,000
2. Difference: Rs 75,000 (cash book) vs. Rs 74,000 (adjusted) → Rs 1,000 overstatement in cash book.
3. Journal Entry:

   Dr. Cash Book Overstatement A/c Rs 1,000
       Cr. Bank A/c               Rs 1,000
   

   (Note: The Rs 1,000 likely represents an unrecorded bank charge or deposit.)

Final Note: Bank reconciliation is not just math—it’s detective work. Always ask:

• Why is there a difference?
• Which book is wrong?
• What entry fixes it?

Practice with Nepali business scenarios (e.g., a hotel in Pokhara, a garage in Kathmandu) to master this unit!