Question 23 When the accountant Sandhill Company prepared the bank reconciliation on May 31, 2021, there were three outstanding cheques: #690 for $310, 2693 for $180, and #694 for $270. There were no deposits in transitas at May 31, 2021. The bank balance at May 31 was 517,680. The balance in the cash account on the May 31, 2021, adjusted trial balance was $15,920. The following is Selected information from the June bank statement: Cheques Cleared Date Cheque No. Amount June 1 690 $310 5 5 209 3,260 5 5 693 180 13 710 1,490 212 4.677 119 470 711 1,290 Other Bank Account Transactions Dale Amount Transaction June 3 $3,320 Deposit 10 5,380 Deposit 17 5,490 Deposit 24 Deposit 25 - 190 NSF cheque 27 -500 EFT insurance payment 30 25 Service charge 30 45 Interest The NSF cheque was originaly received from a customer, Massif Co., in payment of its account of $165. The bank included a $25 service charge for a total $190. Information from the company's accounting records follows: Cash Receipts Date Amount June $3,30 9 5,380 16 5,940 23 2,141 30 3,120 Date June 5 5 19 19 Cash Payments Cheque No. Amount 200 $2,910 209 3,260 711 1,290 712 4,267 713 3,050 714 3,860 27 Investigation reveals that cheque #712 was issued to purchase equipment and cheque #720 was issued to pay an account payable. All deposits are for collections of accounts receivable. The bank made one error: cheque #119 for Sandhil Co. Ltd. was charged to Sanchil's bank account. The company's policy is to pass on all NSF service charges to the customer Calculate the balance per bank statement at June 30 and the unadjusted Cash balance per company records at June 30. Unadjusted bank balance, June 30, 2021 Unadjusted cash balance, June 30, 2021 Prepare a bank reconciliation at June 20. (List items that increase balance as per bank & books first.) SANDHILL COMPANY Bank Reconciliation June 30, 2021 V V