1 / 27

Preparing a worksheet

Preparing a worksheet. Chapter 6 Section 1. 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

melvin-taylor
Download Presentation

Preparing a worksheet

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

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

More Related