Please help me fill out this chart.

The following information is available for Park Valley Spa for July, Year 1: BANK STATEMENT STATE BANK BOLTA VISTA, NV 10001 Park Valley Spa 10 Main Street Bolta Vista, NV 10001 Beginning balance 6/30/Year 1 Total deposits and other credits Total checks and other debits Ending balance 7/31/Year 1 Checks and Debits Check No. Amount 2350 $3,761 2351 1,643 2352 8,000 2354 2,894 2355 1,401 2357 6,187 DM 16 Account number 12-4567 July 31, Year 1 $ 9,031 29,800 237,902 14,929 Deposits and Credits Date Amount July 1 $1,102 July 10 6,498 July 15 4,929 July 21 6,174 July 26 5,963 July 30 2,084 CM 3,050 The following is a list of checks and deposits recorded on the books of the Park Valley Spa for July, Year 1: AN Date July July 4 July 10 July 10 July 15 July 20 July 22 - Check No. 2351 2352 2353 2354 2355 2356 2357 Amount of Check $1,643 8,000 1,500 2,894 1,401 745 6,187 Amount of Deposit $6,498 4,929 6,174 5,963 2,084 3,550 Date July 8 July 14 July 21 July 26 July 29 July 30 Other Information 1. Check no. 2350 was outstanding from June. 2. The credit memo was for collection of notes receivable. 3. All checks were paid at the correct amount 4. The debit memo was for printed checks. 5. The June 30 bank reconciliation showed a deposit in transit of $1,102. 6. The unadjusted Cash account balance at July 31 was $13,200. Required Prepare the bank reconcillotion for Park Valley Spa at the end of July (Negative amounts should be indicated with minus sign.) PARK VALLEY SPA Bank Reconciliation July 31, Year 1 Unadjusted Bank Balance, July 31, Year 1 True Cash Balance, July 31. Year 1 Unadjusted Book Balance, July 31, Year 1 True Cash Balance, July 31. Year 1