{"id":11364,"date":"2017-02-10T15:00:00","date_gmt":"2017-02-10T15:00:00","guid":{"rendered":"https:\/\/zapliance.com\/?p=11364"},"modified":"2022-08-26T14:13:42","modified_gmt":"2022-08-26T14:13:42","slug":"getting-serious-what-are-high-incoming-invoice-amounts","status":"publish","type":"post","link":"https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/","title":{"rendered":"Getting serious: What are high incoming invoice amounts?"},"content":{"rendered":"\n

Part II of this series shows you how to use simple statistical considerations to determine which invoices from a vendor are exceptionally high and thus represent an statistical outlier.<\/p>\n\n\n\n

Part 2 of the series: \u201cVery high incoming invoice amount\u201d<\/p>\n\n\n\n

1. Where Topmanagers should keep an eye on<\/a>
2. Getting serious: What are high incoming invoices?<\/strong>
3. Analytics of high incoming invoices<\/a>
4. Two graphics for evaluating high incoming invoices<\/a><\/p>\n\n\n\n

Outlier Detection made easy or what is a statistical outlier?<\/h2>\n\n\n\n

As mentioned in my last article<\/a>, it is not the sorting of incoming invoices with high amounts but the consideration of statistical outliers. In order to assess what a statistical outlier is, one must look at the variation of a vendor\u2019s invoices by their mean value. The variation around the mean value is measured by the standard deviation. Now comes a formula and I hope I do not lose half the readership, as is often said when formulas come. But auditors are quite accustomed:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Where:<\/p>\n\n\n\n

n is the number of invoices and
Xi<\/sub> is the i-th invoice of the vendor
X the mean value of the vendor\u2019s invoice amounts<\/p>\n\n\n\n

The simple idea for a statistical outlier is that an invoice with an amount that is greater than the average plus n times the standard deviation is considered an outlier and is thus unusually high. <\/p>\n\n\n\n

How high is n<\/strong>?<\/p>\n\n\n\n

Depending on n, you are going to classify an outlier. Luckily, the statistics is helping here too, because intuitively one can judge n hard. In order to approach the solution, we assume for the time being that the invoice amounts of the incoming invoices are normally distributed. In the normal distribution one can always deduce how the frequency of calculation amounts within an interval of mean value +\/- n times the standard deviation is:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\u03c3 is determined as the standard deviation of the vendor invoice amounts. If you look at the graph, you see how many of the invoices would have to lie in an interval +\/- n times standard deviation:<\/p>\n\n\n\n

68.2% of the invoices in the interval mean value +\/- one standard deviation<\/p>\n\n\n\n

95.4 % of the invoices in the interval mean value +\/- two standard deviations<\/p>\n\n\n\n

99,7 % of the invoices in the interval mean value +\/- three standard deviations<\/p>\n\n\n\n

E.g. we could choose n<\/strong> = 3. That means: outliers would have to be (100-99.7) \/ 2 = 0.15% percent of the vendor\u2019s invoices. This provides an individual measure for outliers of a specific vendor.<\/p>\n\n\n\n

But watch out! Invoice amounts are often not distributed normally! Then the statements of the normal distribution with respect to n<\/strong> are also not valid. Finally, one must say that the probability distribution of the invoicing amounts is not always known.<\/p>\n\n\n\n

Can you still specify a rule for n<\/strong> even though you do not know the probability distribution of the invoice amounts? So to speak, a stable rule that is \u201cimmune\u201d against the ignorance of the probability distribution?
Yes we can!<\/em><\/p>\n\n\n\n

The so-called inequality of Chebyshev<\/a> helps us to estimate probabilities without the assumption of distribution. The inequality of Chebyshev tells us how large the probability of invoice amounts is \u201cat most for invoice amounts larger mean + n<\/strong> times the standard deviation\u201d. This expresses the following formula:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Where:<\/p>\n\n\n\n

\u03c3 is the determined standard deviation<\/p>\n\n\n\n

\u03bb stands for the n-fold<\/p>\n\n\n\n

This means the following:<\/p>\n\n\n\n

n or \u03bb<\/td>The probability that an invoice amount is above n times the standard deviation above the mean value is at most<\/td><\/tr>
3<\/td>11,11%<\/td><\/tr>
4<\/td>6,25%<\/td><\/tr>
5<\/td>4,00%<\/td><\/tr>
6<\/td>2,77%<\/td><\/tr>
7<\/td>2,04%<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

The right column indicates the probability that invoice amounts are above the mean plus n times standard deviation. However, this value is the highest possible probability. That is, depending on the actual (unknown) probability distribution, this probability is generally much smaller.<\/p>\n\n\n\n

My recommendation:<\/p>\n\n\n\n

I would take 6 times the standard deviation.<\/p>\n\n\n\n

So we come to our definition, which is an unusually high invoices amount:<\/p>\n\n\n\n

An incoming invoice from a vendor is unusually high if the invoice amount is above the mean value of the vendor\u2019s invoice amounts plus six times the standard deviation of the vendor\u2019s invoice amounts.<\/em><\/p>\n\n\n\n

How to get data for analytics of high input invoices?<\/h2>\n\n\n\n

If you want to analyse unusually high incoming invoices in your SAP, you need the necessary data structures and data from your SAP system. You can perform a data download from your SAP system using zapliance.<\/p>\n\n\n\n

The analytics of high incoming invoices are part of zap Audit<\/a>. <\/p>\n\n\n\n

In the next part of this series, we will show you how these analytics can be done in Excel and prepare a template for your analytics. You have any questions or suggestions? Then leave a comment. <\/p>\n","protected":false},"excerpt":{"rendered":"

Part II of this series shows you how to use simple statistical considerations to determine which invoices from a vendor are exceptionally high and thus represent an statistical outlier. Part 2 of the series: \u201cVery high incoming invoice amount\u201d 1. Where Topmanagers should keep an eye on2. Getting serious: What are high incoming invoices?3. Analytics of high […]<\/p>\n","protected":false},"author":4,"featured_media":10699,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","inline_featured_image":false,"footnotes":""},"categories":[38,37,40],"tags":[],"class_list":["post-11364","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-en-audit","category-en-compliance","category-en-finance"],"acf":[],"yoast_head":"\nGetting serious: What are high incoming invoice amounts? - zapliance<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Getting serious: What are high incoming invoice amounts? - zapliance\" \/>\n<meta property=\"og:description\" content=\"Part II of this series shows you how to use simple statistical considerations to determine which invoices from a vendor are exceptionally high and thus represent an statistical outlier. Part 2 of the series: \u201cVery high incoming invoice amount\u201d 1. Where Topmanagers should keep an eye on2. Getting serious: What are high incoming invoices?3. Analytics of high […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/\" \/>\n<meta property=\"og:site_name\" content=\"zapliance\" \/>\n<meta property=\"article:published_time\" content=\"2017-02-10T15:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-26T14:13:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2400\" \/>\n\t<meta property=\"og:image:height\" content=\"962\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Nick Gehrke\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nick Gehrke\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/\"},\"author\":{\"name\":\"Nick Gehrke\",\"@id\":\"https:\/\/zapliance.com\/en\/#\/schema\/person\/ef4d227360d4b66b84aa95cb72c12f5a\"},\"headline\":\"Getting serious: What are high incoming invoice amounts?\",\"datePublished\":\"2017-02-10T15:00:00+00:00\",\"dateModified\":\"2022-08-26T14:13:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/\"},\"wordCount\":825,\"publisher\":{\"@id\":\"https:\/\/zapliance.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png\",\"articleSection\":[\"Audit\",\"Compliance\",\"Finance\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/\",\"url\":\"https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/\",\"name\":\"Getting serious: What are high incoming invoice amounts? - zapliance\",\"isPartOf\":{\"@id\":\"https:\/\/zapliance.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png\",\"datePublished\":\"2017-02-10T15:00:00+00:00\",\"dateModified\":\"2022-08-26T14:13:42+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/#primaryimage\",\"url\":\"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png\",\"contentUrl\":\"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png\",\"width\":2400,\"height\":962},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\/\/zapliance.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Getting serious: What are high incoming invoice amounts?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zapliance.com\/en\/#website\",\"url\":\"https:\/\/zapliance.com\/en\/\",\"name\":\"zapliance\",\"description\":\"Be the agent of change\",\"publisher\":{\"@id\":\"https:\/\/zapliance.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zapliance.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/zapliance.com\/en\/#organization\",\"name\":\"zapliance\",\"url\":\"https:\/\/zapliance.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zapliance.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/06\/zap_logo.svg\",\"contentUrl\":\"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/06\/zap_logo.svg\",\"width\":200,\"height\":45,\"caption\":\"zapliance\"},\"image\":{\"@id\":\"https:\/\/zapliance.com\/en\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/zapliance.com\/en\/#\/schema\/person\/ef4d227360d4b66b84aa95cb72c12f5a\",\"name\":\"Nick Gehrke\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zapliance.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/07\/avatar_user_4_1657803044-96x96.jpg\",\"contentUrl\":\"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/07\/avatar_user_4_1657803044-96x96.jpg\",\"caption\":\"Nick Gehrke\"},\"description\":\"is Chief of Data & Knowledge and Co-Founder at zapliance as well as Professor of Information Systems with a Big 4 background. He prefers to work as a business information scientist and tax consultant at the converging points of finance, accounting, taxation, audit and ERP systems, data science and information technology.\",\"url\":\"https:\/\/zapliance.com\/en\/blog\/author\/nick-gehrke\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Getting serious: What are high incoming invoice amounts? - zapliance","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/","og_locale":"en_US","og_type":"article","og_title":"Getting serious: What are high incoming invoice amounts? - zapliance","og_description":"Part II of this series shows you how to use simple statistical considerations to determine which invoices from a vendor are exceptionally high and thus represent an statistical outlier. Part 2 of the series: \u201cVery high incoming invoice amount\u201d 1. Where Topmanagers should keep an eye on2. Getting serious: What are high incoming invoices?3. Analytics of high […]","og_url":"https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/","og_site_name":"zapliance","article_published_time":"2017-02-10T15:00:00+00:00","article_modified_time":"2022-08-26T14:13:42+00:00","og_image":[{"width":2400,"height":962,"url":"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png","type":"image\/png"}],"author":"Nick Gehrke","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Nick Gehrke","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/#article","isPartOf":{"@id":"https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/"},"author":{"name":"Nick Gehrke","@id":"https:\/\/zapliance.com\/en\/#\/schema\/person\/ef4d227360d4b66b84aa95cb72c12f5a"},"headline":"Getting serious: What are high incoming invoice amounts?","datePublished":"2017-02-10T15:00:00+00:00","dateModified":"2022-08-26T14:13:42+00:00","mainEntityOfPage":{"@id":"https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/"},"wordCount":825,"publisher":{"@id":"https:\/\/zapliance.com\/en\/#organization"},"image":{"@id":"https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/#primaryimage"},"thumbnailUrl":"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png","articleSection":["Audit","Compliance","Finance"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/","url":"https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/","name":"Getting serious: What are high incoming invoice amounts? - zapliance","isPartOf":{"@id":"https:\/\/zapliance.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/#primaryimage"},"image":{"@id":"https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/#primaryimage"},"thumbnailUrl":"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png","datePublished":"2017-02-10T15:00:00+00:00","dateModified":"2022-08-26T14:13:42+00:00","breadcrumb":{"@id":"https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/#primaryimage","url":"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png","contentUrl":"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png","width":2400,"height":962},{"@type":"BreadcrumbList","@id":"https:\/\/zapliance.com\/en\/blog\/getting-serious-what-are-high-incoming-invoice-amounts\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/zapliance.com\/en\/"},{"@type":"ListItem","position":2,"name":"Getting serious: What are high incoming invoice amounts?"}]},{"@type":"WebSite","@id":"https:\/\/zapliance.com\/en\/#website","url":"https:\/\/zapliance.com\/en\/","name":"zapliance","description":"Be the agent of change","publisher":{"@id":"https:\/\/zapliance.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zapliance.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/zapliance.com\/en\/#organization","name":"zapliance","url":"https:\/\/zapliance.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zapliance.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/06\/zap_logo.svg","contentUrl":"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/06\/zap_logo.svg","width":200,"height":45,"caption":"zapliance"},"image":{"@id":"https:\/\/zapliance.com\/en\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/zapliance.com\/en\/#\/schema\/person\/ef4d227360d4b66b84aa95cb72c12f5a","name":"Nick Gehrke","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zapliance.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/07\/avatar_user_4_1657803044-96x96.jpg","contentUrl":"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/07\/avatar_user_4_1657803044-96x96.jpg","caption":"Nick Gehrke"},"description":"is Chief of Data & Knowledge and Co-Founder at zapliance as well as Professor of Information Systems with a Big 4 background. He prefers to work as a business information scientist and tax consultant at the converging points of finance, accounting, taxation, audit and ERP systems, data science and information technology.","url":"https:\/\/zapliance.com\/en\/blog\/author\/nick-gehrke\/"}]}},"views":1107,"_links":{"self":[{"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/posts\/11364","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/comments?post=11364"}],"version-history":[{"count":1,"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/posts\/11364\/revisions"}],"predecessor-version":[{"id":11365,"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/posts\/11364\/revisions\/11365"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/media\/10699"}],"wp:attachment":[{"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/media?parent=11364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/categories?post=11364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/tags?post=11364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}