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, 2045. 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. 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, 2015 Adjustments Adjusted Trial Balance Unadjusted Trial Balance Dr. Cr. Cr. Dr. Dr. Cri Account Title 99 Cash Accounts Receivable 26 40 Supplies Prepaid Insurance Land 330 No 132 Previous Finment Unadjusted Trial Balance Adjustments Adjusted Trial Balance Account Title Dr. Cr. Dr. Cr. Dr. Cash 99 Accounts Receivable 264 26 Supplies 26 13 X Prepaid Insurance 40 33 Land 330 Equipment 132 Accumulated Depreciation 13 13 Accounts Payable 119 Wages Payable 0 13 Brenda Schultz, Capital 621 Brenda Schultz, Drawing 26 26 297 Fees Earned 13 66 Wages Expense Rent Expense 40 33 0 Insurance Expense Utilities Expense 20 13 Wages Payable Brenda Schultz, Capital Brenda Schultz, Drawing 621 26 Fees Earned 297 26 Wages Expense 66 13 Rent Expense 40 Insurance Expense 33 Utilities Expense 20 13 X Supplies Expense 13 Depreciation Expense Miscellaneous Expense 1,050 1,050 Totals 85 X Fodback Check My Work Adjustments affect both an income statement account and a balance sheet account. Remember that the total debit adjustments must equal the total credit adjustments Also, the adjusted trial balance debit and credit column totals must remain equal. As you prepare the adjusted trial balance, remember you will add a beginning debit(credit) unadjusted amount to a debit(credit) adjustment to obtain the adjusted amount. However, if the unadjusted trial balance amount is a debit and the adjustment is a credit, you will subtract to obtain the adjusted amount. Likewise you will take the difference between a credit unadjusted amount and a debit adjustment to obtain the adjusted amount