Appendix 1: 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, 20Y3
		Adjusted Trial Balance							Income Statement			Balance Sheet
Account Title		Dr.			Cr.				Dr.	Cr.		Dr.	Cr.
Cash		302
Accounts Receivable		2,218
Supplies		101
Prepaid Insurance		76
Land		2,520
Equipment		1,008
Accum. Depr.Equipment					202
Accounts Payable					907
Wages Payable					101
Common Stock					40
Retained Earnings					4,344
Dividends		202
Fees Earned					2,470
Wages Expense		605
Rent Expense		302
Insurance Expense		252
Utilities Expense		176
Supplies Expense		151
Depreciation ExpenseEquip.		101
Miscellaneous Expense		50
		8,064			8,064

Complete the following end-of-period spreadsheet for Alert Security Services Co. 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	Adjusted Trial Balance Debit	Adjusted Trial Balance Credit	Income Statement Debit	Income Statement Credit	Balance Sheet Debit	Balance Sheet Credit
Cash	302		fill in the blank 1	fill in the blank 2	fill in the blank 3	fill in the blank 4
Accounts Receivable	2218		fill in the blank 5	fill in the blank 6	fill in the blank 7	fill in the blank 8
Supplies	101		fill in the blank 9	fill in the blank 10	fill in the blank 11	fill in the blank 12
Prepaid Insurance	76		fill in the blank 13	fill in the blank 14	fill in the blank 15	fill in the blank 16
Land	2520		fill in the blank 17	fill in the blank 18	fill in the blank 19	fill in the blank 20
Equipment	1008		fill in the blank 21	fill in the blank 22	fill in the blank 23	fill in the blank 24
Accum. Depr.Equipment		202	fill in the blank 25	fill in the blank 26	fill in the blank 27	fill in the blank 28
Accounts Payable		907	fill in the blank 29	fill in the blank 30	fill in the blank 31	fill in the blank 32
Wages Payable		101	fill in the blank 33	fill in the blank 34	fill in the blank 35	fill in the blank 36
Common Stock		40	fill in the blank 37	fill in the blank 38	fill in the blank 39	fill in the blank 40
Retained Earnings		4344	fill in the blank 41	fill in the blank 42	fill in the blank 43	fill in the blank 44
Dividends	202		fill in the blank 45	fill in the blank 46	fill in the blank 47	fill in the blank 48
Fees Earned		2470	fill in the blank 49	fill in the blank 50	fill in the blank 51	fill in the blank 52
Wages Expense	605		fill in the blank 53	fill in the blank 54	fill in the blank 55	fill in the blank 56
Rent Expense	302		fill in the blank 57	fill in the blank 58	fill in the blank 59	fill in the blank 60
Insurance Expense	252		fill in the blank 61	fill in the blank 62	fill in the blank 63	fill in the blank 64
Utilities Expense	176		fill in the blank 65	fill in the blank 66	fill in the blank 67	fill in the blank 68
Supplies Expense	151		fill in the blank 69	fill in the blank 70	fill in the blank 71	fill in the blank 72
Depreciation ExpenseEquip.	101		fill in the blank 73	fill in the blank 74	fill in the blank 75	fill in the blank 76
Miscellaneous Expense	50		fill in the blank 77	fill in the blank 78	fill in the blank 79	fill in the blank 80
Totals	8064	8064	fill in the blank 81	fill in the blank 82	fill in the blank 83	fill in the blank 84
Net income (loss)			fill in the blank 85	fill in the blank 86	fill in the blank 87	fill in the blank 88
			fill in the blank 89	fill in the blank 90	fill in the blank 91	fill in the blank 92