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

Extracted 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