Appendix 1: Adjustment Data on an End-of-Period Spreadsheet

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

Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 20Y3
		Unadjusted Trial Balance							Adjustments			Adjusted Trial Balance
Account Title		Dr.			Cr.				Dr.	Cr.		Dr.	Cr.
Cash		81
Accounts Receivable		216
Supplies		22
Prepaid Insurance		32
Land		270
Equipment		108
Accum. Depr.Equipment					11
Accounts Payable					97
Wages Payable					0
Common Stock					160
Retained Earnings					347
Dividends		22
Fees Earned					243
Wages Expense		54
Rent Expense		32
Insurance Expense		0
Utilities Expense		16
Supplies Expense		0
Depreciation ExpenseEquip.		0
Miscellaneous Expense		5
		858			858

The data for year-end adjustments are as follows:

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

Enter the adjustment data, and place the balances in the Adjusted Trial Balance columns. If a box does not require an entry, leave it blank. Enter all amounts as positive numbers.

Alert Security Services Co.
End-of-Period Spreadsheet (Work Sheet)
For the Year Ended October 31, 20Y3
Account Title	Unadjusted Trial Balance Debit	Unadjusted Trial Balance Credit	Adjustments - Debit	Adjustments - Credit	Adjusted Trial Balance Debit	Adjusted Trial Balance Credit
Cash	81
Accounts Receivable	216
Supplies	22
Prepaid Insurance	32
Land	270
Equipment	108
Accum. Depr.Equipment		11
Accounts Payable		97
Wages Payable		0
Common Stock		160
Retained Earnings		347
Dividends	22
Fees Earned		243
Wages Expense	54
Rent Expense	32
Insurance Expense	0
Utilities Expense	16
Supplies Expense	0
Depreciation ExpenseEquip.	0
Miscellaneous Expense	5
Totals	858	858