endoc: Adjustment Data on an End-of-Penod Spreadsheet t 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, 20YS. In addition, the data for year-end adjustments are as follows: ees earned but not yet billed, $31. Supplies on hand, $8. nsurance premiums expired, $39. Depreciation expense, $16. Wages accrued but not paid, $16. er 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 (Wwork Sheet) For the Year Ended October 31, 20Y5 Unadjusted Trial Balance Adjustments Adjusted Trial Balance

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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, $31.
b. Supplies on hand, $8.
c. Insurance premiums expired, $39.
d. Depreciation expense, $16.
e. Wages accrued but not paid, $16.
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
117
Accounts Receivable
312
Supplies
31
Prepaid Insurance
47
Land
390
Equipment
156
Accumulated Depreciation
16
Accounts Payable
140
Wages Payable
Brenda Schultz, Capital
733
Brenda Schultz, Drawing
31
Fees Earned
351
Wages Expense
78
Rent Expense
47
Insurance Expense
Utilities Expense
23
Supplies Expense
Depreciation Expense
Miscellaneous Expense
8
Totals
1,240
1,240
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, $31. b. Supplies on hand, $8. c. Insurance premiums expired, $39. d. Depreciation expense, $16. e. Wages accrued but not paid, $16. 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 117 Accounts Receivable 312 Supplies 31 Prepaid Insurance 47 Land 390 Equipment 156 Accumulated Depreciation 16 Accounts Payable 140 Wages Payable Brenda Schultz, Capital 733 Brenda Schultz, Drawing 31 Fees Earned 351 Wages Expense 78 Rent Expense 47 Insurance Expense Utilities Expense 23 Supplies Expense Depreciation Expense Miscellaneous Expense 8 Totals 1,240 1,240
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
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education