bank reconciliation

On June 30, 2014, bank balance of Melrose Company according to the company's record was $ 5.764,50, while according to the record of Society Bank, it was $ 6.210,25. Below is the data that occurred in June 2014 as the basis of comparison between company's record and bank's record: 1. Bank charged $30 for administration expense to print the check book. 2. On June 12, 2014 Melrose Company received cash from its customer for service revenue. The cash was deposited to the bank with amount of $ 847,15. An error occured in the journal entry of Melrose Company for this transaction, it was recorded $ 870,65. 3. Total of outstanding checks on June 30, 2014 was $1.316,25, and total deposit that had not been recorded by bank was $2.180. 4. On June 18, 2014 Melrose Company issued a check No. 1181 for payment to a supplier, William Madison, with amount of $ 645. Melrose Company recorded the transaction incorrectly. It was recorded in the journal for $ 618. 5. Note Receivable with amount of $2.100 had been collected by bank for Melrose Company with the interest of $60 and bank charged $20 for the administration expense of this transaction 6. On June 30, 2014 Melrose Company went to the bank to cash a check with amount of $750 which was received from a customer, Harold Steward, but the bank rejected the check due to insufficient fund in Harold's account. Instructions: 1) Please prepare Bank Reconciliation for Melrose Company based on the data above. 2) Please prepare Journal of the bank reconciliation