Baylor Company Bank Reconciliation October 31, 2017 $19,687.60 Book balance.. $45,548.66 Bank statement balance Add: Deposit of Oct. 31 in transit.... 4.280.45 $23.968.05 Deduct: Outstanding cheques: #537 #542 Adjusted bank balance $ 725,00 2.965.34 Deduct: NSF cheque plus service charge... Bank service charges.. Adjusted book balance 3.690.34 $20.277.71 $25.140.95 130.00 25.270.95 $20.277.71 The Cash account in the general ledger appeared as follows on November 30 (Baylor Company uses only a general journal to record transactions): Explanation PR Cash Debit Credit Acct. No. 101 Balance Date 2017 Oct. 31 Nov. 1 1 1 1 1 1 1 9 9 Balance Cheque #543 Cheque #544 Cheque #545 Cheque #546 Cheque #547 Cheque #548 Cheque #549 Deposit Cheque #550 Cheque #551 Deposit Cheque #552 Cheque #553 Deposit GJ5 GJ5 GJ5 GJ5 GJ5 GJ6 GJ6 GJ6 GJ6 GJ6 GJ6 GJ6 6.505.12 854.71 1.156.94 2.564.24 1,345.68 56.45 564.23 20.277.71 13.772.59 12.917.88 11.760.94 4.196.70 7.851.02 7.794.57 7,230.34 8.779.31 5.322.16 4,336.52 4.986.37 4.429.66 3.465.41 4.716.06 1.548.97 3.457.15 985.64 5,649.85 9 18 20 27 5,556.71 964.25 GJ6 29 GJ6 1.250.65 The following bank statement is available for November 2017: Bank Statement To: Baylor Company November 30, 2017 Bank of Canada Cheques/Charges Deposits/Credits Balance 9,200 #543 11/02 6,505.12 16.898.70 #549 11/01 564.23 11/01 4.280.45 23.403.82 #537 11/07 725.00 16.173.70 #551 11/04 985.64 11/09 1.584.97 16.773.03 #542 11/12 2.965.34 13.807.69 #544 11/14 854.71 12.952.98 #547 11/18 3.145.68 11/18 5.649.85 15.457.15 #545 11/20 1.156.94 14.300.21 #546 11/29 2.564.24 11.735.97 SC 11/30 115.00 11/30 11,620.97 NSF = Not Sufficient SC = Service PMT = Principal INT = Interest Funds Charge Payment Required a. Prepare a bank reconciliation for Baylor Company for the month of November 2017. Assume that any errors made were by the bookkeeper (cheque #547 was for advertising expense; the deposit of November 9 was regarding a credit customer, Val Pacino). b. Prepare the necessary entries resulting from the bank reconciliation