Accessibility tab summary: Given information for this question is presented in rows $2$ through $40.$ Requirement information is presented in rows $42$ through $69.$

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"$ "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 $1$ $$14,929$

$$

Checks and Debits Deposits and Credits

Check Number Amount Date Amount

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

$2351$ $$1,643$ July $10$ $$6,498$

$2352$ $$8,000$ July $15$ $$4,929$

$2354$ $$2,894$ July $21$ $$6,174$

$2355$ $$1,401$ July $26$ $$5,963$

$2357$ $$6,187$ July $30$ $$2,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 $42352$ $$8,000$ July $14$ $$4,929$

July $102353$ $$1,500$ July $21$ $$6,174$

July $102354$ $$2,894$ July $26$ $$5,963$

July $152355$ $$1,401$ July $29$ $$2,084$

July $202356$ $$745$ July $30$ $$3,550$

July $222357$ $$6,187$

Other Information

$1.$ Check number $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.$ $$1,102$

$6.$ The unadjusted Cash account balance at July $31$ was $$13,200.$ $$13,200$

Required

a$.$ Prepare the bank reconciliation for Park Valley Spa at the end of July.

$($Enter amounts to be deducted with a minus sign.$)($Use the cells from the given information above to complete this question.$)$

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$

b$.$ Record in general journal form any necessary entries to the Cash account to adjust it to the true cash balance.

$($If no entry is required for a transaction$/$event$,$ select $"$No journal entry required" in the first account field.$)$

$($Use the cells from the given information above to complete this question.$)$

No Event General Journal Debit Credit

$11$

$22$