Please help me with this

BANK STATEMENT STATE BANK BOLTA VISTA NV 10001 Park Valley Spa 10 Main Street Account number 12-4567 July Beginning balance 6/30/Year 1 Total deposits and other credits Total checks and other debits Ending balance 7/31/Year 1 $ 9,031 29,800 23,902 14,929 Checks and Debitts Check No. Deposits and Credits Amount 2350 2351 2352 2354 2355 2357 DM Amount $3,761 1,643 8,000 2,894 1,401 6,187 16 Date July1 July 10 July 15 July 21 July 26 July 30 $1,102 6,498 4,929 6,174 5,963 2,084 3,050 The following is a list of checks and deposits recorded on the books of the Park Valley Spa for July Year 1: Amount of Check Amount of Depos&t Date July2 July 4 July 10 July 10 July 15 July 20 July 22 Check No. 2351 2352 2353 2354 2355 2356 2357 Date $1,643July 8 $6,498 8,000July 14 4.929 1,500July 21 6.174 2,894July 265,963 1,401July 292.084 745 6,187 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 reconciliation for Park Valley Spa at the end of July. PARK VALLEY SPA Bank Reconciliation July 31, Year1 Unadjusted Bank Balance, July 31, Year 1 0 True Cash Balance, July 31, Year 1 Unadjusted Book Balance, July 31, Year 1 0 True Cash Balance, July 31. Year 1 0