Question

Appendix: Completing an End-of-Period Spreadsheet

Alert Security Services Co. offers security services to business clients.

Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 2016
		Adjusted Trial Balance							Income Statement			Balance Sheet
Account Title		Dr.			Cr.				Dr.	Cr.		Dr.	Cr.
Cash		12
Accounts Receivable		103
Supplies		4
Prepaid Insurance		2
Land		190
Equipment		50
Accum. Depr. - Equipment					7
Accounts Payable					36
Wages Payable					1
Common Stock					50
Retained Earnings					210
Dividends		8
Fees Earned					213
Wages Expense		111
Rent Expense		12
Insurance Expense		10
Utilities Expense		6
Supplies Expense		4
Depreciation Expense		3
Miscellaneous Expense		2
		517			517

Complete the following end-of-period spreadsheet for Alert Security Services Co. If an amount 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, 2016
Account Title	Adjusted Trial Balance Debit	Adjusted Trial Balance Credit	Income Statement Debit	Income Statement Credit	Balance Sheet Debit	Balance Sheet Credit
Cash	12
Accounts Receivable	103
Supplies	4
Prepaid Insurance	2
Land	190
Equipment	50
Accum. Depr.-Equipment		7
Accounts Payable		36
Wages Payable		1
Common Stock		50
Retained Earnings		210
Dividends	8
Fees Earned		213
Wages Expense	111
Rent Expense	12
Insurance Expense	10
Utilities Expense	6
Supplies Expense	4
Depreciation Expense	3
Miscellaneous Expense	2
Totals	517	517
Net income (loss)

Answer 1

ALERT SECURITY SERVICES CO.
End of Period Work Sheet
For Year Ended October 31,2016
	Adjusted Trial Balance		Income Summary		Balance Sheet
	Debit	Credit	Debit	Credit	Debit	Credit
Balance Sheet Accounts:
Cash	12.00				12.00
Accounts Receivable	103.00				103.00
Supplies	4.00				4.00
Prepaid Insurance	2.00				2.00
Land	190.00				190.00
Equipment	50.00				50.00
Accumulated Dep. - Equipment		7.00				7.00
Accounts Payable		36.00				36.00
Wages Payable		1.00				1.00
Common Stock		50.00				50.00
Retained Earnings		210.00				210.00
Dividends	8.00				8.00
Income Statement Accounts
Fees Earned		213.00		213.00
Wages Expense	111.00		111.00
Rent Expense	12.00		12.00
Insurance Expense	10.00		10.00
Utilities Expense	6.00		6.00
Supplies Expense	4.00		4.00
Depreciation Expense	3.00		3.00
Miscellaneous Expense	2.00		2.00
Total	517.00	517.00	148.00	213.00	369.00	304.00
Net Income (Loss)			65.00	-	-	65.00
Totals			213.00	213.00	369.00	369.00