Spottity Electronics had a computer failure on October 1, 2020, which resulted in the loss of data, including the balance of its Cash account and its bank reconciliation from September 30, 2020 The accountant, Crisanto Danila, has been able to obtain the following information from the records of the company and its bank. (Click the icon to view records a-b.) (Click the icon to view records c-g.) Required 1. Prepare a bank reconciliation as of October 31, 2020, including the calculation of the book balance of October 31, 2020, 2. Prepare all journal entries that would be required by the bank reconciliation Requirement 1. Prepare a bank reconciliation as of October 31, 2020, including the calculation of the book balance of October 31, 2020 Prepare the bank section of the bank reconciliation. Then prepare the book section of the bank reconciliation (Use parentheses or a minus sign when subtracting numbers. Enter all amounts in two decimal places.) Spottify Electronics Bank Reconciliation October 31, 2020 BANK Add Less Cheque No Cheque No BOOKS Add Less Choose from any list or enter any number in the input fields and then continue to the next question. 1:23 PM 4x ENG 2020-12 required by the bank reconciliation BOOKS Add Less ooks Requirement 2. Prepare all journal entries that would be required by the bank reconciliation Record the collection of the note receivable and related interest (Record debits first, then credits. Exclude explanations from journal entries.) Journal Entry Date Accounts Debit Credit Oct Record the collection of the accounts receivable (Enter amounts to two decimal places.) Journal Entry Accounts Debit Date Credit Oct Record the NSF cheques. (Enter amounts to two decimal places.) Journal Entry Date Accounts Debit Credit Oct Record the insurance payment (Enter amounts to two decimal places.) Journal Entry Date Accounts Debit Credit Oct books Record the correction of the book error Journal Entry Date Accounts Debit Credit Oct Record the service charge assessed by the bank. (Enter amounts to two decimal places.) Journal Entry Date Accounts Debit Credit Oct oks Choose from any list or enter any number in the input fields and then continue to the next que i Records a-b. - X a. An examination showed that two cheques (#244 for $305.00 and #266 for $632.50) had not been cashed as of October 1. Danila recalled that there was only one deposit in transit on the September 30 bank reconciliation but was unable to recall the amount b. The cash receipts and cash payments journals contained the following entries for October 2020. Cash Receipts: Amounts 908.50 Cash Payments: Cheque# Amount 275 310.50 276 448.50 277 466.90 1,748.00 3,726.00 1,975.00 736.00 278 811.90 279 577.30 $ 9,093.50 280 281 3,886.90 void 488.50 1,058.00 282 283 $ 8,048.50 Print Done 17 EFT 529.00 6.686.10 19 EFT 414.00 7.100.10 22 #279 577.30 1,748.00 8,270.80 22 #280 3,976.90 EFT 1,196.00 5,489.90 24 EFT 471.50 5,961.40 27 NSF 805.00 3,726.00 8,882.40 28 SC 20.00 8,862.40 31 #283 1,058.00 1,975.00 9,779.40 d. The deposit made on October 14 was for the collection of a note receivable ($1,100.00) plus interest e. The electronic funds transfers (EFTs) had not yet been recorded by Spottify Electronics because the bank statement was the first notification of them The October 17 EFT was for the monthly payment on an insurance policy for Spottify Electronics The October 19 and 24 EFTs were collections on accounts receivable. The October 22 EFT was in error-the transfer should have been to Spottify Horse Farm. f. The NSF cheque on October 27 was received from a customer as payment for electronics purchased for $805.00 g. Cheque #280 was correctly written for $3,976.90 for the purchase of inventory (assume a periodic system) but incorrectly recorded by the cash payments clerk