1.11 points Problem 4-2A (Algo) Prepare the bank reconcillation and record cash adjustments (LO4-5) Wilbur's Red Carpet Store maintains a checking account with Academy Bank. Wilbur's sells carpet each day but makes bank deposits only once per week. The following provides Information from the company's cash ledger for the month ending February 28, 2024. Skipped Date Number Date Amount Deposits: 2/4 $2,300 Checks: 323 2/12 $2,100 2/11 1,900 324 2/19 1,800 2/18 2,800 325 2/27 400 2/25 3.788 1326 2/28 900 eBook Cash receipts: 2/26-2/28 1,200 1327 2/28 1,500 $11,900 $6,700 Amount Ask Balance on February 1 Receipts $6,400 11,900 Disbursements (6,700) Print Balance on February 28 $11,600 이 References Information from February's bank statement and company records reveals the following additional Information: a. The ending cash balance recorded in the bank statement is $9.960. b. Cash receipts of $1,200 from 2/26-2/28 are outstanding c. Checks 325 and 327 are outstanding. d. The deposit on 2/11 Includes a customer's check for $400 that did not clear the bank (NSF check). e. Check 323 was written for $2,800 for advertising in February. The bank properly recorded the check for this amount. f An EFT withdrawal for Wilbur's February rent was made on February 4 for $1,300. g. Debit card transactions Include $4.730 for legal fees expense and $400 for entertainment expense. h. In January, one of Wilbur's suppliers, Titanic Fabrics, borrowed $5,200 from Wilbur On February 24. Titanic paid $5,350 ($5.200 borrowed amount plus $150 Interest) directly to Academy Bank In payment for January's borrowing. 1. Academy Bank charged service fees of $160 to Wilbur's for the month. Required: 1. Prepare a bank reconciliation for Wilbur's checking account on February 28, 2024 2. Record the necessary cash adjustments. Complete this question by entering your answers in the tabs below. Required I Required 2 Prepare a bank reconciliation for Wilbur's checking account on February 28, 2024. (Amounts to be deducted should be indicated with a minus sign.) WILBUR'S RED CARPET STORE Bank Reconciliation February 28, 2024 Bank's Cash Balance Per bank statement Company's Cash Balance Per general ledger Bank balance per reconciliation Company balance per reconciliation

Survey of Accounting (Accounting I)
8th Edition
ISBN:9781305961883
Author:Carl Warren
Publisher:Carl Warren
Chapter5: Internal Control And Cash
Section: Chapter Questions
Problem 5.4.3P
icon
Related questions
Question
None
1.11
points
Problem 4-2A (Algo) Prepare the bank reconcillation and record cash adjustments (LO4-5)
Wilbur's Red Carpet Store maintains a checking account with Academy Bank. Wilbur's sells carpet each day but makes bank deposits
only once per week. The following provides Information from the company's cash ledger for the month ending February 28, 2024.
Skipped
Date
Number
Date
Amount
Deposits:
2/4
$2,300
Checks:
323
2/12
$2,100
2/11
1,900
324
2/19
1,800
2/18
2,800
325
2/27
400
2/25
3.788
1326
2/28
900
eBook
Cash receipts:
2/26-2/28
1,200
1327
2/28
1,500
$11,900
$6,700
Amount
Ask
Balance on February 1
Receipts
$6,400
11,900
Disbursements
(6,700)
Print
Balance on February 28
$11,600
이
References
Information from February's bank statement and company records reveals the following additional Information:
a. The ending cash balance recorded in the bank statement is $9.960.
b. Cash receipts of $1,200 from 2/26-2/28 are outstanding
c. Checks 325 and 327 are outstanding.
d. The deposit on 2/11 Includes a customer's check for $400 that did not clear the bank (NSF check).
e. Check 323 was written for $2,800 for advertising in February. The bank properly recorded the check for this amount.
f An EFT withdrawal for Wilbur's February rent was made on February 4 for $1,300.
g. Debit card transactions Include $4.730 for legal fees expense and $400 for entertainment expense.
h. In January, one of Wilbur's suppliers, Titanic Fabrics, borrowed $5,200 from Wilbur On February 24. Titanic paid $5,350 ($5.200
borrowed amount plus $150 Interest) directly to Academy Bank In payment for January's borrowing.
1. Academy Bank charged service fees of $160 to Wilbur's for the month.
Required:
1. Prepare a bank reconciliation for Wilbur's checking account on February 28, 2024
2. Record the necessary cash adjustments.
Complete this question by entering your answers in the tabs below.
Required I Required 2
Prepare a bank reconciliation for Wilbur's checking account on February 28, 2024. (Amounts to be deducted should be
indicated with a minus sign.)
WILBUR'S RED CARPET STORE
Bank Reconciliation
February 28, 2024
Bank's Cash Balance
Per bank statement
Company's Cash Balance
Per general ledger
Bank balance per reconciliation
Company balance per reconciliation
Transcribed Image Text:1.11 points Problem 4-2A (Algo) Prepare the bank reconcillation and record cash adjustments (LO4-5) Wilbur's Red Carpet Store maintains a checking account with Academy Bank. Wilbur's sells carpet each day but makes bank deposits only once per week. The following provides Information from the company's cash ledger for the month ending February 28, 2024. Skipped Date Number Date Amount Deposits: 2/4 $2,300 Checks: 323 2/12 $2,100 2/11 1,900 324 2/19 1,800 2/18 2,800 325 2/27 400 2/25 3.788 1326 2/28 900 eBook Cash receipts: 2/26-2/28 1,200 1327 2/28 1,500 $11,900 $6,700 Amount Ask Balance on February 1 Receipts $6,400 11,900 Disbursements (6,700) Print Balance on February 28 $11,600 이 References Information from February's bank statement and company records reveals the following additional Information: a. The ending cash balance recorded in the bank statement is $9.960. b. Cash receipts of $1,200 from 2/26-2/28 are outstanding c. Checks 325 and 327 are outstanding. d. The deposit on 2/11 Includes a customer's check for $400 that did not clear the bank (NSF check). e. Check 323 was written for $2,800 for advertising in February. The bank properly recorded the check for this amount. f An EFT withdrawal for Wilbur's February rent was made on February 4 for $1,300. g. Debit card transactions Include $4.730 for legal fees expense and $400 for entertainment expense. h. In January, one of Wilbur's suppliers, Titanic Fabrics, borrowed $5,200 from Wilbur On February 24. Titanic paid $5,350 ($5.200 borrowed amount plus $150 Interest) directly to Academy Bank In payment for January's borrowing. 1. Academy Bank charged service fees of $160 to Wilbur's for the month. Required: 1. Prepare a bank reconciliation for Wilbur's checking account on February 28, 2024 2. Record the necessary cash adjustments. Complete this question by entering your answers in the tabs below. Required I Required 2 Prepare a bank reconciliation for Wilbur's checking account on February 28, 2024. (Amounts to be deducted should be indicated with a minus sign.) WILBUR'S RED CARPET STORE Bank Reconciliation February 28, 2024 Bank's Cash Balance Per bank statement Company's Cash Balance Per general ledger Bank balance per reconciliation Company balance per reconciliation
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
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
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
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Century 21 Accounting Multicolumn Journal
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage