Question

1 Approved Answer

Posted on Sep 28, 2024

Please help me with question 4 I will rate 5 stars thank you!! ame Insert Draw Page Layout Formulas Data Review View Calibri (Body) 11

Please help me with question 4 I will rate 5 stars thank you!! image text in transcribed

ame Insert Draw Page Layout Formulas Data Review View Calibri (Body) 11 v III ab Wrap Text Paste BI A y Merge & Cent! 4 fx 4 Compare the two data sources and identify the variance B 1 1/ GL TAB - this contains data that was booked in General Ledger between January 28-31, 2019 2 2/ BANK - list of transactions between January 28-31, 2019 downloaded from the bank 3 3/ We have a variance in the bank at the end of January in the amount of $35 4 4/ Compare the two data sources and identify the variance 5 5/ Present the results 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 20 INSTRUCTIONS GL BANK + Ready ACTIVITY JANUARY 28-31, 2019 Tyre Date Num Name Meme Operations Account Amount 4,005 DO Vendor Vendor Vendor Vendor Vendor 30,73055 3.00 4,000 Deposit Vendor Deposit Deposit 2009 2.500.00 40.00 5.5053 70222 41245 -11,668 1882 4,000.14 Account Payable Account Payable Accounts Payable Accounts Payable Accounts Payable Unde te Pune Accounts Payable SPLIT undeposed under Account Pay -SPLIT SPLIT SPLIT SPLIT SPLIT SPLIT SPLIT APUT SPLIT Au Pay Au Payne SPUIT 0 1 BP Checi 012/2013 Bil Pre-Checi 01/28/2019 Bull Pchach 0122019 Bill Pet Cher 01/28/2019 BP Chech 02/2019 Depos 02.2019 Bu Chech 01/28/2010 Depok 01/29/2010 Deposit 010/2010 010/2010 Check 03.2010 Check 03/2010 Check OS 01/15/2018 Check 01/31/2019 Check 01/01/2019 011/2012 Che 01/2010 Check 01/2010 0101010 100 Depo 2018 Check G900 Pech QUOS Chec 2018 BeCheck 031/2010 01/2010 01010010 101209 Bahad 130 GO 1901 OST G Vand Vendor Vendor Vendor Vendor Vendor Vendor VON Van Vand Ver Vendas 2 OM 23.01. -1006544 08 42 24 25 27 -18.00 De A Papa 29 30 9.02 - Te VY Vendor Vendor Verw Vendor Vend Vendor Acc Patie Pay Account Payable Accu Pay 6.140.00 12 33 34 35 36 37 38 39 40 Ace Pay Vendor Vender CC Vendor Vendor FF 7.733 A Paya 307.447 42 TOTAL 43 44 45 46 47 INSTRUCTION GL 31 x fx A B C D E Description Beginning balance as of 01/28/2019 Total credits Total debits Ending balance as of 01/31/2019 Date Amount 3 9 2,500.00 (90.00) 2.980.00 2,581.53 7.022.52 (4.005.00) (39,730.55) (270.00) (110,815.01) Reconciling item not part of the variance (56.368.62) Reconciling item not part of the variance (41245) 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Description 1/28/19 Client 1 1/28/19 Vendor F 128/19 Vendor 1/29/19 Client 2 12919 Client 1/29/19 Vendor F 129/19 Vendor F 1/30/19 Client 4 1/30/19 Vendor A 1/30/19 Vendor 1/30/19 Vendor E 1/30/19 Vendor 1/30/19 Vendor 130/19 Vendor 1/30/19 Vendor F 131/19 Clients 1/3119 Client 131/19 Client 7 131/19 Client 1/3119 Client 9 1131/19 Client 10 1/3419 Vendor U 131/19 Vender 2 1/3119 Vendor MA 1/31/19 Vendor Y 13119 Vendor DD 131/19 Vendor CC 13119 Vendor V 1/31/19 Vendor W 119 Vender T 191/19 Vendor BB 13119 Vendor FF Vendor E 3119 Vendor Vendorf 13419 Verder Vendor W419 Vendor the Vander 119 Verder ve Vendor Avto Vendor 31 Vendor Venda Vendor V Vendor av Voda 13,465.00 13,466.00 6.909.05 5.000.00 4.982.50 2.990.00 (37.995.02) (65.4902 (1.558.50) (6.21000 (3.929.96) (1.566.14) (7,744.00) (10,70625) (7.602.6) (4.380.66 (10,7818) (7.738.68 (15.708.42) Reconciling om not part of the variance (40.00 42 44 45 46 47 (35.00 (30.00) (3000) (30.00) (2500) 49 50 51 52 53 54 55 56 57 58 59 60 INSTRUCTION GL BANK Ready ame Insert Draw Page Layout Formulas Data Review View Calibri (Body) 11 v III ab Wrap Text Paste BI A y Merge & Cent! 4 fx 4 Compare the two data sources and identify the variance B 1 1/ GL TAB - this contains data that was booked in General Ledger between January 28-31, 2019 2 2/ BANK - list of transactions between January 28-31, 2019 downloaded from the bank 3 3/ We have a variance in the bank at the end of January in the amount of $35 4 4/ Compare the two data sources and identify the variance 5 5/ Present the results 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 20 INSTRUCTIONS GL BANK + Ready ACTIVITY JANUARY 28-31, 2019 Tyre Date Num Name Meme Operations Account Amount 4,005 DO Vendor Vendor Vendor Vendor Vendor 30,73055 3.00 4,000 Deposit Vendor Deposit Deposit 2009 2.500.00 40.00 5.5053 70222 41245 -11,668 1882 4,000.14 Account Payable Account Payable Accounts Payable Accounts Payable Accounts Payable Unde te Pune Accounts Payable SPLIT undeposed under Account Pay -SPLIT SPLIT SPLIT SPLIT SPLIT SPLIT SPLIT APUT SPLIT Au Pay Au Payne SPUIT 0 1 BP Checi 012/2013 Bil Pre-Checi 01/28/2019 Bull Pchach 0122019 Bill Pet Cher 01/28/2019 BP Chech 02/2019 Depos 02.2019 Bu Chech 01/28/2010 Depok 01/29/2010 Deposit 010/2010 010/2010 Check 03.2010 Check 03/2010 Check OS 01/15/2018 Check 01/31/2019 Check 01/01/2019 011/2012 Che 01/2010 Check 01/2010 0101010 100 Depo 2018 Check G900 Pech QUOS Chec 2018 BeCheck 031/2010 01/2010 01010010 101209 Bahad 130 GO 1901 OST G Vand Vendor Vendor Vendor Vendor Vendor Vendor VON Van Vand Ver Vendas 2 OM 23.01. -1006544 08 42 24 25 27 -18.00 De A Papa 29 30 9.02 - Te VY Vendor Vendor Verw Vendor Vend Vendor Acc Patie Pay Account Payable Accu Pay 6.140.00 12 33 34 35 36 37 38 39 40 Ace Pay Vendor Vender CC Vendor Vendor FF 7.733 A Paya 307.447 42 TOTAL 43 44 45 46 47 INSTRUCTION GL 31 x fx A B C D E Description Beginning balance as of 01/28/2019 Total credits Total debits Ending balance as of 01/31/2019 Date Amount 3 9 2,500.00 (90.00) 2.980.00 2,581.53 7.022.52 (4.005.00) (39,730.55) (270.00) (110,815.01) Reconciling item not part of the variance (56.368.62) Reconciling item not part of the variance (41245) 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Description 1/28/19 Client 1 1/28/19 Vendor F 128/19 Vendor 1/29/19 Client 2 12919 Client 1/29/19 Vendor F 129/19 Vendor F 1/30/19 Client 4 1/30/19 Vendor A 1/30/19 Vendor 1/30/19 Vendor E 1/30/19 Vendor 1/30/19 Vendor 130/19 Vendor 1/30/19 Vendor F 131/19 Clients 1/3119 Client 131/19 Client 7 131/19 Client 1/3119 Client 9 1131/19 Client 10 1/3419 Vendor U 131/19 Vender 2 1/3119 Vendor MA 1/31/19 Vendor Y 13119 Vendor DD 131/19 Vendor CC 13119 Vendor V 1/31/19 Vendor W 119 Vender T 191/19 Vendor BB 13119 Vendor FF Vendor E 3119 Vendor Vendorf 13419 Verder Vendor W419 Vendor the Vander 119 Verder ve Vendor Avto Vendor 31 Vendor Venda Vendor V Vendor av Voda 13,465.00 13,466.00 6.909.05 5.000.00 4.982.50 2.990.00 (37.995.02) (65.4902 (1.558.50) (6.21000 (3.929.96) (1.566.14) (7,744.00) (10,70625) (7.602.6) (4.380.66 (10,7818) (7.738.68 (15.708.42) Reconciling om not part of the variance (40.00 42 44 45 46 47 (35.00 (30.00) (3000) (30.00) (2500) 49 50 51 52 53 54 55 56 57 58 59 60 INSTRUCTION GL BANK Ready