How to update the cash book from the statement
Tick what matches, find what the cash book is missing, and enter it. The result is the updated cash book balance.
Task 1Tick what matches2 questions
Put the cash book and the statement side by side. Tick every item that is in both.
| Date | Details | Received | Paid |
|---|---|---|---|
| 1 May | Balance brought forward | 3,200.00 | |
| 2 May | Beck Estates, rent, standing order | 700.00 | |
| 3 May | Moorside School | 840.00 | |
| 9 May | Pennine Parts, cheque 301 | 520.00 | |
| 12 May | Takings paid in | 615.00 | |
| 18 May | Wages | 1,150.00 | |
| 24 May | Hill Top Hire | 450.00 | |
| 28 May | Dale Signs, cheque 302 | 260.00 | |
| 31 May | Takings paid in | 380.00 |
| Date | Details | Paid out | Paid in | Balance |
|---|---|---|---|---|
| 1 May | Balance brought forward | 3,200.00 | ||
| 2 May | SO Beck Estates, rent | 700.00 | 2,500.00 | |
| 3 May | BACS Moorside School | 840.00 | 3,340.00 | |
| 12 May | Paid in at branch | 615.00 | 3,955.00 | |
| 14 May | CHQ 301 | 520.00 | 3,435.00 | |
| 18 May | FP wages | 1,150.00 | 2,285.00 | |
| 20 May | DD Shield Insurance | 85.00 | 2,200.00 | |
| 24 May | FP Hill Top Hire | 450.00 | 2,650.00 | |
| 27 May | BACS Ridge Road Club | 300.00 | 2,950.00 | |
| 31 May | Bank charges | 15.00 | 2,935.00 |
Anything on the statement with no tick is missing from the cash book. Anything in the cash book with no tick is a timing difference.
Task 2Bring the cash book up to date3 questions
Task 3A cheque that is returned unpaid4 questions