Question: I need help with question 4 please I will rate 5 stars thank you!! B13 fx A B 1 1/ GL TAB - this contains
I need help with question 4 please I will rate 5 stars thank you!!



B13 fx A 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 00 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 20 INSTRUCTIONS GL BANK + U30 fx A B F G H K L M 1 ACTIVITY JANUARY 28-31, 2019 2 3 Type Date 4 5 Num Name Memo Split Amount - Operations Account 6 4.005.00 -39.730,55 7 Vendor A Vendor B Vendor C Vendor D 8 9 Vendor E 10 11 Depost 12 Bil Pmt -Check Bil Pmt -Chech Bil Pmt -Check Bil Pmt -Check Bil Pmt -Check Deposit Bil Pmt -Check Deposit Deposit Bil Pmt -Check Check Check Check Vendor F Depost Deposit Check Check WOON Check Check Vendor G Vendor H Vendor Vendor J Vendor K Vendor L Vendor M Vendor Vendor N Vendor o Vendor P Vendor R Vendor S Check Check Bil Pmt -Choch 01/28/2019 01/28/2019 01/28/2019 01/28/2019 01/28/2019 01/28/2019 01/28/2019 01/29/2019 01/30/2019 01/30/2019 01/31/2019 01/31/2019 made 01/31/2019 dre 01/31/2019 con 01/31/2019 01/31/2019 01/31/2019 01/31/2019 01/31/2019 01/31/2019 01/31/2019 01/31/2019 01/31/2019 01/31/2019 01/31/2019 01/31/2019 01/31/2019 01/31/2019 01/31/2019 01/31/2019 01/31/2019 01/31/2019 01/31/2019 01/31/2019 01/31/2019 Accounts Payable Accounts Payable Accounts Payable Accounts Payable Accounts Payablo Undeposited Funchs Accounts Payable -SPLIT Undeposited Funds Accounts Payable SPLIT SPLIT- -SPLIT SPLIT -SPLIT -SPLIT- -SPLIT- -SPLIT- SPLIT- Accounts Payable Accounts Payable -SPLIT Accounts Payable Accounts Payable Accounts Payable Accounts Payable Accounts Payable Accounts Payable Accounts Payable Accounts Payable Accounts Payable Accounts Payable Accounts Payable Accounts Payable Accounts Payable -31,500.00 -8.000.00 -270.00 2,500.00 -90.00 5,561.53 7.022.52 412.45 -11,666.67 -16.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 -78.00 46.846.58 -7,602.68 -37.995.02 -7.744.00 - 10,766.25 -65,490.29 -6,240.00 -1,558.50 -260.00 4,390.68 -1,555.14 -3.929.96 -7.738.68 -10,781.88 -307, 447.38 -307, 447.36 Deposit Vendor T Vendor U Vendor V 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 23 33 24 34 35 36 37 38 39 40 41 Total Operations Account 42 TOTAL 43 44 45 46 47 48 49 50 51 52 53 54 INSTRUCTIONS Vendor W Bil Pmt -Chech Deposit Bil Pmt -Check Bil Pmt -Check Bil Pmt -Check Bil Pmt -Check Bil Pmt -Check Bil Pmt -Check Bil Pmt -Chech Bil Pmt -Check Bil Pmt -Check Bil Pmt -Check Bil Pmt -Check Bil Pmt -Check Vendor Z Vendor y Vendor AA Vendor F Vendor BB Vendor cc Vendor DD Vendor EE Vendor FI Bil Pmt -Chech GL BANK + Deady L31 X fx B C D E F G H I Amount 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) Reconcoling item not part of the variance (56,368.62) Reconcoling item not part of the variance (412.45) 1 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 Client 1 9 1/28/19 Vendor F 10 1/28/19 Vendor F 11 1/29/19 Client 2 12 1/29/19 Client 3 13 1/29/19 Vendor F 14 1/29/19 Vendor F 15 1/30/19 Client 4 16 1/30/19 Vendor A 17 1/30/19 Vendor B 18 1/30/19 Vendor E 19 1/30/19 Vendor G 20 1/30/19 Vendor G 21 1/30/19 Vendor G 22 1/30/19 Vendor F 23 1/31/19 Client 5 24 1/31/19 Client 6 25 1/31/19 Client 7 26 1/31/19 Client 8 27 1/31/19 Client 9 28 1/31/19 Client 10 29 1/31/19 Vendor U 30 1/31/19 Vendor Z 31 1/31/19 Vendor AA 32 1/31/19 Vendor Y 33 1/31/19 Vendor DD 34 1/31/19 Vendor CC 35 1/31/19 Vendor V 36 1/31/19 Vendor W 37 1/31/19 Vendor T 38 1/31/19 Vendor BB 39 1/31/19 Vendor FF 40 1/31/19 Vendor EE 41 1/31/19 Vendor G 42 1/31/19 Vendor F 43 1/31/19 Vendor F 44 1/31/19 Vendor F 45 1/31/19 Vendor F 46 1/31/19 Vendor F 47 1/31/19 Vendor F 48 1/31/19 Vendor F 49 1/31/19 Vendor F 50 1/31/19 Vendor F 51 1/31/19 Vendor F 52 1/31/19 Vendor F 53 1/31/19 Vendor F 54 1/31/19 Vendor F 55 56 57 58 59 INSTRUCTIONS 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) (6,240.00) (3,929.96) (1,555.14) (7.744.00) (10,766.25) (7,602,68) (4,390.68) (10,781.88) (7,738.68) (15,708.42) Reconcoling item not part of the variance (40.00) (40.00) (35.00) (30.00) (30.00) (30.00) (30.00) (25.00) GL BANK + Roady
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
