Subjects accounting

Bank Reconciliation

Step-by-step solutions with LaTeX - clean, fast, and student-friendly.

Search Solutions

Bank Reconciliation


**Problem Statement:** Mr Kizito has discrepancies between his bank statement and cash book balances as of June 2014. We need to: 1. Prepare an adjusted cash book balance as at 30 June 2014. 2. Prepare a bank reconciliation statement as at 30 June 2014. --- ### Part i: Adjusted Cash Book Balance 1. **Given:** - Cash book balance: Sh.2,366,500 - Bank charges not entered in cash book: Sh.3,000 (deduct) - Receipts not entered in cash book: Sh.26,500 (add) - Standing order payments not entered in cash book: Sh.62,000 (deduct) - Payment entered wrongly (Sh.79,400 instead of Sh.74,900): adjust by adding Sh.4,500 (79,400 - 74,900) because the cash book shows excess payment - Cheque from debtor returned "refer to drawer" and not corrected: deduct Sh.15,000 - Opening cash balance brought forward as debit instead of credit by Sh.329,250, so adjust by adding Sh.658,500 (double this balance) to correct - Old cheque written back in cash book but bank had honored it: deduct Sh.44,000 - Receipts wrongly entered in cash book but not credited by bank (see part ii), already included in cash book, so no adjustment here 2. **Calculation:** Adjusted cash book balance $$ = 2,366,500 - 3,000 + 26,500 - 62,000 + 4,500 - 15,000 + 658,500 - 44,000 $$ 3. **Simplify:** $$ = 2,366,500 - 3,000 + 26,500 - 62,000 + 4,500 - 15,000 + 658,500 - 44,000 = 2,366,500 - 3,000 + 26,500 - 62,000 + 4,500 - 15,000 + 658,500 - 44,000 = (2,366,500 - 3,000) + 26,500 - 62,000 + 4,500 - 15,000 + 658,500 - 44,000 = 2,363,500 + 26,500 - 62,000 + 4,500 - 15,000 + 658,500 - 44,000 = (2,363,500 + 26,500) - 62,000 + 4,500 - 15,000 + 658,500 - 44,000 = 2,390,000 - 62,000 + 4,500 - 15,000 + 658,500 - 44,000 = (2,390,000 - 62,000) + 4,500 - 15,000 + 658,500 - 44,000 = 2,328,000 + 4,500 - 15,000 + 658,500 - 44,000 = (2,328,000 + 4,500) - 15,000 + 658,500 - 44,000 = 2,332,500 - 15,000 + 658,500 - 44,000 = (2,332,500 - 15,000) + 658,500 - 44,000 = 2,317,500 + 658,500 - 44,000 = (2,317,500 + 658,500) - 44,000 = 2,976,000 - 44,000 = 2,932,000 $$ **Adjusted cash book balance = Sh.2,932,000** --- ### Part ii: Bank Reconciliation Statement as at 30 June 2014 1. **Starting point:** Bank statement balance at 30 June 2014 = Sh.706,500 2. **Add:** - Cheques drawn but not yet presented: Sh.22,500 3. **Less:** - Receipts paid into bank but not yet credited by bank: Sh.98,500 - Customer deposits credited to another customer’s account by bank: Sh.832,500 4. **Bank reconciliation calculation:** $$ Adjusted bank balance = 706,500 + 22,500 - 98,500 - 832,500 = 706,500 + 22,500 - 931,000 = 729,000 - 931,000 = -202,000 $$ 5. **However, also consider:** - Receipts entered in cash book of Sh.832,500 (already included in cash book but not bank) 6. **Reconciliation statement format:** \begin{align*} \text{Bank balance as per statement} &= 706,500 \\ \text{Add: Cheques not yet presented} &= 22,500 \\ \text{Less: Receipts not credited by bank} &= 98,500 \\ \text{Less: Deposits credited to another customer's account} &= 832,500 \\ \hline \text{Adjusted bank balance} &= 706,500 + 22,500 - 98,500 - 832,500 = -202,000 \end{align*} --- ### Final answers: - Adjusted cash book balance = Sh.2,932,000 - Adjusted bank statement balance (per reconciliation) = Sh.-202,000 This negative bank balance indicates the bank statement does not reflect these transactions properly, and the reconciliation helps identify these differences.