Appendix: 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 Co. has been prepared on the following end-of-period spreadsheet for the year ended October 31, 20Y5. In addition, 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. If an amount bax does not require an entry, leave it blank. Alert Security Services Co. End-of-Period Spreadsheet (Work Sheet) For the Year Ended October 31, 20Y5 Unadjusted Trial Balance Adjustments Adjusted Trial Balance Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 12 Accounts Receivable 90 Supplies Prepaid Insurance 12 Land 190 Equipment 50 Accumulated Depreciation Accounts Payable 36 Wages Payable Brenda Schultz, Capital 260 Brenda Schultz. Drawing Fees Earned 200 Wages Expense 110 Rent Expense 12 Insurance Expense Utilities Expense Supplies Expense Depreciation Expense Miscellaneous Expense Totals 500 500

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question

Appendix: 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 Co. has been prepared on the following end-of-period spreadsheet for the year ended October 31, 20Y5. In addition, the data for year-end adjustments are as follows:

  1. Fees earned but not yet billed, $13.
  2. Supplies on hand, $4.
  3. Insurance premiums expired, $10.
  4. Depreciation expense, $3.
  5. Wages accrued but not paid, $1.

Enter the adjustment data and place the balances in the Adjusted Trial Balance columns.  If an amount box does not require an entry, leave it blank.

Alert Security Services Co.
End-of-Period Spreadsheet (Work Sheet)
For the Year Ended October 31, 20Y5
 
  Unadjusted Trial Balance   Adjustments   Adjusted Trial Balance
Account Title Dr. Cr.   Dr. Cr.   Dr. Cr.
Cash 12         fill in the blank 1 fill in the blank 2   fill in the blank 3 fill in the blank 4
Accounts Receivable 90         fill in the blank 5 fill in the blank 6   fill in the blank 7 fill in the blank 8
Supplies 8         fill in the blank 9 fill in the blank 10   fill in the blank 11 fill in the blank 12
Prepaid Insurance 12         fill in the blank 13 fill in the blank 14   fill in the blank 15 fill in the blank 16
Land 190         fill in the blank 17 fill in the blank 18   fill in the blank 19 fill in the blank 20
Equipment 50         fill in the blank 21 fill in the blank 22   fill in the blank 23 fill in the blank 24
Accumulated Depreciation     4     fill in the blank 25 fill in the blank 26   fill in the blank 27 fill in the blank 28
Accounts Payable     36     fill in the blank 29 fill in the blank 30   fill in the blank 31 fill in the blank 32
Wages Payable     0     fill in the blank 33 fill in the blank 34   fill in the blank 35 fill in the blank 36
Brenda Schultz, Capital     260     fill in the blank 37 fill in the blank 38   fill in the blank 39 fill in the blank 40
Brenda Schultz, Drawing 8         fill in the blank 41 fill in the blank 42   fill in the blank 43 fill in the blank 44
Fees Earned     200     fill in the blank 45 fill in the blank 46   fill in the blank 47 fill in the blank 48
Wages Expense 110         fill in the blank 49 fill in the blank 50   fill in the blank 51 fill in the blank 52
Rent Expense 12         fill in the blank 53 fill in the blank 54   fill in the blank 55 fill in the blank 56
Insurance Expense 0         fill in the blank 57 fill in the blank 58   fill in the blank 59 fill in the blank 60
Utilities Expense 6         fill in the blank 61 fill in the blank 62   fill in the blank 63 fill in the blank 64
Supplies Expense 0         fill in the blank 65 fill in the blank 66   fill in the blank 67 fill in the blank 68
Depreciation Expense 0         fill in the blank 69 fill in the blank 70   fill in the blank 71 fill in the blank 72
Miscellaneous Expense 2         fill in the blank 73 fill in the blank 74   fill in the blank 75 fill in the blank 76
Totals 500   500     fill in the blank 77 fill in the blank 78   fill in the blank 79 fill in the blank 80
Appendix: 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 Co. has been prepared on the following end-of-period spreadsheet for the year ended October 31, 20Y5. In addition, 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. If an amount box does not require an entry, leave it blank.
Alert Security Services Co.
End-of-Period Spreadsheet (Work Sheet)
For the Year Ended October 31, 20Y5
Unadjusted Trial Balance
Adjustments
Adjusted Trial Balance
Account Title
Dr.
Cr.
Dr.
Cr.
Dr.
Cr.
Cash
12
Accounts Receivable
90
Supplies
Prepaid Insurance
12
Land
190
Equipment
50
Accumulated Depreciation
4
Accounts Payable
36
Wages Payable
Brenda Schultz, Capital
260
Brenda Schultz, Drawing
Fees Earned
200
Wages Expense
110
Rent Expense
12
Insurance Expense
Utilities Expense
Supplies Expense
Depreciation Expense
Miscellaneous Expense
2
Totals
500
500
Transcribed Image Text:Appendix: 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 Co. has been prepared on the following end-of-period spreadsheet for the year ended October 31, 20Y5. In addition, 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. If an amount box does not require an entry, leave it blank. Alert Security Services Co. End-of-Period Spreadsheet (Work Sheet) For the Year Ended October 31, 20Y5 Unadjusted Trial Balance Adjustments Adjusted Trial Balance Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 12 Accounts Receivable 90 Supplies Prepaid Insurance 12 Land 190 Equipment 50 Accumulated Depreciation 4 Accounts Payable 36 Wages Payable Brenda Schultz, Capital 260 Brenda Schultz, Drawing Fees Earned 200 Wages Expense 110 Rent Expense 12 Insurance Expense Utilities Expense Supplies Expense Depreciation Expense Miscellaneous Expense 2 Totals 500 500
Expert Solution
Step 1

Working note:

Journal entry

For easy understanding, before posting balance to trail balance we will prepare journal entries

 

 

Debit

Credit

1

Fess Earned not yet billed

 

 

 

Accounts Receivable

13

 

 

    Unearned Revenue

 

13

 

 

 

 

2

Supplies on Hand $4

 

 

 

Supplies Expense

4

 

 

    supplies

 

4

 

 

 

 

3

Insurance Premium Expired

 

 

 

Insurance expense

10

 

 

    Prepaid Insurance

 

10

 

 

 

 

4

Depreciation expense

 

 

 

Depreciation expense

3

 

 

     To Accumulated Depreciation

 

3

 

 

 

 

5

Wages Accrued but not paid

 

 

 

Wages Expenses

1

 

 

    To wages Payable

 

1

 

 

 

 

 

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
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education