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		329
Accounts Receivable		2,411
Supplies		110
Prepaid Insurance		82
Land		2,740
Equipment		1,096
Accum. Depr.Equipment					219
Accounts Payable					986
Wages Payable					110
Common Stock					40
Retained Earnings					4,729
Dividends		219
Fees Earned					2,685
Wages Expense		658
Rent Expense		329
Insurance Expense		274
Utilities Expense		192
Supplies Expense		164
Depreciation ExpenseEquip.		110
Miscellaneous Expense		55
		8,769			8,769

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	329
Accounts Receivable	2411
Supplies	110
Prepaid Insurance	82
Land	2740
Equipment	1096
Accum. Depr.Equipment		219
Accounts Payable		986
Wages Payable		110
Common Stock		40
Retained Earnings		4729
Dividends	219
Fees Earned		2685
Wages Expense	658
Rent Expense	329
Insurance Expense	274
Utilities Expense	192
Supplies Expense	164
Depreciation ExpenseEquip.	110
Miscellaneous Expense	55
Totals	8769	8769
Net income (loss)