The owner has finished bank reconcilation and can not make cash records equal to bank records. He need help. he gives you the reconcilation statement at the end of last month, his cash records and the most recent bank statement.

Here is last month bank rec statement as at 31 may 2015 : balance per bank statement 30th aprill 2015 4328 Cr

add deposit in transit 1224 less unpresented cheque 223 ----- balance per cash at bank account 31th may 2015 5329

additional information: cash recepts for may was 64776 and cash payments 63265. From the current bank statement, it was noted that cheques presented and paid 59725 and deposit 64780. Moreover, adddiotnal debits on the statement for dishonoured cheque 210 and account fee 20

all reconciling items at 31 may 2015 in bank statement for june are as follows unpresented cheques at 30 june 7154.

QUESTION prepare the bank recoliation at 30 june 2015 and tell the owner whether the cash is being misappropriated