fill out whats in red please

yPLUS Kieso, Intermediate Accounting, 17e INTERMEDIATE ACC. /FINANCIAL REPORT (ACC 304, 305) ad, Study & Practice Assignment Gradebook ORION Downloadable eTextbook > Open Assignment CALCULATOR MESSAGE MY INSTRUCTOR FULL SCREEN PRINTER VERSION BACK) NEXT NT RESOURCES Problem 7-13 (Part Level Submission) The cash account of Aguilar Co. showed a ledger balance of $3,969.85 on June 30, 2020. The bank statement as of that date showed a balance of $4,150. Upon comparing the statement with the cash records, the following facts were determined. e 7-01 se 7-04 se 7-05.(Pert Submission) There were bank service charges for June of $25 A bank memo stated that Bao Dairs note for $1,200 and interest of $36 had been collected on June 29, and the bank had made a charge of $5.5 on the colection. (No entry had been made on Aguilar's books when Bao Dai's note was sent to the bank for collection) Receipts for June 30 for $3,390 were not deposited until July 2 1 se 7-10 se 7-11 che 7-17 cise 7-24 3. Checks outstanding on June 30 totaled $2,136.05. The bank had charged the Aguilar Co.'s account for a customer's uncollectible check amounting to $253.2 on June 29 A customer's check for $90 (as payment on the customer's Accounts Receivable) had been entered as $60 in the cash receipts journal by Agular on June 15 7 4. lem 7-04 (Pert Submission) niem 7-97 blem 7-13 (Pa el Submission 6- Check no. 742 in the amount of $491 had been entered in the cash journal as $419, and check no. 747 in the amount of $58.2 had been entered as $582. Both checks had been issued to pay for purchases and were payments on Agular's Accounts Payable. rw Score (a) ewResults by Study ttive Your answer is partially correct. Try again Prepare a bank reconciliation dated June 30, 2020, proceeding to a correct cash balance. (Enter answers to 2 decimal places, e.g. 125.62.) AGUILAR CO. Bank Reconciliation June 30, 2020 Balance per bank 4150 Add Deposits in transit 3390 14 ese % CALCULATOR MESSAGE MY INSTRUCTO (a) MENT RESOURCES r7 Your answer is partially correct. Try again. ise 7-01 cise 7-04 cise 7-05 (Part l Submission) Prepare a bank reconciliation dated June 30, 2020, proceeding to a correct cash balance. (Enter answers to 2 decimal places, e.g. 12. AGUILAR CO. Bank Reconciliation cise 7-10 cise 7-11 olse 7-17 June 30, 2020 cise 7-24 Balance per bank plem 7-04 (Part l Submission) blem 7-07 plem 7-13 (Part el Submission) 4150 Add Deposits in transit 3390 Less Outstanding checks 2136.05 wScore Correct cash balance 5403.95 w Results by Study tive Balance per books 3969.85 Add: Error in recording deposit 30 Error on check no. 747 523.80 Note collection 1230.50 1784.30 1704 3n CT 14 Assignment CALCULATOR MESSAGE MY INSTRUCTOR RCES Note collection 1230.50 1784.30 1784.30 Less: NSF check 253.20 Error on check no. 742 72 Bank service charges 25 350.20 Correct cash balance 5403.95 Study Click if you would like to Show Work for this question: Open Show Work SHOW LIST OF ACCOUNTS LINK TO TEXT Attempts: (b) A 45 OCT 14