Category: Spreadsheets, Tools
This spreadsheet shared by Claire Worledge was used as the first practical exercise in the virtual event on Thursday July 22nd, 2021 “Segregation of Duties Audit in SAP”. In this spreadsheet we see the methodology followed in order to check who has violated user access, based on the general ledger header table. Normally, this process would be done in a data mining tool (ACL, IDEA, SQL, Alteryx, QLIK), however, here we show it in Excel, for the purpose of understanding the process and to help those of you that don’t have access to any of the above tools.
This list of tables and fields shared by Claire Worledge includes those that were used in the virtual event on July 22nd, 2021 “Segregation of Duties Audit in SAP”. Here we list the SAP tables that help us to determine “who did what” during the period, either in the general ledger, purchase to pay or order to cash.
I have use this workpaper in the past to track the status of my audit findings
A concise, high-level summary of the risk related to a business initiative, for example, deploying a new system, setting up a new partnership, the business units involved, what the project or change is and what the objective is of the project/ change.