Homework: Chapter 7 Problems Score: 0 of 6 pts P7-27A (similar to) 2 of 2 (1 complete) Additional data for the bank reconciliation (Click the icon to view the additional in The December cash records of Harvey Insurance follow (Click the icon to view the checkbook) Harvey's Cash account shows a balance of 516,770 at December 31. On December 31, Harvey Insurance received the following bank statement (Click the icon to view the December bank statement) Read the requirements Requirement 1. Prepare the bank reconciliation of Harvey Insurance at December 31, 2018 Prepare the bank portion of the reconciliation followed by the book portion of the reconciliation Harvey Insurance Bank Reconciliation December 31, 2018 Balance, December 31, 2018 ADD Deposit in transit LESS Outstanding checks Choose any ist enter any number the input felds and then dick Check Read the reque . Data Table Cash Payments Check No. Cash Credit 1416 860 Cash Receipts Date Cash Debit Dec. 4 $ 4.150 500 540 2 200 1417 1418 1419 1.820 1420 1421 1422 Print Done Data Table 13,700 Bank Statement for December Beginning Balance Deposits and other Credits: Dec. 1 EFT $ 300 Dec. 5 4,150 Dec. 10 500 Dec. 15 540 Dec. 18 2.200 Dec. 22 2.400 Checks and other Debits: Dec NSF Dec 11 (check no. 1416) Dec 19 EFT 700 22 (check no 1417) 29 (check no. 1418) 730 Dec 31 (check no 1419) 1940 Dec 31 SC 30 Ending Balance Dec (5.230) 18,260 Print Done 31, 2018 conciliation i 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 $2,100 bank collection was for a note receivable. d. The correct amount of check no. 1419, for rent expense, is $1,940. Harvey's controller mistakenly recorded the check for $1,490. Print Done = 31, 2018 econciliation Requirements 1. Prepare the bank reconciliation of Harvey Insurance at December 31, 2018. 2. Journalize any required entries from the bank reconciliation. Print Done