Financial statement fraud leaves a footprint in the general ledger. However, given the millions of journal entries in the general ledger, identifying this footprint, can be like finding a needle in a haystack.
If we are going to find a needle in a haystack, we would be better off with a metal detector.
But before, we get into analyzing the general ledger, it is a good idea to make sure that our general ledger data is complete (ie, someone from finance did not remove the suspicious transactions). We need to reconcile the general ledger to the trial balance to ensure:
The original idea behind this book was “what if we put all of those SAP tables and fields into one file, sot hat everyone could know exactly what they need to use to do each audit test”. It then evolved into information concerning how to use those tables and fields, typical audit tests and more.
Data analytics secrets is a fun read with lots of stories, pictures, reference tables and diagrams that bring your SAP data analytics learning to life.
Ever wanted to get data out of SAP, but been blocked by the IT department, don’t know where to start or spent too long time downloading data through SE16? When you get the ASAP tool, you will be able to automate your SAP downloads (without installing anything SAP-side) and you will also get templates for automating all the downloads of all the SAP tables and fields that you need for the audit tests mentioned in our book.
ASAP is SAP certified and works for ECC as for S4.
Say you’ve got 40,000 suppliers in your supplier database and want to test those suppliers automatically because you’ve got too many. Maybe you want to check those supplies on Google. Maybe you’re going to look through and see which ones are people, and which ones are real companies. By downloading the Supplier Checker, you can speed up this process. The Supplier Checker automatically identifies fictitious supplier tax codes, automatically identifies suppliers without a website and automatically identifies suppliers that are individuals rather than companies.
