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

Total deposits and other credits $29,799$

Total checks and other debits $22,508$

Ending balance $7/31/$Year $116,401$

Checks and Debits Deposits and Credits

Check Number Amount Date Amount

$2350$ $ $3,767$ July $1$ $ $1,104$

$23511,643$ July $106,497$

$23527,998$ July $154,928$

$23541,401$ July $216,174$

$23556,181$ July $265,964$

$23571,499$ July $302,082$

DM $19$ 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,497$

July $423527,998$ July $144,928$

July $1023532,898$ July $216,174$

July $1023541,401$ July $265,964$

July $1523556,181$ July $292,082$

July $20235672$ July $303,545$

July $2223571,499$

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,104.$

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

Required

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