Completing an end-of-period spreadsheet

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

Complete the end-of-period spreadsheet for Alert Security Services Co. Leave cells blank that do not require an entry.

Alert Security Services Co.

End-of-Period Spreadsheet

For the Year Ended October 31, 2016

1		Adjusted	Adjusted
2		Trial Balance	Trial Balance	Income Statement	Income Statement	Balance Sheet	Balance Sheet
3		Debit	Credit	Debit	Credit	Debit	Credit
4	Cash	12.00
5	Accounts Receivable	102.00
6	Supplies	3.00
7	Prepaid Insurance	2.00
8	Land	186.00
9	Equipment	55.00
10	Accumulated Depreciation-Equipment		9.00
11	Accounts Payable		35.00
12	Wages Payable		1.00
13	Common Stock		50.00
14	Retained Earnings		201.00
15	Dividends	6.00
16	Fees Earned		222.00
17	Wages Expense	107.00
18	Rent Expense	16.00
19	Insurance Expense	13.00
20	Utilities Expense	8.00
21	Supplies Expense	3.00
22	Depreciation Expense	3.00
23	Miscellaneous Expense	2.00
24		$518.00	$518.00
25	Net income (loss)
26