Bank Reconciliation and Updated Cash Book Notes - Zac (31 March 2025)

Bank Statement Items Not Yet Recorded in Cash Book:
- 20 March 2025: Payment received by bank transfer from Zoe (a credit customer) amounting to $\$310$ . This represents an unrecorded receipt that increases the cash book balance.
- 23 March 2025: Electricity charges paid by direct debit amounting to $\$936$ . This represents an unrecorded automated payment that decreases the cash book balance.
- 25 March 2025: Bank charges amounting to $\$58$ . This represents an unrecorded bank fee that decreases the cash book balance.
- 29 March 2025: A standing order for insurance deducted in error by the bank amounting to $\$1121$ . Because this is an error committed by the bank, it is not adjusted in the business cash book; instead, it is included as a correcting item in the bank reconciliation statement.
- 30 March 2025: Interest received amounting to $\$45$ . This represents an unrecorded bank income receipt that increases the cash book balance.
Cash Book Items Not Yet Reflected on Bank Statement:
- 27 March 2025: A cheque payable to AC Motors amounting to $\$480$ that has not been presented to the bank for payment (Unpresented Cheque).
- 30 March 2025: Cash and cheques deposited into the bank amounting to $\$1210$ that have not yet been credited by the bank (Uncredited Deposits / Amounts in Transit).

To update the bank column of Zac's cash book, all valid unrecorded bank transactions must be entered. Bank errors are excluded from the cash book.

Debit Side (Receipts and Income):
- Opening Debit Balance: $\$825$
- Credit customer payment (Zoe): $\$310$
- Interest received: $\$45$
- Total Debit Receipts: $\$825 + \$310 + \$45 = \$1180$
Credit Side (Payments and Expenditure):
- Direct debit for electricity: $\$936$
- Bank charges: $\$58$
- Total Credit Payments: $\$936 + \$58 = \$994$
Balancing the Cash Book Account:
- Net Balance carried down ( $\text{Balance c/d}$ ) on 31 March 2025: $\$1180 - \$994 = \$186$
- Total Debit Side: $\$1180$
- Total Credit Side: $\$1180$
- Balance brought down ( $\text{Balance b/d}$ ) on 1 April 2025: Debit balance of $\$186$
Cash Book Bank Column Summary Table:
- Debit Side (Receipts):
- Balance b/d: $\$825$
- Zoe (Bank transfer): $\$310$
- Interest received: $\$45$
- Total: $\$1180$
- Credit Side (Payments):
- Electricity (Direct debit): $\$936$
- Bank charges: $\$58$
- Balance c/d (31 March 2025): $\$186$
- Total: $\$1180$
- Opening Balance for New Period:
- 1 April 2025 Balance b/d: $\$186$ (Debit)

The bank reconciliation statement reconciles the updated balance per cash book with the overdrawn balance shown on the bank statement.

Method 1: Starting from Updated Cash Book Balance:
- Updated Balance per Cash Book (Debit): $\$186$
- Add: Unpresented cheque (AC Motors): $\$480$
- Subtotal: $\$186 + \$480 = \$666$
- Less: Uncredited deposits (Cash/cheques deposited 30 March): $\$1210$
- Less: Insurance standing order deducted in error by bank: $\$1121$
- Total Deductions: $\$1210 + \$1121 = \$2231$
- Balance per Bank Statement (Overdrawn): $\$666 - \$2231 = -\$1565$ or $\$666 - \$1210 - \$1121 = -\$1665$
- Final Balance per Bank Statement: Overdrawn balance of $\$1665$
Method 2: Starting from Bank Statement Overdrawn Balance:
- Balance per Bank Statement (Overdrawn): $-\$1665$
- Add: Uncredited deposits: $\$1210$
- Add: Correction of bank error (Insurance deducted in error added back): $\$1121$
- Subtotal: $-\$1665 + \$1210 + \$1121 = \$666$
- Less: Unpresented cheque (AC Motors): $\$480$
- Updated Balance per Cash Book (Debit): $\$666 - \$480 = \$186$

Updating the Cash Book:
- The cash book must be updated for items that appear on the bank statement but have not been recorded in the cash book, such as bank charges, direct debits, standing orders, credit transfers, and bank interest.
- Bank errors must never be entered into the cash book because they do not represent actual transactions of the business.
Bank Reconciliation Statement Function:
- The bank reconciliation statement explains the remaining timing differences (unpresented cheques and uncredited deposits) and corrects bank errors to ensure the cash book balance matches the bank statement perspective.
- Unpresented Cheques: Cheques issued by the business and recorded in the cash book credit side, but not yet processed by the bank.
- Uncredited Deposits: Funds deposited by the business and recorded on the cash book debit side, but not yet cleared or credited on the bank statement.