Connors Limiteds ledger showed a cash balance of $15,330 on October 31, 2021. In preparing the bank reconciliation, the following information was determined:

• The balance on the bank statement was $14,860

• EFT collection by the bank from a tenant for rent of $1,200

• A deposit in transit for the amount of $1,800 for October 31^st was not recorded in the bank statement

• Cheque 273 for $1,720 and cheque 275 for $680 were outstanding on October 31^st.

• An NSF cheque in the amount of $780 from a credit customer was included in the October bank statement.

• Interest and bank charges for October were $50

• A cheque for utilities expense in the amount of $1,600 was mistakenly recorded as $160 in the books.

Required:

1. Prepare Connors Bank reconciliation for the month of October.

2. Prepare the journal entries to update the cash.