1. Build a trial balance in the correct order.

2. Check for the seggregation of duties and define where/when this concept is not applied.

ON EXCEL PLEASE AND SHOW THE STEPS

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