Appendix: Completing an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. Complete the following end-of-period spreadsheet for Alert Security Services Co.: If an amount box does not require an entry, leave it blank. Alert Security Services Co. End-of-Period Spreadsheet (Work Sheet) For the Year Ended October 31, 20Y7 Account Title Adjusted Trial Balance Debit Adjusted Trial Balance Credit Income Statement Debit Income Statement Credit Balance Sheet Debit Balance Sheet Credit Cash 12 fill in the blank 1 fill in the blank 2 fill in the blank 3 fill in the blank 4 Accounts Receivable 103 fill in the blank 5 fill in the blank 6 fill in the blank 7 fill in the blank 8 Supplies 4 fill in the blank 9 fill in the blank 10 fill in the blank 11 fill in the blank 12 Prepaid Insurance 2 fill in the blank 13 fill in the blank 14 fill in the blank 15 fill in the blank 16 Land 190 fill in the blank 17 fill in the blank 18 fill in the blank 19 fill in the blank 20 Equipment 50 fill in the blank 21 fill in the blank 22 fill in the blank 23 fill in the blank 24 Accumulated Depreciation 7 fill in the blank 25 fill in the blank 26 fill in the blank 27 fill in the blank 28 Accounts Payable 36 fill in the blank 29 fill in the blank 30 fill in the blank 31 fill in the blank 32 Wages Payable 1 fill in the blank 33 fill in the blank 34 fill in the blank 35 fill in the blank 36 Brenda Schultz, Capital 260 fill in the blank 37 fill in the blank 38 fill in the blank 39 fill in the blank 40 Brenda Schultz, Drawing 8 fill in the blank 41 fill in the blank 42 fill in the blank 43 fill in the blank 44 Fees Earned 213 fill in the blank 45 fill in the blank 46 fill in the blank 47 fill in the blank 48 Wages Expense 111 fill in the blank 49 fill in the blank 50 fill in the blank 51 fill in the blank 52 Rent Expense 12 fill in the blank 53 fill in the blank 54 fill in the blank 55 fill in the blank 56 Insurance Expense 10 fill in the blank 57 fill in the blank 58 fill in the blank 59 fill in the blank 60 Utilities Expense 6 fill in the blank 61 fill in the blank 62 fill in the blank 63 fill in the blank 64 Supplies Expense 4 fill in the blank 65 fill in the blank 66 fill in the blank 67 fill in the blank 68 Depreciation Expense 3 fill in the blank 69 fill in the blank 70 fill in the blank 71 fill in the blank 72 Miscellaneous Expense 2 fill in the blank 73 fill in the blank 74 fill in the blank 75 fill in the blank 76 Totals 517 517 fill in the blank 77 fill in the blank 78 fill in the blank 79 fill in the blank 80 Net income (loss) fill in the blank 81 fill in the blank 82 fill in the blank 83 fill in the blank 84 fill in the blank 85 fill in the blank 86 fill in the blank 87 fill in the blank 88

Appendix: Completing an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. Complete the following end-of-period spreadsheet for Alert Security Services Co.: If an amount box does not require an entry, leave it blank. Alert Security Services Co. End-of-Period Spreadsheet (Work Sheet) For the Year Ended October 31, 20Y7 Account Title Adjusted Trial Balance Debit Adjusted Trial Balance Credit Income Statement Debit Income Statement Credit Balance Sheet Debit Balance Sheet Credit Cash 12 fill in the blank 1 fill in the blank 2 fill in the blank 3 fill in the blank 4 Accounts Receivable 103 fill in the blank 5 fill in the blank 6 fill in the blank 7 fill in the blank 8 Supplies 4 fill in the blank 9 fill in the blank 10 fill in the blank 11 fill in the blank 12 Prepaid Insurance 2 fill in the blank 13 fill in the blank 14 fill in the blank 15 fill in the blank 16 Land 190 fill in the blank 17 fill in the blank 18 fill in the blank 19 fill in the blank 20 Equipment 50 fill in the blank 21 fill in the blank 22 fill in the blank 23 fill in the blank 24 Accumulated Depreciation 7 fill in the blank 25 fill in the blank 26 fill in the blank 27 fill in the blank 28 Accounts Payable 36 fill in the blank 29 fill in the blank 30 fill in the blank 31 fill in the blank 32 Wages Payable 1 fill in the blank 33 fill in the blank 34 fill in the blank 35 fill in the blank 36 Brenda Schultz, Capital 260 fill in the blank 37 fill in the blank 38 fill in the blank 39 fill in the blank 40 Brenda Schultz, Drawing 8 fill in the blank 41 fill in the blank 42 fill in the blank 43 fill in the blank 44 Fees Earned 213 fill in the blank 45 fill in the blank 46 fill in the blank 47 fill in the blank 48 Wages Expense 111 fill in the blank 49 fill in the blank 50 fill in the blank 51 fill in the blank 52 Rent Expense 12 fill in the blank 53 fill in the blank 54 fill in the blank 55 fill in the blank 56 Insurance Expense 10 fill in the blank 57 fill in the blank 58 fill in the blank 59 fill in the blank 60 Utilities Expense 6 fill in the blank 61 fill in the blank 62 fill in the blank 63 fill in the blank 64 Supplies Expense 4 fill in the blank 65 fill in the blank 66 fill in the blank 67 fill in the blank 68 Depreciation Expense 3 fill in the blank 69 fill in the blank 70 fill in the blank 71 fill in the blank 72 Miscellaneous Expense 2 fill in the blank 73 fill in the blank 74 fill in the blank 75 fill in the blank 76 Totals 517 517 fill in the blank 77 fill in the blank 78 fill in the blank 79 fill in the blank 80 Net income (loss) fill in the blank 81 fill in the blank 82 fill in the blank 83 fill in the blank 84 fill in the blank 85 fill in the blank 86 fill in the blank 87 fill in the blank 88

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Concept explainers

Question

Appendix: Completing an End-of-Period Spreadsheet

Alert Security Services Co. offers security services to business clients. Complete the following end-of-period spreadsheet for Alert Security Services Co.:

If an amount box does not require an entry, leave it blank.

Alert Security Services Co.
End-of-Period Spreadsheet (Work Sheet)
For the Year Ended October 31, 20Y7
Account Title	Adjusted Trial Balance Debit	Adjusted Trial Balance Credit	Income Statement Debit	Income Statement Credit	Balance Sheet Debit	Balance Sheet Credit
Cash	12		fill in the blank 1	fill in the blank 2	fill in the blank 3	fill in the blank 4
Accounts Receivable	103		fill in the blank 5	fill in the blank 6	fill in the blank 7	fill in the blank 8
Supplies	4		fill in the blank 9	fill in the blank 10	fill in the blank 11	fill in the blank 12
Prepaid Insurance	2		fill in the blank 13	fill in the blank 14	fill in the blank 15	fill in the blank 16
Land	190		fill in the blank 17	fill in the blank 18	fill in the blank 19	fill in the blank 20
Equipment	50		fill in the blank 21	fill in the blank 22	fill in the blank 23	fill in the blank 24
Accumulated Depreciation		7	fill in the blank 25	fill in the blank 26	fill in the blank 27	fill in the blank 28
Accounts Payable		36	fill in the blank 29	fill in the blank 30	fill in the blank 31	fill in the blank 32
Wages Payable		1	fill in the blank 33	fill in the blank 34	fill in the blank 35	fill in the blank 36
Brenda Schultz, Capital		260	fill in the blank 37	fill in the blank 38	fill in the blank 39	fill in the blank 40
Brenda Schultz, Drawing	8		fill in the blank 41	fill in the blank 42	fill in the blank 43	fill in the blank 44
Fees Earned		213	fill in the blank 45	fill in the blank 46	fill in the blank 47	fill in the blank 48
Wages Expense	111		fill in the blank 49	fill in the blank 50	fill in the blank 51	fill in the blank 52
Rent Expense	12		fill in the blank 53	fill in the blank 54	fill in the blank 55	fill in the blank 56
Insurance Expense	10		fill in the blank 57	fill in the blank 58	fill in the blank 59	fill in the blank 60
Utilities Expense	6		fill in the blank 61	fill in the blank 62	fill in the blank 63	fill in the blank 64
Supplies Expense	4		fill in the blank 65	fill in the blank 66	fill in the blank 67	fill in the blank 68
Depreciation Expense	3		fill in the blank 69	fill in the blank 70	fill in the blank 71	fill in the blank 72
Miscellaneous Expense	2		fill in the blank 73	fill in the blank 74	fill in the blank 75	fill in the blank 76
Totals	517	517	fill in the blank 77	fill in the blank 78	fill in the blank 79	fill in the blank 80
Net income (loss)			fill in the blank 81	fill in the blank 82	fill in the blank 83	fill in the blank 84
			fill in the blank 85	fill in the blank 86	fill in the blank 87	fill in the blank 88

Appendix: Completing an End-of-Period Spreadsheet
Alert Security Services Co. offers security services to business clients. Complete the following end-of-period spreadsheet for Alert Security Services Co.:
If an amount box does not require an entry, leave it blank.
Alert Security Services Co.
End-of-Period Spreadsheet (Work Sheet)
For the Year Ended October 31, 20Y7
Adjusted
Adjusted
Trial Balance Trial Balance
Debit
Income Statement Income Statement Balance Sheet Balance Sheet
Credit
Debit
Debit
Credit
Account Title
Credit
Cash
12
Accounts Receivable
103
Supplies
Prepaid Insurance
Land
190
50
Accumulated Depreciation
Equipment
Accounts Payable
36
Wages Payable
Brenda Schultz, Capital
Brenda Schultz, Drawing E
260
Fees Earned
213
Wages Expense
Rent Expense
Insurance Expense
Utilities Expense
Supplies Expense
Depreciation Expense
Miscellaneous Expense
Totals
517
517
Net income (loss

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.