The following information was avaliable to reconcile Montrose Companys book balance of Cash with nts bank statement balance as of October 31,2023 a. After-all posting was completed on October 31, the company's Cash account had a $176ta debt balance but its bank statement showed a $39192 balance. b. Cheques $296 for $1,781 and $307 for $17,028 were outstanding on the September 30 bank reconciliaton, Cheque \# 307 was returned with the October cancelfed cheques. but cheque =296 was not it was alsa found that cheque ir 315 for 51,192 and cheque $321 for $2,670, both written in October, wete not among the cancelled cheques returned with the staternert. c. In comparing the cancelled cheques refutned by the bank with the entries in the accounting records, it was found that cheque #320 for the October rent was correctly written for $4,110 but was erroneously entered in the accounting records as $4,920 d. A credit memo enclosed with the bank statement indicated that there was an electronic fund transfer related to a customer payment for $21,535. A $160 bank service charge was deducted. This transaction was not fecorded by Montrose before receiving the bank statement - A dicbit memo for $4,336 listed a $4.271 NSF cheque plus a $65 NSF charge. The cheque had been recerved from a customer, Jefferson Tyler Montrose had not recorded this bounced cheque before recelving the statement. 6. Also enclosed with the statement was a $98 debit memo for bank services. it had not been recorded because no prepious notification had been received 9. The October 31 cash receipts, $1,815, were placed in the bank's night depository after barking hours on that date and this amount did not appear on the bank statement. Required: 1. Prepare a bank reconcilation for the company as of October 31,2023 2. Prepare the General Joumal entries necessary to bring the company's book balance of Cash into agreement with the reconciled balance Journal entry worksheet Record the collection of note less collection fee