P$7\mathrm{.}7$B $($LO $4)$ AP On October $31,2024,$ Charlie Company had a cash balance per books of $$12,300.$ The statement from Canada Bank on that date showed a balance of $$13,134.$ A comparison of the bank statement with the Cash account revealed the following facts:

The bank service charge for October was $$55.$

The bank collected $$2,350$ of rental revenue for Charlie Company through electronic funds transfer.

The $$5,380$ deposited by the company in a night deposit vault on September $30$ was not included in the September bank statement. This amount was included in the October statement.

The October $31$ receipts of $$2,467$ were not included in the bank deposits for October. These receipts were deposited by the company in a night deposit vault on October $31.$

Company cheque No$.331$ issued to J$.$ Johnson, a creditor, for $$221$ that cleared the bank in October was incorrectly entered in the books as a cash payment on October $12$ for $$112.$

Cash sales of $$525$ on October $12$ were deposited in the bank. The journal entry to record the cash receipt and the deposit slip were incorrectly made out and recorded by the bookkeeper as $$225.$ The bank detected the error on the deposit slip and credited Charlie Company for the correct amount.

Cheques #$335$ for $$1,050,$ #$336$ for $$435,$ #$338$ for $$121,$ and #$343$ for $$584$ were outstanding on October $31.$

On October $31,$ the bank statement showed an NSF charge of $$575$ for a cheque received by the company from R$.$ Mahomes, on account. This included a $$50$ service charge. The company policy is to charge this amount back to the customer.

Payment of the monthly insurance was made using a monthly scheduled EFT payment for $$800$ that the bookkeeper forgot to record.

Instructions

a$.$ Prepare the bank reconciliation as at October $31.$

i$.$ Frepare tho necessary entries related to the bank reconciliation at October $31.$