The following information was avallable to reconcile Montrose Company's book balance of Cash with its bank statement balance as of October 31, 2023: o. After all posting was completed on October 31 , the company's Cash account had a $15.441 debit balance but its bank statement showed a $34,370 balance. b. Cheques #296 for $1,564 and $307 for $14,951 were outstanding on the September 30 bank reconciliation. Cheque $307 was returned with the October cancelled cheques, but cheque \#296 was not. It was also found that cheque \#315 for $1,047 and cheque \#321 for $2.346, both witten in October, were not among the cancelled cheques returned with the statement. c. In compating the cancelled cheques returned by the bank with the entries in the accounting records. It was found that cheque $320 for the October rent was correctly witten for $6,090 but was erroneously entered in the accounting records as $6,720. d. A credit memo enclosed with the bank statement indicated that there was an electronic fund transfer related to a customer payment for $22,263. A $141 bank service charge was deducted. This transaction was not recorded by Montrose before receiving the bank statement. e. A debit memo for $3.820 listed a $3.763 NSF cheque plus a $57 NSF charge. The cheque had been recelved from a customer, Jefferson Tyler. Montrose had not recorded this bounced cheque before recelving the statement. f. Also enciosed with the statement was a $86 debit memo for bank services. It had not been recorded because no previous notification had been recelved. 9. The October 31 cash recelpts, $4.874, were placed in the bank's night depository after banking hours on that date and this amount did not appear on the bank statement. Required: 1. Prepare a bank reconcillation for the company as of October 31,2023. MONTROSE COMPANY Bank Reconciliation October 31,2023 Prepare the General Journal entries necessary to bring the company's book balance of Cash into agreement with the reconciled lance. Journal entry worksheet 4 Record the collection of note less collection fee. Note: Enter debits before credits: 1 Record the collection of note less collection fee. 2 Record the NSF cheque. 3. Record the bank service charges. 4 Record to correct error in Cheque \#320