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$ Account number

$12-4567$

July $31,$ Year $1$

Beginning balance $6/30/$Year $1$ $ $9,031$

Total deposits and other credits $29,800$

Total checks and other debits $23,902$

Ending balance $7/31/$Year $114,929$

Checks and Debits Deposits and Credits

Check Number Amount Date Amount

$2350$ $ $3,761$ July $1$ $ $1,102$

$23511,643$ July $106,498$

$23528,000$ July $154,929$

$23542,894$ July $216,174$

$23551,401$ July $265,963$

$23576,187$ July $302,084$

DM $16$ 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$:

Date Check Number Amount of Check Date Amount of Deposit

July $22351$ $ $1,643$ July $8$ $ $6,498$

July $423528,000$ July $144,929$

July $1023531,500$ July $216,174$

July $1023542,894$ July $265,963$

July $1523551,401$ July $292,084$

July $202356745$ July $303,550$

July $2223576,187$

Other Information

Check number $2350$ was outstanding from June.

The credit memo was for collection of notes receivable.

All checks were paid at the correct amount.

The debit memo was for printed checks.

The June $30$ bank reconciliation showed a deposit in transit of $$1,102.$

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.

Note: Negative amounts should be indicated with minus sign.