Warning: foreach() argument must be of type array|object, bool given in /var/www/html/web/app/themes/studypress-core-theme/template-parts/header/mobile-offcanvas.php on line 20

What is a worksheet, and how is it used to help prepare an adjusted trial balance?

Short Answer

Expert verified

Worksheet is doscument prepared internally that summarize the data which assist in preparing the financial statements. It summarizes the accounts of the business and adjustments are recorded in the worksheet, which helps in preparing adjusted trial balance.

Step by step solution

01

Step-by-Step SolutionStep 1: Explanation on Adjusted Trial Balance

It is prepared after the journalizing and posting of adjusting entries in the books of accounts.

02

Sections of Worksheet

Worksheet is divided into four sections such as account names, unadjusted trial balance, adjustments and adjusted trial balance.

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Question :The accounting records of Mackay Architects include the following selected, unadjusted balances at March 31: Accounts Receivable, \(1,500; Office Supplies, \)700; Prepaid Rent, \(2,240; Equipment, \)8,000; Accumulated Depreciationโ€”Equipment, \(0; Salaries Payable, \)0; Unearned Revenue, \(900; Service Revenue, \)4,100; Salaries Expense, \(800; Supplies Expense, \)0; Rent Expense, \(0; Depreciation Expenseโ€”Equipment, \)0. The data developed for the March 31 adjusting entries are as follows: a. Service revenue accrued, \(700. b. Unearned revenue that has been earned, \)100. c. Office Supplies on hand, \(300. d. Salaries owed to employees, \)200. e. One month of prepaid rent has expired, \(560. f. Depreciation on equipment, \)120. Requirements 1. Open a T-account for each account using the unadjusted balances given. 2. Journalize the adjusting entries using the letter and March 31 date in the date column. 3. Post the adjustments to the T-accounts, entering each adjustment by letter. Show each accountโ€™s adjusted balance.

On October 1, Orlando Gold Exchange paid cash of $57,600 for computers that are expected to remain useful for three years. At the end of three years, the value of the computers is expected to be zero. Requirements 1. Calculate the amount of depreciation for the month of October using the straightline depreciation method. 2. Record the adjusting entry for depreciation on October 31. 3. Post the purchase of October 1 and the depreciation on October 31 to T-accounts for the following accounts: Computer Equipment, Accumulated Depreciationโ€” Computer Equipment, and Depreciation Expenseโ€”Computer Equipment. Show their balances at October 31. 4. What is the computer equipmentโ€™s book value on October 31?

Question :Consider the following independent situations at December 31: a. On October 1, a business collected \(3,000 rent in advance, debiting Cash and crediting Unearned Revenue. The tenant was paying one yearโ€™s rent in advance. On December 31, the business must account for the amount of rent it has earned. b. Salaries expense is \)1,800 per dayโ€”Monday through Fridayโ€”and the business pays employees each Friday. This year, December 31 falls on a Thursday. c. The unadjusted balance of the Office Supplies account is \(3,000. Office supplies on hand total \)1,900. d. Equipment depreciation was \(500. e. On April 1, when the business prepaid \)4,320 for a two-year insurance policy, the business debited Prepaid Insurance and credited Cash. Journalize the adjusting entry needed on December 31 for each situation. Use the letters to label the journal entries

The Pink Peonies Law Firm prepays for advertising in the local newspaper. On January 1, the law firm paid $3,000 for 10 months of advertising. How much advertising expense should Pink Peonies Law Firm record for the two months ending February 28 under the a. cash basis? b. accrual basis?

Question :Laughter Landscaping has collected the following data for the December 31 adjusting entries: a. Each Friday, Laughter pays employees for the current weekโ€™s work. The amount of the weekly payroll is \(8,000 for a five-day workweek. This year, December 31 falls on a Tuesday. Laughter will pay its employees on January 3. b. On January 1 of the current year, Laughter purchases an insurance policy that covers two years, \)8,000.c. The beginning balance of Office Supplies was \(4,300. During the year, Laughter purchased office supplies for \)5,600, and at December 31 the office supplies on hand total \(1,500. d. During December, Laughter designed a landscape plan and the client prepaid \)6,500. Laughter recorded this amount as Unearned Revenue. The job will take several months to complete, and Laughter estimates that the company has earned 40% of the total revenue during the current year. e. At December 31, Laughter had earned \(3,000 for landscape services completed for Turnkey Appliances. Turnkey has stated that it will pay Laughter on January 10. f. Depreciation for the current year includes Equipment, \)3,000; and Trucks, \(2,200. g. Laughter has incurred \)250 of interest expense on a $550 interest payment due on January 15. Requirements 1. Journalize the adjusting entry needed on December 31 for each of the previous items affecting Laughter Landscaping. Assume Laughter records adjusting entries only at the end of the year. 2. Journalize the subsequent journal entries for adjusting entries a, d, and g.

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free