Security Services has been prepared on the following end-of-period spreadsheet for the year Appendix 1 • EX 4-21 Adjustment data on an end-of-period spreadsheet Alert Security Services Co. offers security services to business clients. The trial balance for Aler ended October 31, 20Y3: D G A Alert Security Services Co. 1 End-of-Period Spreadsheet For the Year Ended October 31, 20Y3 3 Unadjusted Adjusted 4 Trial Balance Adjustments Trial Balance 6. Account Title Dr. Cr. Dr. Cr. Dr. Cr. 7. 8 Cash 9 Accounts Receivable 10 Supplies 11 Prepaid Insurance 12 Land 13 Equipment 14 Accum. Depr.-Equipment 15 Accounts Payable 16 Wages Payable 17 Common Stock 18 Retained Earnings 19 Dividends 20 Fees Earned 21 Wages Expense 22 Rent Expense 23 Insurance Expense 24 Utilities Expense 25 Supplies Expense 26 Depreciation Expense Equip. 27 Miscellaneous Expense 12 90 8 12 190 50 4 36 0. 50 210 8 200 110 12 6. 28 500 500 29 e data for year-end adjustments are as follows: Fees earned, but not yet billed, $13. Supplies on hand, $4. Insurance premiums expired, $10. Depreciation expense, $3. Wages accrued, but not paid, $1. er the adjustment data, and place the balances in the Adjusted Trial Balance columns. L. CO
Security Services has been prepared on the following end-of-period spreadsheet for the year Appendix 1 • EX 4-21 Adjustment data on an end-of-period spreadsheet Alert Security Services Co. offers security services to business clients. The trial balance for Aler ended October 31, 20Y3: D G A Alert Security Services Co. 1 End-of-Period Spreadsheet For the Year Ended October 31, 20Y3 3 Unadjusted Adjusted 4 Trial Balance Adjustments Trial Balance 6. Account Title Dr. Cr. Dr. Cr. Dr. Cr. 7. 8 Cash 9 Accounts Receivable 10 Supplies 11 Prepaid Insurance 12 Land 13 Equipment 14 Accum. Depr.-Equipment 15 Accounts Payable 16 Wages Payable 17 Common Stock 18 Retained Earnings 19 Dividends 20 Fees Earned 21 Wages Expense 22 Rent Expense 23 Insurance Expense 24 Utilities Expense 25 Supplies Expense 26 Depreciation Expense Equip. 27 Miscellaneous Expense 12 90 8 12 190 50 4 36 0. 50 210 8 200 110 12 6. 28 500 500 29 e data for year-end adjustments are as follows: Fees earned, but not yet billed, $13. Supplies on hand, $4. Insurance premiums expired, $10. Depreciation expense, $3. Wages accrued, but not paid, $1. er the adjustment data, and place the balances in the Adjusted Trial Balance columns. L. CO
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question

Transcribed Image Text:ins.
Extend the adjusted
Alert Security Services Co. offers security services to business clients. The trial balance for Alert
Security Services has been prepared on the following end-of-period spreadsheet for the year
Appendix 1
• EX 4-21 Adjustment data on an end-of-period spreadsheet
V Total of Adjustments
Debit column: $31
Security Services has been prepared on the following end-of-period spreadsheet for the Alert
ended October 31, 20Y3:
E
в с
D
B
C
EXCEL TEMPLATE
Alert Security Services Co.
2
End-of-Period Spreadsheet
3
For the Year Ended October 31, 20Y3
Unadjusted
Adjusted
4
5
Trial Balance
Adjustments
Trial Balance
6 Account Title
Dr.
Cr.
Dr.
Cr.
Dr.
Cr.
7
12
8 Cash
9 Accounts Receivable
10 Supplies
11 Prepaid Insurance
12 Land
13 Equipment
14 Accum. Depr.-Equipment
15 Accounts Payable
16 Wages Payable
17 Common Stock
18 Retained Eanings
19 Dividends
90
8
12
190
50
4
36
50
210
8
20 Fees Earned
200
21 Wages Expense
22 Rent Expense
23 Insurance Expense
24 Utilities Expense
25 Supplies Expense
26 Depreciation Expense-Equip.
27 Miscellaneous Expense
110
12
28
500
500
29
The data for year-end adjustments are as follows:
a. Fees earned, but not yet billed, $13.
b. Supplies on hand, $4.
c. Insurance premiums expired, $10.
d. Depreciation expense, $3.
e. Wages accrued, but not paid, $1.
Enter the adjustment data, and place the balances in the Adjusted Trial Balance coluni.
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images

Recommended textbooks for you


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON

Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education