Michael's Green Carpet Store maintains a checking account with Maroon Bank. Michael Selis 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 April 28, 2015. Date Amount Deposits: Checks: 54,700 400 2/4 2/11 2/18 2/25 2/26-2/28 Amount $ 2700 2,300 3,200 4,100 1,600 $13.900 No. 321 322 323 324 325 326 327 Date 2/2 2/8 2/12 2/19 2/27 2/28 2/28 Cash receipts: 2,500 2,200 200 700 1.400 $12,600 Balance on February 1 Receipts Disbursements Balance on Fabruary 28 $ 6,800 13,900 (12,600 $ 8.100 Information from April's bank statement and company records reveals the following additional information: 1. The ending cash balance recorded in the bank statement is $13,325. 2. Cash receipts of $1,600 from 2/26-2/28 are outstanding. 3. Checks 325 and 327 are outstanding. 4. The deposit on 2/11 includes a customer's check for $200 that did not clear the bank (NSF check). 5. Check 323 was written for $2,800 for advertising in April. The bank properly recorded the check for this amount. However, the company recorded a different amount. 6. An automatic withdrawal for Michael's April rent was made on April 4 for $1,100. 7. Michael's checking account earns interest based on the average daily balance. The amount of interest earned for April is $200. 8. In January one of Michael's suppliers, Titanic Fabrics, borrowed $6,000 from Oscar and signed a note. On April 24, Titanic paid $6,250 ($6,000 borrowed amount plus $250 interest) directly to Maroon Bank in payment for January's borrowing. 9. Maroon Bank charged the following service fees to Michael's: $60 for NSF check, $15 for automatic withdrawal for rent payment, and $50 for collection of the loan amount from Titanic. 10. Bank charged Michael's account $600 for a check that belonged to another customer. DAN NECUNCILIATION WORKSHEET CLOSING BALANCE SHOWN ON BANK STATEMENT AMOUNTS RECONCILING ITEMS DESCRIPTION ADJUSTED BANK BALANCE AMOUNTS BOOK BALANCE AS OF RECONCILING ITEMS DESCRIPTION ADJUSTED BANK BALANCE Chart of accounts 101 102 103 200 300 400 401 500 501 502 503 504 Cash Accounts receivable Notes receivable Accounts payable Capital Sales Interest income advertising expense service fee expense Rent expense Miscellaneous expense Bank service charge PAGE