Subscribe now – and receive valuable tips and tricks for your next audit!

Quick Guide: Three steps to determine if postings are being recorded in a timely manner

zeitnahe-Erfassung-von-Buchungen

Up to 52% of postings are not made within the limit of 40 days for timely posting (posting month + 10 days). By reading this Quick Guide, you will be able to find out how to analyze whether postings are being made in a timely manner in SAP. Reduce the risk of incorrect or fraudulent postings in (reopened) posting periods with this method today.

Part II of the series: “Recording of postings in a timely manner”

1. Don’t put it off until tomorrow… recording of postings in a timely manner
2. Quick Guide: Three steps to determine if postings are being recorded in a timely manner
3. Analysis of the continuous recording of postings over time
4. How you can notice which business transactions are being left undealt with for a longer period of time

How can you find out if business transactions have not been posted in a timely manner?

But that’s enough of the legalese: you want to know how the situation really looks like in practice at your company when comes to postings being made in a timely manner!

As Goethe’s Faust himself said:

“Well, that’s Philosophy I’ve read,
And Law and Medicine, and I fear
Theology, too, from A to Z;
Hard studies all, that have cost me dear.
And so I sit, poor silly man
No wiser now than when I began…”

So now let’s get down to the practical details!

In SAP, each posting document has different date fields:

  • Posting date
  • Document date
  • Processing date

We are now going to make use of this. As a measure for a timely posting, I therefore recommend that you calculate the difference in days between the posting date and the processing date. If a certain number of days is exceeded, we can consider that we are dealing with a document that has not been recorded in a timely manner. I recommend setting this period at 40 days, because if it takes any longer than that then the posting is made within the (posting) month.

How to get data for an analysis of postings in a timely manner?

If you want to analyze postings in a timely manner in your SAP, you need the necessary data structures and data from your SAP system. zap Audit automatically extracts all the necessary data from your SAP system.

How to perform analytics to determine which postings have been made in a timely manner in SAP?

I have written an ePaper on this subject, where you can read up on how I ran analytics of postings made in a timely manner with raw SQL queries. You can download this paper free of charge by clicking on the following link:

Download ePaper! (free Download)

Step 1: Statistics on the creation of postings in a timely manner

First, you need to generate statistics on how many documents were posted after how many days:

Days between processing and posting dateAmount
80525
8042
77412
77313
71513
68514
5932

Step 2: Analyzing documents that were not posted in a timely manner

Now determine the documents that have not been posted in a timely manner (BELNR field). In what follows, documents with a delay of more than 40 days between the date of the posting (BUDAT field) and the date of processing (CPUDT field) are considered as non-timely documents. The client (MANDT field), the company code (BUKRS field), the fiscal year (GJAHR field), the transaction code (TCODE field), the document type (BLART field), and the user (USNAM field) are also displayed.

MANDTBUKRSGJAHRBELNRTCODEBLARTUSNAMBUDATCPUDTDAYS_BETWEEN_
PROCESSING_ AND_POSTING_DATE
902100020142000000586F110ZPUSER_301/01/201417/03/2016805
902100020142000000583F110ZPUSER_401/01/201417/03/2016805
902100020141600000085FOSADAUSER_201/04/201417/03/2016715
902100020140100008378FB1SABUSER_131/12/201417/09/2015260
902100020140100007696FB01ABUSER_301/05/201419/12/2014232
902100020140100007728FB01SAUSER_430/05/201422/12/2014206
902100020141400002741FBZ1DZUSER_213/08/201403/03/2015202
902100020142000000280F110ZPUSER_122/08/201403/03/2015193

Step 3: Use your Professional Judgment when determining postings not made in a timely manner

When interpreting your results, take the following points into consideration:

  • Create a list of document types that are operational (for example, invoices and payments). Documents with such document types should in particular be posted very promptly. The explanations for the document types can be determined by using this SQL query:

SELECT * FROM T003T WHERE SPRAS=’E’

  • Look out for documents with a retention period of more than one year.

In zap Audit, we have integrated a much more efficient process for the analysis of postings in a timely manner, so you don’t need to look up document types, processing and posting dates or examine any data on your own. In addition, we have added business intelligence methods and are constantly working to improve the algorithms used. That’s why you should automate everything that can be automated with zap Audit, and only audit, what needs to be audited.

Subscribe now – and you will receive valuable tips and tricks for your next SAP audit.

Contact

We would be happy to hear from you.
You can reach us here: