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 Tool; Mac: Cmd+Shift+4)

Data: Excel File Lab 1-1 Data.xlsx.

Perform the Analysis: Refer to Lab 1-1 in the text for instructions and steps for each the of lab parts.

Share the Story: Once we have completed the trial balance and it, in fact, balances, we are ready to publish the balance sheet and the income statement for all interested stakeholders.

Upload the Word or PDF document containing your Lab screenshots using the button below.

Take a screenshot of your final trial balance and label it Lab 1-1 Submission.

A B 1 Date JE# 2 2022/1/3 3 2022/1/3 4 2022/1/3 5 2022/1/3 6 2022/1/3 7 2022/1/3 8 2022/1/5 9 2022/1/5 10 2022/1/6 11 2022/1/6 12 2022/1/7 13 2022/1/7 142022/1/7 15 2022/1/7 16 2022/1/8 17 2022/1/8 18 2022/1/8 19 2022/1/8 20 2022/1/9 21 2022/1/9 22 2022/1/9 23 2022/1/9 24 2022/1/9 25 2022/1/9 26 2022/1/10 27 2022/1/10 28 2022/1/10 29 2022/1/10 30 2022/1/11 31 2022/1/11 32 2022/1/11 33 2022/1/11 34 2022/1/12 35 2022/1/12 D E F G |Account Name Debit Credit Entered Approved 1 Cash 50,000 VR AC 1 Common Stock 50,000 VR AC 2 Travel Expense 250 VR AC 2 Cash 250 VR AC 3 Building 32,000 VR AC 3 Cash 32,000 VR AC 4 Utilities Expense 1,600 VR AC 4 Cash 1,600 VR AC 5 Equipment 19,300 VR AC 5 Notes Payable 19,300 VR AC 6 Salaries Expense 5,200 VR AC 6 Cash 5,200 VR AC 7 Payroll Tax Expense 1,100 VR AC 7 Cash 1,100 VR AC 8 Accounts Receivable 10,000 VR AC 8 Service Revenue 10,000 VR AC 9 Cash 12,000 VR AC 9 Notes Payable 12,000 VR AC 10 Repairs Expense 7,000 VR AC 10 Cash 7,000 VR AC 11 Accounts Receivable 20,000 VR DH 11 Service Revenue 20,000 VR DH 12 Cash 10,000 VR DH 12 Accounts Receivable 10,000 VR DH 13 Utilities Expense 1,300 MW DH 13 Cash 1,300 MW DH 14 Rent Expense 7,000 MW DH 14 Cash 7,000 MW DH 15 Notes Payable 1,000 MW DH 15 Cash 1,000 MW DH 16 Accounts Receivable 15,000 MW DH 16 Service Revenue 15,000 MW DH 17 Notes Payable 3,000 MW DH 17 Cash 3,000 MW DH B D E G 400 MW DH 600 DH DH 5,200 DH DH 1,100 MW 1,000 MW MW 5,200 MW MW 1,100 MW VR 2,025 VR VR 1,200 VR VR 23,000 VR VR DH DH DH 2,025 DH 1,200 DH DH 23,000 DH DH 500 DH DH 500 VR VR 50 36 2022/1/13 37 2022/1/13 38 2022/1/13 39 2022/1/14 40 2022/1/14 41 2022/1/14 42 2022/1/14 43 2022/1/15 44 2022/1/15 45 2022/1/15 46 2022/1/15 47 2022/1/16 48 2022/1/16 49 2022/1/16 50 2022/1/16 51 2022/1/16 52 2022/1/16 53 2022/1/16 54 2022/1/16 55 2022/1/17 56 2022/1/17 57 2022/1/17 58 2022/1/17 59 2022/1/19 60 2022/1/19 61 2022/1/21 62 2022/1/21 63 2022/1/21 64 2022/1/21 65 2022/1/22 66 2022/1/22 67 2022/1/22 68 2022/1/22 69 2022/1/22 70 2022/1/22 18 Supplies 18 Computer Supplies 18 Cash 19 Salaries Expense 19 Cash 20 Payroll Tax Expense 20 Cash 21 Travel Expense 21 Cash 22 Insurance Expense 22 Cash 23 Cash 23 Service Revenue 24 Training Expense 24 Cash 25 Misc. Expense 25 Cash 26 Travel Expense 26 Cash 27 Travel Expense 27 Cash 28 Travel Expense 28 Cash 29 Cash 29 Accounts Receivable 30 Salaries Expense 30 Cash 31 Payroll Tax Expense 31 Cash 32 Accounts Receivable 32 Service Revenue 33 Cash 33 Service Revenue 34 Travel Expense 34 Cash DH DH DH 200 DH 2,025 DH DH 250 AC AC 2,000 AC 5,200 50 VR VR 200 VR MW 2,025 MW 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 1,100 AC AC AC AC AC AC AC 1,200 2,400 AC AC 272 AC AC B D E F G VR VR 500 VR VR VR AC 125 VR VR AC AC AC AC 350 VR VR 2,025 VR VR AC AC 250 VR AC AC AC MW 400 MW MW 2,200 MW MW AC AC AC AC AC AC A 71 2022/1/23 72 2022/1/23 73 2022/1/23 74 2022/1/23 75 2022/1/23 76 2022/1/23 77 2022/1/23 78 2022/1/23 79 2022/1/23 80 2022/1/23 81 2022/1/24 82 2022/1/24 83 2022/1/24 84 2022/1/24 85 2022/1/24 86 2022/1/24 87 2022/1/25 88 2022/1/25 89 2022/1/25 90 2022/1/25 91 2022/1/25 92 2022/1/25 93 2022/1/28 94 2022/1/28 95 2022/1/28 96 2022/1/28 97 2022/1/29 98 2022/1/29 99 2022/1/29 100 2022/1/29 101 2022/1/29 102 2022/1/29 103 2022/1/30 104 2022/1/30 105 2022/1/31 106 2022/1/31 107 35 Training Expense 500 35 Cash 36 Misc. Expense 125 36 Cash 37 Travel Expense 350 37 Cash 38 Travel Expense 2,025 38 Cash 39 Travel Expense 250 39 Cash 40 Training Expense 400 40 Cash 41 Cash 2,200 41 Service Revenue 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 5,200 46 Cash 47 Payroll Tax Expense 1,100 47 Cash 48 Bad Debt Expense 6,000 48 Allowance for Doubtful Accour 49 Depreciation Expen: 1,000 49 Accumulated Depreciation 50 Training Expense 400 50 Cash 51 Insurance Expense 200 51 Prepaid Insurance 52 Cash 21,000 52 Service Revenue AC AC AC AC AC 250 MW MW 12,000 MW MW 200 MW MW 255 MW MW 5,200 MW MW 1,100 MW VR 6,000 VR VR 1,000 VR VR AC AC AC AC AC AC AC 400 VR AC AC AC AC VR 200 VR VR 21,000 VR DH DH A B 1 Date JE# 2 2022/1/3 3 2022/1/3 4 2022/1/3 5 2022/1/3 6 2022/1/3 7 2022/1/3 8 2022/1/5 9 2022/1/5 10 2022/1/6 11 2022/1/6 12 2022/1/7 13 2022/1/7 142022/1/7 15 2022/1/7 16 2022/1/8 17 2022/1/8 18 2022/1/8 19 2022/1/8 20 2022/1/9 21 2022/1/9 22 2022/1/9 23 2022/1/9 24 2022/1/9 25 2022/1/9 26 2022/1/10 27 2022/1/10 28 2022/1/10 29 2022/1/10 30 2022/1/11 31 2022/1/11 32 2022/1/11 33 2022/1/11 34 2022/1/12 35 2022/1/12 D E F G |Account Name Debit Credit Entered Approved 1 Cash 50,000 VR AC 1 Common Stock 50,000 VR AC 2 Travel Expense 250 VR AC 2 Cash 250 VR AC 3 Building 32,000 VR AC 3 Cash 32,000 VR AC 4 Utilities Expense 1,600 VR AC 4 Cash 1,600 VR AC 5 Equipment 19,300 VR AC 5 Notes Payable 19,300 VR AC 6 Salaries Expense 5,200 VR AC 6 Cash 5,200 VR AC 7 Payroll Tax Expense 1,100 VR AC 7 Cash 1,100 VR AC 8 Accounts Receivable 10,000 VR AC 8 Service Revenue 10,000 VR AC 9 Cash 12,000 VR AC 9 Notes Payable 12,000 VR AC 10 Repairs Expense 7,000 VR AC 10 Cash 7,000 VR AC 11 Accounts Receivable 20,000 VR DH 11 Service Revenue 20,000 VR DH 12 Cash 10,000 VR DH 12 Accounts Receivable 10,000 VR DH 13 Utilities Expense 1,300 MW DH 13 Cash 1,300 MW DH 14 Rent Expense 7,000 MW DH 14 Cash 7,000 MW DH 15 Notes Payable 1,000 MW DH 15 Cash 1,000 MW DH 16 Accounts Receivable 15,000 MW DH 16 Service Revenue 15,000 MW DH 17 Notes Payable 3,000 MW DH 17 Cash 3,000 MW DH B D E G 400 MW DH 600 DH DH 5,200 DH DH 1,100 MW 1,000 MW MW 5,200 MW MW 1,100 MW VR 2,025 VR VR 1,200 VR VR 23,000 VR VR DH DH DH 2,025 DH 1,200 DH DH 23,000 DH DH 500 DH DH 500 VR VR 50 36 2022/1/13 37 2022/1/13 38 2022/1/13 39 2022/1/14 40 2022/1/14 41 2022/1/14 42 2022/1/14 43 2022/1/15 44 2022/1/15 45 2022/1/15 46 2022/1/15 47 2022/1/16 48 2022/1/16 49 2022/1/16 50 2022/1/16 51 2022/1/16 52 2022/1/16 53 2022/1/16 54 2022/1/16 55 2022/1/17 56 2022/1/17 57 2022/1/17 58 2022/1/17 59 2022/1/19 60 2022/1/19 61 2022/1/21 62 2022/1/21 63 2022/1/21 64 2022/1/21 65 2022/1/22 66 2022/1/22 67 2022/1/22 68 2022/1/22 69 2022/1/22 70 2022/1/22 18 Supplies 18 Computer Supplies 18 Cash 19 Salaries Expense 19 Cash 20 Payroll Tax Expense 20 Cash 21 Travel Expense 21 Cash 22 Insurance Expense 22 Cash 23 Cash 23 Service Revenue 24 Training Expense 24 Cash 25 Misc. Expense 25 Cash 26 Travel Expense 26 Cash 27 Travel Expense 27 Cash 28 Travel Expense 28 Cash 29 Cash 29 Accounts Receivable 30 Salaries Expense 30 Cash 31 Payroll Tax Expense 31 Cash 32 Accounts Receivable 32 Service Revenue 33 Cash 33 Service Revenue 34 Travel Expense 34 Cash DH DH DH 200 DH 2,025 DH DH 250 AC AC 2,000 AC 5,200 50 VR VR 200 VR MW 2,025 MW 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 1,100 AC AC AC AC AC AC AC 1,200 2,400 AC AC 272 AC AC B D E F G VR VR 500 VR VR VR AC 125 VR VR AC AC AC AC 350 VR VR 2,025 VR VR AC AC 250 VR AC AC AC MW 400 MW MW 2,200 MW MW AC AC AC AC AC AC A 71 2022/1/23 72 2022/1/23 73 2022/1/23 74 2022/1/23 75 2022/1/23 76 2022/1/23 77 2022/1/23 78 2022/1/23 79 2022/1/23 80 2022/1/23 81 2022/1/24 82 2022/1/24 83 2022/1/24 84 2022/1/24 85 2022/1/24 86 2022/1/24 87 2022/1/25 88 2022/1/25 89 2022/1/25 90 2022/1/25 91 2022/1/25 92 2022/1/25 93 2022/1/28 94 2022/1/28 95 2022/1/28 96 2022/1/28 97 2022/1/29 98 2022/1/29 99 2022/1/29 100 2022/1/29 101 2022/1/29 102 2022/1/29 103 2022/1/30 104 2022/1/30 105 2022/1/31 106 2022/1/31 107 35 Training Expense 500 35 Cash 36 Misc. Expense 125 36 Cash 37 Travel Expense 350 37 Cash 38 Travel Expense 2,025 38 Cash 39 Travel Expense 250 39 Cash 40 Training Expense 400 40 Cash 41 Cash 2,200 41 Service Revenue 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 5,200 46 Cash 47 Payroll Tax Expense 1,100 47 Cash 48 Bad Debt Expense 6,000 48 Allowance for Doubtful Accour 49 Depreciation Expen: 1,000 49 Accumulated Depreciation 50 Training Expense 400 50 Cash 51 Insurance Expense 200 51 Prepaid Insurance 52 Cash 21,000 52 Service Revenue AC AC AC AC AC 250 MW MW 12,000 MW MW 200 MW MW 255 MW MW 5,200 MW MW 1,100 MW VR 6,000 VR VR 1,000 VR VR AC AC AC AC AC AC AC 400 VR AC AC AC AC VR 200 VR VR 21,000 VR DH DH