Enter the adjustment data, and place the balances in the Adjusted Trial Balance columns. Leave cells blank that do not require an entry.

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, 2016:

Alert Security Services Co.

End-of-Period Spreadsheet

For the Year Ended October 31, 2016

1		Unadjusted	Unadjusted			Adjusted	Adjusted
2		Trial Balance	Trial Balance	Adjustments	Adjustments	Trial Balance	Trial Balance
3	Account Title	Debit	Credit	Debit	Credit	Debit	Credit
4	Cash	18.00
5	Accounts Receivable	80.00
6	Supplies	14.00
7	Prepaid Insurance	14.00
8	Land	182.00
9	Equipment	53.00
10	Accumulated Depreciation-Equipment		7.00
11	Accounts Payable		37.00
12	Wages Payable		0.00
13	Brenda Schultz, Capital		255.00
14	Brenda Schultz, Drawing	5.00
15	Fees Earned		203.00
16	Wages Expense	108.00
17	Rent Expense	20.00
18	Insurance Expense	0.00
19	Utilities Expense	6.00
20	Supplies Expense	0.00
21	Depreciation Expense	0.00
22	Miscellaneous Expense	2.00
23	Totals	$502.00	$502.00

The data for year-end adjustments are as follows:

	Fees earned, but not yet billed, $13.
	Supplies on hand, $7.
	Insurance premiums expired, $7.
	Depreciation expense, $4.
	Wages accrued, but not paid, $2.

Enter the adjustment data, and place the balances in the Adjusted Trial Balance columns. Leave cells blank that do not require an entry.

Worksheet

Shaded cells have feedback.

Enter the adjustment data, and place the balances in the Adjusted Trial Balance columns. Leave cells blank that do not require an entry.

Score: 47/175

Alert Security Services Co.

End-of-Period Spreadsheet

For the Year Ended October 31, 2016

1		Unadjusted	Unadjusted			Adjusted	Adjusted
2		Trial Balance	Trial Balance	Adjustments	Adjustments	Trial Balance	Trial Balance
3	Account Title	Debit	Credit	Debit	Credit	Debit	Credit
4	Cash	18.00
5	Accounts Receivable	80.00
6	Supplies	14.00
7	Prepaid Insurance	14.00
8	Land	182.00
9	Equipment	53.00
10	Accumulated Depreciation-Equipment		7.00
11	Accounts Payable		37.00
12	Wages Payable		0.00
13	Brenda Schultz, Capital		255.00
14	Brenda Schultz, Drawing	5.00
15	Fees Earned		203.00
16	Wages Expense	108.00
17	Rent Expense	20.00
18	Insurance Expense	0.00
19	Utilities Expense	6.00
20	Supplies Expense	0.00
21	Depreciation Expense	0.00
22	Miscellaneous Expense	2.00
23	Totals	$502.00