1 / 38

Describe the flow of accounting information using the worksheet.

0. 4-1. Objective 1. Describe the flow of accounting information using the worksheet. 0. 4-1. 5. 0. 4-1. Spreadsheet (Work Sheet). Trial Balance. Adjustments. Adjusted TB. Accounts Dr Cr Dr Cr Dr Cr.

kylee-bennett
Download Presentation

Describe the flow of accounting information using the 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. 0 4-1 Objective 1 Describe the flow of accounting information using the worksheet.

  2. 0 4-1 5

  3. 0 4-1 Spreadsheet (Work Sheet) Trial Balance Adjustments Adjusted TB Accounts Dr Cr Dr Cr Dr Cr Accounts are listed in the Trial Balance column using the ending balance found in the general ledger. 6

  4. 0 4-1 Spreadsheet (Work Sheet) Trial Balance Adjustments Adjusted TB Accounts Dr Cr Dr Cr Dr Cr Adjustments are entered here. Two possibilities: 1. Deferrals – Existing balances are changed. 2. Accruals – New information is entered. 7

  5. 0 4-1 Spreadsheet (Work Sheet) Trial Balance Adjustments Adjusted TB Accounts Dr Cr Dr Cr Dr Cr Adjustments are combined with the trial balance. Account balances are now adjusted. 8

  6. 0 4-1 Spreadsheet (Work Sheet) Adjusted TB Income State. Balance Sheet Accounts Dr Cr Dr Cr Dr Cr Revenue and expense balances in the Adjusted Trial Balance column are extended to the Income Statement column. 9

  7. 0 4-1 Spreadsheet (Work Sheet) Adjusted TB Income State. Balance Sheet Accounts Dr Cr Dr Cr Dr Cr Asset, liability, owner’s equity, and drawing balances in the Adjusted Trial Balance column are extended to the Balance Sheet column. 10

  8. Example Exercise 4-1 0 4-1 The balances for the accounts listed below appear in the Adjusted Trial Balance columns of the end-of-period spreadsheet (work sheet). Indicate whether each balance should be extended to (a) an Income Statement column or (b) a Balance Sheet column. • Fees Earned • Accounts Payable • Rent Revenue • Supplies • Amber Bablock, Drawing • Utilities Expense • Accumulated Depreciation—Equipment • Unearned Rent 11

  9. Follow My Example 4-1 0 4-1 • Balance Sheet column • Income Statement column • Balance Sheet column • Balance Sheet column • Income Statement column • Balance Sheet column • Income Statement column • Balance Sheet column For Practice: PE 4-1A, PE 4-1B 12

  10. 0 Appendix End-of-Period Spreadsheet (Work Sheet)

  11. 0 The end-of-period spreadsheet (work sheet) shown in the following slides does not have the usual spreadsheet headings due to space constraints.

  12. 0 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Account Title Debit Credit Debit Credit Debit Credit 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Cash 2,065 Accounts Receivable 2,220 Supplies 2,000 Prepaid Insurance 2,400 Land 20,000 Office Equipment 1,800 Accounts Payable 900 Unearned Rent 360 Chris Clark, Capital 25,000 Chris Clark, Drawing 4,000 Fees Earned 16,340 Wages Expense 4,275 Rent Expense 1,600 Utilities Expense 985 Supplies Expense 800 Miscellaneous Expense 455 42,600 42,600 The unadjusted trial balance is checked for equality. 55

  13. 0 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Account Title Debit Credit Debit Credit Debit Credit 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Cash 2,065 Accounts Receivable 2,220 Supplies 2,000 Prepaid Insurance 2,400 Land 20,000 Office Equipment 1,800 Accounts Payable 900 Unearned Rent 360 Chris Clark, Capital 25,000 Chris Clark, Drawing 4,000 Fees Earned 16,340 Wages Expense 4,275 Rent Expense 1,600 Utilities Expense 985 Supplies Expense 800 Miscellaneous Expense 455 42,600 42,600 (a) 1,240 Cost of supplies on hand at end of period is $760. (a) 1,240 56

  14. Accounts are added as needed. 0 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Account Title Debit Credit Debit Credit Debit Credit 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Cash 2,065 Accounts Receivable 2,220 Supplies 2,000 (a) 1,240 Prepaid Insurance 2,400 Land 20,000 Office Equipment 1,800 Accounts Payable 900 Unearned Rent 360 Chris Clark, Capital 25,000 Chris Clark, Drawing 4,000 Fees Earned 16,340 Wages Expense 4,275 Rent Expense 1,600 Utilities Expense 985 Supplies Expense 800 (a) 1,240 Miscellaneous Expense 455 42,600 42,600 (b) 200 The insurance expense for December is $200 ($2,400/12) Insurance Expense (b) 200 57

  15. 0 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Account Title Debit Credit Debit Credit Debit Credit 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Cash 2,065 Accounts Receivable 2,220 Supplies 2,000 (a) 1,240 Prepaid Insurance 2,400 (b) 200 Land 20,000 Office Equipment 1,800 Accounts Payable 900 Unearned Rent 360 Chris Clark, Capital 25,000 Chris Clark, Drawing 4,000 Fees Earned 16,340 Wages Expense 4,275 Rent Expense 1,600 Utilities Expense 985 Supplies Expense 800 (a) 1,240 Miscellaneous Expense 455 42,600 42,600 Rent revenue earned during December was $120. (c) 120 Insurance Expense (b) 200 58 Rent Revenue (c) 120

  16. 0 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Account Title Debit Credit Debit Credit Debit Credit 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Cash 2,065 Accounts Receivable 2,220 Supplies 2,000 (a) 1,240 Prepaid Insurance 2,400 (b) 200 Land 20,000 Office Equipment 1,800 Accounts Payable 900 Unearned Rent 360 (c) 120 Chris Clark, Capital 25,000 Chris Clark, Drawing 4,000 Fees Earned 16,340 Wages Expense 4,275 Rent Expense 1,600 Utilities Expense 985 Supplies Expense 800 (a) 1,240 Miscellaneous Expense 455 42,600 42,600 Wages accrued but not paid at the end of December totaled $250. (d) 250 Insurance Expense (b) 200 Rent Revenue (c) 120 59 Wages Payable (d) 250

  17. 0 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Account Title Debit Credit Debit Credit Debit Credit 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Cash 2,065 Accounts Receivable 2,220 Supplies 2,000 (a) 1,240 Prepaid Insurance 2,400 (b) 200 Land 20,000 Office Equipment 1,800 Accounts Payable 900 Unearned Rent 360 (c) 120 Chris Clark, Capital 25,000 Chris Clark, Drawing 4,000 Fees Earned 16,340 Wages Expense 4,275 (d) 250 Rent Expense 1,600 Utilities Expense 985 Supplies Expense 800 (a) 1,240 Miscellaneous Expense 455 42,600 42,600 (e) 500 Fees accrued at the end of December but not recorded total $500. (e) 500 Insurance Expense (b) 200 Rent Revenue (c) 120 Wages Payable (d) 250 60

  18. 0 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Account Title Debit Credit Debit Credit Debit Credit 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Cash 2,065 Accounts Receivable 2,220 (e) 500 Supplies 2,000 (a) 1,240 Prepaid Insurance 2,400 (b) 200 Land 20,000 Office Equipment 1,800 Accounts Payable 900 Unearned Rent 360 (c) 120 Chris Clark, Capital 25,000 Chris Clark, Drawing 4,000 Fees Earned 16,340 (e) 500 Wages Expense 4,275 (d) 250 Rent Expense 1,600 Utilities Expense 985 Supplies Expense 800 (a) 1,240 Miscellaneous Expense 455 42,600 42,600 Depreciation of office equipment is $50 for December. Insurance Expense (b) 200 Rent Revenue (c) 120 Wages Payable (d) 250 61 Depreciation Expense (f) 50 Accum. Depreciation (f) 50

  19. 0 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Account Title Debit Credit Debit Credit Debit Credit 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Cash 2,065 Accounts Receivable 2,220 (e) 500 Supplies 2,000 (a) 1,240 Prepaid Insurance 2,400 (b) 200 Land 20,000 Office Equipment 1,800 Accounts Payable 900 Unearned Rent 360 (c) 120 Chris Clark, Capital 25,000 Chris Clark, Drawing 4,000 Fees Earned 16,340 (e) 500 Wages Expense 4,275 (d) 250 Rent Expense 1,600 Utilities Expense 985 Supplies Expense 800 (a) 1,240 Miscellaneous Expense 455 42,600 42,600 To make more space, let’s remove the heading. Insurance Expense (b) 200 Rent Revenue (c) 120 Wages Payable (d) 250 Depreciation Expense (f) 50 Accum. Depreciation (f) 50 62

  20. Unadjusted Adjusted Trial Balance Adjustments Trial Balance 0 Account Title Debit Credit Debit Credit Debit Credit 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Cash 2,065 Accounts Receivable 2,220 (e) 500 Supplies 2,000 (a) 1,240 Prepaid Insurance 2,400 (b) 200 Land 20,000 Office Equipment 1,800 Accounts Payable 900 Unearned Rent 360 (c) 120 Chris Clark, Capital 25,000 Chris Clark, Drawing 4,000 Fees Earned 16,340 (e) 500 Wages Expense 4,275 (d) 250 Rent Expense 1,600 Utilities Expense 985 Supplies Expense 800 (a) 1,240 Miscellaneous Expense 455 42,600 42,600 Insurance Expense (b) 200 Rent Revenue (c) 120 Wages Payable (d) 250 Depreciation Expense (f) 50 Accum. Depreciation (f) 50 2,360 2,360 Summed and ruled 63

  21. 0 The next step is to add or subtract the adjustments from (to) the amounts found in the Unadjusted Trial Balance columns and enter the results in the Adjusted Trial Balance columns.

  22. Unadjusted Adjusted Trial Balance Adjustments Trial Balance 0 Account Title Debit Credit Debit Credit Debit Credit 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Cash 2,065 Accounts Receivable 2,220 (e) 500 Supplies 2,000 (a) 1,240 Prepaid Insurance 2,400 (b) 200 Land 20,000 Office Equipment 1,800 Accounts Payable 900 Unearned Rent 360 (c) 120 Chris Clark, Capital 25,000 Chris Clark, Drawing 4,000 Fees Earned 16,340 (e) 500 Wages Expense 4,275 (d) 250 Rent Expense 1,600 Utilities Expense 985 Supplies Expense 800 (a) 1,240 Miscellaneous Expense 455 42,600 42,600 Insurance Expense (b) 200 Rent Revenue (c) 120 Wages Payable (d) 250 Depreciation Expense (f) 50 Accum. Depreciation (f) 50 2,360 2,360 65

  23. Unadjusted Adjusted Trial Balance Adjustments Trial Balance 0 Account Title Debit Credit Debit Credit Debit Credit 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Cash 2,065 2,065 Accounts Receivable 2,220 (e) 500 2,720 Supplies 2,000 (a) 1,240760 Prepaid Insurance 2,400 (b) 200 2,200 Land 20,000 20,000 Office Equipment 1,800 1,800 Accounts Payable 900 900 Unearned Rent 360 (c) 120 240 Chris Clark, Capital 25,00025,000 Chris Clark, Drawing 4,000 4,000 Fees Earned 16,340 (e) 500 16,840 Wages Expense 4,275 (d) 250 4,525 Rent Expense 1,600 1,600 Utilities Expense 985 985 Supplies Expense 800 (a) 1,2402,040 Miscellaneous Expense 455 455 42,600 42,600 Insurance Expense (b) 200 200 Rent Revenue (c) 120 120 Wages Payable (d) 250 250 Depreciation Expense (f) 50 50 Accum. Depreciation (f) 50 50 2,360 2,360 43,400 43,400 66

  24. 0 Because of space constraints, the Unadjusted Trial Balance and the Adjustments columns will not be shown in the following slides.

  25. Adjusted Trial Balance Income Statement Balance Sheet 0 Account Title Debit Credit Debit Credit Debit Credit 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Cash 2,065 Accounts Receivable 2,720 Supplies 760 Prepaid Insurance 2,200 Land 20,000 Office Equipment 1,800 Accounts Payable 900 Unearned Rent 240 Chris Clark, Capital 25,000 Chris Clark, Drawing 4,000 Fees Earned 16,840 Wages Expense 4,525 Rent Expense 1,600 Utilities Expense 985 Supplies Expense 2,040 Miscellaneous Expense 455 Insurance Expense 200 Rent Revenue 120 Wages Payable 250 Depreciation Expense 50 Accum. Depreciation 50 43,400 43,400 68

  26. 0 The next step is to extend amounts in the Adjusted Trial Balance columns to the Income Statement and Balance Sheet columns.

  27. Adjusted Trial Balance Income Statement Balance Sheet 0 Account Title Debit Credit Debit Credit Debit Credit 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Cash 2,065 Accounts Receivable 2,720 Supplies 760 Prepaid Insurance 2,200 Land 20,000 Office Equipment 1,800 Accounts Payable 900 Unearned Rent 240 Chris Clark, Capital 25,000 Chris Clark, Drawing 4,000 Fees Earned 16,840 Wages Expense 4,525 Rent Expense 1,600 Utilities Expense 985 Supplies Expense 2,040 Miscellaneous Expense 455 Insurance Expense 200 Rent Revenue 120 Wages Payable 250 Depreciation Expense 50 Accum. Depreciation 50 43,400 43,400 70

  28. Adjusted Trial Balance Income Statement Balance Sheet 0 Account Title Debit Credit Debit Credit Debit Credit 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Cash 2,065 2,065 Accounts Receivable 2,720 2,720 Supplies 760 760 Prepaid Insurance 2,200 2,200 Land 20,000 20,000 Office Equipment 1,800 1,800 Accounts Payable 900 900 Unearned Rent 240 240 Chris Clark, Capital 25,00025,000 Chris Clark, Drawing 4,000 4,000 Fees Earned 16,840 16,840 Wages Expense 4,525 4,525 Rent Expense 1,600 1,600 Utilities Expense 985 985 Supplies Expense 2,040 2,040 Miscellaneous Expense 455 455 Insurance Expense 200 200 Rent Revenue 120 120 Wages Payable 250 250 Depreciation Expense 50 50 Accum. Depreciation 50 50 43,400 43,400 71

  29. 0 The Income Statement and Balance Sheet columns are totaled.

  30. Adjusted Trial Balance Income Statement Balance Sheet 0 Account Title Debit Credit Debit Credit Debit Credit 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Cash 2,065 2,065 Accounts Receivable 2,720 2,720 Supplies 760 760 Prepaid Insurance 2,200 2,200 Land 20,000 20,000 Office Equipment 1,800 1,800 Accounts Payable 900 900 Unearned Rent 240 240 Chris Clark, Capital 25,000 25,000 Chris Clark, Drawing 4,000 4,000 Fees Earned 16,840 16,840 Wages Expense 4,525 4,525 Rent Expense 1,600 1,600 Utilities Expense 985 985 Supplies Expense 2,040 2,040 Miscellaneous Expense 455 455 Insurance Expense 200 200 Rent Revenue 120 120 Wages Payable 250 250 Depreciation Expense 50 50 Accum. Depreciation 50 5043,400 43,400 73

  31. Adjusted Trial Balance Income Statement Balance Sheet 0 Account Title Debit Credit Debit Credit Debit Credit 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Cash 2,065 2,065 Accounts Receivable 2,720 2,720 Supplies 760 760 Prepaid Insurance 2,200 2,200 Land 20,000 20,000 Office Equipment 1,800 1,800 Accounts Payable 900 900 Unearned Rent 240 240 Chris Clark, Capital 25,000 25,000 Chris Clark, Drawing 4,000 4,000 Fees Earned 16,840 16,840 Wages Expense 4,525 4,525 Rent Expense 1,600 1,600 Utilities Expense 985 985 Supplies Expense 2,040 2,040 Miscellaneous Expense 455 455 Insurance Expense 200 200 Rent Revenue 120 120 Wages Payable 250 250 Depreciation Expense 50 50 Accum. Depreciation 50 5043,400 43,400 9,855 16,960 33,545 26,440 74

  32. 0 The net income or net loss is determined. Then the Income Statement and Balance Sheet columns are totaled and double-ruled.

  33. Adjusted Trial Balance Income Statement Balance Sheet 0 Account Title Debit Credit Debit Credit Debit Credit 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Cash 2,065 2,065 Accounts Receivable 2,720 2,720 Supplies 760 760 Prepaid Insurance 2,200 2,200 Land 20,000 20,000 Office Equipment 1,800 1,800 Accounts Payable 900 900 Unearned Rent 240 240 Chris Clark, Capital 25,000 25,000 Chris Clark, Drawing 4,000 4,000 Fees Earned 16,840 16,840 Wages Expense 4,525 4,525 Rent Expense 1,600 1,600 Utilities Expense 985 985 Supplies Expense 2,040 2,040 Miscellaneous Expense 455 455 Insurance Expense 200 200 Rent Revenue 120 120 Wages Payable 250 250 Depreciation Expense 50 50 Accum. Depreciation 50 5043,400 43,400 9,855 16,960 33,545 26,440 76

  34. Adjusted Trial Balance Income Statement Balance Sheet 77 0 Account Title Debit Credit Debit Credit Debit Credit 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Cash 2,065 2,065 Accounts Receivable 2,720 2,720 Supplies 760 760 Prepaid Insurance 2,200 2,200 Land 20,000 20,000 Office Equipment 1,800 1,800 Accounts Payable 900 900 Unearned Rent 240 240 Chris Clark, Capital 25,000 25,000 Chris Clark, Drawing 4,000 4,000 Fees Earned 16,840 16,840 Wages Expense 4,525 4,525 Rent Expense 1,600 1,600 Utilities Expense 985 985 Supplies Expense 2,040 2,040 Miscellaneous Expense 455 455 Insurance Expense 200 200 Rent Revenue 120 120 Wages Payable 250 250 Depreciation Expense 50 50 Accum. Depreciation 50 5043,400 43,400 9,855 16,960 33,545 26,440 Net income 7,105 7,105 16,960 16,960 33,545 33,545

  35. Income Statement Balance Sheet 9,855 16,960 33,545 26,440 7,105 7,105 16,960 16,960 33,545 33,545 Net Income Net Income 0 The difference between the Income Statement column totals is the net income (or net loss) for the period. 78

  36. 0 4-2 Objective 2 Prepare financial statements from adjusted account balances.

  37. 0 4-2 To balance sheet 14

  38. 0 4-2 (Concluded) From statement of owner’ equity 15

More Related