6-21A (Algo) Bank reconciliation and adjustments to the cash account LO 6-3 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 Beginning balance 6/30/Year 1 Total deposits and other credits Total checks and other debits Ending balance 7/31/Year 1 Account number 12-4567 July 31, Year 1 $ 9,710 Deposits and Credits Amount Checks and Debits Check Number Amount Date 2350 $ 3,769 July 1 $ 1,108 2351 1,642 July 101 6,499 2352 8,005 July 15 4,928 2354 1,404 July 21 6,175 2355 6,185 July 26 5,963 2357 1,503 July 30 2,087 DM 19 CM 3,052 29,812 22,527 16,995 The following is a fist of checks and deposits recorded on the books of the Park Valley Spa for July Year 1 The following is a list of checks and deposits recorded on the books of the Park Valley Spa for July Year 1. Date July 2 Check Number Amount of Amount of Check Date Deposit 2351 $1,642 July 4 July 8 $6,499 2352 8,005 July 14 4,928 July 10 2353 2,899 July 21 July 10 6,175 2354 1,404 July July 26 15 5,963) 2355 6,185 July 20 July 29 2,087 2356 73 July 30 3,548 July 22 2357 1,503 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,108, 6. The unadjusted Cash account balance at July 31 was $14,538. Required a. Prepare the bank reconciliation for Park Valley Spa at the end of July. b. Record in general journal form any necessary entries to the Cash account to adjust it to the true cash balance. Complete this question by entering your answers in the tabs below. Required A Required B Prepare the bank reconciliation for Park Valley Spa at the end of July. PARK VALLEY SPA Bank Reconciliation Unadjusted Bank Balance, July 31, Year 1 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 Prev Novt Journal entry worksheet A B Record the collection of notes receivable. Note: Enter debits before credits. Event 1 General Journal Debit Credit Record entry Clear entry View general journal Journal entry worksheet < A B Record cash paid for office supplies expenses. Note: Enter debits before credits. Event 2 General Journal Debit Credit Record entry Clear entry View general journal