use the excel to complete general journal, T accounts, and Trial balance.

Journal T Accounts Trial Balance GENERAL GOGO Journal T Accounts Trial Balance CAL Journe TAccounts Trial Balance Trial Balance co C 3,860 50,000 H Company's unadjusted trial balance for the current year follows: H Company Trial Balance December 31 Cash $7,200 Prepaid property insurance 2,400 Prepaid life insurance 3,000 Shop supplies 790 Shop equipment Accumulated depreciation - equipment $770 Building 59,500 Accumulated depreciation-building 3,840 Land 55,000 Unearned rent 7,600 Accounts payable 3,720 Long-term notes payable Common stock 1,000 Retained earnings 47,860 Rent earned 2,400 Fees earned 23,400 Wages expense 3,200 Utilities expense 690 Property taxes expense 600 Interest expense 4,350 Total $140,590 $140,590 Additional information: a) A life insurance policy examination showed $1,040 of expired insurance. b) An inventory count showed $210 of unused shop supplies still available. c) Depreciation expense on shop equipment, $350. d) Depreciation expense on the building, $2,020. e) A beautician is behind on space rental payments, and this $200 of accrued revenues was unrecorded at the time the trial balance was prepared. $2,800 of the Unearned Rent account balance was still unearned by year-end. g) The one employee, a receptionist, works a five-day workweek at $50 per day. The employee was paid last week but has worked Tuesday through Friday this week for which she has not been paid. Page 15 of 28 h) Three months' property taxes, totaling $450, have accrued. This additional amount of property taxes expense has not been recorded. i) One month's interest on the note payable, $600, has accrued but is unrecorded. 1) The Prepaid Property Insurance account has a $2,400 debit balance before adjustment. An examination of insurance policies shows $950 of unexpired insurance. k) The company has three office employees who each earn $100 per day for a five-day workweek that ends on Friday. The employees were paid last Friday and worked full days on Monday, Wednesday and Friday this week for which they have not been paid. 1) On November 1, the company received 6 months' rent in advance from a tenant whose rent is $700 per month. The $4,200 was credited to the Unearned Rent account. m) The company has not received a water and sewer services bill for December. Based on prior months' bills, the bill is expected to be $1,000 for the month. Required: Journalize the necessary adjusting entries and create and Adjusted Trial Balance