Alert Security Services Co.
End-of-Period Spreadsheet (Work Sheet)
For the Year Ended October 31, 2014
Unadjusted
Trial Balance Adjustments
Adjusted
Trial Balance
Account Title Dr. Cr. Dr. Cr. Dr. Cr.
Cash 12
Accounts Receivable 90
Supplies 8
Prepaid Insurance 12
Land 190
Equipment 50
Accum. Depr.—Equipment 4
Accounts Payable 36
Wages Payable 0
Brenda Schultz, Capital 260
Brenda Schultz, Drawing 8
Fees Earned 200
Wages Expense 110
Rent Expense 12
Insurance Expense 0
Utilities Expense 6
Supplies Expense 0
Depreciation Expense 0
Miscellaneous Expense 2
500 500
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.
Answer:
ALERT SECURITY SERVICES CO.
End-of-Period Spreadsheet (Work Sheet)
For the Year Ended October 31, 2014
Account Title
Unadjusted
Trial Balance Adjustments
Adjusted
Trial Balance
Debit Credit Debit Credit Debit Credit
Cash 12 12
Accounts Receivable 90 (a) 13 103
Supplies 8 (b) 4 4
Prepaid Insurance 12 (c) 10 2
Land 190 190
Equipment 50 50
Accum. Depr.—Equipment 4 (d) 3 7
Accounts Payable 36 36
Wages Payable 0 (e) 1 1
Brenda Schultz, Capital 260 260
Brenda Schultz, Drawing 8 8
Fees Earned 200 (a) 13 213
Wages Expense 110 (e) 1 111
Rent Expense 12 12
Insurance Expense 0 (c) 10 10
Utilities Expense 6 6
Supplies Expense 0 (b) 4 4
Depreciation Expense 0 (d) 3 3
Miscellaneous Expense 2 2
Totals 500 500 31 31 517 517