The following is information for Dundee Realty a. Balance per the bank statement dated October 31, 2023, is $28,234. b. Balance of the Cash account on the company books as of October 31, 2023, is $5,620. c. $14,770 of customer deposits were outstanding as of September 30, this amount had been deposited to Dundee's account in October d. Cheques written in October that had not cleared the bank as of October 31 were: #8700, $994 #8709, $12,690 #8801, $710 #8815, $154, e. The bank charged Dundee's account for a $2,395 cheque of the E-Zone Networks; the cheque was found among the cancelled cheques returned with the bank statement. f. Bank service charges for October amount to $74. g. A customer's cheque (Teresa Krant) for $8,020 had been deposited in the bank correctly but was recorded in the accounting records as $8,200 h. Among the cancelled cheques is one for $380 given in payment of an account payable to Decker Company, the bookkeeper had recorded the cheque incorrectly at $830 in the company records Activate Window h. Among the cancelled cheques is one for $380 given in payment of an account payable to Decker Company, the bookkeeper had recorded the cheque incorrectly at $830 in the company records. i. The bank statement showed an electronic fund transfer of $23,870 for a customer payment. A bank service fee of $95 was charged j. A bank deposit of October 31 for $13,510 does not appear on the bank statement. Required: 1. Prepare a bank reconciliation statement as of October 31, 2023. DUNDEE REALTY Bank Reconciliation October 31, 2023 Bank Statement Bank statement balance Add: Company's Books. Book balance Add: $ Deduct Deduct Outstanding cheques $ 0 Activate Windo Bank statement balance Add: Bank Statement DUNDEE REALTY Bank Reconciliation October 31, 2023 Book balance Add: Deduct: Outstanding cheques $ Deduct Company's Books $ 0 0 0 Adjusted bank balance Adjusted book balance. 2. Prepare the necessary entries to make the Cash account agree with the bank reconciliation adjusted Cash balance as of October 31. View transaction list Journal entry worksheet < 1 2 3 Record the collection of note less service charge expense. Note: Enter debits before credits. Date Oct 31 General Journal Debit Credit Activa Go to S The following is information for Dundee Realty a. Balance per the bank statement dated October 31, 2023, is $28,234 b. Balance of the Cash account on the company books as of October 31, 2023, is $5,620 c. $14,770 of customer deposits were outstanding as of September 30, this amount had been deposited to Dundee's account in October d. Cheques written in October that had not cleared the bank as of October 31 were #8700, $994 #8709, $12.690 #8801, $710 #8815, $154. e. The bank charged Dundee's account for a $2,395 cheque of the E-Zone Networks, the cheque was found among the cancelled cheques returned with the bank statement f. Bank service charges for October amount to $74. g. A customer's cheque (Teresa Krant) for $8,020 had been deposited in the bank correctly but was recorded in the accounting records as $8,200 h. Among the cancelled cheques is one for $380 given in payment of an account payable to Decker Company; the bookkeeper had recorded the cheque incorrectly at $830 in the company records The bank statement showed an electronic fund transfer of $23,870 for a customer payment. A bank service fee of $95 was charged J. A bank deposit of October 31 for $13,510 does not appear on the bank statement Required: 1. Prepare a bank reconciliation statement as of October 31, 2023. Bank Statement Bank statement balance Add: DUNDEE REALLY Blank Reconciation October 31, 2023 Book balance Add: Company's Books Deduct Outstanding cheques $ 0 Deduct: $ O Bank statement balance Add Deduct Outstanding cheques Bank Statement Plank Reconcha Ob 21, 2123 Book balance Add: $ Deduct Company's Books $ 0 0 Adjusted bank balance Adjusted book balance 2. Prepare the necessary entries to make the Cash account agree with the bank reconciliation adjusted Cash balance as of October 31 View transaction list Journal entry worksheet < 1 2 3 Record the October bank charges. Note: Enter debuts before credits Date Oct 31 General Journal Debit Credit Journal entry worksheet < 1 2 3 4 Record the October bank charges. Note: Enter debits before credits. Date Oct 31 General Journal Debit Credit Record entry Clear entry View general journal