Appendix: Adjustment Data on an EndofPeriod 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 endofperiod spreadsheet for the year ended October Y In addition, the data for yearend adjustments are as follows:
a Fees earned but not yet billed, $
b Supplies on hand, $
c Insurance premiums expired, $
d Depreciation expense, $
e Wages accrued but not paid, $
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
EndofPeriod Spreadsheet Work Sheet
For the Year Ended October Y
