III. BANK RECONCILIATION! (20 marks) (write solution on p. 7) The June 30, 2017, bank statement of Copps Shoes has just arrived from the Royal Bank. To prepare the Copps Shoes bank reconciliation, you gather the following data: a. The Copps Shoes Cash account shows a balance of $39,518 on June 30. b. The bank statement includes two charges for returned cheques from customers. One is a $3,558 cheque received from Trinity Western and deposited on June 20, returned by Trinity Western's bank with the imprint "Unauthorized Signature." The other is an NSF ited on June 17. cheque in the amount of $988 received from Mavis Jones. This cheque had been depos- month by EFT. c. Copps Shoes pays rent ($5,650), utilities ($2,000), and cellphone charges ($120) each d. The following Copps Shoes' cheques are outstanding at June 30: Cheque No. Amount 291 $ 306 322 1,074 327 4,312 329 82 330 3,096 331 432 332 1,860 e. The bank statement includes a deposit of $11,466, collected by the bank on behalf of Copps Shoes. Of the total, $11,208 is collection of a note receivable and the remainder is interest revenue. f. The bank statement shows that Copps Shoes earned $26 in interest on its bank balance during June. This amount was added to Copps Shoes' account by the bank. g. The bank statement lists a $144 subtraction for the bank service charge. h. On June 30, the Copps Shoes accountant deposited $3,378, but this deposit does not appear on the bank statement. i. The bank statement includes a 54,200 deposit that Copps Shoes did not make. The bank had erroneously credited the Copps Shoes' account for another bank customer's deposit. j. The June 30 bank balance is $50,534. Required 1. Prepare the bank reconciliation for Copps Shoes at June 30, 2017