Worked example 1
On 31 May, a business's cash book showed a bank balance of $5,280. The bank statement on the same date showed a balance of $6,145. The following discrepancies were found:
- Bank charges of $55 had not been entered in the cash book.
- Cheques issued to suppliers totalling $1,320 were unpresented.
- A deposit of $400 made on 31 May was not yet credited by the bank.
Prepare the updated cash book extract and a bank reconciliation statement as at 31 May.
Show solution outline
Step 1 — Update the Cash Book We must record the bank charges that are on the statement but not yet in our books.
Cash Book (Bank Column)
| Details | $ | Details | $ |
|---|---|---|---|
| Balance b/d | 5,280 | Bank charges | 55 |
| --- | --- | --- | --- |
| Balance c/d | 5,225 | ||
| 5,280 | 5,280 |
The updated cash book balance is $5,225. This is the figure that would be shown in the Statement of Financial Position.
Step 2 — Prepare the Bank Reconciliation Statement We will use the format that starts with the updated cash book balance.
Bank Reconciliation Statement as at 31 May | | | :--- | ---: |
| Balance as per updated cash book | 5,225 |
|---|---|
| Add: Unpresented cheques | 1,320 |
| 6,545 | |
| Less: Uncredited deposits | (400) |
| --- | --- |
| Balance as per bank statement | 6,145 |
This matches the balance on the bank statement, so the accounts are reconciled.