Question: 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

Cumberland City Cycles, Inc. opened a checking
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 Beginning Balance, January 31 $ 0 Deposits and other credits Jan. 2 $ 50,000 10 500 15 6,000 20 750 25 3,500 26 EFT CC Youth Center 250 31 Interest Revenue 25 61,025 Checks and other debits Jan. 3 Ck# 100 250 5 Ck# 103 2,000 7 Ck# 102 5,000 10 Ck# 105 1,000 15 Ck# 106 4,000 20 Ck# 104 750 25 EFT to CC Utilities? 500 31 Bank service charge 50 13.550 Ending balance, January 31, 2021 $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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!