I need help completing this

Additional data: Beverly deposits all cash receipts in the bank and makes all payments by che The Cash account of Beverly Associates at February 28, 2019, follows: (Click the icon to view the Cash account.) Beverly Associates received the following bank statemente E: (Click the icon to view the February bank statement.) Data Table Requirement 1. Prepare the bank reconciliation of Beverly Prepare the bank portion of the reconciliation, followed by Cash Beg. Bal. 200 Feb. 3 Beverly Associates Bank Reconciliation February 28, 2019 Feb. 6 Feb. 15 Feb. 23 4,115 1,300 1,600 1,900 2,500 5,515 2,200 Feb. 12 1,700 Feb. 19 800 Feb. 25 1,000 Feb. 27 Bank: Balance, February 28, 2019 Feb. 28 Add: Deposit in transit End. Bal. Less: Print Outstanding checks issued on February 25 Print Done Done Choose from any list or enter any number in the input fields and then continue to the next question. 1 Data Table BANK STATEMENT CHECKING ACCOUNT 136-213734 BANK OF TOMORROW 123 PETER PAN RD, KISSIMMEE, FL 34747 Beverly Associates 14 W Gadsden St Pensacola, FL 32501 BEGINNING BALANCE TOTAL DEPOSITS $ 4,115 6,645 SERVICE CHARGES TOTAL WITHDRAWALS 6,010 TRANSACTIONS February 28, 2019 ENDING BALANCE $ 4,745 DEPOSITS Deposit DATE 02/07 02/15 02/17 02/24 AMOUNT 1,300 1,600 Deposit EFTCollection of note 1,800 Deposit 1,900 Print Print Done Done] Data Table Dupont VGI TO EFTCollection of note 02/17 1,800 Deposit 02/24 1,900 Interest 02/28 45 CHARGES DATE AMOUNT Service Charge 02/28 CHECKS Number Amount Number Amount Number Amount 102 200 103 1,700 101 2.200 OTHER DEDUCTIONS DATE AMOUNT Data Table interest UZI20 CHARGES DATE AMOUNT Service Charge 02/28 CHECKS Number Amount Number Amount ver Number Amount 102 200 101 2,200 103 1,700 OTHER DEDUCTIONS AMOUNT DATE 02/01 410 EFTEZ Rent NSF Check 02/13 1,500 Print Done Bank Reconciliation February 28, 2019 Bank: Balance, February 28, 2019 4745 Add: Deposit in transit 2500 7245 Less: Outstanding checks issued on February 25 issued on February 27 Adjusted bank balance, February 28, 2019 Books: Balance, February 28, 2019 Books: Balance, February 28, 2019 Add: Bank collection of note receivable Interest revenue earned on bank balance Less: Service charge NSF check EFTRent expense | Adjusted book balance, February 28, 2019 Requirement 2. Journalize the entries based on 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 of the