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
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
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
None
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education