Step 1. Fill out the Trial Balance in the work sheet provided in the Worksheet Tab in Excel
Step 2. Journalize the given adjustments below. Use J2 to denote general journal page 2. General Journal Page 2 on the Excel Worksheet.
ADJUSTMENTS: At the end of the month, the following adjustments need to be recorded
A physical food inventory was taken and $1,500 of food remains in the storerooms.
Depreciation of the equipment needs to be recognized. (Hint go back to first transactions where you bought equipment).
The insurance used needs to be adjusted.
The hotel used $2,750 in utilities but have not paid Center Point Energy.
A Party for Lancer Ltd. was held on September 30th. The total invoice of $10,000 for food revenue needs to be billed.
The last pay day was the 26th and Cougar Hotel pays its employees every two weeks. Ten employees with wages totaling $250 per person per day needs to be accrued.
