In: Accounting
Appendix: Completing an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. Complete the following end-of-period spreadsheet for Alert Security Services Co. If a 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, 2019 Adjusted Trial Balance Income Statement Balance Sheet Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 250 Accounts Receivable 1,830 Supplies 83 Prepaid Insurance 62 Land 2,080 Equipment 832 Accum. Depr.-Equipment 166 Accounts Payable 749 Wages Payable 83 Brenda Schultz, Capital 3,620 Brenda Schultz, Drawing 166 Fees Earned 2,038 Wages Expense 499 Rent Expense 250 Insurance Expense 208 Utilities Expense 146 Supplies Expense 125 Depreciation Expense 83 Miscellaneous Expense 42 Totals 6,656 6,656 Net income (loss) Check My Work
Adjusted Trial Balance | Income Statement | Balance Sheet | ||||
Debit | Credit | Debit | Credit | Debit | Credit | |
Cash | 250 | 250 | ||||
Accounts Receivable | 1830 | 1830 | ||||
Supplies | 83 | 83 | ||||
Prepaid Insurance | 62 | 62 | ||||
Land | 2080 | 2080 | ||||
Equipment | 832 | 832 | ||||
Accum. Depr Equipment | 166 | 166 | ||||
Accounts Payable | 749 | 749 | ||||
Wages Payable | 83 | 83 | ||||
Brenda Schultz,Capital | 3620 | 3620 | ||||
Brenda Schultz,Drawing | 166 | 166 | ||||
Fees earned | 2038 | 2038 | ||||
Wages expense | 499 | 499 | ||||
Rent expense | 250 | 250 | ||||
Insurance expense | 208 | 208 | ||||
Utilities expense | 146 | 146 | ||||
Supplies expense | 125 | 125 | ||||
Depreciation expense | 83 | 83 | ||||
Miscellaneous expense | 42 | 42 | ||||
Totals | 6656 | 6656 | 1353 | 2038 | 5303 | 4618 |
Net income (loss) | 685 | 685 | ||||
2038 | 2038 | 5303 | 5303 |