The cash account of Stellar Co. showed a ledger balance of $7,867.70 on June 30, 2022. The bank statement as of that date showed a balance of $8,300. Upon comparing the statement with the cash records, the following facts were determined. 1. . 2. 3. There were bank service charges for June of $50. A bank memo stated that Bao Dai's note for $2.400 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 Stellar's books when Bao Dai's note was sent to the bank for collection) Receipts for June 30 for $6,780 were not deposited until July 2. Checks outstanding on June 30 totaled $4,272.10. The bank had reduced Stellar Co.'s account for a customer's uncollectible check amounting to $506.40 on June 29. A customer's check for $180 (payment on account) had been entered as $120 in the cash receipts journal by Stellar on June 4. 5. 6. 15. 7. 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 $116.40 had been entered as $1,164,00. Both checks had been issued to pay for purchases of equipment on account. STELLAR CO. Bank Reconciliation June 30, 2022 $ Balance per bank, June 30 8300 6870 Add : Deposits in transit Outstanding checks 427210 Less $ 10807.90 Correct cash balance, June 30 Balance per books, June 30 7867.70 Add: Error in recording deposit 50 Note collection 2472 Error on check no. 747 1047,80 3579.80 11447.30 Less > Bank service charges 61 Error on check na 742 72 Customer NSF check 506.40 639 40 Correct cash balance June 30 V $ 10807.90 (5) Prepare entries necessary to make the books correct and complete. Use Office Expense account for bank service charges (Enter answers to 2 decimal places, es 125.62. If no entry is required, select "No Entry for the account titles and enter 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 increases to cash) (To record decreases to cash)