The following is information for Dundee Realty:

1. Balance per the bank statement dated October 31, 2023, is $25,330.
2. Balance of the Cash account on the company books as of October 31, 2023, is $5,535.
3. $14,600 of customer deposits were outstanding as of September 30; this amount had been deposited to Dundees account in October.
4. Cheques written in October that had not cleared the bank as of October 31 were: #8700, $945 #8709, $12,520 #8801, $540 #8815, $137.
5. The bank charged Dundees account for a $2,310 cheque of the E-Zone Networks; the cheque was found among the cancelled cheques returned with the bank statement.
6. Bank service charges for October amount to $57.
7. A customers cheque (Teresa Krant) for $4,060 had been deposited in the bank correctly but was recorded in the accounting records as $4,600.
8. Among the cancelled cheques is one for $450 given in payment of an account payable to Decker Company; the bookkeeper had recorded the cheque incorrectly at $540 in the company records.
9. The bank statement showed an electronic fund transfer of $21,890 for a customer payment. A bank service fee of $90 was charged.
10. A bank deposit of October 31 for $13,330 does not appear on the bank statement.

Required: 1. Prepare a bank reconciliation statement as of October 31, 2023.

2. Prepare the necessary entries to make the Cash account agree with the bank reconciliation adjusted Cash balance as of October 31.