Villa Spa shows a general ledger balance for the Cash account of $3,969.85 on June 30 and the bank statement as of that date indicates a balance of $4,150.00. When the statement was compared with the cash records, the following facts were determined 1. There were bank service charges for June of $25.00 2. A bank memo stated that Bao Dai's note for $900 and interest of $36.00 had been collected on June 29, and the bank had charged $5.50 for the collection Any interest revenue has not been accrued 3. Deposits in transit June 30 were $2,890.00 4. Cheques outstanding on June 30 totalled $2,136.05 . On June 29, the bank had charged Villa Spa's account for a customer's NSF cheque amounting to $453.20 6. A customer's cheque received as a payment on account of $90 had been entered as $60 in the cash receipts journal by Villa Spa on June 15 7. Cheque no. 742 in the amount of $491 had been entered in the books as $419, and cheque no. 747 in the amount of $58.20 had been entered as $582.00. Both cheques were issued as payments on account. In May, the bank had charged a $27.50 Wella Spa cheque against the Villa Spa account. The June bank statement indicated that the bank had reversed this charge and corrected its error 8. Villa Spa Bank Reconctllatlon June 30 4150 Balance per bank, June 30 | Add # I. Deposits in transit | Less # Outstanding Cheques 2890 2136.05 Adjusted cash balance, June 30 per bank 4903.95 Balance per books, June 30 3969.85 Add # Note collection 936 Error on cheque no. 747 523.8 Error in recording deposit 30 1489.80 Less # NSF cheque 453.2 Bank service charges 30.50 Error on cheque no. 742 72 555.70 4903.95 | Adjusted balance, June 30 per books Prepare any journal entries that are needed to adjust the Cash account at June 30. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter O for the amounts. Round answers to 2 decimal places, e.g. 52.75) Date Account Titles and Explanation Debit Credit June 30 (To correct error and record cash receipts) June 30 To record NSF cheque and other cash payments) Villa Spa shows a general ledger balance for the Cash account of $3,969.85 on June 30 and the bank statement as of that date indicates a balance of $4,150.00. When the statement was compared with the cash records, the following facts were determined 1. There were bank service charges for June of $25.00 2. A bank memo stated that Bao Dai's note for $900 and interest of $36.00 had been collected on June 29, and the bank had charged $5.50 for the collection Any interest revenue has not been accrued 3. Deposits in transit June 30 were $2,890.00 4. Cheques outstanding on June 30 totalled $2,136.05 . On June 29, the bank had charged Villa Spa's account for a customer's NSF cheque amounting to $453.20 6. A customer's cheque received as a payment on account of $90 had been entered as $60 in the cash receipts journal by Villa Spa on June 15 7. Cheque no. 742 in the amount of $491 had been entered in the books as $419, and cheque no. 747 in the amount of $58.20 had been entered as $582.00. Both cheques were issued as payments on account. In May, the bank had charged a $27.50 Wella Spa cheque against the Villa Spa account. The June bank statement indicated that the bank had reversed this charge and corrected its error 8. Villa Spa Bank Reconctllatlon June 30 4150 Balance per bank, June 30 | Add # I. Deposits in transit | Less # Outstanding Cheques 2890 2136.05 Adjusted cash balance, June 30 per bank 4903.95 Balance per books, June 30 3969.85 Add # Note collection 936 Error on cheque no. 747 523.8 Error in recording deposit 30 1489.80 Less # NSF cheque 453.2 Bank service charges 30.50 Error on cheque no. 742 72 555.70 4903.95 | Adjusted balance, June 30 per books Prepare any journal entries that are needed to adjust the Cash account at June 30. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter O for the amounts. Round answers to 2 decimal places, e.g. 52.75) Date Account Titles and Explanation Debit Credit June 30 (To correct error and record cash receipts) June 30 To record NSF cheque and other cash payments)