X AutoSave On 4 Book1 - Excel File Home Insert Page Layout Formulas Data Review View Help & Cut Search (Alt+Q) Copy Calibri Cyn-Thina Hughes CH 6 - 11 -A" A ' Undo ab Wrap Text Comments Share General Clipboard J1 Font 3 2Merge & Center $ % 9 78 98 Normal Bad condition Good Neutral Calculation AutoSum A O v: XV fx Complete the worksheet Alignment rmatting Check Cell Explanatory ... Input Linked Cell Note Format Find & Number Clear Select B Styles Cells Editing Analysis G M 3 The trial balance columns of the worksheet for Blue Spruce Roofing at March 31, 2022, are as follows." N O P Q Complete the worksheet 4 Blue Spruce Roofing 5 Worksheet For the Month Ended March 31, 2022 7 Trial Balance 8 Account Titles Dr. 9 Cash 4,100 Trial Balance Adjustments Adjusted trial balance Income Statement Balance Sheet 10 Accounts Receivable 3,400 Account Titles Dr. Cr. Dr. credits Dr. Debits Credits Debits Credits 11 Supplies 2, 100 Cash 4100 o 4100 O O 4100 2 Equipment 11,440 Accounts Receivable 3400 0 3400 3400 Supplies 2100 13 Accumulated Depreciation-Equipment 0 1500 600 o 600 1,300 Equipment 11440 o 11440 Accounts Payable o 11440 3,000 Accumulated Depreciation-Equipment 1300 260 1560 o 15 Unearned Service Revenue o 0 ? 700 Accounts Payable 3000 O 3000 o o 0 16 Common Stock 8 , 8 80 Unearned Service Revenue 700 510 190 o ? o 0 ? 17 Retained Earnings 2,600 Common Stock 8880 0 o ? o o 0 ? 18 Dividends 1,100 Retained Earnings 2600 O ? o ? o o 9 Service Revenue 7,000 Dividends 1100 0 ? o o ? 1,000 Service Revenue 7000 o 510 ? o ? 20 Salaries and Wages E 340 Salaries and Wages Expense 1000 700 0 ? o 21 Miscellaneous Expen o 340 O ? o o 22 23,480 23 , 480 Miscellaneous Expense o? Total 23480 23480 23 Supplies Expense o 1500 1500 o o 24 Depreciation Expense 260 260 25 Other data: Salaries and Wages Payable o? 26 A physical count reveals only $600 of roofing supplies on hand. 24440 3800 ? 27 Totals 2970 2970 24440 Depreciation for March is $260. 28 W N Unearned service revenue amounted to $190 at March 31. Net Income 3710 ? 3710 29 Accrued salaries are $700. 30 Totals 7510 7510 20640 20640 31 32 Sheet! @ 33OF Partly cloudy ~ (:) ENG 25/207 Enter Links Type here to search