2. Journalize A-G and post to General ledger (include trans # at beginning of each explanation. A, B, etc) 3. Prepare the Trial Balance in the Worksheet

000 20K Evans 1500pts XX 2019 (2) - Excel File Formulas Data Review View Tell me what you want to do.... SP Home Insert Page Layout Cut Arial EE Copy - Paste Format Painter B I U , Clipboard Font 10 - - A A A = = = E Wrap Text Merge & Center - Accounting $ - %, Accent2 Conditional Format as comma Formatting Table Accent3 Comma [0] Accent4 Currency 8 Alignment Number Styles F18X fax H L M N O Q R S ABC E F G Print format Journal Set Print area: Columns B-G, Fit to: 25 points One page wide, Rows 2-81, 2 pages tall. Page: Portrait for print Left & Right margins half inch, top and bottom .75 inch, fomatting Horizontally, File name at bottom (footer). See Excel Practice for instructions on print formatting, 25 pts Be sure to include all related transation details are in the explanation. Names, ka Inv#. Also, use the transaction Letter (A.B.C...) at the beginning of each explanation. (Not demonstrated in video) READ THESE AND ALL INSTRUCTIONS CAREFULLY! Evansl: Submission 91. (Use this as a check list before you submit!) 1. Save Excel with Your name + Evans Project Sample: Lname, Fname Evans1 2. Journalize A-G and post to GL (include trans #at beginning of each explanation. A, B, etc) 3. Prepare the Trial Balance in the Worksheet 4. Format for printing & Submit for grading 5. Do not continue until Evansl graded. Correct your original Evans Project. Accnt# Chart of Account Titles General Journal (Explanation with Details for each JE. #'s decimal places. Description PR Dr. 101 CASH Watch video demonstrations for each submission: 112 ACCOUNT RECEIVABLE 114 SUPPLIES Transactions Evans project overview (10 min) 115 PREPAID RENT to enter: 121 EQUIPMENT Evans 1 Video Demonstration of this assignment. 122 ACCUM DEPR - EQUIP Journalizing and posting to GL: 201 ACCOUNTS PAYABLE 311 EYANS, CAPITAL Take Quiz on these videos in Canvas in Week #3 before starting project. 312 EVANS, VITHDRAYALS 411 SERVICE REVENUE 519 SUPPLIES EXPENSE 511 RENT EXPENSE 518 DEPRECIATION EXP - EQ Evanst: Journalize and post the following June transactions. Include full details in JE explanation. Transaction Ref: Yr: 2018 External Entries included in Trial Balance 1-Jun Dan Evans invests (contributes) $20,000 cash and $2.000 of supplies in business: Evans Consulting. 2-Jun Evans pays seven month's rent in advance totaling $8.500 Ck # 101 10-Jun Evans provides services of $20,000 on account to a customer, Aatriz Corp. 11-Jun Evans purchases equipment for $28.800 with Check # 102 for $13,000 with the balance "on account payable from Home Depot Iny #27487 Useful life of the equipment is 5 years. $4,000 salvage value. 16-Jun Evans collects $5,000 of the Accounts Receivable from Aatrix Corp. 18-Jun Dan Evans takes a $2.500 drav Ck # 103 20-Jun Evans purchased office supplies for $2,000 Inv12345 Ck #104 from Office Depot Adjusting Entries H 30-Jun June Rent Used 30-Jun Equipment depreciated for one month. 30-Jun Took physical Inventory of Supplies totalling $4,000 Closing Entries See page 161 27e Remember Explanation required: K. Closing, L. Closing, etc G 2:18 Done icdn.inst-fs-iad-prod.inscloudgate C no Grading Journal General Ledger Trial Balance Worksheet Statements Post Clos Evans1: Submission #1. (Use this as a check list before you submit!) 1. Save Excel with your name + Evans Project Sample: Lname, Frame Evans1 Journalize A-G and post to GL (include trans #at beginning of each explanation. A, B, etc) 3. Prepare the Trial Balance in the Worksheet 4. Format for printing & Submit for grading 5. Do not continue until Evansl graded. Correct your original Evans Project. Acent Chart of Account Titles 101 112 114 15 121 201 311 12 $19 518 CASH Watch Video demonstrations for each submission: ACCOUNT RECEIVABLE Transactions SUPPLIES to enter: Evans project overview (10 min) PREPAID RENT EQUIPMENT Evans 1 Video Demonstration of this assignment ACCUM DEPR - EQUIP Journalizing and posting to GL: ACCOUNTS PAYABLE EVANS, CAPITAL Take Quiz on these videos in Canvas in Week 3 before starting project EVANS, WITHDRAWALS SERVICE REVENUE SUPPLIES EXPENSE RENT EXPENSE DEPRECIATION EXPEQ Evans 1: Journalize and post the following June transactions, include full details in JE explanation. Transaction Ret: Yr: 2018 External Stries included in Trial Balance 1 Jun Dan Evans Invests (contributes) 20,000 cast and 2,000 of supplies in business: Evans Consulting 2-Jun Evans pays seven month's rent in advance totaling $8,500 Ck # 101 10-Jun Evans provides services of $20,000 on account to a customer, Aatrix Corp. 11 Jun Evans purchases equipment for $28,800 with Check # 102 for $13,000 with the balance "on account payable from Home Depot Inv 27487 Useful life of the equipment is 5 years. $4,000 salvage value. 16-Jun Evans collects $5,000 of the Accounts Receivable from Aatrix Corp. 18-Jun Dan Evans takes a $2,500 draw Ck # 103 20-Jun Evans purchased office supplies for $2.000 invw 12345 Ck #104 from Office Depot Adjusting Entries 30-Jun June Rent Used 30-Jun Equipment depreciated for one month. 30-Jun Took physical Inventory of Supplies totalling $4,000 Closing Entries KL See page 161 27e Remember Explanation required: K. Closing, L. Closing, etc 000 20K Evans 1500pts XX 2019 (2) - Excel File Formulas Data Review View Tell me what you want to do.... SP Home Insert Page Layout Cut Arial EE Copy - Paste Format Painter B I U , Clipboard Font 10 - - A A A = = = E Wrap Text Merge & Center - Accounting $ - %, Accent2 Conditional Format as comma Formatting Table Accent3 Comma [0] Accent4 Currency 8 Alignment Number Styles F18X fax H L M N O Q R S ABC E F G Print format Journal Set Print area: Columns B-G, Fit to: 25 points One page wide, Rows 2-81, 2 pages tall. Page: Portrait for print Left & Right margins half inch, top and bottom .75 inch, fomatting Horizontally, File name at bottom (footer). See Excel Practice for instructions on print formatting, 25 pts Be sure to include all related transation details are in the explanation. Names, ka Inv#. Also, use the transaction Letter (A.B.C...) at the beginning of each explanation. (Not demonstrated in video) READ THESE AND ALL INSTRUCTIONS CAREFULLY! Evansl: Submission 91. (Use this as a check list before you submit!) 1. Save Excel with Your name + Evans Project Sample: Lname, Fname Evans1 2. Journalize A-G and post to GL (include trans #at beginning of each explanation. A, B, etc) 3. Prepare the Trial Balance in the Worksheet 4. Format for printing & Submit for grading 5. Do not continue until Evansl graded. Correct your original Evans Project. Accnt# Chart of Account Titles General Journal (Explanation with Details for each JE. #'s decimal places. Description PR Dr. 101 CASH Watch video demonstrations for each submission: 112 ACCOUNT RECEIVABLE 114 SUPPLIES Transactions Evans project overview (10 min) 115 PREPAID RENT to enter: 121 EQUIPMENT Evans 1 Video Demonstration of this assignment. 122 ACCUM DEPR - EQUIP Journalizing and posting to GL: 201 ACCOUNTS PAYABLE 311 EYANS, CAPITAL Take Quiz on these videos in Canvas in Week #3 before starting project. 312 EVANS, VITHDRAYALS 411 SERVICE REVENUE 519 SUPPLIES EXPENSE 511 RENT EXPENSE 518 DEPRECIATION EXP - EQ Evanst: Journalize and post the following June transactions. Include full details in JE explanation. Transaction Ref: Yr: 2018 External Entries included in Trial Balance 1-Jun Dan Evans invests (contributes) $20,000 cash and $2.000 of supplies in business: Evans Consulting. 2-Jun Evans pays seven month's rent in advance totaling $8.500 Ck # 101 10-Jun Evans provides services of $20,000 on account to a customer, Aatriz Corp. 11-Jun Evans purchases equipment for $28.800 with Check # 102 for $13,000 with the balance "on account payable from Home Depot Iny #27487 Useful life of the equipment is 5 years. $4,000 salvage value. 16-Jun Evans collects $5,000 of the Accounts Receivable from Aatrix Corp. 18-Jun Dan Evans takes a $2.500 drav Ck # 103 20-Jun Evans purchased office supplies for $2,000 Inv12345 Ck #104 from Office Depot Adjusting Entries H 30-Jun June Rent Used 30-Jun Equipment depreciated for one month. 30-Jun Took physical Inventory of Supplies totalling $4,000 Closing Entries See page 161 27e Remember Explanation required: K. Closing, L. Closing, etc G 2:18 Done icdn.inst-fs-iad-prod.inscloudgate C no Grading Journal General Ledger Trial Balance Worksheet Statements Post Clos Evans1: Submission #1. (Use this as a check list before you submit!) 1. Save Excel with your name + Evans Project Sample: Lname, Frame Evans1 Journalize A-G and post to GL (include trans #at beginning of each explanation. A, B, etc) 3. Prepare the Trial Balance in the Worksheet 4. Format for printing & Submit for grading 5. Do not continue until Evansl graded. Correct your original Evans Project. Acent Chart of Account Titles 101 112 114 15 121 201 311 12 $19 518 CASH Watch Video demonstrations for each submission: ACCOUNT RECEIVABLE Transactions SUPPLIES to enter: Evans project overview (10 min) PREPAID RENT EQUIPMENT Evans 1 Video Demonstration of this assignment ACCUM DEPR - EQUIP Journalizing and posting to GL: ACCOUNTS PAYABLE EVANS, CAPITAL Take Quiz on these videos in Canvas in Week 3 before starting project EVANS, WITHDRAWALS SERVICE REVENUE SUPPLIES EXPENSE RENT EXPENSE DEPRECIATION EXPEQ Evans 1: Journalize and post the following June transactions, include full details in JE explanation. Transaction Ret: Yr: 2018 External Stries included in Trial Balance 1 Jun Dan Evans Invests (contributes) 20,000 cast and 2,000 of supplies in business: Evans Consulting 2-Jun Evans pays seven month's rent in advance totaling $8,500 Ck # 101 10-Jun Evans provides services of $20,000 on account to a customer, Aatrix Corp. 11 Jun Evans purchases equipment for $28,800 with Check # 102 for $13,000 with the balance "on account payable from Home Depot Inv 27487 Useful life of the equipment is 5 years. $4,000 salvage value. 16-Jun Evans collects $5,000 of the Accounts Receivable from Aatrix Corp. 18-Jun Dan Evans takes a $2,500 draw Ck # 103 20-Jun Evans purchased office supplies for $2.000 invw 12345 Ck #104 from Office Depot Adjusting Entries 30-Jun June Rent Used 30-Jun Equipment depreciated for one month. 30-Jun Took physical Inventory of Supplies totalling $4,000 Closing Entries KL See page 161 27e Remember Explanation required: K. Closing, L. Closing, etc