Financial AccountingUnit 513 min read
Bank Reconciliation & Cash Management: Statements, Errors & Controls
Unit 5 of Financial Accounting covers bank reconciliation techniques (identifying discrepancies between books and bank statements), cash management strategies (imprest systems, petty cash), and controls to prevent fraud or errors—with real-world examples from Nepali banks (Nabil, Global IME) and apps (eSewa, Khalti).
TAKEAWAYS:
- Bank reconciliation resolves four common discrepancies: unrecorded deposits, unpresented checks, bank charges, and errors in either books or statements.
- The imprest system ensures petty cash is controlled by requiring vouchers and periodic replenishment.
- Cash management prioritizes liquidity, security, and profitability—using tools like lockboxes (Nepal Rastra Bank’s interbank transfers) and float optimization.
- Internal controls (segregation of duties, surprise audits) prevent fraud, as seen in the 2018 Nabil Bank scam (₹1.2B loss due to collusion).
- Adjusting entries for bank reconciliation must follow the double-entry rule: every debit has a credit, and totals must balance.
- Cash flow vs. cash balance: A company can be profitable (high cash flow) but insolvent (negative cash balance), as in Daraz Nepal’s 2022 liquidity crisis.
1. Why Reconcile Bank Accounts?
Banks and businesses often record transactions differently:
- Bank’s perspective: Only processes checks/deposits physically received or cleared.
- Business’s perspective: Records transactions when written (e.g., a check issued on Dec 31 is recorded immediately, but the bank may clear it in January).
Result: Discrepancies arise. Reconciliation ensures accuracy and detects:
- Errors (e.g., duplicate payments, misrecorded amounts).
- Fraud (e.g., forged checks, unauthorized withdrawals).
- Timing differences (e.g., deposits in transit, outstanding checks).
Key Idea: The adjusted book balance must equal the adjusted bank balance after reconciliation.
2. Step-by-Step Bank Reconciliation Process
Use this checklist to reconcile:
| Step | Action | Example (Nepali Context) |
|---|---|---|
| 1. Start with balances | Note the ending balance per bank statement and ending balance per books. | Bank statement shows ₹1,200,000; books show ₹1,180,000. |
| 2. Add deposits in transit | Deposits recorded in books but not yet cleared by the bank. | A ₹50,000 deposit made on Dec 30 but cleared on Jan 2 → add ₹50,000 to bank balance. |
| 3. Deduct outstanding checks | Checks issued by the business but not yet presented to the bank. | A ₹30,000 check to a supplier on Dec 28 not cleared by Dec 31 → deduct ₹30,000 from bank balance. |
| 4. Adjust for bank errors | Errors only the bank made (e.g., wrong interest credited). | Bank credited ₹2,000 extra as interest → deduct ₹2,000 from bank balance. |
| 5. Adjust for book errors | Errors only the business made (e.g., misrecorded cash receipts). | Books recorded a ₹10,000 receipt as ₹1,000 → add ₹9,000 to book balance. |
| 6. Verify adjusted balances | Both balances should now match. | Adjusted bank balance = ₹1,200,000 + ₹50,000 - ₹30,000 - ₹2,000 = ₹1,218,000. |
| 7. Record adjustments | Journalize book-side adjustments only (never adjust the bank statement). | Debit Bank Charges Expense ₹2,000; Credit Bank ₹2,000. |
3. Common Reconciliation Items (With Nepali Examples)
| Item | Definition | Nepali Business Example |
|---|---|---|
| Deposits in Transit | Cash/cheques deposited but not yet cleared by the bank. | Khalti’s daily collections (₹5B/day) take 1–2 days to reflect in bank statements. |
| Outstanding Checks | Checks issued but not yet cashed by the payee. | A Daraz seller issues a ₹20,000 check to a supplier on Dec 30; bank clears it Jan 5. |
| Bank Charges | Fees for NSF checks, ATM withdrawals, or service charges. | Nabil Bank charges ₹500 for exceeding daily ATM limits. |
| Interest Earned | Interest credited by the bank but not yet recorded in books. | Global IME credits ₹15,000 interest on Dec 31; recorded in Jan. |
| Direct Payments | Payments made directly by customers (e.g., online transfers) not recorded. | An eSewa user pays ₹10,000 for a NTC bill via bank transfer; NTC records it late. |
| Errors | Typographical errors in recording amounts. | A Kathmandu shop records a ₹50,000 sale as ₹5,000 in cash receipts. |
4. Journal Entries for Reconciliation Adjustments
Only book-side adjustments are journalized. Never adjust the bank statement.
Example: Reconciling Naya Aath Shop (Kathmandu)
Given:
- Bank statement balance (Dec 31): ₹850,000
- Book balance (Dec 31): ₹820,000
- Discrepancies found:
- Deposits in transit: ₹30,000
- Outstanding checks: ₹20,000
- Bank charged ₹1,500 for ATM fees (unrecorded in books)
- Books recorded a ₹5,000 cash sale as ₹500 (error)
Step 1: Calculate Adjusted Balances
- Adjusted Bank Balance = ₹850,000 + ₹30,000 (deposits) - ₹20,000 (checks) - ₹1,500 (fees) = ₹858,500
- Adjusted Book Balance = ₹820,000 + ₹5,000 (error correction) - ₹1,500 (bank fees) = ₹858,500
Step 2: Journal Entries
5. Cash Management Techniques
Cash management ensures liquidity, security, and profitability. Key tools:
| Technique | How It Works | Nepali Example |
|---|---|---|
| Imprest Petty Cash System | Fixed cash float (e.g., ₹50,000) replenished when spent. | Hotel Yak & Yeti keeps ₹30,000 in petty cash for daily expenses; replenished weekly. |
| Lockbox System | Customers send payments to a PO Box near the bank for faster clearing. | Nepal Rastra Bank’s interbank lockbox for NEPSE dividend payments. |
| Float Optimization | Minimize collection float (time between deposit and availability). | eSewa processes payments instantly via Fintech APIs, reducing float to <1 hour. |
| Cash Concentration | Pool cash from multiple accounts into a master account. | Global IME consolidates branch cash into a central account for better interest. |
| Zero-Balance Accounts | Bank account with no minimum balance; overdrafts allowed up to a limit. | Nabil Bank’s corporate clients use ZBA for payroll processing. |
6. Petty Cash: Imprest System Explained
The imprest system ensures petty cash is controlled and accounted for.
Steps:
- Establish a float: Approve a fixed amount (e.g., ₹50,000).
- Issue vouchers: Every expenditure must have a signed voucher.
- Replenish periodically: When cash drops to a minimum (e.g., ₹5,000), replenish.
Example: Pathao Driver’s Petty Cash
- Float: ₹20,000
- Transactions in a week:
- Fuel: ₹8,000 (voucher #101)
- Parking: ₹1,200 (voucher #102)
- Maintenance: ₹3,500 (voucher #103)
- Ending cash: ₹7,300 (below ₹10,000 threshold).
Journal Entry to Replenish: Supporting Entries (for expenses):
7. Internal Controls for Cash
Fraud prevention requires segregation of duties and surprise audits.
| Control | How It Works | Nepali Example |
|---|---|---|
| Segregation of Duties | Different people handle custody, recording, and authorization of cash. | Nepal Bank Limited: Cashier ≠ Accountant ≠ Manager. |
| Surprise Audits | Unannounced checks on cash balances. | Nepal Rastra Bank conducts surprise audits on NEPSE clearing agents. |
| Locks & Alarms | Physical security for cash registers and safes. | Kathmandu’s jewelry shops use biometric safes for petty cash. |
| Reconciliation | Monthly bank reconciliations by an independent person. | Global IME assigns a senior accountant to reconcile branch accounts. |
| Electronic Payments | Reduce cash handling via digital transfers (e.g., Khalti, eSewa). | Daraz encourages sellers to use bank transfers instead of cash-on-delivery. |
In the Real World
eSewa’s Cash Flow Management
- Idea Used: Float optimization and lockbox system.
- How: eSewa processes ₹3B+ daily via Fintech APIs, reducing the time between deposit and fund availability to <1 hour (vs. 2–3 days for traditional banks). Their real-time reconciliation ensures no discrepancies in merchant payouts.
Nabil Bank’s Petty Cash Scandal (2018)
- Idea Used: Failure of internal controls.
- How: A ₹1.2B fraud occurred due to lack of segregation of duties—the same employee handled petty cash, authorization, and accounting. The bank later implemented biometric verification for cash withdrawals.
Daraz Nepal’s Cash Management Crisis (2022)
- Idea Used: Liquidity vs. cash balance.
- How: Daraz reported ₹50B in sales but faced cash flow shortages because:
- High COD (Cash on Delivery) rates tied up cash in inventory.
- Supplier payments were delayed, hurting working capital.
- Solution: Shifted to digital payments (Khalti, eSewa) to improve liquidity.
Exam Tip
Memorize the Reconciliation Formula:
Adjusted Book Balance = Book Balance + Deposits in Transit - Outstanding Checks ± Errors- Always reconcile to the bank’s adjusted balance.
Journalize Only Book-Side Adjustments:
- If the bank made an error, adjust the books to correct it.
- Example: If the bank overcharged you ₹1,000, debit Bank and credit Bank Charges Expense.
Petty Cash Questions Are Common:
- Always show:
- The replenishment entry (debit Petty Cash, credit Cash).
- The expense entries (debit Expense, credit Petty Cash).
- Example: If petty cash starts at ₹50,000 and ends at ₹5,000 with ₹40,000 in vouchers, the replenishment is ₹40,000.
- Always show:
Real-World Scenarios:
- Bank reconciliation: Use Nepali bank names (Nabil, Global IME, Standard Chartered).
- Cash management: Relate to eSewa, Khalti, or Daraz (e.g., "How does eSewa minimize float?").
- Internal controls: Link to scams (e.g., "Why did Nabil Bank’s petty cash system fail?").
Common Mistakes to Avoid:
- Adjusting the bank statement (only adjust books).
- Ignoring timing differences (deposits in transit, outstanding checks).
- Forgetting to reconcile interest or bank fees.
Final Worked Example (Exam-Style Question) Question: The bank statement of Thapathali Retail Shop shows a balance of ₹750,000 on Dec 31, 2023. The book balance is ₹720,000. The following discrepancies were found:
- Deposits in transit: ₹40,000
- Outstanding checks: ₹30,000
- Bank charged ₹2,500 for ATM fees (unrecorded in books).
- Books recorded a ₹10,000 cash sale as ₹1,000.
Required: a) Prepare a bank reconciliation statement. b) Pass the necessary journal entries.
Solution:
a) Bank Reconciliation Statement
b) Journal Entries
Based on the TU BIM syllabus for Financial Accounting (ACC201), unit 5.
Discussion
Loading…