Reference no: EM131217670

The cash account of Aguilar Co. showed a ledger balance of $5,528.99 on June 30, 2014. The bank statement as of that date showed a balance of $5,810.00. Upon comparing the statement with the cash records, the following facts were determined. 1. There were bank service charges for June of $35.00. 2. A bank memo stated that Bao Dai’s note for $1,680.00 and interest of $50.40 had been collected on June 29, and the bank had made a charge of $7.70 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 $4,746.00 were not deposited until July 2. 4. Checks outstanding on June 30 totaled $2,990.47. 5. The bank had charged the Aguilar Co.’s account for a customer’s uncollectible check amounting to $354.48 on June 29. 6. A customer’s check for $126.00 (as payment on the customer’s Accounts Receivable) had been entered as $84.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 $81.48 had been entered as $814.8. Both checks had been issued to pay for purchases and were payments on Aquilar’s Accounts Payable. Prepare a bank reconciliation dated June 30, 2014, proceeding to a correct cash balance. AGUILAR CO. Bank Reconciliation June 30, 2014 $ : : $ $ : $ : $ SHOW LIST OF ACCOUNTS LINK TO TEXT 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.) Account Titles and Explanation Debit Credit (To record the Increases to cash) (To record decreases to cash)