The December cash records of Buffy Insurance follow: Click the icon to view the checkbook.) Bully's Cash account shows a balance of $15,620 at December 31. On December 31, Buffy Insurance received the following bank statement: Click the icon to view the December bank statement.) Requirement 1. Prepare the bank reconciliation of Buffy insurance at December 31, 2024. Prepare the bank portion of the reconciliation, followed by the book portion of the reconciliation Buffy Insurance Bank Reconciliation December 31, 2024 Bank: ADD LESS Requirement 1. Prepare the bank reconciliation of Buffy Insurance at Decembe Prepare the bank portion of the reconciliation, followed by the book portion of the Buffy Insurance Bank Reconciliation December 31, 2024 Bank: Adjusted bank balance, December 31, 2024 Adjusted book balance, December 31, 2024 Balance, December 31, 2024 The December cash records of Buffy Insurance follow: (Click the icon to view the checkbook.) Buffy's Cash account shows a balance of $15,620 at December 31. On De Click the icon to view the December bank statement) Requirement 1. Prepare the bank reconciliation of Buffy Insurance at Decem Prepare the bank portion of the reconciliation, followed by the book portion o Buffy Insurance Bank Reconciliation December 31, 2024 Bank: ADD: LESS Bank collection of note receivable Correction of bank error Correction of book error Deposit in transit EFT collection of rent EFT payment of insurance NSF check Outstanding checks Service charge Buffy Insurance Bank Reconciliation December 31, 2024 Bank: ADD: LESS: Bank collection of note receivable Correction of bank error Correction of book error Deposit in transit EFT collection of rent EFT payment of insurance NSF check Outstanding checks Service charge Requirement 1. Prepare the bank reconciliation of Buffy Insurance at December 31, 2024. Prepare the bank portion of the reconciliation, followed by the book portion of the reconciliation. Buffy Insurance Bank Reconciliation December 31, 2024 Bank: ADD: LESS: 1416 1417 1418 1419 1420 1421 1422 Cequirement 1. Prepare the bank reconciliation of Buffy Insurance at Decem Prepare the bank portion of the reconciliation, followed by the book portion of Buffy Insurance Bank Reconciliation December 31, 2024 Bank: ADD: LESS: Adjusted bank balance, December 31, 2024 Adjusted book balance, December 31, 2024 Balance, December 31, 2024 Data table Cash Receipts Cash Payments Date Cash Debit Check No. Cash Credit Dec. 4 $ 4.190 1416 $ 800 9 480 1417 220 14 550 1418 660 17 2,000 1419 1,590 31 1,830 1420 1,420 1421 1.600 1422 640 Print Done * he Data table s 13,500 Bank Statement for December Beginning Balance $ Deposits and other Credits: Dec. 1 EFTIS 150 Dec 5 4,190 Dec. 10 480 Dec 15 550 Dec 18 2.000 Dec. 22 BC 1,300 Checks and other Debits: Dec 8 NSF 200 Doc. 11 (check no. 1416) 800 Dec 19 EFT 930 Dec 22 (check no. 1417) 220 Dec 29 (check no. 1418) 660 Dec 31 (check no. 1419) 1.950 Dec. 31 SC 45 8,670 (4.805) 17,365 Ending Balance Explanations: BC-bank collection, EFT-electronic funds transfer NSF-nonsufficient funds checks: SC-service charge Print Done More info 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,300 bank collection was for a note receivable. d. The correct amount of check no. 1419, for rent expense, is $1,950. Buffy's controller mistakenly recorded the check for $1,590. Print Done