help with companys cash balance

Banowetz Flooring has a checking account with American Trust Bank For the month ending February 28, 2021, Banowetz's cash ledger is as follows: Deposits: Date 2/4 2/11 2/18 2/25 2/26-2/28 Amount $ 2,600 Checks: 2,2ee 3,100 4,000 1,5ee $ 13,400 No. 321 322 32 324 325 326 327 Date 2/2 2/8 2/12 2/19 2/27 2/28 2/28 Cash receipts: Amount $ 4,600 650 2,400 2,100 450 950 1,800 $12,950 Balance on February 1 Receipts Disbursements Balance on February 28 $ 6,709 13,400 (12,950) $ 7,150 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 $11.770 b. Cash receipts of $1,500 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 $450 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 1. An automatic withdrawal for Banowetz's February rent was made on February 4 for $1,300 g. Banowetz's checking account earns interest based on the average daily balance. The amount of interest earned for February is $190 hIn January, one of Banowetz suppliers, Floor Show, borrowed $5,800 from Banowetz on February 24, Floor Show pald $5,950 ($5,800 borrowed amount plus $150 interest) directly to American Trust Bank in payment for January's borrowing 1. American Trust Bank charged service fees of $120 to Banowetz for the month Required: 1. Prepare a bank reconciliation for Banowetz'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.) BANOWETZ FLOORING FLOORING onciliation 28, 2021 Company's Cash Balance er general ledger NSF check Company error EFT for rent $ 7,150 Interest on account 190 Note collected Interest on note 150 Service fees Company balance per reconciliation $ 11,020