In: Accounting
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, 2016:
|
Alert Security Services Co. |
|
End-of-Period Spreadsheet |
|
For the Year Ended October 31, 2016 |
|
1 |
Unadjusted |
Unadjusted |
Adjusted |
Adjusted |
|||
|
2 |
Trial Balance |
Trial Balance |
Adjustments |
Adjustments |
Trial Balance |
Trial Balance |
|
|
3 |
Debit |
Credit |
Debit |
Credit |
Debit |
Credit |
|
|
4 |
Cash |
18.00 |
|||||
|
5 |
Accounts Receivable |
90.00 |
|||||
|
6 |
Supplies |
14.00 |
|||||
|
7 |
Prepaid Insurance |
14.00 |
|||||
|
8 |
Land |
198.00 |
|||||
|
9 |
Equipment |
53.00 |
|||||
|
10 |
Accumulated Depreciation-Equipment |
7.00 |
|||||
|
11 |
Accounts Payable |
37.00 |
|||||
|
12 |
Wages Payable |
0.00 |
|||||
|
13 |
Common Stock |
50.00 |
|||||
|
14 |
Retained Earnings |
231.00 |
|||||
|
15 |
Dividends |
5.00 |
|||||
|
16 |
Fees Earned |
203.00 |
|||||
|
17 |
Wages Expense |
108.00 |
|||||
|
18 |
Rent Expense |
20.00 |
|||||
|
19 |
Insurance Expense |
0.00 |
|||||
|
20 |
Utilities Expense |
6.00 |
|||||
|
21 |
Supplies Expense |
0.00 |
|||||
|
22 |
Depreciation Expense |
0.00 |
|||||
|
23 |
Miscellaneous Expense |
2.00 |
|||||
|
24 |
Totals |
$528.00 |
$528.00 |
The data for year-end adjustments are as follows:
| • | Fees earned, but not yet billed, $13. |
| • | Supplies on hand, $7. |
| • | Insurance premiums expired, $7. |
| • | Depreciation expense, $4. |
| • | Wages accrued, but not paid, $2. |
Enter the adjustment data, and place the balances in the Adjusted Trial Balance columns. Leave cells blank that do not require an entry.