Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Appendix 1: 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

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Appendix 1: 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 end-of-period spreadsheet for the year ended October 31, 2018, shown below. Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 2018 Unadjusted Trial Balance Adjustments Dr. Cr. Dr. Cr. 66 Adjusted Trial Balance Dr. Cr. Account Title Cash Accounts Receivable Supplies 176 Prepaid Insurance Land Equipment Accum. Depr.--Equipment Accounts Payable Wages Payable Common Stock 130 283 Retained Earnings Dividends Fees Farned Accounts Payable Wages Payable Common Stock Retained Earnings Dividends Fees Earned Wages Expense Rent Expense Insurance Expense Utilities Expense Supplies Expense Depreciation Expense Miscellaneous Expense 699 699 The data for year-end adjustments are as follows: a. Fees earned, but not yet billed; $18. b. Supplies on hand, $4. C. Insurance premiums expired, $22. d. Depreciation expense, $9. e. Wages accrued, but not paid, $9. Enter the adjustment data, and place the balances in the Adjusted Trial Balance columns. If a box does not require an entry, leave it blank. En amounts as positive numbers. eBook Calculator Print Item Alert Security Services Co. End-of-Period Spreadsheet (Work Sheet) . For the Year Ended October 31, 2018 Unadjusted Trial Balance Adjustments - Adjustments - Credit Credit Account Title Adjusted Trial Balance Debit Adjusted Trial Balance Credit Unadjusted Trial Balance Debit 66 176 Accounts Receivable Supplies Prepaid Insurance Land 26 Equipment Accum. Depr.- Equipment Accounts Payable Wages Payable Common Stock Retained Earnings 198 Dividends Fees Earned Wages Expense Rent Expense 26 Insurance Expense Utilities Expense 0 13 Check My Work Previous eBook Print Item Supplies Prepaid Insurance Land 26 Equipment Accum. Depe- Equipment Accounts Payable Wages Payable Common Stock Retained Earnings Dividends Fees Earned Wages Expense Rent Expense 26 Insurance Expense 0 Utilities Expense 13 Supplies Expense 0 Depreciation Expense o Miscellaneous Expense Totals 699 699 Check My Work Previous All work saved. Emai

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Organizational Behavior Improving Performance And Commitment In The Workplace

Authors: Jason Colquitt

8th Edition

126412435X, 9781264124350

More Books

Students also viewed these Accounting questions

Question

Mortality rate

Answered: 1 week ago

Question

Armed conflicts.

Answered: 1 week ago