he following is information for Dundee Realty:

1. Balance per the bank statement dated October 31, 2023, is $27,230.
2. Balance of the Cash account on the company books as of October 31, 2023, is $5,600.
3. $14,730 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, $990 #8709, $12,650 #8801, $670 #8815, $150.
5. The bank charged Dundees account for a $2,375 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 $70.
7. A customers cheque (Teresa Krant) for $8,050 had been deposited in the bank correctly but was recorded in the accounting records as $8,500.
8. Among the cancelled cheques is one for $240 given in payment of an account payable to Decker Company; the bookkeeper had recorded the cheque incorrectly at $420 in the company records.
9. The bank statement showed an electronic fund transfer of $23,430 for a customer payment. A bank service fee of $75 was charged.
10. A bank deposit of October 31 for $13,470 does not appear on the bank statement.

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