Question

Question 1: Topic - Bank Reconciliation

The 2020 June bank statement of Wheeler Ltd has just been received from its bankers. The owner, Ken
Wheeler, has been quietly monitoring internal controls over few months and has sufficient grounds to
believe that cash is being misappropriated in his business. He has approached an accounting consultant,
Tony, to verify his accounting records and confirm his worst fears. Tony is supplied with the
reconciliation statement at the end of last month together with the cash records and the most recent bank
statement of Wheeler Ltd.
Last Month’s Reconciliation statement is presented below:
Bank Reconciliation Statement as at 31 May 2020
($)
Balance as per Bank Statement 30 April 2020 4328.90 Cr
Add: Outstanding Deposit 1224.50
5553.40
Less: Unpresented Cheques 223.70
Balance per Cash at Bank Account at 31 May 2020 $5329.70 Dr
The total of the cash receipts journal for June is $64,776.30 and the total of the cash payments journal is
$63,265.60. The current bank statement shows that cheques presented and paid amount to $59,725.10,
and total deposits amount to $64,780.60. There are also additional debits on the statement for a
dishonored cheque for $210, and account fees for $20.
Additional information:
An examination of the records reveals that all reconciling items at 31 May 2020 appear in the bank
statement for June, unpresented cheques at 30 June total $7154.40, and the 30 June deposit of
$1950.40 has not been credited by the bank. Your check of the cash journals reveals that addition errors
have been made by the clerks responsible. Receipts should total $65,766.30 and payments should total
$63,185.60.
Required:
a) Prepare the Cash at Bank account of Wheeler Ltd showing the final balance at 30 June 2020.
(4 marks)
b) Prepare the bank reconciliation statement of Wheeler Ltd at 30 June 2020. (4 marks)
c) Advice the owner, Ken Wheeler, whether cash is being misappropriated by any amount, assuming
that the records maintained by the bank are accurate. (3 marks)

Answer 1

Wheeler Ltd

Balance per Cash at Bank Account at 31 May 2020 $5,329.70 DR

Total cash receipts for June, 2020 $65,766.30

less Total cash payments for June, 2020 ($63,185.60)

Dishonored check ($210.00)

Bank charges ($20.00)

Adjusted balance per Cash at Bank $7,680.40 DR

Bank Reconciliation Statement at 30 June 2020

Adjusted balance per Cash at Bank $7,680.40

Add Unpresented cheques at 30 June total $7,154.40

Less Uncredited deposits = ($1,950.40)

Balance as per bank statement, 30 June, 2020 $12,884.40

c) Cash was misappropriated by $1,070 with the under-counting of cash receipts ($990) and overstatement of cash payments ($80).

Step-by-step explanation:

a) Data and Calculations:

Total cash receipts = $64,776.30 $65,766.30 $990 error understated

Total cash payments = $63,265.60 $63,185.60 $80 error overstated

Checks presented and paid by bank = $59,725.10

Checks deposited in June = $64,780.60

Dishonored check $210

Bank charges $20

Additional information:

Unpresented cheques at 30 June total $7,154.40

Uncredited deposits = $1,950.40