The cash account of aguilar co. showed a ledger balance of $7,867.70 on june 30, 2014. the bank statement as of that date showed a balance of $8,300.00. upon comparing the statement with the cash records, the following facts were determined.1. there were bank service charges for june of $50.00.2. a bank memo stated that bao dai’s note for $2,400.00 and interest of $72.00 had been collected on june 29, and the bank had made a charge of $11.00 on the collection. (no entry had been made on aguilar’s books when bao dai’s note was sent to the bank for collection.)3. receipts for june 30 for $6,780.00 were not deposited until july 2.4. checks outstanding on june 30 totaled $4,272.10.5. the bank had charged the aguilar co.’s account for a customer’s uncollectible check amounting to $506.40 on june 29.6. a customer’s check for $180.00 (as payment on the customer’s accounts receivable) had been entered as $120.00 in the cash receipts journal by aguilar on june 15.7. check no. 742 in the amount of $491.00 had been entered in the cash journal as $419.00, and check no. 747 in the amount of $116.40 had been entered as $1,164.0. both checks had been issued to pay for purchases and were payments on aquilar’s accounts payable. a)prepare a bank reconciliation dated june 30, 2014, proceeding to a correct cash balance. b)prepare any entries necessary to make the books correct and complete. (if no entry is required, select "no entry" for the account titles and enter 0 for the amounts. credit account titles are automatically indented when the amount is entered. do not indent manually.)