Procurement controls audit · a real ERP purchase-to-pay log, 2018

5,000 real purchase-order items. 13 checks. … fail at least one.

Running in your browser on a fixed random 5,000 (seed 2019) of the log's … items, with the full audit's rules. A test checks every flag here against the Python run.

    This sample, in your browser…
    Full log, every item…

    Bars run 0 to 10%. The fourteenth control, payment blocks removed, is process volume rather than a broken rule, so it is in the table below but not counted here.

    Loading 5,000 items…

    Before a supplier gets paid, three documents have to agree.

    A purchase order says what was bought. A goods receipt says it arrived. An invoice says what is owed. This is an audit of how often that rule held across … real purchase-order items from a multinational coatings company's ERP, 2018.

    Walk one item through the controls

    Each tab is a real item from the log. Lines connect the receipt, invoice and clearing that the matching rule paired.

    What the controls found

    Rates use only the items a control applies to. A 2-way item cannot fail a goods-receipt check, so it is not in that denominator.

    ControlItems checked ExceptionsRate

    How long payment takes, once an item is payable

    Payable means the later of receipt and invoice. Median days to clearing, per matched invoice.

    What this log can and cannot prove