An unsparing look behind the scenes: How to analyze one-time accounts in SAP
Numerous compliance guidelines exist in medium- to large-sized companies for the usage of one-time accounts in SAP. These may vary from the total prohibition of one-time payments to a limit placed on such payments, which may extend up to quite a significant amount of money, depending on the company. Based on the guidelines and using […]
How to prevent Duplicate Payments in SAP with the Internal Control System
You want to avoid potential duplicate payments in SAP by using the internal control system (ICS)? Even before the postings are made in the financial accounting department? Then don’t miss out this blog post! I will show you the settings, how to develop them and where the limits are. Optimize your processes and reduce potential duplicate […]
Duplicate Payments in SAP: Reducing False Positives using a Utility Analysis
“How can we reduce the amount of results of twice payed invoices?” was a question in the preparation of this blog post. In collaboration with the Professor and my vague recollection of past business administration lectures, we opted for a utility analysis. Therefore, the combination of Professional Judgement and hard facts of data analytics should […]
Quick Guide: Reducing the identified amount of postings
In the fourth part of this series, you will learn how to further reduce the results from last post and find actual outliers. You will then be able to question the operating departments even more specifically. Part IV of the series: “FI documents posted during weekend” 1. What postings during weekend have to do with the […]
Postings during weekend you should definitely not ignore
In today’s blog post, we will analyze which types of documents posted during weekend must be inspected closely. For this purpose, we will use the analytics of the SQL statements of the previous series. Part III of the series: “FI documents posted during weekend” 1. What postings during weekend have to do with the fraud triangle2. How to […]
Two graphics for evaluating high incoming invoices
In the final part of this series, I will show you how to visually recognize and evaluate incoming invoices with high invoice amounts. For this matter, we will use simple Excel tools and illustrate the described approach with two graphs. Part 4 of the series: “Very high incoming invoice amount” 1. Where Topmanagers should keep an […]
Analytics of high incoming invoices
In today’s blog post, I will show you how to use Excel to implement the analytics of high incoming invoice amounts from Part II of this series. It is easy to understand, so everybody can use this. Part 3 of the series: “Very high incoming invoice amount” 1. Where Topmanagers should keep an eye on2. Getting serious: What […]
Do it yourself: Analytics of SAP super users in Excel
Today’s blog post for the “Do it yourself” evaluation of the SAP super user operations shows you the basics for the analytics, how to evaluate the results with Excel and the interpretation of the results. Part 3 of the series: “Operations done by super users” 1. How to avoid manipulations done by super users 2. How to analyse the risk […]