Bank Reconciliation Statement & Cash Management

5.1 Introduction to Bank Reconciliation

In business, cash is rarely kept entirely in the safe. Most transactions flow through a bank account. The business maintains a Cash Book (specifically the Bank Account column), while the bank maintains its own record called the Bank Statement.

Ideally, the balance in the Cash Book (Pass Book) and the Bank Statement should match. However, due to the time lag between recording a transaction in the books and the bank processing it, or due to errors, the balances often differ.

Bank Reconciliation Statement (BRS) is a statement prepared to reconcile the difference between the balance as per the Cash Book and the balance as per the Bank Statement.

Why do balances differ?

1. Timing Differences (Lag):
   • Cheques issued but not presented: The business records the payment immediately, but the bank only deducts it when the payee presents the cheque.
   • Deposits in transit: The business records the receipt, but the bank adds it only when the funds are credited.
   • Direct credits/debits by bank: Interest, bank charges, or dividend payments made directly by the bank without the business's prior entry in the cash book.
2. Errors:
   • Arithmetical errors: Addition or subtraction mistakes.
   • Omissions: Forgetting to record a transaction in either the cash book or the bank statement.
   • Wrong entries: Recording a debit as credit or vice versa.

5.2 Preparation of Bank Reconciliation Statement

There are two methods to prepare a BRS:

1. Cash Book Balance Method: Start with the Cash Book balance and adjust to reach the Bank Statement balance.
2. Bank Statement Balance Method: Start with the Bank Statement balance and adjust to reach the Cash Book balance.

Note: For exam purposes, the Cash Book Balance Method is most common. If the Cash Book shows a Debit balance (positive cash), we start with that. If it shows a Credit balance (overdraft), we start with that.

Key Rules for Adjustment

• Add to Cash Book Balance:
  • Cheques issued but not presented.
  • Cheques deposited but not credited.
  • Bank charges/interest paid directly by bank (if not in Cash Book).
• Deduct from Cash Book Balance:
  • Interest/dividends received directly by bank (if not in Cash Book).
  • Direct payments by bank (e.g., insurance premium paid by bank).

Visual: The Reconciliation Flow

Worked Example: Kathmandu Retail Shop

Scenario: On 31st Chaitra 2080, the Cash Book of Sita Electronics in Kathmandu shows a Debit balance of Rs. 50,000. The Bank Statement shows a Debit balance of Rs. 55,000.

Differences identified:

1. Cheques issued but not presented: Rs. 10,000.
2. Cheques deposited but not credited: Rs. 5,000.
3. Bank charges debited by bank but not recorded in Cash Book: Rs. 2,000.
4. Interest received by bank but not recorded in Cash Book: Rs. 2,000.

Step 1: Update the Cash Book First, we must record items in the Cash Book that the bank has already processed but the business missed.

• Bank Charges (Expense): Debit Cash Book.
• Interest Received (Income): Credit Cash Book.

Calculation: $50,000+2,000-2,000=50,000$. The adjusted Cash Book balance is still Rs. 50,000 (Debit).

Step 2: Prepare Bank Reconciliation Statement

Verification: $50,000+10,000-5,000=55,000$. This matches the Bank Statement balance.

5.3 Cash Management

Cash management is the process of ensuring that a company has enough cash to meet its immediate obligations while maximizing the return on any idle cash.

Key Concepts

1. Liquidity: The ability to convert assets into cash quickly without significant loss of value.
2. Cash Cycle: The time between paying for inventory and receiving cash from customers. $$\text{Cash Cycle}=\text{Days Inventory Outstanding}+\text{Days Sales Outstanding}-\text{Days Payable Outstanding}$$
3. Opportunity Cost: The return lost by holding cash instead of investing it.

Techniques for Cash Management

• Accelerating Collections: Using electronic payments (eSewa, Khalti) to receive money instantly rather than waiting for cheques.
• Delaying Payments: Paying suppliers as late as possible within credit terms to keep cash in the account longer.
• Cash Pooling: For multi-branch companies, netting out cash positions so that surplus cash in one branch offsets deficits in another.
• Zero-Balance Accounts: An account that is swept to zero at the end of the day, transferring all funds to a central account.

Visual: The Cash Cycle

In the real world

1. eSewa and Khalti (Instant Settlement): In the past, businesses in Nepal faced a "float" period where cheques took days to clear. Today, eSewa and Khalti use real-time gross settlement (RTGS) or instant transfer systems. When a customer pays a bill via eSewa, the merchant's account is credited almost instantly. This eliminates the "Deposits in Transit" discrepancy found in traditional bank reconciliation, significantly shortening the Cash Cycle.

2. Daraz (Cash-on-Delivery Reconciliation): Daraz operates on a Cash-on-Delivery (COD) model. The delivery agent collects cash from the customer. This cash is not immediately in Daraz's bank account; it sits with the logistics partner (e.g., Pathao or internal fleet). Daraz must perform a complex Bank Reconciliation daily to match:

   • Cash collected by agents (Cash Book entry).
   • Cash deposited into Daraz's bank account (Bank Statement).
   • Differences due to agent errors or transit delays. This is a massive operational task involving thousands of small transactions, requiring automated reconciliation software.

3. Ncell (Cash Pooling): Ncell has thousands of retail outlets across Nepal. Some outlets have excess cash (high sales), while others have deficits. Ncell uses Cash Pooling strategies. Instead of each outlet maintaining its own bank balance, cash is swept centrally. This allows Ncell to invest the aggregate surplus in short-term instruments (like Treasury Bills) while ensuring every outlet has enough cash for change and daily expenses. This reduces the overall Opportunity Cost of holding cash.

Exam tip

• Always update the Cash Book first: In exam questions, if the problem states "Bank charges were debited by the bank but not recorded in the Cash Book," you must make a journal entry in the Cash Book before preparing the BRS. If you skip this, your BRS will not balance.
• Sign Convention: Be careful with Debit/Credit.
  • Cash Book Debit Balance = Positive Cash.
  • Cash Book Credit Balance = Overdraft (Negative Cash).
  • If you start with a Credit balance, the logic for adding/subtracting reverses.
• Common Trap: "Cheque issued but dishonored." This is not a timing difference. If a cheque is dishonored, the bank reverses the debit. You must record this in the Cash Book (Debit Cash, Credit Payee) as a new transaction, not as a reconciliation item.
• Presentation: Always show the calculation for the "Adjusted Cash Book Balance" clearly. Examiners award marks for the process, not just the final number.