On March 31, the following data were accumulated to assist the accountant in preparing the adjusting entries for Potomac Realty: • The supplies account balance on March 31 is $5,865, the supplies on hand on March 31 are $1,330. • The unearned rent account balance on March 31 is $4,100 representing the receipt of an advance payment on March 1 of four months' rent from tenants. • Wages accrued but not paid at March 31 are $2,030. • Fees accrued but unbilled at March 31 are $18,090. • Depreciation of office equipment is $4,500.

On March 31, the following data were accumulated to assist the accountant in preparing the adjusting entries for Potomac Realty: • The supplies account balance on March 31 is $5,865, the supplies on hand on March 31 are $1,330. • The unearned rent account balance on March 31 is $4,100 representing the receipt of an advance payment on March 1 of four months' rent from tenants. • Wages accrued but not paid at March 31 are $2,030. • Fees accrued but unbilled at March 31 are $18,090. • Depreciation of office equipment is $4,500.

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

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.
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.
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.
At the end of April, the first month of operations, the following selected data were taken from the financial statements of Shelby Crawford, an attorney: In preparing the financial statements, adjustments for the following data were overlooked: Supplies used during April, 2,750. Unbilled fees earned at April 30, 23,700. Depreciation of equipment for April, 1,800. Accrued wages at April 30, 1,400. Instructions 1. Journalize the entries to record the omitted adjustments. 2. Determine the correct amount of net income for April and the total assets, liabilities, and owners equity at April 30. In addition to indicating the corrected amounts, indicate the effect of each omitted adjustment by setting up and completing a columnar table similar to the following. The adjustment for supplies used is presented as an example.
At the end of August, the first month of operations, the following selected data were taken from the financial statements of Tucker Jacobs, an attorney: In preparing the financial statements, adjustments for the following data were overlooked: Unbilled fees earned at August 31, 31,900. Depreciation of equipment for August, 7,500. Accrued wages at August 31, 5,200. Supplies used during August, 3,000. Instructions 1. Journalize the entries to record the omitted adjustments. 2. Determine the correct amount of net income for August and the total assets, liabilities, and owners equity at August 31. In addition to indicating the corrected amounts, indicate the effect of each omitted adjustment by setting up and completing a columnar table similar to the following. The first adjustment is presented as an example.
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.
Considering the following events, determine which month the revenue or expenses would be recorded using the accounting method specified. a. Gerber Company uses the cash basis of accounting. Gerber prepays cash in May for insurance that only covers the following month, (June). b. Matthews and Dudley Attorneys uses the accrual basis of accounting. Matthews and Dudley Attorneys receives cash from customers in June for services to be performed in July. c. Eckstein Company uses the accrual basis of accounting. Eckstein prepays cash in October for rent that covers the following month, (October). d. Gerbino Company uses the cash basis of accounting. Gerbino makes a sale to a customer in February but does not expect payment until March.
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
Reece Financial Services Co., which specializes in appliance repair services, is owned and operated by Joni Reece. Reece Financial Services Co.s accounting clerk prepared the following unadjusted trial balance at July 31, 2016: The data needed to determine year-end adjustments are as follows: a. Depreciation of building for the year, 6,400. b. Depreciation of equipment for the year, 2,800. c. Accrued salaries and wages at July 31, 900. d. Unexpired insurance at July 31, 1,500. e. Fees earned but unbilled on July 31, 10,200. f. Supplies on hand at July 31, 615. g. 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 preparean adjusted trial balance.
The following accounts appear in the ledger of Celso and Company as of June 30, the end of this fiscal year. The data needed for the adjustments on June 30 are as follows: ab.Merchandise inventory, June 30, 54,600. c.Insurance expired for the year, 475. d.Depreciation for the year, 4,380. e.Accrued wages on June 30, 1,492. f.Supplies on hand at the end of the year, 100. Required 1. Prepare a work sheet for the fiscal year ended June 30. Ignore this step if using CLGL. 2. Prepare an income statement. 3. Prepare a statement of owners equity. No additional investments were made during the year. 4. Prepare a balance sheet. 5. Journalize the adjusting entries. 6. Journalize the closing entries. 7. Journalize the reversing entry as of July 1, for the wages that were accrued in the June adjusting entry. Check Figure Net income, 14,066
The balances of the ledger accounts of Pelango Furniture as of December 31, the end of its fiscal year, are as follows: Data for the adjustments are as follows: ab. Merchandise Inventory at December 31, 104,565. c. Wages accrued at December 31, 934. d. Supplies inventory (on hand) at December 31, 755. e. Depreciation of store equipment, 4,982. f. Depreciation of office equipment, 1,531. g. Insurance expired during the year, 935. h. Rent earned, 2,450. Required 1. Complete the work sheet after entering the account names and balances onto the work sheet. Ignore this step if using CLGL. 2. Journalize the adjusting entries. If using manual working papers, record adjusting entries on journal page 16.
The balances of the ledger accounts of Beldren Home Center as of December 31, the end of its fiscal year, are as follows: Data for the adjustments are as follows: ab. Merchandise Inventory at December 31, 102,765. c. Wages accrued at December 31, 1,834. d. Supplies inventory (on hand) at December 31, 645. e. Depreciation of store equipment, 5,782. f. Depreciation of office equipment, 1,791. g. Insurance expired during the year, 845. h. Rent earned, 2,500. Required 1. Complete the work sheet after entering the account names and balances onto the work sheet. Ignore this step if using CLGL. 2. Journalize the adjusting entries. If using manual working papers, record adjusting entries on journal page 16.