25A Preparing a bank reconciliation and journal entries The December cash records of Duaffy Insurance follow Internal Control and Cash 413 P7-25A P Learning Objective 5 Cash Receipts 1. Adjsted Balance $17,010 Cash Payments Date Cash Debit Check No. Cash Credit Dec. 4 4190 510 550 2,150 1,830 1416 1417 1418 1419 1420 1421 1422 840 170 680 1,190 470 1,200 630 31 Duffy's Cash account shows a balance of $17,050 at December 31. On December 31, Duffy Insurance received the following bank statement Beginning Balance Ceposits and other Credt 5 14,000 400 4,190 510 Dec. 1 Dec. 5 Dec 10 Dec 15 Dec. 18 Dec 22 8 1,6009,400 BC 1,600 Checks and other Debits Dec 8 Dec. 11 (check no. 1416 Dec. 19 Dec. 22 (check no. 1417) Dec. 29 icheck no. 1418 Dec. 31 (check no. 1419) Dec. 31 EFT 170 1,910 4,920) S 18,480 Sc Ending Balance Explanations: 8C-bank collection, EFT-electronic funds trarafer NSE-nonsufficient funds checks SC-service change Additional data for the bank reconciliation follow a. The EFT credit was a receipt of rent. The EFT debit was an insurance payment. b. The NSF check was received from a customer. c. The $1,600 bank collection was for a note receivable. d. The correct amount of check 1419, for rent axpense, is $1,910. Duffy's controller mistakenly recorded the check for $1,190