5. On the Gen Journal worksheet, record the following adjusting entries a. through h. Use column B for the debits and
column C for the credits. Record the debits first and the credits second.
a.
Depreciation for the year on the machinery is $2,900.
b. Medical supplies remaining on hand at the end of the year equal $1,200.
c.
Of the $7,000 paid in advance by customers, $4,000 of the work has been completed by the end of the year.
d. Employees' salaries are paid every two weeks. The last pay period ended on December 23. Salaries earned from
December 24 through December 31, 2018, are $4,200.
e. Record the appropriate entry for item g. in the summary of transactions above.
f.
On December 30, 2018, Mike's receives a utility bill of $1,900 for the month. The bill will not be paid until early
January 2019, and no entry was recorded when the bill was received.
g. Advanced Health determines that services for $1,800 had been provided and the client had not paid at the time
the services were performed. The transaction was not recorded during the year.
h. Record the required adjusting entry related to the external journal entry (h).
6. Once all the entries have been prepared, use the cell reference to post all the entries to the appropriate T-
accounts on the Gen Ledger worksheet.
7. Once all the journal entries have been posted, total each T-account. In the formulas, use cell references to include
all rows from the debit and credit columns, not just the rows in which you have values. The formulas for the T-
account totals should be consistent. To help you determine if you have the correct transactions the following
balances are provided:
Cash: $58,250
Service Revenue: $85,800
8. After totaling each of the T-accounts prepare an adjusted trial balance in the space provided on the Gen Ledger
worksheet. The format for the trial balance has been provided for you.
a. Prepare the trial balance in the proper account order.
b.
Use the cell reference to post all the entries to the Debits and Credits columns.
c. Use a formula to total the debit and the credit column.
IMPORTANT:
Verify that cell references are used for all items in the T-accounts on the Gen Ledger worksheet.
Verify that cell references are used for all values listed in the Adjusted Trial Balance.