preparing a worksheet n.
Skip this Video
Loading SlideShow in 5 Seconds..
Preparing a worksheet PowerPoint Presentation
Download Presentation
Preparing a worksheet

Loading in 2 Seconds...

  share
play fullscreen
1 / 27
Download Presentation

Preparing a worksheet - PowerPoint PPT Presentation

melvin-taylor
84 Views
Download Presentation

Preparing a worksheet

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Preparing a worksheet Chapter 6 Section 1

  2. What is the worksheet • Worksheet is used for a couple of things: • Recheck our trial balance • To make adjustments to accounts • To prepare our balance sheet at the end of the year • To prepare out income statement at the end of the year • To determine our net income

  3. The 6th step of the Accounting Cycle: The work Sheet

  4. Step #1 • Take all of the balances from the general ledger and place them into the Trial balance columns of the worksheet.

  5. 156791 156791

  6. Work on “on your own” on page 153

  7. Adjustments Section 2

  8. Definition of adjustment The number of things change from the beginning of the year to the end of the year. Supplies Beg------------------ Supplies End 100 10 Prepaid Insurance Beg -----PPI End 1200 1100

  9. We record those changes (adjustments) in the adjustment columns. • Because both of these accounts are assets. If the number goes up we Debit • If it goes down we credit

  10. a b b a

  11. Please work “on your own” on page 158

  12. Chapter 8 Section 3 Extending Amounts Across the worksheet

  13. Next step in preparing a work sheet • Step 1 • After placing all of the accounts in the proper places and putting the numbers that correspond with them, and making sure that the two columns equal. • Step 2 • Take the numbers and move them into the proper columns

  14. Three major rules to remember • Accounts that go on the Income Statement • Revenue, expenses

  15. Three major rules to remember • Accounts that go on the Income Statement • Revenue, expenses • Accounts that go on the Balance Sheet • Assets, Liabilities, Owners Equity

  16. Three major rules to remember • Accounts that go on the Income Statement • Revenue, expenses • Accounts that go on the Balance Sheet • Assets, Liabilities, Owners Equity • If all else fails, everything above the INCOME SUMMARY goes in the balance sheet, every thing after goes in the income statement

  17. Total the columns • Total the columns in the income statement • Total the columns in the balance sheet

  18. Finishing the work sheet • In the income statement • Take the credit side and subtract out the debit side. • In the balance sheet columns • Take the debit side and subtract out the credit side.

  19. Finishing the work sheet • In the income statement • Take the credit side and subtract out the debit side. • In the balance sheet columns • Take the debit side and subtract out the credit side. • Rule of thumb after subtracting the numbers it always goes under the smaller of the amounts so that we may get it to equal.

  20. Problems • 7-1,2,3,4,5