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 :Chef ’s Catering completed the following selected transactions during May 2018: Learning Objectives 1, 2 Learning Objectives 1, 2 > Exercises May 1 Prepaid rent for three months, \(2,400. 5 Received and paid electricity bill, \)700. 9 Received cash for meals served to customers, \(2,600. 14 Paid cash for kitchen equipment, \)3,000. 23 Served a banquet on account, \(2,800. 31 Made the adjusting entry for rent (from May 1). 31 Accrued salary expense, \)1,600. 31 Recorded depreciation for May on kitchen equipment, \(50. Date May 1 \)(2,400) $0 Cash Basis Amount of Revenue (Expense) Accrual Basis Amount of Revenue (Expense) Amount of Revenue (Expense) for May Requirements 1. Show whether each transaction would be handled as a revenue or an expense using both the cash basis and accrual basis accounting systems by completing the following table. (Expenses should be shown in parentheses.) Also, indicate the dollar amount of the revenue or expense. The May 1 transaction has been completed as an example. 2. After completing the table, calculate the amount of net income or net loss for Chef ’s Catering under the accrual basis and cash basis accounting systems for May. 3. Considering your results from Requirement 2, which method gives the best picture of the true earnings of Chef ’s Catering? Why?

Question :Seacoast Magazine sells subscriptions for $36 for 18 issues. The company collects cash in advance and then mails out the magazines to subscribers each month. Apply the revenue recognition principle to determine a. when Seacoast Magazine should record revenue for this situation. b. the amount of revenue Seacoast Magazine should record for eight issues.

Question :The worksheet of Macey’s Landscaping Services follows but is incomplete.Requirements 1. Calculate and enter the adjusted account balances in the Adjusted Trial Balance columns. 2. Describe each adjusting entry. For example, a. Prepaid rent expires, $1,150.

Question :Momentous Occasions is a photography business that shoots videos at college parties. The freshman class pays \(1,000 in advance on March 3 to guarantee services for its party to be held on April 2. The sophomore class promises a minimum of \)2,800 for filming its formal dance and actually pays cash of \(4,100 on February 28 at the dance. Answer the following questions about the correct way to account for revenue under the accrual basis: a. Considering the \)1,000 paid by the freshman class, on what date was revenue recognized? Did the recognition occur on the same date cash was received? b. Considering the $4,100 paid by the sophomore class, on what date was revenue recognized? Did the recognition occur on the same date cash was received?

Question :At the beginning of the year, Modish Advertising owed customers \(2,100 for unearned revenue collected in advance. During the year, Modish received advance cash receipts of \)6,100 and earned \(20,000 of service revenue (exclusive of any amount earned from advance payments). At year-end, the liability for unearned revenue is \)3,100 and unadjusted service revenue is $20,000. Requirements 1. Record the adjusting entry assuming that Modish records the cash receipt of unearned revenue by initially crediting a liability account. Post the adjusting entry to the Unearned Revenue and Service Revenue T-accounts. Make sure to include the beginning balance and additional unearned revenue in the Unearned Revenue T-account. 2. Record the adjusting entry assuming that Modish records the cash receipt of unearned revenue by initially crediting a revenue account. Post the adjusting entry to the Unearned Revenue and Service Revenue T-accounts. Make sure to include the beginning balance in the Unearned Revenue T-account and the additional unearned revenue in the Service Revenue T-account. 3. Compare the ending balances of the T-accounts under both approaches. Are they the same?

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