Appendix: Adjustment Data on an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business dients. The trial balance for Alert Security Services Co. has been prepared on the following end-of-period spreadsheet for the year ended October 31, 20Y5. In addition, the data for year-end adjustments are as follows: a. Fees earned but not yet billed, $29. b. Supplies on hand, $7. C. Insurance premiums expired, $36. d. Depreciation expense, $14. e. Wages accrued but not paid, $14. Enter the adjustment data and place the balances in the Adjusted Trial Balance columns. If an amount box does not require an entry, leave it blank.

Century 21 Accounting General Journal
11th Edition
ISBN:9781337680059
Author:Gilbertson
Publisher:Gilbertson
Chapter22: End-of-fiscal-period Work For A Corporation
Section22.1: Preparing Adjusting Entries
Problem 1OYO
icon
Related questions
icon
Concept explainers
Question
Appendix: Adjustment Data on an End-of-Period Spreadsheet
Alert Security Services Co. offers security services to business clients. The trial balance for Alert Security Services Co. has been prepared on the following end-of-period spreadsheet for the year ended October 31, 20Y5. In addition, the data for year-end adjustments are as follows:
a. Fees earned but not yet billed, $29.
b. Supplies on hand, $7.
c. Insurance premiums expired, $36.
d. Depreciation expense, $14.
e. Wages accrued but not paid, $14.
Enter the adjustment data and place the balances in the Adjusted Trial Balance columns. 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, 20Y5
Unadjusted Trial Balance
Adjustments
Adjusted Trial Balance
Account Title
Dr.
Cr.
Dr.
Cr.
Dr.
Cr.
Cash
108
Accounts Receivable
288
Supplies
29
Prepaid Insurance
43
Land
360
Equipment
144
Accumulated Depreciation
14
Accounts Payable
130
Wages Payable
Brenda Schultz, Capital
677
Brenda Schultz, Drawing
29
Fees Earned
324
Wages Expense
72
Rent Expense
43
Insurance Expense
Utilities Expense
22
Supplies Expense
Depreciation Expense
Miscellaneous Expense
Totals
1,145
1,145
Transcribed Image Text:Appendix: Adjustment Data on an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. The trial balance for Alert Security Services Co. has been prepared on the following end-of-period spreadsheet for the year ended October 31, 20Y5. In addition, the data for year-end adjustments are as follows: a. Fees earned but not yet billed, $29. b. Supplies on hand, $7. c. Insurance premiums expired, $36. d. Depreciation expense, $14. e. Wages accrued but not paid, $14. Enter the adjustment data and place the balances in the Adjusted Trial Balance columns. 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, 20Y5 Unadjusted Trial Balance Adjustments Adjusted Trial Balance Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 108 Accounts Receivable 288 Supplies 29 Prepaid Insurance 43 Land 360 Equipment 144 Accumulated Depreciation 14 Accounts Payable 130 Wages Payable Brenda Schultz, Capital 677 Brenda Schultz, Drawing 29 Fees Earned 324 Wages Expense 72 Rent Expense 43 Insurance Expense Utilities Expense 22 Supplies Expense Depreciation Expense Miscellaneous Expense Totals 1,145 1,145
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
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.
Similar questions
Recommended textbooks for you
Century 21 Accounting General Journal
Century 21 Accounting General Journal
Accounting
ISBN:
9781337680059
Author:
Gilbertson
Publisher:
Cengage
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Century 21 Accounting Multicolumn Journal
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College