Appendix 1: Adjustment Data on an End-of-Period Spreadsheet Alert Security Services Co. offers security services to...

Question

Question

Appendix 1: Adjustment Data on an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business

Accounts Payable Wages Payable Common Stock Retained Earnings Dividends Fees Earned Wages Expense Rent Expense Insurance Expe

eBook Calculator Print Item Alert Security Services Co. End-of-Period Spreadsheet (Work Sheet) . For the Year Ended October 3

eBook Print Item Supplies Prepaid Insurance Land 26 Equipment Accum. Depe- Equipment Accounts Payable Wages Payable Common St

business accounting

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

Alert Security Services Co.
End-of-Period Spreadsheet
For the Year Ended October 31, 2018
Account Title	Unadjusted Trial Balance	Unadjusted Trial Balance	Adjustments	Adjustments	Adjusted Trial Balance	Adjusted Trial Balance
	Debit	Credit	Debit	Credit	Debit	Credit
Cash	66				66
Accounts Receivable	176		18		194
Supplies	18			14	4
Prepaid Insurance	26			22	4
Land	220				220
Equipment	88				88
Accum. Depr. - Equipment		9		9		18
Accounts Payable		79				79
Wages Payable		0		9		9
Common Stock		130				130
Retained Earnings		283				283
Dividends	18				18
Fees Earned		198		18		216
Wages Expense	44		9		53
Rent Expense	26				26
Insurance Expense	0		22		22
Utilities Expense	13				13
Supplies Expense	0		14		14
Depreciation Expense	0		9		9
Miscellaneous Expense	4				4
Totals	699	699	72	72	735	735

Add a comment

Answer 2

Similar Homework Help Questions

Appendix 1: Adjustment Data on an End-of-Period Spreadsheet Alert Security Services Co. offers security services to...

Appendix 1: 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: Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 20Y3 Unadjusted Trial Balance Adjustments Adjusted Trial Balance Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 81 Accounts Receivable 216 Supplies 22 Prepaid Insurance 32 Land 270...
Appendix: Adjustment Data on an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business...

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, 2019. In addition, the data for year- end adjustments are as follows: a. Fees earned, but not yet billed, $26. b. Supplies on hand, $7. c. Insurance premiums expired, $33. d. Depreciation expense, $13. e. Wages accrued, but not paid, $13....
Appendix 1: Completing an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients....

Appendix 1: Completing an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 20Y3 Adjusted Trial Balance Income Statement Balance Sheet Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 329 Accounts Receivable 2,411 Supplies 110 Prepaid Insurance 82 Land 2,740 Equipment 1,096 Accum. Depr.—Equipment 219 Accounts Payable 986 Wages Payable 110 Common Stock 40 Retained Earnings 4,729 Dividends 219 Fees Earned 2,685 Wages Expense...

Appendix 1: Closing Entries from an End-of-Period Spreadsheet Alert Security Services Co. offers security services to...

Appendix 1: Closing Entries from an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business dients. Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 2043 Adjusted Trial Balance Income Statement Balance Sheet Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 438 Accounts Receivable 3,212 146 Supplies Prepaid Insurance 110 Land 3,650 1,460 Equipment Accum. Depr. - Equipment Accounts Payable Wages Payable Common Stock 292 1,314 146 BO Retained Earnings 6,272 Dividends 292 Fees...
ppendix 1: Closing Entries From an End-of-Period Spreadsheet Alert Security Services Co. offers security services to...

ppendix 1: Closing Entries From an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business dients. Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 2018 Adjusted Trial Balance Income Statement Balance Sheet Account Title Dr. Cr. Dr. Cr Dr Cr. 314 2,306 105 79 2,620 1,048 Cash Accounts Receivable Supplies Prepaid Insurance Land Equipment Accum. Depr. Equipment Accounts Payable Wages Payable Common Stock 210 943 105 80 4,478 Retained Earnings Dividends 210 fees Earned...
Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 20Y3 Adjusted Trial Balance...

Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 20Y3 Adjusted Trial Balance Income Statement Balance Sheet Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 494 Accounts Receivable 3,626 Supplies 165 Prepaid Insurance 124 Land 4,120 Equipment 1,648 Accum. Depr.-Equipment 330 Accounts Payable 1,483 Wages Payable 165 Common Stock 40 Retained Earnings 7,128 Dividends 330 Fees Earned 4,038 Wages Expense 989 Rent Expense 494 Insurance Expense 412 Utilities Expense 288 Supplies Expense 247 Depreciation Expense-Equip. 165...

The data for year-end adjustments are as follows: Fees earned, but not yet billed, $26. Supplies...

The data for year-end adjustments are as follows: Fees earned, but not yet billed, $26. Supplies on hand, $6. Insurance premiums expired, $32. Depreciation expense, $13. Wages accrued, but not paid, $13. Alert Security Services Co. offers security services to business clients. The trial balance for Alert Security Services Co. has been prepared on the end-of-period spreadsheet for the year ended October 31, 2018, shown below. Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 2018 Unadjusted...
EX 4-23 Completing an end-of-period spreadsheet Account Title Alert Security Services Co. End-of-Period Spreadsheet For the...

EX 4-23 Completing an end-of-period spreadsheet Account Title Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 2018 Adjusted Income Statement Trial Balance Debit Credit Debit Credit 12 103 Balance Sheet Debit Credit 12 103 50 210 210 Cash Accounts Receivable Supplies Prepaid Insurance Land Equipment Accumulated Depr.-Equipment Accounts Payable Wages Payable Common Stock Retained Earnings Dividends Fees Earned Wages Expense Rent Expense Insurance Expense Utilities Expense Supplies Expense Depreciation Expense-Equipment Miscellaneous Expense Totals Net Income (loss)...
Closing entries from an end-of-period spreadsheet Instructions Chart of Accounts Journal Instructions Alert Security Services Co....

Closing entries from an end-of-period spreadsheet Instructions Chart of Accounts Journal Instructions Alert Security Services Co. offers security services to business clients. Based on the end-of-period spreadsheet, prepare the two closing entries for Alert Security Services Co. Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 2019 Adjusted Adjusted Income Trial Balance Trial Balance Incon Staten 2 Statement Account Title Debit Credit 3 Debit Cred 4 Cash 18.00 5 Accounts Receivable 101.00 7.00 6 Supplies 7 Prepaid...

Alert Security Services Co. offers security services to business clients. The adjusted trial balance is presented...

Alert Security Services Co. offers security services to business clients. The adjusted trial balance is presented below. Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 2016 1 Adjusted Adjusted 2 Trial Balance Trial Balance Income Statement Income Statement Balance Sheet Balance Sheet 3 Debit Credit Debit Credit Debit Credit 4 Cash 12.00 5 Accounts Receivable 103.00 6 Supplies 4.00 7 Prepaid Insurance 2.00 8 Land 190.00 9 Equipment 50.00 10 Accumulated Depreciation-Equipment 7.00 11 Accounts Payable...

Appendix 1: Adjustment Data on an End-of-Period Spreadsheet Alert Security Services Co. offers security services to...

Homework Answers