Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please can you show me how to solve it .The right answer is 176,100.Just I need to understand how to solve it Required information [The
Please can you show me how to solve it .The right answer is 176,100.Just I need to understand how to solve it
Required information [The following information applies to the questions displayed below.) NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document. Label each screenshot in accordance to what is noted in the lab. This document with all of the screenshots included should be uploaded through Connect as a Word or PDF document when you have reached the final step of the lab. In this lab, you will: Required: Take the journal entries and create a trial balance. Ask the Question: Can PivotTables be used to post journal entries and create a trial balance? Master the Data: AttackID is formed to sell privacy and cybersecurity, AttackID begins business January 1, 2022, and has 52 journal entries in the first month, which we have now input into an Excel spreadsheet. Software needed - Excel Screen capture tool (Windows: Snipping Took Mac: Cmd+Shift+4) Dato: Excel File Lab 1.1 Alt.Data.xlsx Prev 1 of 1 !!! Next --- . mwen www. Master the Data: AttackID is formed to sell privacy and cybersecurity, Attackid begins business January 52 journal entries in the first month, which we have now input into an Excel spreadsheet. Software needed Excel Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Excel File Lab 1-1 All Data xlsx Perform the Analysis: Refer to Lab 1-1 Alternative in the text for instructions and Lab 1-1 steps for each of th- Share the Story: Once we have completed the trial balance and it, in fact, balances, we are ready to publis! sheet and the income statement for all interested stakeholders. Required: 1. What is the total credits for the final trial balance? 176,100 Can not be calculated 284,477 Preu NA B1 UJA JER H AC AC B D E F G 1 Date JE# Account Name Debit Credit Entered Approved 2 1/2/2022 1 Cash 50,000 VR AC 3 1/2/2022 1 Common Stock 50,000 VR AC 4 1/2/2022 2 Travel Expense 150 VR AC 5 1/2/2022 2 Cash 150 VR AC 6 1/2/2022 3 Building 30,000 VR 7 1/2/2022 3 Cash 30,000 VR AC 8 1/4/2022 4 Utilities Expense 1,500 MW 9 1/4/2022 4 Cash 1,500 MW AC 10 1/5/2022 5 Equipment 17,200 VR AC 11 1/5/2022 5 Notes Payable 17,200 VR AC 12 1/6/2018 6 Salaries Expense 1,300 VR AC 13 1/6/2018 6 Cash 1,300 VR AC 14 1/5/2022 7 Payroll Tax Expense 1,000 VR AC 15 1/5/2022 7 Cash 1,000 VR AC 16 1/6/2022 8 Accounts Receivable 10,000 VR AC 17 1/6/2022 8 Sales Revenue 10,000 VR AC 18 1/6/2022 9 Cash 11,000 VR AC 19 1/6/2022 9 Notes Payable 11,000 VR AC 20 1/7/2022 10 Repairs Expense 7,000 VR AC 21 1/7/2022 10 Cash 7,000 VR AC 22 1/7/2022 11 Accounts Receivable 20,000 VR DH 23 1/7/2022 11 Sales Revenue 20,000 VR DH 24 1/10/2022 12 Cash 10,000 VR DH 25 1/10/2022 12 Accounts Receivable 10,000 VR DH 26 1/10/2022 13 Repairs Expense 1,300 MW DH 271/10/2020 13 Cash 1300 MW DH Sheet1 1,300 G DH DH DH DH DH 7,000 1,000 DH 15,000 2,000 25 1/10/2022 12 Accounts Receivable 26 1/10/2022 13 Repairs Expense 27 1/10/2022 13 Cash 28 1/10/2022 14 Rent Expense 29 1/10/2022 14 Cash 30 1/10/2022 15 Prepaid Insurance 31 1/10/2022 15 Cash 32 1/10/2022 16 Accounts Receivable 33 1/10/2022 16 Sales Revenue 34 1/10/2022 17 Notes Payable 35 1/10/2022 17 Cash 36 1/11/2022 18 Supplies 37 1/11/2022 18 Computer Supplies 38 1/11/2022 18 Cash 39 1/12/2022 19 Salaries Expense 40 1/12/2022 19 Cash 41 1/12/2022 20 Payroll Tax Expense 42 1/12/2022 20 Cash 43 1/13/2022 21 Travel Expense 44 1/13/2022 21 Cash 45 1/13/2022 22 Insurance Expense 46 1/13/2022 22 Cash 47 1/14/2022 23 Cash 48 1/14/2022 23 Sales Revenue 49 1/14/2022 24 Training Expense 50 1/14/2022 24 Cash 511/14/2029 25 Travel Expense Sheet1 10,000 VR MW 1,300 MW MW 7,000 MW VR 1,000 VR VR 15,000 VR MW 2,000 MW MW MW 1,000 MW MW 5,200 MW MW 1,000 MW VR 2,025 VR DH DH DH DH DH DH DH DH DH DH 500 500 5,200 1,000 DH 2,025 DH DH DH DH DH 1,200 VR 23,000 DH 1,200 VR VR 23,000 VR VR 500 VR VR 500 DH DH DH DH 50 F D 500 50 200 2,025 G DH DH DH DH DH DH DH DH AC AC AC AC AC 250 A B 49 1/14/2022 24 Training Expense 50 1/14/2022 24 Cash 51 1/14/2022 25 Travel Expense 52 1/14/2022 25 Cash 53 1/14/2022 26 Misc. Expense 54 1/14/2022 26 Cash 55 1/15/2022 27 Travel Expense 56 1/15/2022 27 Cash 57 1/15/2022 28 Postage Expense 58 1/15/2022 28 Cash 59 1/17/2022 29 Cash 60 1/17/2022 29 Accounts Receivable 61 1/19/2022 30 Salaries Expense 62 1/19/2022 30 Cash 63 1/19/2022 31 Payroll Tax Expense 64 1/19/2022 31 Cash 65 1/20/2022 32 Accounts Receivable 66 1/20/2022 32 Sales Revenue 67 1/20/2022 33 Cash 68 1/20/2022 33 Sales Revenue 69 1/20/2022 34 Travel Expense 70 1/20/2022 34 Cash 71 1/21/2022 35 Training Expense 72 1/21/2022 35 Cash 73 1/21/2022 36 Misc. Expense 74 1/21/2022 36 Cash 75 1/21/2022 37 Travel Exnense Sheet1 2,000 E VR 500 VR VR 50 VR VR 200 VR DH 2,025 DH VR 250 VR VR 2,000 VR MW 5,200 MW MW 1,100 MW MW 1,200 MW MW 2,400 MW MW 272 MW VR 500 VR VR 125 VR VR 5,200 AC 1,100 1,200 2,400 272 AC AC AC AC AC AC AC AC VR VR AC AC AC 500 125 350 B D 73 1/21/2022 36 Misc. Expense 125 74 1/21/2022 36 Cash 75 1/21/2022 37 Travel Expense 350 76 1/21/2022 37 Cash 77 1/21/2022 38 Travel Expense 2,025 78 1/21/2022 38 Cash 79 1/21/2022 39 Travel Expense 250 80 1/21/2022 39 Cash 81 1/22/2022 40 Training Expense 400 82 1/22/2022 40 Cash 83 1/22/2022 41 Cash 2,200 84 1/22/2022 41 Sales Revenue 85 1/22/2022 42 Travel Expenses 250 86 1/22/2022 42 Cash 87 1/23/2022 43 Cash 12,000 88 1/23/2022 43 Accounts Receivable 89 1/23/2022 44 Computer Supplies 200 90 1/23/2022 44 Cash 91 1/23/2022 45 Supplies Expense 255 92 1/23/2022 45 Supplies 93 1/26/2022 46 Salaries Expense 4,200 94 1/26/2022 46 Cash 95 1/26/2022 47 Payroll Tax Expense 1,100 96 1/26/2022 47 Cash 97 1/27/2022 48 Bad Debt Expense 5,000 98 1/27/2022 48 Allowance for Doubtful Accoun 99 1/27/2022 49 Depreciation Expens 1 100 Sheet1 Accessibilitu Gonnan E VR 125 VR VR 350 VR VR 2,025 VR VR 250 VR MW 400 MW MW 2,200 MW MW 250 MW VR 12,000 VR MW 200 MW MW 255 MW MW 4,200 MW MW 1,100 MW VR 5,000 VR F G AC AC AC AC AC AC AC AC AC AC AC AC AC AC AC AC AC AC AC AC AC AC AC AC VR Ready E F MW 250 MW VR 85 1/22/2022 86 1/22/2022 87 1/23/2022 88 1/23/2022 89 1/23/2022 90 1/23/2022 91 1/23/2022 92 1/23/2022 93 1/26/2022 94 1/26/2022 95 1/26/2022 96 1/26/2022 97 1/27/2022 98 1/27/2022 99 1/27/2022 100 1/27/2022 101 1/27/2022 102 1/27/2022 103 1/28/2022 104 1/28/2022 105 1/29/2022 106 1/29/2022 107 108 D 42 Travel Expense 250 42 Cash 43 Cash 12,000 43 Accounts Receivable 44 Computer Supplies 200 44 Cash 45 Supplies Expense 255 45 Supplies 46 Salaries Expense 4,200 46 Cash 47 Payroll Tax Expense 1,100 47 Cash 48 Bad Debt Expense 5,000 48 Allowance for Doubtful Accour 49 Depreciation Expens 1,100 49 Accumulated Depreciation 50 Training Expense 300 50 Cash 51 Insurance Expense 150 51 Prepaid Insurance 52 Cash 20,000 52 Sales Revenue 12,000 VR MW 200 MW MW 255 MW MW 4,200 MW MW 1,100 MW VR 5,000 VR VR 1,100 VR VR 300 VR G AC AC AC AC AC AC AC AC AC AC AC AC AC AC AC AC AC VR 150 VR MW 20,000 MW 10a Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started