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-or-period spreadsheet for the year ended Octaber 31, 2019. 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 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, 2019Adjusted Trial BalanceCreditUnadjusted TrialUnadjusted TrialAdjustments AdjustmentsAdjusted TrialAccount TitleBalance DebitBalance CreditDebitCreditBalance DebitCash12Accounts90ReceivableSuppliesBpaid Insurance12Land190Equipment50Accum. Depr.-Equioment

According to the rules of accountancy, all assets and expenses have a normal debit balance, and all…

Answered: Alert Security Services Co. offers…

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter2: Service Company Worksheet (f1work)

Section: Chapter Questions

Problem 1R: The trial balance of Wikki Cleaners at December 31, 2012, the end of the current fiscal year, is as...

See similar textbooks

Similar questions

Reece Financial Services Co., which specializes in appliance repair services, is owned and operated by Joni Reece. Reece Financial Services accounting clerk prepared the following unadjusted trial balance at July 31, 2019: The data needed to determine year-end adjustments are as follows: Depreciation of building for the year, 6,400. Depreciation of equipment for the year, 2,800. Accrued salaries and wages at July 31, 900. Unexpired insurance at July 31, 1,500. Fees earned but unbilled on July 31, 10,200. Supplies on hand at July 31, 615. Rent unearned at July 31, 300. Instructions 1. Journalize the adjusting entries using the following additional accounts: Salaries and Wages Payable, Rent Revenue, Insurance Expense, Depreciation ExpenseBuilding, Depreciation ExpenseEquipment, and Supplies Expense. 2. Determine the balances of the accounts affected by the adjusting entries and prepare an adjusted trial balance.
Worksheet Victoria Company has the following account balances on December 31, 2019, prior to any adjustments: Additional adjustment information: (a) depreciation on buildings, 1,100; on equipment, 600; (b) bad debts expense, 240; (c) interest accumulated but not paid: on note payable, 50; on mortgage payable, 530 (this interest is due during the next accounting period); (d) insurance expired, 175; (e) salaries accrued but not paid 370; (f) rent was collected in advance and the performance obligation is now satisfied, 800; (g) office supplies cm hand at year-end, 230 (expensed when originally purchased earlier in the year); and (h) the income tax rate is 30% on current income and is payable in the first quarter of 2020. Required: 1. Transfer the account balances to a 10-column worksheet and prepare a trial balance. 2. Prepare the adjusting entries in the general journal and complete the worksheet. 3. Prepare the companys income statement, retained earnings statement, and balance sheet. 4. Prepare closing entries in the general journal.
Valley Realty acts as an agent in buying, selling, renting, and managing real estate. The unadjusted trial balance on July 31, 2019, follows: The following business transactions were completed by Valley Realty during August 2019: Aug. 1. Purchased office supplies on account, 3,150. 2.Paid rent on office for month, 7,200. 3.Received cash from clients on account, 83,900. 5.Paid insurance premiums, 12,000. 9.Returned a portion of the office supplies purchased on August 1, receiving full credit for their cost, 400. Analyzing Transactions Aug. 17. Paid advertising expense, 8,000. 23.Paid creditors on account, 13,750. Enter the following transactions on Page 19 of the two-column journal: 29.Paid miscellaneous expenses, 1,700. 30.Paid automobile expense (including rental charges for an automobile), 2,500. 31.Discovered an error in computing a commission during July; received cash from the salesperson for the overpayment, 2,000. 31.Paid salaries and commissions for the month, 53,000. 31.Recorded revenue earned and billed to clients during the month, 183,500. 31.Purchased land for a future building site for 75,000, paying 7,500 in cash and giving a note payable for the remainder. 31.Withdrew cash for personal use, 1,000. 31.Rented land purchased on August 31 to a local university for use as a parking lot during football season (September, October, and November); received advance payment of 5,000. Instructions 1. Record the August 1 balance of each account in the appropriate balance column of a four-column account, write Balance in the item section, and place a check mark () in the Posting Reference column. 2. Journalize the transactions for August in a two-column journal beginning on Page 18. Journal entry explanations may be omitted. 3. Post to the ledger, extending the account balance to the appropriate balance column after each posting. 4. Prepare an unadjusted trial balance of the ledger as of August 31, 2019. 5. Assume that the August 31 transaction for Cindy Getmans cash withdrawal should have been 10,000. (a) Why did the unadjusted trial balance in (4) balance? (b) Journalize the correcting entry. (c) Is this error a transposition or slide?
Elite Realty acts as an agent in buying, selling, renting, and managing real estate. The unadjusted trial balance on March 31, 2019, follows: The following business transactions were completed by Elite Realty during April 2019: Apr. 1. Paid rent on office for month, 6,500. 2.Purchased office supplies on account, 2,300. 5.Paid insurance premiums, 6,000. 10.Received cash from clients on account, 52,300. 15.Purchased land for a future building site for 200,000, paying 30,000 in cash and giving a note payable for the remainder. 17.Paid creditors on account, 6,450. 20.Returned a portion of the office supplies purchased on April 2, receiving full credit for their cost, 325. 23.Paid advertising expense, 4,300. Enter the following transactions on Page 19 of the two-column journal: 27.Discovered an error in computing a commission; received cash from the salesperson for the overpayment, 2,500. 28.Paid automobile expense (including rental charges for an automobile), 1,500. 29.Paid miscellaneous expenses, 1,400. 30.Recorded revenue earned and billed to clients during the month, 57,000. 30.Paid salaries and commissions for the month, 11,900. 30.Withdrew cash for personal use, 4,000. 30.Rented land purchased on April 15 to local merchants association for use as a parking lot in May and June, during a street rebuilding program; received advance payment of 10,000. Instructions 1. Record the April 1, 2019, balance of each account in the appropriate balance column of a four-column account, write Balance in the item section, and place a check mark () in the Posting Reference column. 2. Journalize the transactions for April in a two-column journal beginning on Page 18. Journal entry explanations may be omitted. 3. Post to the ledger, extending the account balance to the appropriate balance column after each posting. 4. Prepare an unadjusted trial balance of the ledger as of April 30, 2019. 5. Assume that the April 30 transaction for salaries and commissions should have been 19,100. (a) Why did the unadjusted trial balance in (4) balance? (b) Journalize the correcting entry. (c) Is this error a transposition or slide?
The trial balance of Wikki Cleaners at December 31, 2012, the end of the current fiscal year, is as follows: Information for the adjusting entries is as follows: a. Cleaning supplies on hand on December 31, 2012, 18,750. b. Insurance premiums expired during the year, 1,800. c. Depreciation on equipment during the year, 21,600. d. Wages accrued but not paid at December 31, 2012, 1,830. As the accountant for Wikki Cleaners, you have been asked to prepare financial statements for the year. A file called F1WORK has been provided to assist you in this assignment. As you review this file, it should be noted that columns H and I will automatically change when you enter values in columns E or G.
The unadjusted trial balance of Recessive Interiors at January 31, 2019, the end of the year, follows: The data needed to determine year-end adjustments are as follows: a. Supplies on hand at January 31 are 2,850. b. Insurance premiums expired during the year are 3,150. c. Depreciation of equipment during the year is 5,250. d. Depreciation of trucks during the year is 4,000. e. Wages accrued but not paid at January 31 are 900. Instructions 1. For each account listed in the unadjusted trial balance, enter the balance in the appropriate Balance column of a four-column account and place a check mark () in the Posting Reference column. 2. (Optional) Enter the unadjusted trial balance on an end-of-period spreadsheet and complete the spreadsheet. Add the accounts listed in part (3) as needed. 3. Journalize and post the adjusting entries, inserting balances in the accounts affected. Record the adjusting entries on Page 26 of the journal. The following additional accounts from Recessive Interiors chart of accounts should be used: Wages Payable, 22; Depreciation ExpenseEquipment, 54; Supplies Expense, 55; Depreciation ExpenseTrucks, 56; Insurance Expense, 57. 4. Prepare an adjusted trial balance. 5. Prepare an income statement, a statement of owners equity (no additional investments were made during the year), and a balance sheet. 6. Journalize and post the closing entries. Record the closing entries on Page 27 of the journal. Indicate closed accounts by inserting a line in both Balance columns opposite the closing entry. 7. Prepare a post-closing trial balance.
Prepare adjusting journal entries, as needed, considering the account balances excerpted from the unadjusted trial balance and the adjustment data. A. supplies actual count at year end, $6,500 B. remaining unexpired insurance, $6,000 C. remaining unearned service revenue, $1,200 D. salaries owed to employees, $2,400 E. depreciation on property plant and equipment, $18,000
On July 1, a client paid an advance payment (retainer) of $5,000 to cover future legal services. During the period, the company completed $3,500 of the agreed-on services for the client. There was no beginning balance in the Unearned Revenue account for the period. Based on the information provided, A. Make the December 31 adjusting journal entry to bring the balances to correct. B. Show the impact that these transactions had.
Prepare journal entries to record the business transaction and related adjusting entry for the following: A. March 1, paid cash for one year premium on insurance contract, $18,000 B. December 31, remaining unexpired balance of insurance, $3,000
On September 1, a company received an advance rental payment of $12,000, to cover six months rent on an office building. There was no beginning balance in the Unearned Rent account for the period. Based on the information provided, A. Make the December 31 adjusting journal entry to bring the balances to correct. B. Show the impact that these transactions had.
Kelly Pitney began her consulting business, Kelly Consulting, on April 1, 2019. The accounting cycle for Kelly Consulting for April, including financial statements, was illustrated in this chapter. During May, Kelly Consulting entered into the following transactions: Instructions 1. The chart of accounts for Kelly Consulting is shown in Exhibit 9, and the post-closingtrial balance as of April 30, 2019, is shown in Exhibit 17. For each account in the post-closing trial balance, enter the balance in the appropriate Balance column of a four-column account. Date the balances May 1, 2019, and place a check mark () in the Posting Reference column. Journalize each of the May transactions in a twocolumn journal starting on Page 5 of the journal and using Kelly Consultings chart of accounts. (Do not insert the account numbers in the journal at this time.) 2. Post the journal to a ledger of four-column accounts. 3. Prepare an unadjusted trial balance. 4. At the end of May, the following adjustment data were assembled. Analyze and use these data to complete parts (5) and (6). a. Insurance expired during May is 275. b. Supplies on hand on May 31 are 715. c. Depreciation of office equipment for May is 330. d. Accrued receptionist salary on May 31 is 325. e. Rent expired during May is 1,600. f. Unearned fees on May 31 are 3,210. 5. (Optional) Enter the unadjusted trial balance on an end-of-period spreadsheet and complete the spreadsheet. 6. Journalize and post the adjusting entries. Record the adjusting entries on Page 7 of the journal. 7. Prepare an adjusted trial balance. 8. Prepare an income statement, a statement of owners equity, and a balance sheet. 9. Prepare and post the closing entries. Record the closing entries on Page 8 of the journal. Indicate closed accounts by inserting a line in both Balance columns opposite the closing entry. 10. Prepare a post-closing trial balance.
The account balances of Bryan Company as of June 30, the end of the current fiscal year, are as follows: Required 1. Data for the adjustments are as follows: a. Expired or used up insurance, 495 b. Depreciation expense on equipment, 670. c. Depreciation expense on the van, 1,190. d. Salary accrued (earned) since the last payday, 540 (owed and to be paid on the next payday). e. Supplies used during the period, 97. Your instructor may want you to use a work sheet for these adjustments. 2. Journalize the adjusting entries. 3. Prepare an income statement. 4. Prepare a statement of owners equity. Assume that there was an additional investment of 2,000 on June 10. 5. Prepare a balance sheet. 6. Journalize the closing entries using the four steps in the correct sequence. Check Figure Net Income, 13,627

SEE MORE QUESTIONS

Recommended textbooks for you

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Financial Accounting

Accounting

ISBN:

9781337272124

Author:

Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:

Cengage Learning

College Accounting (Book Only): A Career Approach

Accounting

ISBN:

9781337280570

Author:

Scott, Cathy J.

Publisher:

South-Western College Pub

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Financial Accounting

Accounting

ISBN:

9781337272124

Author:

Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:

Cengage Learning

College Accounting (Book Only): A Career Approach

Accounting

ISBN:

9781337280570

Author:

Scott, Cathy J.

Publisher:

South-Western College Pub

Intermediate Accounting: Reporting And Analysis

Accounting

ISBN:

9781337788281

Author:

James M. Wahlen, Jefferson P. Jones, Donald Pagach

Publisher:

Cengage Learning

Financial Accounting: The Impact on Decision Make…

Accounting

ISBN:

9781305654174

Author:

Gary A. Porter, Curtis L. Norton

Publisher:

Cengage Learning

Principles of Accounting Volume 1

Accounting

ISBN:

9781947172685

Author:

OpenStax

Publisher:

OpenStax College

SEE MORE TEXTBOOKS