Preparing a worksheet

• Accounting
• Secondary Education

Do you think all the accounts are listed on the worksheet trial balance section?What about those with a zero balance?

8.1:Preparing the worksheet

Pages 199-203

Objectives

Summarize the importance of the items in a trial balance section.

Analyze a source document of a company

Create a six column worksheet 

A Worksheet

Like the T account, the work sheet is a tool that the accountant uses. With the work sheet, an accountant gathers all of the information needed to prepare the financial statements and to complete the other end-of-period activities.

All of the general ledger accounts are listed on the work sheet, even
those that have a zero balance. Listing all of the accounts avoids accidentally omitting an account and ensures that the work sheet contains all accounts 

needed to prepare the financial reports.

https:

Activity 1: Individually: What
is the order of accounts on the work
sheet by classification?

Why is the above order followed in the trial balance section of a worksheet

Pairs

1.Farah and Maria

2. Zainab and Raghad

3. Mariam and Yasmeen

4. Shatha and Malika

5.S. Ahmed and S. Mohammed

Questions based on the source document

Based on the invoice presented here, answer the following questions in your working papers.

1. Which company ordered the supplies?

3. On what date were the supplies received?

4. What does item 1  cost?

5. How many item 2  were ordered?

6. What is the invoice number?

Answer Here

Refer to textbook pages 203 

The columns in the Trial Balance section of the work sheet have different totals:

Debit total =$34,800

Credit total =$35,600

The accountant
discovered that  the balance for  Advertising Expense had been entered in  the Credit column

instead of the Debit column. Calculate the balance for the

Advertising Expense account that should have been entered

in the Debit column.

What is the new total
of the Debit column  and Credit column?

Answer here

Answer

Out-of-balance amount: $800; correct balance: $400;

 debit total: $35,200;

 credit total: $35,200

Check the answers of your friends of the given question.

Groups

1.Maria, Farah, Malika, S. Mohammed, Shatha

2.Mariam, Zainab, Raghad, Yasmeen,S. Ahmed

Group Work: Create a six column worksheet .List the items and amounts of your choice. Do it in a word document and post here.

GIve the learning targets of the lesson.

Write the main points of the lesson.