Question

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 Expense—Equip.		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 Expense—Equip.	0
Miscellaneous Expense	5
Totals	858	858

Answer 1

Account Titles Cash Accounts Receivable Supplies Prepaid Insurance Unbilled Fees Land Equipment Accumulated Depreciation-Equipment Accounts Payable Wages Payable Common Stock Retained Earnings Dividends Fees Earned Wages Expense Rent Expense Insurance Expense Utilities Expense Supplies Expense Depreciation Expense-Equip. Miscellaneous Expense Alert Security Services Co. End of Period Spreadsheet October 31,2043 Unadjusted Trial Balance Adjusting Entries Debit ($) Credit ($) Debit ($) Credit (S) 81 216 22 11 32 27 22 270 108 11 11 97 11 160 347 22 243 22 54 11 32 27 16 Adjusted Trial Balance Debit ($) Credit ($) 81 216 11 5 22 270 108 22 97 11 160 347 22 265 65 32 27 16 11 11 5 11 11 5 858 858 82 82 902 902