Auditing Mod 4 12-31:
A. Some concerns i would have are that there are quite a few negative balance transactions that have no indication as to whether they are purchase returns or not. Also there are three transactions with missing dates.
B. The total amount of purchases is $300,682.04
C. There are twelve gaps in the invoice numbers and 22 duplicates. With regards to the gaps, an auditor would be concerned that there may be unrecorded purchases and with the duplicates they would be worried that the purchases were recorded more than once.
D.
PRODNO AMOUNT COUNT 010102710 65.89 2 010102840 11859.40 3 010134420 7107.44 11 010155150 3183.60 2 010155170 5858.55 2 010207220 3223.22 2 010226620 5594.40 2 010310890 735.28 2 010311990 2157.52 1 010551340 974.96 1 010631190 1483.70 5 010803760 -2481.33 6 023946372 270.06 2 023973042 5323.64 6 024104312 435.60 2 024121332 39.20 1 024128712 3609.69 26 024128812 1271.00 2 024128932 177.99 2 024130572 31.80 1 024133112 18497.00 9 024139372 148.50 1 030030323 1210.00 3 030303343 35.32 1 030305603 310.69 3 030321663 291.27 4 030321683 946.68 3 030324883 874.20 1 030364163 644.80 1 030412553 1625.73 6 030412903 12.40 2 030934423 4407.30 2 034255003 6627.20 8 040224984 44.00 2 040225014 208.80 2 040226054 43.50 1 040240284 10293.40 4 040240664 3552.00 1 040240884 3967.50 1 040241754 6029.24 4 040247034 7650.80 3 040270354 1242.56 5 040276054 4124.50 2 052204515 1997.94 1 052208805 10618.25 3 052210545 0.00 1 052484425 726.24 1 052484435 864.00 5 052504005 200.94 3 052530155 122.88 32 052720305 164.00 1 052720615 15826.00 2 052770015 90.52 2 060100306 190.40 2 060100356 318.00 2 060102066 39.80 1 060102106 5014.80 2 060112296 10964.80 2 060217066 2359.80 3 070104177 -6155.52 4 070104347 144.27 1 070104397