wwwwwwwwwwwwwwwwwwwwwwwww L06 excel www.mhhe.com The bookkeeper at Wood Company has not reconciled the bank statement with the Cash account, saying, "I don't have time." You have been asked to prepare a reconciliation and review the procedures with the bookkeeper The April 30, 2011, bank statement and the April ledger accounts for cash showed the following (summarized): BANK STATEMENT Checks Deposits Balance Balance, April 1, 2011 $31,000 Deposits during April $36,100 67.100 Interest collected 1.180 68,280 Checks cleared during April $44,500 23,780 NSF check-A. B. Wright 160 23,620 Bank service charges 23,570 Balance, April 30, 2011 23,570 50 Apr. 1 Balance Apr. Deposits Cash (A) 23,500 Apr. Checks written 41,500 41,100 A comparison of checks written before and during April with the checks cleared through the bank showed outstanding checks at the end of April of $4,100. No deposits in transit were carried over from March, but a deposit was in transit at the end of April. Required: 1. Prepare a detailed bank reconciliation for April 2. Give any required journal entries as a result of the reconciliation. Why are they necessary? 3. What was the balance in the cash ad gount in the ledger on May 1, 2011? 4. What total amount of cash should be reported on the balance sheet at the end of April