Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 2019 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 Payable0 Brenda Schultz, Capital 260 Brenda Schultz, Drawing 8 Fees Earned200 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.
Answers:
Account TitleDebit Credit Debit Credit
Cash1212
Accounts Receivable90 (a) 13 103
Supplies8 (b) 4 4
Prepaid Insurance12 (c) 10 2
Land190190
Equipment5050
Accumulated Depreciation—Equipment 4 (d) 3 7
Accounts Payable3636
Wages Payable0 (e) 1 1
Brenda Schultz, Capital260260
Brenda Schultz, Drawing 88
Fees Earned200 (a) 13 213
Wages Expense110 (e) 1 111
Rent Expense1212
Insurance Expense0 (c) 10 10
Utilities Expense66
Supplies Expense0 (b) 4 4
Depreciation Expense0 (d) 3 3
Miscellaneous Expense22
Totals500 500 31 31 517 517