write my assignment 10816

The cash account for Interactive Systems at February 28, 2010, indicated a balanceof $7,635. The bank statement indicated a balance of $13,333 on February28, 2010. Comparing the bank statement and the accompanying canceled checksand memos with the records reveals the following reconciling items:a. Checks outstanding totaled $4,118.b. A deposit of $4,500, representing receipts of February 28, had been made toolate to appear on the bank statement.c. The bank had collected $5,200 on a note left for collection. The face of thenote was $5,000.d. A check for $290 returned with the statement had been incorrectly recordedby Interactive Systems as $920. The check was for the payment of an obligationto Busser Co. for the purchase of office supplies on account.e. A check drawn for $415 had been incorrectly charged by the bank as $145.f. Bank service charges for February amounted to $20.Instructions1. Prepare a bank reconciliation.2. Illustrate the effects on the accounts and financial statements of the bankreconciliation.PLEASE PUT INFORMATION INTO THE ATTACHED EXCEL DOC. THANK YOU!