50.1K

Verified Solution

Link Copied!

Instructions 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, 2018 Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 2018 Unadjusted Unadjusted Adjusted Trial Balance 1 Trial Balance Trial Balance Adjustments Debit Adjustments Credit 2 Debit Debit Credit 15.00 Cash 82.00 5 Accounts Receivable 14.00 Supplies 7 Prepaid Insurance 16.00 184.00 1 Land 53.00 6.00 Equipment 10 Accumulated Depreciation Equipment Previous Next 38.00 0.00 11 Accounts Payable 12 Wages Payable 2 Common Stock 50.00 195.00 14 Retained Earnings 8.00 15 Dividends 212.00 1 Fees Eamed 105.00 17.00 0.00 5.00 1 Wages Expense 1 Rent Expense 19 Insurance Experise Utilities Expense 21 Supplies Expense Depreciation Expense-Equip. Miscellaneous Expense 0.00 0.00 2.00 5501.00 550100 The data for year-end adjustments are as follows A Fees earned, but not yet billed. $13 5.00 0.00 20 Utilities Expense 21 Supplies Expense 22 Depreciation Expense-Equip. 23 Miscellaneous Expense 0.00 2.00 24 Totals $501.00 $501.00 The data for year-end adjustments are as follows: A. Fees earned, but not yet billed, 513. B. Supplies on hand, S7 C. Insurance premiums expired, 58 D. Depreciation expense, 53. E Wages accrued, but not paid $4 We jusument 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, 2018 1 Unadjusted Unadjusted Trial Balance Adjusted 2 Trial Balance Adjustments Adjustments Trial Balance 3 Debit Credit Debit Credit Debit 4 Cash 15.00 Accounts Receivable 82.00 14.00 16.00 184.00 53.00 Supplies Prepaid Insurance Land Equipment 20 Accumulated Depreciation Equipment 11 Accounts Payable 12 Wages Payable 13 Common Stock 6.00 38.00 0.00 50.00 195.00 14 Retained Earnings 15 Dividends 8.00 16 Fees Earned 212.00 105.00 11 Wages Expense u Rent Expense 19 Insurance Expense 17.00 0.00 20 Utilities Expense 5.00 0.00 21 Supplies Expense 22 Depreciation Expense-Equipment 0.00 23 Miscellaneous Expense 2.00 34 Totals $501.00 $501.00 Unadjusted Trial Balance Unadjusted Adjusted Trial Balance Adjustments Adjustments Adjusted Trial Balance Debit Trial Balance Credit Debit Credit Debit 15 m Credit

Answer & Explanation Solved by verified expert

See Answer