Question: Oscar's Red Carpet Store maintains a checking account with Academy Bank. Oscar's sells carpet each day but makes bank deposits only once per week. The




Oscar's Red Carpet Store maintains a checking account with Academy Bank. Oscar'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, 2021. Date 2/4 Deposits: Date Amount $1,700 Checks: No. 321 2/2 Amount $3,700 1,300 322 2/8 400 2,200 323 2/12 1,500 324 2/19 1,200 Cash receipts: 3,100 600 325 2/27 200 $ 8,900 326 2/28 700 327 2/28 900 $ 5,800 $8,600 Balance on February 1 Receipts Disbursements 8,900 (8,600) Balance on February 28 $ 6,100 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 $8,230. b. Cash receipts of $600 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 $200 that did not clear the bank (NSF check). e. Check 323 was written for $2,500 for advertising in February. The bank properly recorded the check for this amount. f. An automatic withdrawal for Oscar's February rent was made on February 4 for $1,300. A g. Oscar's checking account earns interest based on the average daily balance. The amount of interest earned for February is $100. h. In January, one of Oscar's suppliers, Titanic Fabrics, borrowed $4,000 from Oscar. On February 24, Titanic paid $4.150 ($4,000 borrowed amount plus $150 interest) directly to Academy Bank in payment for January's borrowing. 1. Academy Bank charged service fees of $120 to Oscar's for the month. 2/11 2/18 2/25 2/26-2/28 Required: 1. Prepare a bank reconciliation for Oscar's checking account on February 28, 2021. (Amounts to be deducted should be indicated with a minus sign. Total entries to the same account together when entering in the bank reconciliation.) OSCAR'S RED CARPET STORE Bank Reconciliation February 28, 2021 Bank's Cash Balance Company's Cash Balance Per bank statement Deposits outstanding. Checks outstanding Bank balance per reconciliation Per general ledger Company error EFT for rent Interest on account Interest on note Note collected NSF check Service fees Company balance per reconciliation 4 View transaction list Journal entry worksheet
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
