Question 3 Question 4 Requirement 1. Prepare the bank reconciliation of Duffy Insurance at December 31, 2023 In this step, prepare the bank portion of the reconciliation. Then, complete the book portion of the reconciliation in the next step Duffy Insurance Bank Reconciliation December 31, 2023 O Question 5 Bank: O Question 6 ADD Cash records LESS Addtional data Bank Statement Bank Statement for December Beginning Total Total Balance Deposits Withdrawals $ 14,000 9,170 Service Charges Ending Balance 4,395 Transactions 8 $ 18,767 Deposits Date Amount EFT 12/01 500 Deposit 12/05 4,210 Deposit 12/10 470 Deposit 12/15 590 - Deposit 12/18 2,100 BC 12/22 1,300 Cash Receipts Date Cash Debit Cheque No. Cash Payments Cash Credit a. The EFT credit was a receipt of rent. The EFT debit was an insurance payment. b. The NSF cheque was received from a customer. Charges Service Charge Date Amount 12/31 8 c. The $1,300 bank collection (BC) was for a note receivable December 4 $ 4,210 1416 $ 790 d. The correct amount of cheque #1419, for rent expense, is $1,920. Duffy's controller mistakenly recorded the cheque for $1,290. Cheques December 9 470 1417 190 Number Amount Number Amount December 14 590 1418 570 1416 790 1418 December 17 2,100 1419 1,290 1417 190 1419 570 1,920 December 31 1,800 1420 1,510 Print Done 1421 740 1422 620 Print Done