ame Insert Draw Page Layout Formulas Data Review View Cambria (He... 12 7 A A = te BIU A lili DO 1 F B C D E G Optional: It may help to journalize the adjusting entries here first, before completing the worksheet. STEP 1: JOURNALIZE TRANSACTIONS Date Account Name Debit Credit + Assessment Services Worksheet. Prepare Adjusted Trial Balance Adjustments Dr Cr ADJUSTED TB Dr Cr Income Stmt Dr Cr Balance Sheet Dr Trial Balance Dr 13,000 2.000 1300 10.500 3,500 3,000 Account Name 5 Cash - Prepaid Expenses Office Supplies omce Equipment 10 Accum. Depreciation 11 Accounts Payable 12 Salaries Payable 13 Lineared Serv. Revenge 34 Capital 35 Drawing 26 Service Revenue a Salary Expense 13 Depreciation Expense 19 Supplies Expense 20 Insurance Expense 21 22 4.500 11,750 5,600 13,350 3,700 24 25 26 Totals 36,100 36,100 27 28 29 30 31 Excel File Edit View Insert Format Tools Data Window Help ACC 1800 - Comprehensive Pro Formulas Data Review View Home Insert Draw Page Layout Cambria (He... 12 A- A+ A. General Paste B T U $ % 112 H A 1 ACC1800 - ACCOUNTING PROCEDURES 2 Completing the Period-End Worksheet (Chapters 3 & 4 Concepts) STUDENT NAME: Assessment Services has the following UN-ADJUSTED balances at Dec 31, 2019 Cash $ 13,000 Prepaid insurance 2.000 10 Office supplies 1,300 11 Office equipment 10.500 12 Accumulated depreciation office equipment 3,500 13 Accounts payable 3,000 14 Salaries payable 15 Unearned service revenue 4,500 16 Capital 11,750 17 Withdrawals 5,600 Service revenue 13,350 19 Salary expense 3.700 20 Deprecation expense 21 Supplies expense 22 Insurance expense 23 24 Required: 25 '1. Based on the adjustment information listed below, complete the Worksheet. 26 Offeplies will on hand: 100 27 b. med 5335 28 c. de $2.000 29 d. Deprem 5300 30 e achemployees for the same wo wo The the way 1.500 den 31 Monday through Friday December 3 w Waddy 32 Optimalt may help to journalte the adjusting entries her best here completing the worksheet STEP 1: JOURNALIZE TRANSACTIONS 35 Date Account Name Debit Credit 36 27 Problem 1 Worksheet 1-15 2.0E 3-05 Problem 2 1 Journal 2-TA IV J A STEP 7: PREPARE INCOME STATEMENT Cambria (He... 11 A- A- = ab General BIU $ % 3 0 .00 A STEP 8: PREPARE STATEMENT OF OWNER'S EQUITY 4 5 26 22 Insert Draw Page Layout Formulas Data Review View Cambria (He... 11 7 A- A- ab General BIU A $ - % ) .00 STEP 9: PREPARE BALANCE SHEET Problem 1 ame Insert Draw Page Layout Formulas Data Review View Cambria (He... 12 7 A A = te BIU A lili DO 1 F B C D E G Optional: It may help to journalize the adjusting entries here first, before completing the worksheet. STEP 1: JOURNALIZE TRANSACTIONS Date Account Name Debit Credit + Assessment Services Worksheet. Prepare Adjusted Trial Balance Adjustments Dr Cr ADJUSTED TB Dr Cr Income Stmt Dr Cr Balance Sheet Dr Trial Balance Dr 13,000 2.000 1300 10.500 3,500 3,000 Account Name 5 Cash - Prepaid Expenses Office Supplies omce Equipment 10 Accum. Depreciation 11 Accounts Payable 12 Salaries Payable 13 Lineared Serv. Revenge 34 Capital 35 Drawing 26 Service Revenue a Salary Expense 13 Depreciation Expense 19 Supplies Expense 20 Insurance Expense 21 22 4.500 11,750 5,600 13,350 3,700 24 25 26 Totals 36,100 36,100 27 28 29 30 31 Excel File Edit View Insert Format Tools Data Window Help ACC 1800 - Comprehensive Pro Formulas Data Review View Home Insert Draw Page Layout Cambria (He... 12 A- A+ A. General Paste B T U $ % 112 H A 1 ACC1800 - ACCOUNTING PROCEDURES 2 Completing the Period-End Worksheet (Chapters 3 & 4 Concepts) STUDENT NAME: Assessment Services has the following UN-ADJUSTED balances at Dec 31, 2019 Cash $ 13,000 Prepaid insurance 2.000 10 Office supplies 1,300 11 Office equipment 10.500 12 Accumulated depreciation office equipment 3,500 13 Accounts payable 3,000 14 Salaries payable 15 Unearned service revenue 4,500 16 Capital 11,750 17 Withdrawals 5,600 Service revenue 13,350 19 Salary expense 3.700 20 Deprecation expense 21 Supplies expense 22 Insurance expense 23 24 Required: 25 '1. Based on the adjustment information listed below, complete the Worksheet. 26 Offeplies will on hand: 100 27 b. med 5335 28 c. de $2.000 29 d. Deprem 5300 30 e achemployees for the same wo wo The the way 1.500 den 31 Monday through Friday December 3 w Waddy 32 Optimalt may help to journalte the adjusting entries her best here completing the worksheet STEP 1: JOURNALIZE TRANSACTIONS 35 Date Account Name Debit Credit 36 27 Problem 1 Worksheet 1-15 2.0E 3-05 Problem 2 1 Journal 2-TA IV J A STEP 7: PREPARE INCOME STATEMENT Cambria (He... 11 A- A- = ab General BIU $ % 3 0 .00 A STEP 8: PREPARE STATEMENT OF OWNER'S EQUITY 4 5 26 22 Insert Draw Page Layout Formulas Data Review View Cambria (He... 11 7 A- A- ab General BIU A $ - % ) .00 STEP 9: PREPARE BALANCE SHEET Problem 1
