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 500 10 15 6,000 20 tel:10%20500%2015%206,000 25 26 31 EFT CC Youth Center' Interest Revenue 3,500 250 25 61,025 Checks and other debits Jan. 3 5 Ck# 100 Ck# 103 250 2,000 5,000 1,000 4,000 750 500 50 7 Ck# 102 Ck# 105 10 15 Ck# 106 Ck# 104 20 EFT to CC Utilities? Bank service charge Ending balance, January 31, 2021 25 31 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.

College Accounting (Book Only): A Career Approach
13th Edition
ISBN:9781337280570
Author:Scott, Cathy J.
Publisher:Scott, Cathy J.
Chapter6: Bank Accounts, Cash Funds, And Internal Controls
Section: Chapter Questions
Problem 5PB
icon
Related questions
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 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
Deposits and other credits
Jan. 2
$ 50,000
500
10
15
20
6,000
tel:10%20500%2015%206,000
25
3,500
250
26
EFT CC Youth Center'
31
Interest Revenue
25
61,025
Checks and other debits
Jan. 3
Ck# 100
250
Ck# 103
Ck# 102
2,000
5,000
1,000
4,000
750
5
7
10
Ck# 105
15
Ck# 106
20
Ck# 104
EFT to CC Utilities?
Bank service charge
Ending balance, January 31, 2021
25
500
31
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.
%24
Transcribed Image Text: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 Deposits and other credits Jan. 2 $ 50,000 500 10 15 20 6,000 tel:10%20500%2015%206,000 25 3,500 250 26 EFT CC Youth Center' 31 Interest Revenue 25 61,025 Checks and other debits Jan. 3 Ck# 100 250 Ck# 103 Ck# 102 2,000 5,000 1,000 4,000 750 5 7 10 Ck# 105 15 Ck# 106 20 Ck# 104 EFT to CC Utilities? Bank service charge Ending balance, January 31, 2021 25 500 31 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. %24
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Bank reconciliation statement
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
College Accounting (Book Only): A Career Approach
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781337280570
Author:
Scott, Cathy J.
Publisher:
South-Western College Pub
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Century 21 Accounting General Journal
Century 21 Accounting General Journal
Accounting
ISBN:
9781337680059
Author:
Gilbertson
Publisher:
Cengage
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Century 21 Accounting Multicolumn Journal
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage