Question: Ex 04.24 Appendix: Adjustment Data on an End-of-Period SpreadsheetAlert Security Services Co. offers security services to business clients. The trial balance for Alert Security ServicesCo.
Ex 04.24 Appendix: Adjustment Data on an End-of-Period SpreadsheetAlert Security Services Co. offers security services to business clients. The trial balance for Alert Security ServicesCo. has been prepared on the following end-of-period spreadsheet for the year ended October 31, 20Y5. Inaddition, the data for year-end adjustments are as follows:a. Fees earned but not yet billed, $25.b. Supplies on hand, $6.c. Insurance premiums expired, $31.d. Depreciation expense, $12.e. Wages accrued but not paid, $12.Enter the adjustment data and place the balances in the Adjusted Trial Balance columns. If an amount box doesnot 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 93 Accounts Receivable 248 Supplies 25 Prepaid Insurance 37 Land 310 Equipment 124 Accumulated Depreciation 12 Accounts Payable 112 Wages Payable Brenda Schultz, Capital 583 Brenda Schultz, Drawing 25 Fees Earned 279 00000000OOOOOO0 Wages Expense 62 Rent Expense 37 Insurance Expense 0 Utilities Expense Supplies Expense oo OOOOC Depreciation Expense 6 Miscellaneous Expense 986 986 Totals Check My Work All work saved
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
