Need help!

Data table

Jestion list Question 1 Question 2 Question 3 Requirements The December cash records of Davey Insurance follow (Click the icon to view the checkbook) Davey's Cash account shows a balance of S16,3S0 at December 31 On December 31 , Davey Insurance received the following bank statement: (Click the icon to view the December bank statement) Requirement 1. Prepare the bank reconciliation of Davey Insurance at December 31, 2024. Prepare the bank portion of the reconciliation, followed by the book portion of the reconciliation. Additional data for the bank reconciliation follow O (Click the icon to view the additional information.) Read the Leguirements_ Cash Payments Data table Bank Statement for December Bank: LESS: Davey Insurance Bank Reconciliation December 31, 2024 c:::::::::::::::::::::::::::::::::::::::z Beginning Balance Deposits and other Credits: Data table Cash Receipts Date Cash Debit Dec. Dec. Dec. Dec. Dec. Dec. Check No. 1416 1417 1418 1419 1420 1421 1422 Done Cash Credit 850 220 640 1,090 1,500 1,300 650 10 15 18 22 Dec. 4 S 9 14 17 31 4, 190 530 510 2,000 1,870 print Checks and other Debits: Dec. Dec. Dec. Dec. Dec. Dec. Dec. 11 (check no 19 22 (check no 29 (check no 31 (check no 31 1416) 1417) 1418) 1419) EFT NSF EFT sc s s 560 4,190 530 510 2,000 1,700 soo 850 475 220 640 1 ,900 25 13,500 9,480 (4,610) 18,370 Ending Balance 2. Prepare the bank reconciliation of Davey Insurance at December 31 , 2024. Journalize any required entries from the bank reconciliation. Explanations: SC-bank collection; EFT-electronic funds transfer; NSF-nonsufficient funds checks; SC-service charge print Done print Done