The following are the Company's cash transactions for the June 2023.

1.LadyBug's account showed a cash balance at June 30, 2023 of $6,750.

2.The closing balance was $4,710 on the June bank statement.

3.Cash received in the amount of $3,850 on June 29th. Because of the weekend, It was not recorded by the bank on the June statement.

4.$15 in service charges for June were recorded on the bank statement.

5.There was credit memo included within the June bank statement that states a note receivable for $4,000 from BuzzyBee has been collected and credited to LadyBug's account.

6.A review of checks paid that were returned by the bank were compared to LadyBug's accounting records. Check no. 765 for $430, issue June 17th in payment for supplies, had been erroneously recorded in Lady's record as $340.

7.A review of checks paid identified 3 checks that were issued in June but not yet paid by the bank.

1. No. 733 $115

2. No. 783 $170

3. No. 787 $530

8.Included in the June bank statement was a NSF check drawn by Taj, in the amount of $2,900. The check was included in the deposit of June 28th but had been charged back against the company's account on June 30th.

Instructions: Prepare a June 2023 bank reconciliation for LadyBug Inc. using the template attached. Also note, what the cash balance for June 2023 should be?