Answer:
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).
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
