Bank Reconciliation: Statements, Discrepancies & Adjustments

TAKEAWAYS:

• Purpose: Bank reconciliation ensures the cash book and bank statement balances match by identifying missing entries, errors, or unauthorized transactions.
• Key Discrepancies: Cheques issued but not yet presented, deposits in transit, bank charges, interest credited, and direct debits/credits cause mismatches.
• Adjustments: Correct the cash book (not the bank statement) to reflect accurate financial records.
• Process: Compare dates, amounts, and transactions systematically; use a reconciliation statement to document adjustments.
• Real-World Use: Banks (Ncell, NTC), e-commerce (Daraz, eSewa), and businesses (Kathmandu retail shops) rely on reconciliation to prevent fraud and ensure accuracy.
• Exam Focus: Numerical problems (e.g., given cash book and bank statement, prepare a reconciliation statement) dominate; memorize common adjustments.

1. What is Bank Reconciliation?

Bank reconciliation is the process of comparing the cash book (business records) with the bank statement (bank’s records) to identify and resolve discrepancies. Discrepancies arise due to:

• Timing differences (e.g., cheques issued but not yet cleared by the bank).
• Errors (e.g., incorrect entries in the cash book or bank statement).
• Unauthorized transactions (e.g., bank charges, direct debits).

Why is it important?

• Detects fraud or theft (e.g., unauthorized withdrawals).
• Ensures accuracy in financial statements.
• Helps track missing deposits or unrecorded transactions.

2. Common Causes of Discrepancies

Discrepancies can be categorized into two types:

3. Step-by-Step Reconciliation Process

Use this mermaid flowchart to visualize the process:

flowchart TD
    A["Start"] --> B["Obtain Cash Book & Bank Statement"]
    B --> C["Compare Dates & Amounts"]
    C --> D{"Discrepancies Found?"}
    D -->|"Yes"| E["Identify Type of Discrepancy"]
    E --> F["Adjust Cash Book or Note for Future"]
    F --> G["Prepare Reconciliation Statement"]
    D -->|"No"| H["Balances Match: No Action Needed"]
    G --> I["End"]

Key Steps:

1. List the balances:
   • Cash book balance (as of the date).
   • Bank statement balance (as of the same date).
2. Compare transactions:
   • Check for cheques issued but not yet presented (deduct from cash book).
   • Check for deposits in transit (add to bank statement).
   • Check for bank charges, interest, or direct debits/credits (adjust cash book).
3. Prepare a reconciliation statement to document adjustments.

4. Worked Example: Reconciling for a Kathmandu Retail Shop

Scenario: Kathmandu Mart has the following records for Chaitra 30, 2079:

• Cash book balance (debit): Rs. 10,000
• Bank statement balance (credit): Rs. 12,500

Transactions causing discrepancies:

1. Cheque issued to a supplier (Rs. 2,000) but not yet presented to the bank.
2. Deposit of Rs. 1,500 (from sales) made on Chaitra 29 but not yet cleared by the bank.
3. Bank charged Rs. 500 for printing cheques (not recorded in the cash book).
4. Interest credited by the bank (Rs. 300) not yet recorded.

Step 1: Identify Discrepancies

Step 2: Adjust the Cash Book

The correct cash book balance should be:

Cash book balance (given)          = Rs. 10,000
Add: Interest credited             = + Rs. 300
Less: Bank charges                = - Rs. 500
Less: Cheque not presented        = - Rs. 2,000
Adjusted cash book balance        = **Rs. 7,800**

Step 3: Reconciliation Statement

Correction: The reconciliation statement should directly compare adjusted balances:

• Adjusted cash book balance (Rs. 7,800) should match the bank statement balance after adjustments (Rs. 12,500 - Rs. 1,500 deposit in transit = Rs. 11,000). (Note: The above table was simplified for clarity; in exams, show all steps.)

5. Real-World Applications

In the Real World:

1. eSewa/Khalti (Digital Payments):

   • Reconciliation ensures that every transaction (e.g., Rs. 500 deposited via Khalti) matches between the user’s account and eSewa’s records. If a user sees Rs. 1,000 in their Khalti app but eSewa’s system shows Rs. 900, reconciliation identifies the missing Rs. 100 (e.g., a pending deduction).

2. Daraz (E-Commerce Orders):

   • When a customer pays via bank transfer for a Daraz order, the seller’s cash book records the payment, but the bank statement may not reflect it immediately. Reconciliation ensures the seller knows which orders are "paid" vs. "pending" to avoid shipping delays.

3. Nepal Rastra Bank (NRB) Audits:

   • Banks like Ncell or NTC reconcile their cash books daily to detect fraud (e.g., unauthorized SIM sales) or errors in billing. For example, if Ncell’s records show Rs. 50,000 collected but the bank statement shows Rs. 48,000, reconciliation pinpoints the missing Rs. 2,000 (e.g., a cashier’s theft).

6. Common Adjustments in Reconciliation

7. Reconciliation Statement Format

Use this Markdown table for exam answers:

Note: The "difference" row explains why the initial balances didn’t match (e.g., Rs. 500 bank charges + Rs. 300 interest = Rs. 800, but the example above was simplified).

8. Exam Tip: How to Score Full Marks

1. Always start with the given balances (cash book and bank statement).
2. List all discrepancies in a table (like above) before preparing the statement.
3. Adjust the cash book (not the bank statement) unless the bank’s error is confirmed.
4. Show all steps in the reconciliation statement—examiners deduct marks for missing logic.
5. Use real-world examples in explanations (e.g., "Like how Daraz reconciles payments to avoid shipping unpaid orders").
6. Common mistakes to avoid:
   • Forgetting to adjust for bank charges or interest.
   • Not reconciling timing differences (e.g., deposits in transit).
   • Mixing up debit/credit adjustments.

9. Practice Problem (Solve Like an Exam)

Given:

• Cash book balance (Chaitra 30, 2079): Rs. 15,000 (debit).
• Bank statement balance (same date): Rs. 18,000 (credit).
• Discrepancies:
  1. Cheque issued to a creditor (Rs. 3,000) not yet presented.
  2. Deposit of Rs. 2,500 (from debtors) not yet cleared.
  3. Bank charged Rs. 400 for statement printing.
  4. Interest credited by bank (Rs. 200) not recorded.

Tasks:

1. Prepare a reconciliation statement.
2. Show the adjusted cash book balance.

Solution Outline:

1. Adjusted cash book balance = Rs. 15,000 - Rs. 3,000 (cheque) - Rs. 400 (charges) + Rs. 200 (interest) = Rs. 11,800.
2. Reconciliation statement will show:
   • Cash book balance: Rs. 15,000
   • Add: Deposit in transit (Rs. 2,500)
   • Less: Cheque not presented (Rs. 3,000)
   • Adjusted balance: Rs. 14,500
   • Bank statement balance: Rs. 18,000
   • Difference: Rs. 3,500 (due to bank charges and interest).

10. Key Formulas to Remember

1. Adjusted Cash Book Balance = Cash Book Balance ± Unpresented Cheques ± Bank Charges ± Interest ± Direct Debits/Credits
2. Reconciled Balance = Bank Statement Balance ± Deposits in Transit ± Errors

11. Visual Summary: Accounting Cycle with Reconciliation

flowchart LR
    A["Journal Entries"] --> B["Ledger Postings"]
    B --> C["Trial Balance"]
    C --> D["Bank Reconciliation"]
    D --> E["Adjusted Trial Balance"]
    E --> F["Financial Statements"]
    D -->|"Identifies Errors"| G["Correct Journal Entries"]
    G --> C

12. Final Checklist for Exams

Before submitting your answer: ✅ Did I compare all transactions between cash book and bank statement? ✅ Did I adjust the cash book for all discrepancies? ✅ Did I prepare a clear reconciliation statement with headings and totals? ✅ Did I explain each adjustment (e.g., "Cheque not presented" or "Deposit in transit")? ✅ Did I show the final reconciled balance matching both sides?