B c | D E F G 1 Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 20Y3 4. Unadusted Adusted Adjustments Cr. Trial Balance Trial Balance 6 Account Title Dr. Cr. Dr. Dr. Cr. 12 90 8 12 8 Cash 9 Accounts Receivable 10 Supplies 11 Prepaid Insurance 12 Land 13 Equipment 14 Accum. Depr-Equipment 15 Accounts Payable 16 Wages Payable 17 Common Stock 18 Retained Earnings 19 Dividends 20 Fees Eamed 21 Wages Expense 22 Rent Expense 23 Insurance Expense 24 Utes Expense 25 Supplies Expense 26 Depreciation Epense-Equip. 27 Miscelaneous Expense 28 190 50 36 50 210 200 110 12 6. 2 200 29 Th E end foll

Quickbooks Online Accounting
3rd Edition
ISBN:9780357391693
Author:Owen
Publisher:Owen
Chapter3: Setting Up A New Company
Section: Chapter Questions
Problem 4.6C
icon
Related questions
icon
Concept explainers
Question

Adjustment data on an end-of-period spreadsheet
Alert Security Services Co. offers security services to business clients.
The trial balance for Alert Security Services has been prepared on the
following end-of-period spreadsheet for the year ended October 31,
20Y3:

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.

B
c | D
E
F
G
1
Alert Security Services Co.
End-of-Period Spreadsheet
For the Year Ended October 31, 20Y3
4.
Unadusted
Adusted
Adjustments
Cr.
Trial Balance
Trial Balance
6 Account Title
Dr.
Cr.
Dr.
Dr.
Cr.
12
90
8
12
8 Cash
9 Accounts Receivable
10 Supplies
11 Prepaid Insurance
12 Land
13 Equipment
14 Accum. Depr-Equipment
15 Accounts Payable
16 Wages Payable
17 Common Stock
18 Retained Earnings
19 Dividends
20 Fees Eamed
21 Wages Expense
22 Rent Expense
23 Insurance Expense
24 Utes Expense
25 Supplies Expense
26 Depreciation Epense-Equip.
27 Miscelaneous Expense
28
190
50
36
50
210
200
110
12
6.
2
200
29
Th
E end
foll
Transcribed Image Text:B c | D E F G 1 Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 20Y3 4. Unadusted Adusted Adjustments Cr. Trial Balance Trial Balance 6 Account Title Dr. Cr. Dr. Dr. Cr. 12 90 8 12 8 Cash 9 Accounts Receivable 10 Supplies 11 Prepaid Insurance 12 Land 13 Equipment 14 Accum. Depr-Equipment 15 Accounts Payable 16 Wages Payable 17 Common Stock 18 Retained Earnings 19 Dividends 20 Fees Eamed 21 Wages Expense 22 Rent Expense 23 Insurance Expense 24 Utes Expense 25 Supplies Expense 26 Depreciation Epense-Equip. 27 Miscelaneous Expense 28 190 50 36 50 210 200 110 12 6. 2 200 29 Th E end foll
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning