Question

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 Expense—Equip.		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 Expense—Equip.	110
Miscellaneous Expense	55
Totals	8769	8769
Net income (loss)

Answer 1

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