Using formulas only, transfer the balances from the November Trial Balance into the ledger accounts.
Accounting Cycle Project-F20-A Q Search Sheet Home Insert Page Layout Formulas Data Review View 2+ Share a Insert Calibri (Body) 12 A A ET) Wrap Text Custom NA 49 Paste B I U + Merge & Center $ % ) 2.0 .00 .00 0 Conditional Format Cell Formatting as Table Styles x Delete Format Sort & Filter B32 fx =SUM(B6:B31) B D E F G H 1 J L M N O P R s U V w 1 2 3 3 4 PART 1 DEWITT ADVERTISING Trial Balance November 30, 2020 5 ACCOUNT DR CR $ 112,331 38,600 3,280 3,000 45,000 $ 9,000 48,000 10,600 9,976 2,448 3,200 1,600 855 6 Cash 7 Accounts receivable 8 Supplies 9 Prepaid insurance 10 Equipment 11 Accumulated Depreciation 12 Notes payable 13 Accounts payable 14 Salaries and wages payable 15 FICA tax payable 16 Federal income tax payable 17 State income tax payable 18 Utilities payable 19 Uneamed service revenue 20 Interest payable 21 Common stock 22 Additional Paid-in Capital-Common 23 Retained earnings 24 Service revenue 25 Rent expense 26 Salaries and wages expense 27 Payroll tax expense 28 Supplies expense 29 Interest expense 30 Insurance expense 31 Utilities expense 32 TOTALS 33 14,000 800 50,000 10,000 10,540 258,600 24,200 176,000 13,954 2,780 800 600 9,074 429,619 $ $ 429,619 $ 24 Instructions & Transactions Nov Trial Balance and COA Journal Ledger Worksheet Statements Post-Closing Trial Balance + Ready + 86% Accounting Cycle Project-F20-A Q Search Sheet Home Insert Page Layout Formulas Data Review View 2+ Share a Insert Calibri (Body) 12 A A ET) Wrap Text Custom NA 49 Paste B I U + Merge & Center $ % ) 2.0 .00 .00 0 Conditional Format Cell Formatting as Table Styles x Delete Format Sort & Filter B32 fx =SUM(B6:B31) B D E F G H 1 J L M N O P R s U V w 1 2 3 3 4 PART 1 DEWITT ADVERTISING Trial Balance November 30, 2020 5 ACCOUNT DR CR $ 112,331 38,600 3,280 3,000 45,000 $ 9,000 48,000 10,600 9,976 2,448 3,200 1,600 855 6 Cash 7 Accounts receivable 8 Supplies 9 Prepaid insurance 10 Equipment 11 Accumulated Depreciation 12 Notes payable 13 Accounts payable 14 Salaries and wages payable 15 FICA tax payable 16 Federal income tax payable 17 State income tax payable 18 Utilities payable 19 Uneamed service revenue 20 Interest payable 21 Common stock 22 Additional Paid-in Capital-Common 23 Retained earnings 24 Service revenue 25 Rent expense 26 Salaries and wages expense 27 Payroll tax expense 28 Supplies expense 29 Interest expense 30 Insurance expense 31 Utilities expense 32 TOTALS 33 14,000 800 50,000 10,000 10,540 258,600 24,200 176,000 13,954 2,780 800 600 9,074 429,619 $ $ 429,619 $ 24 Instructions & Transactions Nov Trial Balance and COA Journal Ledger Worksheet Statements Post-Closing Trial Balance + Ready + 86%
