the 1st pictrue is the pictrue of the problem and pictrues 2-4 is the problem template. please help

Problem 4 Chapter 7 Cumberland City Cycles, Inc. opened a checking account at First City Bank when it opened on January 1, 2021. It is preparing the bank reconciliation on January 31, 2021, for the first month of operations. The bank statement, dated January 31, 2021, is below: First City Bank Cumberland City January 31, 2021 0 Beginning Balance, January 31 Deposits and other credits Jan. 2 10 15 20 25 $ 50,000 500 6,000 750 3,500 250 25 26 EFT CC Youth Center Interest Revenue 31 61,025 Checks and other debits Jan. 3 Ck# 100 5 CK# 103 7 Ck# 102 10 Ck# 105 15 Ck# 106 20 Ck# 104 25 EFT to CC Utilities 31 Bank service charge Ending balance, January 31, 2021 250 2,000 5,000 1,000 4,000 750 500 50 13.550 $47.475 On the Excel worksheet are the T-accounts for Cash and other accounts need to record the bank reconciliation. Also, the format for the bank reconciliation is provided. Complete the bank reconciliation, using formulas when possible. This EFT from CC Youth Center is a receipt from a customer making a payment on account. This is the company's only accounts receivable, This EFT to CC Ulities is for January utility expenses. This is first utilities expense payment fx | B D E F Cumberland City Cycles, Inc. 2-Jan 10-Jan 15-Jan 20-Jan 25-Jan Cash--First City Bank 50,000 500 250 Ck# 100 6,000 850 Ck# 101 750 5,000 Ck# 102 3,500 2,000 Ck# 103 4,000 750 Ck# 104 1,000 Ck# 105 4,000 Ck# 106 450 ck# 107 31-Jan 50,450 Interest Revenue Utilities Expense 500 250 2350 Bank Charge Expense Accounts Receivable 400 M N O P Q R s Cumberland City Cydes, Inc Bank Reconciliation 31-Jan-21 Bank: Balance, January 31, 2021 Add: 47,475 Deduct: Adjusted Bank Balance Books: Balance, january 31, 2021 Add 50,450 Deduct Ad usted Book Balance anuary 31 2021