Data table BANK STATEMENT BANK OF TOMORROW 123 PETER PAN RD, KISSIMMEE, FL 34747 Billerica Associates 14 W Gadsden St Pensacola, FL 32501 BEGINNING BALANCE TOTAL DEPOSITS S 5,005 7,335 CHECKING ACCOUNT 136 213734 TOTAL WITHDRAWALS 6 860 SERVICE CHARGES 22 February 28, 2025 ENDING BALANCE $ 5.458 TRANSACTIONS DEPOSITS DATE AMOUNT Deposit Deposit EFT-Collection of note Deposit Interest 02/07 02/15 02/17 500 2.400 2,800 02/24 02/28 1,600 35 CHARGES Service Charge DATE AMOUNT 02/28 22 CHECKS Amount Number Number 102 101 Number 103 Amount Amount 550 2.900 1,700 DATE AMOUNT OTHER DEDUCTIONS EFT-EZ Rent NSF Check 02/01 02/13 410 1300 Print Done - X Data table Cash 5,005 550 Feb. 3 Beg. Bal. Feb. 6 500 2,900 Feb. 12 Feb. 15 2,400 1,700 Feb. 19 Feb. 23 1,600 900 Feb. 25 Feb. 28 2,300 500 Feb. 27 End. Bal. 5,255 Print Done Requirement 1. Prepare the bank reconciliation of Billerica Associates at February 28, 2025. Prepare the bank portion of the reconciliation followed by the book portion of the reconciliation Billerica Associates Bank Reconciliation February 28, 2025 Bank: Add: Less Books: NILI Add Less Requirement 2. Journalize the entries based on the bank reconciliation (Record debits first, then credits. Select the expl Begin with the EFT collection of the note Review the bank reconciliation Date Accounts and Explanation Debit Credit Feb. 28 Journalize the interest earned on the company's cash balance Review the bank reconciliation Date Accounts and Explanation Debit Credit Feb. 28 Journalize the service charge. Review the bank reconciliation Date Accounts and Explanation Debit Credit Feb. 28 Journalize the NSF check returned from a customer Review the bank reconciliation Date Accounts and Explanation Debit Credit Feb 28 Journalize the EFT payment to EZ rent Review the bank reconciliation Date Accounts and Explanation Feb. 28 Debit Credit