Question: 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

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, 2016

Alert Security Services Co.

End-of-Period Spreadsheet

For the Year Ended October 31, 2016

Alert Security Services Co. offers security services to business clients.

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 columns.

Unadjusted Trial Balance Adjustments Cr. Trial Balance Dr. Account Title Cr. Accounts Receivable Supplies Prepaid Insurance 2 190 50 Equipment Accum. Depr-Equipment Accounts Payable Wages Payable Brenda Schultz, Capital Brenda Schultz, Drawing Fees Earned Wages Expense Rent Expense 110 Utilities Expense Supplies Expense Depreciation Expense Miscellaneous Expense 500 500

Step by Step Solution

3.61 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

ALERT SECURITY SERVICES CO EndofPeriod Spreadsheet Work Sheet For the Y... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Excel file Icon

1139-B-A-G-F-A(11259).xlsx

300 KBs Excel File

Students Have Also Explored These Related Accounting Questions!