Spottify Electronics had a computer failure on October 1, 2017, that resulted in the loss of data,

Question:

Spottify Electronics had a computer failure on October 1, 2017, that resulted in the loss of data, including the balance of its Cash account and its bank reconciliation from September 30, 2017. The accountant, Matt Vincent, has been able to obtain the following information from the records of the company and its bank:
a. An examination showed that two cheques (#244 for $305.00 and #266 for $632.50) had not been cashed as of October 1. Vincent 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 2017:

c. The company's bank provided the following statement as of October 31, 2017:

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 Auto Parts.
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.
Required
1. Prepare a bank reconciliation as of October 31, 2017, including the calculation of the book balance of October 31, 2017.
2. Prepare all journal entries that would be required by the bank reconciliation.