Chapter 4

Appendix 1: Adjusting Entries From an End-of-Period Spreadsheet

Alert Security Services Co. offers security services to business clients. The trial balance for Alert Security Services Co. has been prepared on the following end-of-period spreadsheet for the year ended October 31, 2019:

Alert Security Services Co.

End-of-Period Spreadsheet

For the Year Ended October 31, 2019

Unadjusted Trial Balance

Adjustments

Adjusted Trial Balance

Account Title

Dr.

Cr.

Dr.

Cr.

Dr.

Cr.

Cash

129

Accounts Receivable

344

Supplies

34

Prepaid Insurance

52

Land

430

Equipment

172

Accum. Depr. - Equipment

17

Accounts Payable

155

Wages Payable

Brenda Schultz, Capital

809

Brenda Schultz, Drawing

34

Fees Earned

387

Wages Expense

86

Rent Expense

52

Insurance Expense

Utilities Expense

26

Supplies Expense

Depreciation Expense

Miscellaneous Expense

9

1,368

1,368

The data for year-end adjustments are as follows:

1. Fees earned but not yet billed, $34.
2. Supplies on hand, $9.
3. Insurance premiums expired, $43.
4. Depreciation expense, $22.
5. Wages accrued but not paid, $17.

Prepare the adjusting entries for Alert Security Services Co.

a.
b.
c.
d.
e.