Auditing Program by using excel to answer the questions QuestionsYour accounting firm is auditor of VINCENTPRAN LTD. A consumable product company that deals in sale of traditional cloths on both whole

VINCENTPRANLTD Accounts Receivable Doc. No. Doc. Type TRN Date AMT Due Date PMT Date AMTPAID BAL AA 51593 IN 1/02/2016 1189.11 28/02/2016 15/04/2016 889 300.11 47 51593 CN 1/02/2016 -73.4 29/02/2016 1/03/2016 0 -73.4 45 56016 IN 1/02/2016 1070.92 1/03/2016 1/06/2016 1070 0.92 44 56016 IN 2/02/2016 736.74 2/03/2016 2/06/2016 520 216.74 43 56016 CN 3/02/2016 -736.74 3/03/2016 3/06/2016 0 -736.74 42 56016 IN 4/02/2016 -1070.92 3/03/2016 4/06/2016 0 -1070.92 42 65003 IN 5/02/2016 1189.11 4/03/2016 5/06/2016 224 965.11 41 65003 IN 8/02/2016 1189.11 7/03/2016 15/03/2016 1190 -0.89 38 65003 IN 11/02/2016 1189.11 10/03/2016 25/04/2016 1189.11 0 35 65003 IN 17/02/2016 1189.11 16/03/2016 30/04/2016 1189.11 0 29 65003 IN 6/03/2016 1189.11 3/01/2016 28/06/2016 600 589.11 102 65004 IN 6/02/2016 1280.2 5/03/2016 6/06/2016 680 600.2 40 65004 IN 18/02/2016 1280.2 17/03/2016 30/04/2016 1576 -295.8 28 65004 IN 4/03/2016 1280.2 1/04/2016 26/06/2016 1189.11 91.09 14 65005 IN 7/02/2016 945.4 6/03/2016 7/06/2016 945 0.4 39 65006 IN 9/02/2016 540.19 8/03/2016 16/03/2016 540.19 0 37 65007 IN 10/02/2016 418.27 9/03/2016 17/03/2016 418.27 0 36 65008 IN 19/02/2016 1783.67 18/03/2016 30/04/2016 1783.67 0 27 65009 IN 12/02/2016 1465.42 11/03/2016 26/04/2016 1465.42 0 34 65009 IN 3/03/2016 1465.42 31/03/2016 25/06/2016 1321.24 144.18 15 65010 IN 13/02/2016 1771.46 12/03/2016 27/04/2016 1171 600.46 33 65010 IN 20/02/2016 1771.46 19/03/2016 25/04/2016 615.64 1155.82 26 65011 IN 14/02/2016 3152.46 13/03/2016 28/04/2016 2152 1000.46 32 65011 IN 21/02/2016 3152.46 20/03/2016 26/04/2016 2801.2 351.26 25 65012 IN 15/02/2016 615.64 14/03/2016 29/04/2016 615.64 0 31 65012 IN 22/02/2016 615.64 21/03/2016 27/04/2016 4954.64 -4339 24 65013 IN 16/02/2016 1755.52 15/03/2016 31/07/2016 1755.22 0.3 30 65013 IN 24/02/2016 1755.52 23/03/2016 29/04/2016 2069.13 -313.61 22 65014 IN 25/02/2015 2378.22 24/08/2015 30/04/2016 378 2000.22 231 65015 IN 26/02/2016 1124.77 25/03/2016 1/05/2016 1124.77 0 20 65016 IN 27/02/2016 2397.31 26/03/2016 20/04/2016 2397.31 0 19 65016 IN 9/03/2016 2397.31 6/04/2016 21/05/2016 1494.13 903.18 9 65017 IN 28/02/2014 1981.62 27/03/2014 21/04/2016 281 1700.62 738 65017 IN 5/03/2016 1981.62 2/04/2016 27/06/2016 619.94 1361.68 13 65018 IN 29/02/2016 1397.12 28/03/2016 22/04/2016 800 597.12 17 65019 IN 1/03/2016 1919.58 29/03/2016 23/04/2016 1919.58 0 16 65020 IN 2/03/2016 1685.1 30/03/2015 24/04/2016 1685.1 0 375 65022 IN 7/03/2016 519.2 4/04/2016 30/07/2016 519.2 0 11 65023 IN 8/03/2016 1149.5 5/04/2016 20/05/2016 1149.5 0 10 65028 IN 23/02/2016 209.13 22/03/2016 28/04/2016 209.13 0 23