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

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education