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 2 | 2351 | $1,643 | July 8 | $6,498 | |
July 4 | 2352 | $8,000 | July 14 | $4,929 | |
July 10 | 2353 | $1,500 | July 21 | $6,174 | |
July 10 | 2354 | $2,894 | July 26 | $5,963 | |
July 15 | 2355 | $1,401 | July 29 | $2,084 | |
July 20 | 2356 | $745 | July 30 | $3,550 | |
July 22 | 2357 | $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 | |
1 | 1 | | | | |
| | | | | |
2 | 2 | | | | |
| | | | | |
| | | | | |
| | | | | |