You must prepare the task on the Excel electronic sheet. Accounts and amounts must be entered in the cells, they must not be copied.
A) Make the Closing Entries and the Post Closing Trial Balance for the following:
1) Adjustement entry Account Debit Credit Supply Expense 7,500 Supplies 7,500 Insurance Expense 3,600 Prepaid Insurance 3,600 Depreciation Expense - Equipment 22,000 Depreciation Expense - Trucks 12,000 Accumulate Depreciation - Equipment 22,000 Accumulate Depreciation - Trucks 12,000 Salaries Expense 1,500 Salaries Payable 1,500 Unearned Revenue 1,500 Services Revenue 1,500 Truck Expense 1,750 Cash 1,750Accumulate Depreciation Depreciation Expense Cash Salaries Expense Trucks Equipment 12,000 15,000 45,000 - 22,000 - 1,?50 12,000 1,500 - - 10,250 211,000 40,500 - 22,000 - Supplies 30,000 10,000 - 12,000 - 1500 - - 22,500 10,000 - 12,000 - Prepaid Insurance Trucks Expense 0 000 - 1,750 Equipment Accumulate Depreciation Equipment Trucks 00,000 50,000 Zetas Corporation Adjusted Trial Balance August 31, 2020 Description Debit Credit Debit Credit CASH 10,250 SUPPLIES 22,500 PREPAID INSURANCE EQUIPMENT 110,000 ACCUMULATED DEPRECIATION - EQUIPMENT 47,000 TRUCKS 60,000 ACCUMULATED DEPRECIATION TRUCKS 27,000 ACCOUNTS PAYABLE 4,000 UNEARNED REVENUE 4,500 ALICIA ZETAS CAPITAL 90,000 ALICIA ZETAS DRAWINGS 15,000 SERVICE REVENUE 161,500 SALARIES EXPENSE 46,500 RENT EXPENSE 10,600 TRUCK EXPENSE 10,750 MISCELLANEOUS EXPENSE 4,800 SUPPLIES EXPENSE 7,500 INSURANCE EXPENSE 3,600 DEPRECIATION EXPENSE - EQUIPMENT 22,000 DEPRECIATION EXPENSE - TRUCKS 12,000 SALARIES PAYABLE 1,500 TOTAL 335,500 335,500Accounting -Answers - Microsoft Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in * Cut Be Copy Calibri 14 A'A = ) Wrap Text General AutoSum . Ay Hi Paste Format Painter BIU . B . g . A . BE= Merge & Center . $ - % , Conditional Format as Cell Insert Delete Format Fill Formatting . Table. Styles . Clear Sort & Find & Filter . Select Clipboard Font Alignment Number Styles Cells Editing A78 vi XV fx G H K 78 Matos Corporation 79 Adjusted Trial Balance 80 As at May 31, 2020 81 Accounts Debit Credit 82 Cash 56,80 83 Accounts Receivable 39,700 Prepaid Insurance 0 Supplies 1,300 Equipment 196,000 Accumulated Depr. - Equipment 78,400 Accounts Payable 26,000 Salaries Payable 3,500 Notes Payable 97,600 Terry Colby, Capital 129,150 Terry Colby, Drawing 56,000 ranA Carand 417 meal Accounting -Answers - Microsoft Excel ? 0 - 6X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in & Cut Copy . Calibri - 14 . AT A = Wrap Text General E AutoSum . A Hi Fil- Paste Format Painter BIU . BB . . A . BEE E Merge & Center . $ . % , Conditional Format as Cell Insert Delete Format Sort & Find & Formatting * Table. Styles . Clear Filter . Select . clipboard Font Alignment Number Styles Cells Editing D110 D H 93 Fees Earned 417,250 94 alaries Expense 273,500 95 Rent Expense 51,800 96 Advertising Expense 15,200 97 nsurance Expense 1,200 98 Depreciation Expense 39,200 99 Supplies Expense 6,100 100 Miscellaneous Expense 5,100 101 Total 751,900 751,900 102 103 104 105 106 107 108 109 110 111 Sheet2 Sheet3 Sheet4 Sheets Sheets Sheet6 Sheet7 Sheet9 Sheet10 Sheetll ... ( READY # O " -- -+ 100%% 9 8:19 PM 6/5/2020Accounting -Answers - Microsoft Excel 2 0 - 6X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in & Cut Calibri 11 A'A = ) Wrap Text General [ AutoSum . Ay # Paste Je Copy " Format Painter BIU . B . 2. A . EE EE Merge & Center . $ . % , *:8 : Conditional Format as Cell Insert Delete Format Formatting * Table Styles Clear Sort & Find & Filter . Select Clipboard Font Alignment Number G Styles Cells Editing H7 ix v fx A C D E F G H I K ADJUSTING ENTRIES Date Account Title & Explanation Debit Credit 3 1). 31-May-20 Supplies Expense 6,100 Supplies 6,100 5 To adjust for and record the Supplies used 6 2). 31-May-20 Insurance Expense 1,200 7 Prepaid insurance 1,200 8 To record one month of prepaid insurance has expired 9 3). 31-May-20 Depreciation Expense 39,200 10 Accumulated Depreciation-Equipment 39,200 11 To record One month depreciation of equipment 12 4). 31-May-20 Salaries Expense 3,500 13 Salaries Payable 3,500 14 To record Salaries not paid to employees 15 5). 31-May-20 Accounts Receivable 2,000 16 Fees Earned 2,000 17 To record Services given but not billed 19 Sheet2 Sheet3 Sheet4 Sheets Sheets Sheeto Sheet7 Sheet9 Sheet10 Sheet11 . (+ READY -+ 100%% 9 edof 8:24 PM 6/5/2020Accounting -Answers - Microsoft Excel ? 0 - 5X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in & Cut Copy " Calibri - 14 .A'A = Wrap Text Number AutoSum . AH Paste Format Painter BIU . B. 2 . A . BEE EE Merge & Center . $ . % , * ; Conditional Format as Cell Insert Delete Format Clear Sort & Find & Formatting * Table. Styles . Filter . Select Clipboard G Font Alignment Number G Styles Cells Editing C47 ix V f C D E F G H I K 42 43 T-ACCOUNTS 44 Supplies Supplies Expense Prepaid insurance 45 Unadj. Bal. 7,400 6,100 Unadj. Bal. 1,200 1,200 46 6,100 47 Adj Bal. 1,300 Adj Bal. 6,100 Adj Bal. 0 49 50 Insurance Expense Depreciation Expense Accumulated Depreciation-Equip. 51 1,200 39,200 Unadj. Bal. 39,200 52 39,200 53 54 Adj Bal. 1,200 Adj Bal. 39,200 Adj Bal. 78,400 Accounting -Answers - Microsoft Excel ? a - 5X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in & Cut Be Copy " Calibri 14 A'A = ) Wrap Text Number AutoSum . A Hi 6 Paste Format Painter BIU . B . LA . BEEN Merge & Center . $ . % , 38 48 Conditional Format as Cell Insert Delete Format Fill Formatting " Table Styles . & Clear Sort & Find & Filter . Select Clipboard Font Alignment Number Styles Cells Editing 20 64 D G H 57 Salaries Expense Salaries Payable Accounts Receivable 8 Unadj. Bal. 270,000 3,500 Unadj. Bal. 37,70 50 3,500 2,000 60 61 Adj Bal 273,500 Adj Bal. 3,500 Adj Bal. 39,700 62 63 Fees Earned 64 8 9 8 8 Unadj. Bal. 15,250 2,000 Adj Bal. 417,250 69 70 71 Sheet2 Sheet3 Sheet4 Sheets Sheets | Sheets | Sheet7 | Sheets | Sheet10 | Sheetli .. () READY # 0 J -- -+ 100% i ed of w x p 8:17 PM 6/5/2020
