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 Taccounts 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. 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 Taccounts 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
