50.1K

Verified Solution

Link Copied!

I appreciate the help, thank you

Data table Cash Receipts Cash Payments Date Cash Debit Check No. Cash Credit Dec. 4 $ 4,250 1416 $ 840 9 530 1417 220 14 560 1418 730 17 1,950 1419 680 31 1,880 1420 1,470 1421 800 1422 670 Print Done Data table Bank Statement for December Beginning Balance 14,000 Deposits and other Credits: Dec. 1 EFT $ 150 Dec. 5 4,250 Dec. 10 530 Dec. 15 560 Dec. 18 1,950 1,200 BC 8,640 NSF 100 840 Dec. 22 Checks and other Debits: Dec. 8 Dec. 11 (check no. 1416) Dec. 19 Dec. 22 (check no. 1417) Dec. 29 (check no. 1418) Dec. 31 (check no. 1419) Dec 31 EFT 1,000 220 730 860 SC 40 (3.790) $ Ending Balance 18,850 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,200 bank collection was for a note receivable. d. The correct amount of check no. 1419, for rent expense, is $860. Devin's controller mistakenly recorded the check for $680. Print Done * The December cash records of Devin Insurance follow: (Click the icon to view the checkbook.) Devin's Cash account shows a balance of $17.760 at December 31. On December 31, Devin Insurance received the following bank statement: Click the icon to view the December bank statement.) Requirement 1. Prepare the bank reconciliation of Devin Insurance at December 31, 2024. Prepare the bank portion of the reconciliation, followed by the book portion of the reconciliation Devin Insurance Bank Reconciliation December 31, 2024 Bank: ADD: LESS: Books: ADD Bank: ADD: LESS: Books: ADD: 11 LESS: Requirement 2. Journalize any required entries from the bank reconciliation (Record debits first, then credits. Select the explanation on the last line of the journal entry table) Begin with the EFT collection Accounts and Explanation Debit Dec. 31 Date Credit Journalize the collection of the note Date Accounts and Explanation Debit Credit Dec 31 Journalize the NSF check. Date Accounts and Explanation Debit Credit Dec. 31 Journalize the EFT payment. Date Accounts and Explanation Debit Credit Dec. 31 Journalize the service charge. Date Accounts and Explanation Debit Credit Dec. 31 Journalize the entry to correct the error. Date Accounts and Explanation Debit Credit Dec. 31

Answer & Explanation Solved by verified expert

See Answer