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
Unadjusted Trial Balance Adjustments Adjusted Trial Balance
Account Title Debit Credit Debit Credit Debit Credit
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:
• Fees earned, but not yet billed, $13.
• Supplies on hand, $4.
• Insurance premiums expired, $10.
• Depreciation expense, $3.
• Wages accrued, but not paid, $1.
Enter the adjustment data, and place the balances in the Adjusted Trial Balance columns. Leave cells blank that do not require an entry.
Enter the adjustment data, and place the balances in the Adjusted Trial Balance columns. Leave cells blank that do not require an entry.
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
12.00
5
Accounts Receivable
90.00
6
Supplies
8.00
7
Prepaid Insurance
12.00
8
Land
190.00
9
Equipment
50.00
10
Accumulated Depreciation-Equipment
4.00
11
Accounts Payable
36.00
12
Wages Payable
0.00
13
Brenda Schultz, Capital
260.00
14
Brenda Schultz, Drawing
8.00
15
Fees Earned
200.00
16
Wages Expense
110.00
17
Rent Expense
12.00
18
Insurance Expense
0.00
19
Utilities Expense
6.00
20
Supplies Expense
0.00
21
Depreciation Expense
0.00
22
Miscellaneous Expense
2.00
23
Totals
$500.00
$500.00
Alert Security Services Co.
End-of-Period Spreadsheet
For the Year Ended October 31, 2016
Unadjusted Trial Balance Adjustments Adjusted Trial Balance
Account Title Debit Credit Debit Credit Debit Credit
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:
• Fees earned, but not yet billed, $13.
• Supplies on hand, $4.
• Insurance premiums expired, $10.
• Depreciation expense, $3.
• Wages accrued, but not paid, $1.
Enter the adjustment data, and place the balances in the Adjusted Trial Balance columns. Leave cells blank that do not require an entry.
Enter the adjustment data, and place the balances in the Adjusted Trial Balance columns. Leave cells blank that do not require an entry.
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
12.00
5
Accounts Receivable
90.00
6
Supplies
8.00
7
Prepaid Insurance
12.00
8
Land
190.00
9
Equipment
50.00
10
Accumulated Depreciation-Equipment
4.00
11
Accounts Payable
36.00
12
Wages Payable
0.00
13
Brenda Schultz, Capital
260.00
14
Brenda Schultz, Drawing
8.00
15
Fees Earned
200.00
16
Wages Expense
110.00
17
Rent Expense
12.00
18
Insurance Expense
0.00
19
Utilities Expense
6.00
20
Supplies Expense
0.00
21
Depreciation Expense
0.00
22
Miscellaneous Expense
2.00
23
Totals
$500.00
$500.00
1 answer:
Answer:
attached file with the solution to give a better format
Explanation:
The fees earned will increase fees and account receivables is we don't colelct the amount
the supplied on hand will be compared against the book value
8 - 4 = 4 supplies expense
the premium expired will decrease the prepaid insurance
wages accrued will generate both, a wages payable and wages expense
You might be interested in