70.2K

Verified Solution

Link Copied!

Can I please get the highlighted question solved? With an explanation! I will rate 5 stars please

ili = ! I. Merge & Center 19 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 C D E G H L 2 ACTIVITY JANUARY 28-31, 2019 Type Date Num Name Memo Operations Account Split Amount Vendor A Vendor Vendor Vendor Vendor Deposit Vendor 8 9 10 11 12 13 14 15 16 17 18 19 20 22 Deposit Deposit Bull Pche Bill Pche Bill Pmt Che Bi Pmt Che BPm Che Deposit BP Che Deposit Deposit BIPt Che Check Check Check Check Check Checi Check Crack Check Peche Bitche Deposit BP-Che Pelche Patch BIPO DE POR Picha Pt Che PwC 01/20/2010 01/26/2019 0122019 0428/2010 021/2019 01/202019 01/28/2010 01/29/2010 013072019 01/30/2019 01/31/2019 01/31/2010 0131/2010 01/31/2019 01/31/2010 01/31/2010 011/2012 01/31/2010 011./2010 03/2010 31/2010 01/11/2010 01/31/2010 01/31/2010 01/31/2010 01/31/2019 01/01/2010 01/31/2010 01/31/2019 01/31/2010 1/31/2010 031/2019 0132010 2010 2010 Vendor Vendor Vandri Vendor Vendor Vendor Vendor Vendor Vendor Vendor Vendor Vans Accounts Payable Accounts Payable Accounts Payable Accounts Payable Accounts Payable Undeposited Funds Accounts Payable SPLIT Undeposited Funds Accounts Payable SPLIT SPLIT SPLIT -SPLIT SPLIT SPLIT SPLIT SPLIT SPLIT Accounts Payable Accounts Payable SPUIT Accounts Payable Account Payable Accounts Payable Aco Pay Accounts Payable Accounts Payable Accounts Payable Accounts Payable Accounts Payable Accounts Payable Accounts Payable Accounts Payable Accounts Paya 4.005.00 -39.730.55 -31.500.00 -8.000.00 270.00 2,500.00 -90.00 5,561.53 7,03252 412.45 -11,666.87 -18.288.62 6,980.84 -15,435.65 6,980.84 22,166.67 - 10.055.44 -11.534.05 -15.482.17 -2.647.93 7800 40.146.55 -7.402.60 37,995.02 -7,744.00 -10,786.25 45.410 29 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 Depost Vandort Vendor Vander V Vendor w Vendor Z Vendor Vendor AA Vendor Vandora Vendore Vendor BIP-che BNP Che PC -1.558.50 360.00 439088 -1,555.14 310200 40 41 Toate Acco 42 TOTAL 43 Vendor 10781 -S07447 45 46 INSTRUCTIONS GL BANK + F28 : xv fx B D E Amount 2.500,00 (90.00) 2.980.00 2,581.53 7,022.52 14.005.00) (39.730.55) 270.00) (110,815.01) Reconcoling item not part of the variance (56,368.62) Reconcoling item not part of the variance 1412.45) Description 2 Beginning balance as of 01/28/2019 3 Total Credits 4 Total debits 5 Ending balance as of 01/31/2019 6 7 Date Description 8 1/28/19 Client1 9 1/28/19 Vendorf 10 1/28/19 Vendor 11 1/29/19 Client 2 12 1/29/19 Client 3 13 1/29/19 Vendor 14 1/29/19 Vendor 15 1/30/19 Client 4 16 1/30/19 Vender A 17 1/30/19 Vendor 18 1/30/19 Vendor E 19 1/30/19 Vendor 20 1/30/19 Vendor 21 1/30/19 Vendor 22 1/30/19 Vendor 23 1/31/19 Clients 24 1/31/19 Client 25 1/31/19 Client 26 1/31/19 Client 27 1/31/19 Client 9 28 1/31/19 Client 10 29 1/31/10 Vendor 30 1/31/19 Vendor Z 31 1/31/19 Vendor AA 32 1/31/19 Vendor Y 33 1/31/19 Vendor DO 34 1/31/19 Vender CC 35 1/31/19 Vendor 36 1/31/19 Vendor W 37 1/31/19 Vendor T 38 1319 Vendor 39 1/31/10 Vender FF 40 1/31/19 Vendor EE 1/31/19 Vendor 42 1/31/19 Vendor F 43 1010 Vendor 44 1/31/19 Vendor 45 13119 Vendorf 46 1/31/19 Vendorf 47 1931/19 Vendorf 48 131/19 Vendorf 49 1/3119 Vendorf 50 1/31/19 Vendorf 51 1/31/19 Vendor 52 1/3419 Vendorf 53 1/3419 Vendor F 54 131/19 Vendorf 55 56 57 13,465.00 13.465.00 6.909.05 5,000.00 4.982.50 2,990.00 37.995.02) (65,490.29) (1.558,50) (5.240.00) 3.929.95) (1.555.14 (7,744.00) (10.756.25) (7.602.68) 14,300,68 (10,781.88) (7.738.68) (15,708.42) Reconcoing item not part of the variance 140.00) (140.00) (35.00) 30.00) (30.00) 30.00) pad.00) (25.00) 59 INSTRUCTIONS GL BANK + ili = ! I. Merge & Center 19 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 C D E G H L 2 ACTIVITY JANUARY 28-31, 2019 Type Date Num Name Memo Operations Account Split Amount Vendor A Vendor Vendor Vendor Vendor Deposit Vendor 8 9 10 11 12 13 14 15 16 17 18 19 20 22 Deposit Deposit Bull Pche Bill Pche Bill Pmt Che Bi Pmt Che BPm Che Deposit BP Che Deposit Deposit BIPt Che Check Check Check Check Check Checi Check Crack Check Peche Bitche Deposit BP-Che Pelche Patch BIPO DE POR Picha Pt Che PwC 01/20/2010 01/26/2019 0122019 0428/2010 021/2019 01/202019 01/28/2010 01/29/2010 013072019 01/30/2019 01/31/2019 01/31/2010 0131/2010 01/31/2019 01/31/2010 01/31/2010 011/2012 01/31/2010 011./2010 03/2010 31/2010 01/11/2010 01/31/2010 01/31/2010 01/31/2010 01/31/2019 01/01/2010 01/31/2010 01/31/2019 01/31/2010 1/31/2010 031/2019 0132010 2010 2010 Vendor Vendor Vandri Vendor Vendor Vendor Vendor Vendor Vendor Vendor Vendor Vans Accounts Payable Accounts Payable Accounts Payable Accounts Payable Accounts Payable Undeposited Funds Accounts Payable SPLIT Undeposited Funds Accounts Payable SPLIT SPLIT SPLIT -SPLIT SPLIT SPLIT SPLIT SPLIT SPLIT Accounts Payable Accounts Payable SPUIT Accounts Payable Account Payable Accounts Payable Aco Pay Accounts Payable Accounts Payable Accounts Payable Accounts Payable Accounts Payable Accounts Payable Accounts Payable Accounts Payable Accounts Paya 4.005.00 -39.730.55 -31.500.00 -8.000.00 270.00 2,500.00 -90.00 5,561.53 7,03252 412.45 -11,666.87 -18.288.62 6,980.84 -15,435.65 6,980.84 22,166.67 - 10.055.44 -11.534.05 -15.482.17 -2.647.93 7800 40.146.55 -7.402.60 37,995.02 -7,744.00 -10,786.25 45.410 29 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 Depost Vandort Vendor Vander V Vendor w Vendor Z Vendor Vendor AA Vendor Vandora Vendore Vendor BIP-che BNP Che PC -1.558.50 360.00 439088 -1,555.14 310200 40 41 Toate Acco 42 TOTAL 43 Vendor 10781 -S07447 45 46 INSTRUCTIONS GL BANK + F28 : xv fx B D E Amount 2.500,00 (90.00) 2.980.00 2,581.53 7,022.52 14.005.00) (39.730.55) 270.00) (110,815.01) Reconcoling item not part of the variance (56,368.62) Reconcoling item not part of the variance 1412.45) Description 2 Beginning balance as of 01/28/2019 3 Total Credits 4 Total debits 5 Ending balance as of 01/31/2019 6 7 Date Description 8 1/28/19 Client1 9 1/28/19 Vendorf 10 1/28/19 Vendor 11 1/29/19 Client 2 12 1/29/19 Client 3 13 1/29/19 Vendor 14 1/29/19 Vendor 15 1/30/19 Client 4 16 1/30/19 Vender A 17 1/30/19 Vendor 18 1/30/19 Vendor E 19 1/30/19 Vendor 20 1/30/19 Vendor 21 1/30/19 Vendor 22 1/30/19 Vendor 23 1/31/19 Clients 24 1/31/19 Client 25 1/31/19 Client 26 1/31/19 Client 27 1/31/19 Client 9 28 1/31/19 Client 10 29 1/31/10 Vendor 30 1/31/19 Vendor Z 31 1/31/19 Vendor AA 32 1/31/19 Vendor Y 33 1/31/19 Vendor DO 34 1/31/19 Vender CC 35 1/31/19 Vendor 36 1/31/19 Vendor W 37 1/31/19 Vendor T 38 1319 Vendor 39 1/31/10 Vender FF 40 1/31/19 Vendor EE 1/31/19 Vendor 42 1/31/19 Vendor F 43 1010 Vendor 44 1/31/19 Vendor 45 13119 Vendorf 46 1/31/19 Vendorf 47 1931/19 Vendorf 48 131/19 Vendorf 49 1/3119 Vendorf 50 1/31/19 Vendorf 51 1/31/19 Vendor 52 1/3419 Vendorf 53 1/3419 Vendor F 54 131/19 Vendorf 55 56 57 13,465.00 13.465.00 6.909.05 5,000.00 4.982.50 2,990.00 37.995.02) (65,490.29) (1.558,50) (5.240.00) 3.929.95) (1.555.14 (7,744.00) (10.756.25) (7.602.68) 14,300,68 (10,781.88) (7.738.68) (15,708.42) Reconcoing item not part of the variance 140.00) (140.00) (35.00) 30.00) (30.00) 30.00) pad.00) (25.00) 59 INSTRUCTIONS GL BANK +

Answer & Explanation Solved by verified expert

See Answer