The July 31, 2023, unadjusted trial balance for Daimler Tours after its first month of operations is shown below:

Required
1. Enter the unadjusted trial balance onto a work sheet.
2. Using the following additional information, enter the adjustments into the work sheet (the Chart of Accounts in Appendix IV may be useful when additional accounts are required):
1. Interest of $40 had accrued on the note receivable by month-end.
2. The July utility bill for $175 was received in the mail on July 31. It is unpaid and unrecorded.
3. Depreciation on the furniture for the month of July is $210.
4. The balance in Prepaid Insurance is from a six-month policy that went into effect on July 1, 2023.
5. The company has two part-time employees, each of whom gets paid $315 every other Friday for a five-day part-time workweek. July 31 falls on a Friday, however two days of accrued wages need to be recorded for each employee.
6. At July 31, it was determined that $4,900 of the balance in Unearned Tour Revenue was not yet earned.
7. Accrued tour revenue of $1,600 was unrecorded and uncollected at July 31.

3. Complete the work sheet.

Transcribed Image Text:

123 + 4 LO Daimler Tours Trial Balance.xlsx Home Insert Page Layout Formulas Data Review View fx P18 A Daimler Tours Unadjusted Trial Balance July 31, 2023 5 6 No. 7 101 Cash 8 106 Accounts receivable 9 111 Notes receivable, due Feb. 2024 10 128 Prepaid insurance 11 161 Furniture Account 12 201 Accounts payable 13 230 Unearned tour revenue 14 301 Jan Rider, capital 15 302 Jan Rider, withdrawals 16 403 Tour revenue 17 623 Wages expense 18 Totals B Unadjusted Trial Balance Dr. $ 9,100 18,700 16,000 5,100 6,750 -O- 41,380 $ 97,030 C Cr. $ 6,925 12,430 60,975 16,700 $ 97,030