Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Curriculum Auditing

Authors: Fenwick W. English

1st Edition

0877625921, 978-0877625926

More Books

Students also viewed these Accounting questions

Question

10. What is meant by a feed rate?

Answered: 1 week ago