please include formuals with explaination.

The following information is available for Park Valley Spa for July Year 1.

BANK STATEMENT STATE BANK

Park Valley Spa 10 Main Street Bolta Vista, NV 10001

Beginning balance 6/30/Year 1 $9031

Total deposits and other credits $29,800

Total checks and other debits $23,902

Ending balance 7/31 year 1 $14,929

Checks and Debits / debits and credits

ck numbers

2350 - $3,761 - date of deposit 7/1 - $1,102

2351 - $1,643 - date of deposit 7/10 - $6,498

2352 - $8,000 - date of deposit 7/15 - $4,929

2354 - $2,8 - date of deposit 7/21- $6,174

2355 - $1,401 - date of deposit 26 - $5,963

2357 - $6,187 - date of deposit 730 - $2,084

dm -$16 - cm - $3,050Date Account number 34

Other Information 35 1.

Check number 2350 was outstanding from June 12-4567 July 31, Year 1

Worksheet Chart of

Accounts $9,031 $29,800 $23,902 $14,929 23

The following is a list of checks and deposits recorded on the books of the Park Valley Spa for July Year 1.

Amount $3,761 July 1 $1,643 July 10 $8,000 July 15 $2,894 July 21 $1,401 July 26 $6,187 July 30 $16 CM Deposits and Credits Date Check Number 2351 2352 2353 2354 2355 2356 2357 Amount of Check

The following information is avalable for Park Walley Spa for luly Year 1 23 The following is a lst of checks and deposits recorded on the books of the Park Vailey Spa for fuly Year 1 Iuly 22 2357 $6,187 3). 34 Other information 35 1. Check number 2350 was outstanding from lune. 35.2 The credit memo was for collection of notes receivable. 37 . All checks were paid at the correct amount: 38 4. The debit memo was for printed checls 39. 5. The June 30 bank reconcliation showed a deposit in transit of $1,102. 6. The unadjusted Cash account balance at July 31 was $13,200 $1,102 40. 41 42 Required 43 a. Prepare the bank reconclistion for Park Valley Spa at the end of July. 44 45 (Enter amounts to be deducted with a minus sign).) (Use the cells from the given information above to complete this question.) (If no entry is required for a transactionvevent, select "No journal entry required" in the first account field.) 63 (Use the cells from the given information above to complete this question.)