Preparing an Audit Work Program

Objective

After completing this lesson, you will be able to build a preparation work program for a risk assessment process and an execution work program for an audit execution process.

Audit Work Program Preparation Steps

As a general guide, audit efforts are focused on the aims and objectives identified for an audit. Detailed audit work program should be created to execute an audit according to its objectives. During work program creation, an audit lead defines audit procedures with steps to make the audit process systematic and planned. Audit risk and materiality, among other business relevant matters, need to be considered together in designing the nature, timing, and extent of audit procedures in a work program.

Work program preparation starts after audit initiation or announcement letter distribution, depending on the enablement of the announcement letter step for a particular audit type. An audit lead creates an audit work program for execution - execution work program - and submits it for approval to an audit manager. The audit manager receives the work program, reviews it, and decides to approve or reject it. After the audit manager approves an execution work program of the audit, the audit execution phase will be started for this audit.

Prior to the preparation of the execution work program, the audit lead can prepare the work program for a risk assessment - preparation work program. Then the audit team conducts a risk assessment involving external auditors and partners to clarify the audit execution plan, scope, and update objectives for the most important areas. After the risk assessment process, the audit lead will start an execution work program preparation on the basis of risk assessment results. The risk assessment step is optional and can be enabled for certain audit types and disabled for others.

This figure compares audit processes with and without a risk assessment step, illustrating additional preparation and assessment in the former.

Fiori Interface of the Audit Work Program Preparation Steps

The following apps are used in the work program preparation steps:

  • Prepare Audits - assigned to an audit lead
  • Approve Audit Preparation - assigned to an audit manager
  • My Work Packages - assigned to a partner or an external auditor
  • Review Work Packages - assigned to an audit lead
This figure shows dashboard tasks for Audit lead, Audit manager, and Partner/External auditor roles in an audit engagement system.

Editing an Audit within the Preparation Phase

The audit preparation process requires capabilities to coordinate the efforts of dedicated team members. An audit lead/audit manager is able to edit an audit team and some of the attributes of an audit on the preparation phase in the Prepare Audits/Track Ongoing Audits apps, respectively.

This figure shows the SAP Treasury audit interface, highlighting audit team roles, stakeholders, basic details, resources, and timeline settings.

In addition, if during audit preparation an audit lead found additional necessary areas to analyze or clarified the scope of an audit, then the audit lead can change the set of risks, auditable items, organizations, processes, or dimensions for the initiated audit in the Prepare Audits app.

Audit Work Program Definition

As an audit lead allocated to an audit, you can prepare a work program. Audit work program preparation is performed in the Prepare Audits app.

There are several ways to create a work program:

  • Create from scratch

    This way is usually used if you have a limited number of work packages. Select Edit to start creation of an audit work program. A system will show the edit mode of the work program that allows you to define details manually.

  • Create a work program using an Excel template

    If you need to define your program with a larger number of work packages, then it might be easier to prepare them offline. You can download an Excel template and fill the template with all work program content, such as work packages, procedures, and steps of procedures. When it is edited, upload your file.

  • Copy a work program from an existing audit or prefilled template

    One of the desirable states for an Audit department is to administer an audit plan involving a high level of continuous auditing. Generally, that entails the implementation of continuous auditing with established priority areas. Practically, this means that you have identified a stable set of monitoring and continuous audit rules on a very generic process, can apply the same set of continuous audit parameters, can determine predictable follow up, and just need to adjust on how and to whom to communicate results. Therefore, you don't need to rebuild an audit work program each time, you can simply copy a previous one. SAP Audit Management allows you to extend or replace a work program by a work program from existing audits.

    To copy a work program from an existing audit, select Copy, and choose the From an Audit option. After selecting an existing audit from which a work program will be copied, you can choose whether to Extend or Replace a work program of your audit by the work program from the existing audit. In the case of the Extend option, previous work program entries, if any, will be kept and the previous work program will be amended with the copied work program. In the case of the Replace option, previous work program entries, if any, will be deleted and the copied work program will replace the previous work program.

    In addition, it is possible to fill a set of Excel templates and configure SAP Audit Management system to make them available for a user. Then the user can use these prefilled templates and save effort while creating a work program. To copy a work program from a template, click on the Copy button and choose From a Template. Select a template from which to copy, and select Replace or Extend. In the case of the Extend option, previous work program entries, if any, will be kept, and the previous work program will be amended with a work program from the template. In the case of the Replace option, previous work program entries, if any, will be deleted, and the work program from the template will replace the previous work program.

This figure shows SAP Treasury audit work program options to edit, download, upload, or copy work programs from templates or audits.

Work Program Structure

There are two categories of work program in SAP Audit Management: B and C. Work program of category B is a preparation work program and used for a risk assessment process, work program of category C is an execution work program and used for audit execution. If the risk assessment process is enabled for a particular audit type and scope scheme for category B is set in configuration of this audit type, then the Category column will be shown in a work program structure of an audit of this audit type. Otherwise, category column will not be shown in a work program structure.

Work programs of both categories are created in the same way and consist of work packages. Work packages define a content of an audit work program. All upper level entities of a work program, for example, key scopes on the screenshot below, are used only for building a structure and placing work packages into sections.

An audit work program structure can be of one-level, two-level, or three-level. The structure of the work program in the following screenshot is two-level.

This figure shows a Partner Audit work program, outlining hierarchical key scopes and work packages, categories, status, and responsible persons.

Three-Level Work Program Structure

This is an example of three-level work program structure.

This figure shows a hierarchical structure for an audit work program, displaying key scope, scopes, and work packages in SAP.

Work Program Hierarchy Definition

Creating a Work Program as Hierarchy - Adding a Single Work Package

To create a work program from scratch, select Edit in the Work Program section of an audit in the Prepare Audits app. You can add new rows in a hierarchy by selecting Add, then choose the category of a work package if applicable. Fill rows, select responsible persons for work packages, and select Save. To remove rows, select a row, and select Delete.

This figure shows the process of editing and saving items in the Work Program section of a Treasury audit.

Adding Multiple Work Packages to Program Hierarchy

You can add multiple key scopes to a work program by selecting Add Multiple in edit mode. Specify the category, if applicable, the number, and a responsible person for work packages. In the result, multiple key scopes with one work package in each key scope will be added to the work program.

Press on the button to the right to maximize a window with the work program, you will see the work program hierarchy in a separate window where you can add, delete scopes and work packages.

To add multiple underlying work program structure items, select upper level item, and select Add Multiple. For example, on the screenshot below, to add multiple work packages to a particular key scope, select the key scope, and select Add Multiple, and specify the number of work packages and a responsible person for them. In the result, three additional work packages will be created within the key scope.

This figure shows adding multiple work program items and assigning responsibility and category using the Add Multiple feature.

Work Package Content

You can enter a description, assign a responsible person, specify a deadline for a work package, and create procedures of test, question, detection, and business rule types in the work package. In addition, there is a possibility to assign risks and controls associated with these risks to the work package.

This figure shows an SAP Treasury Operations work package dashboard with tabs for General, Risks, Controls, Procedures, and Activities.

Audit Work Program Master Data

To allow a risk to be assigned to a work package, the risk must be added to the relevant audit first. After the risk is assigned to the work package, only controls associated with this risk can be added to the work package. Only controls assigned to the work package are available to be added to the test and business rule procedures of this work package.

This figure shows you how risks and controls are integrated into audit work packages through test and business rule procedures.

Test Type Procedure Definition

Adding a New Test Procedure to a Work Package

Test procedures contain information about controls to be checked and set of steps to be performed by an audit team. To create a test procedure, select an audit in the Prepare Audits app, go to the Work Program section of the audit, open a work package of an audit work program, switch to the Procedures section, select Add, and choose Test. Define the following attributes of a test procedure during creation: title, description of a procedure, a responsible person, and planned start and end dates. Select Save.

This figure shows how to add a new test procedure in the SAP Treasury Operations Procedures section.

Associating Controls, Adding Steps and Comments to a Test Procedure

When a procedure is created, you can add controls, create test steps manually or copy test steps of controls imported from SAP Process Control. To have controls available for assigning to the test procedure, add corresponding risks to the audit, then assign risks and controls of the risks to the work package.

In addition, there is a possibility to enter comments for the test procedure.

This figure shows a Treasury Operations Procedure interface with sections for controls, steps, and comments, including editing and adding options.

Copying SAP Process Control Test Steps

You can copy test steps from a control to a test procedure if the control is imported from SAP Process Control and has a test plan. Initially, a needed control with a test plan must be added to the test procedure to copy steps. When the control is added, the test steps from the control can be copied by selecting Copy.

This figure shows the Treasury Operations Procedure SAP interface, highlighting controls, steps, and options to add or copy steps.

After you select Copy, a window with a list of controls will be shown. Select controls from which the test steps are to be copied, and select OK. The test steps will be copied into the test procedure. You can copy test steps from multiple controls.

This figure shows a control selection window with Monitor suspicious payments (ID: 00636) chosen as a key control.

Test Procedure Step Creation

Adding a Step to a Test Procedure

It is also possible to add additional test steps directly to the test procedure. In this case, go to the Steps section, and select Add or Add Multiple. Enter the details of the step/steps, and select Create.

This figure shows how to add a step to the Treasury Operations Procedure in an SAP system.

Modifying, Resequencing, or Deleting a Step in a Test Procedure

The test steps can be manually adjusted or deleted. Select Edit to change, delete the steps, or adjust the sequence.

This figure displays the Treasury Operations Procedure steps overview screen in SAP, enabling users to edit, add, or copy steps.

Question Type Procedure Definition

For some audits, audit objectives are often set out in the form of one overall audit question and a limited number of subsidiary questions (that is, what is needed to be known) or hypotheses (that is, what is needed to be confirmed). The aim of the audit is to answer, verify, and conclude against these. All evidence gathering, data evaluation, and analysis are guided by audit questions.

It is therefore of fundamental importance that questions are well-founded, relevant, and auditable. Posing questions incorrectly or asking the wrong questions will inevitably lead to audits going in the wrong direction. By doing it right, the auditor can save time by not collecting and analyzing less relevant information. SAP Audit Management solution allows you to define audit question procedures in an audit work program.

Refer to the screenshot below to get an overview of how question procedures are processed on the audit execution phase. An auditor answers a question by choosing one of answers and enters text in the Remarks field to clarify the answer. In addition, findings can be attached to the question, descriptive assessment should be stored in the Working Papers section of the procedure, and comments can be added to the procedure.

Each answer has a rating defined in configuration. Such configuration should be done by the administrator of SAP Audit Management. A rating has a numeric value. Question ratings can be set for each audit type, so that each audit type has own set of answers with numeric value of score for each answer.

This figure shows a SAP question procedure form rating the adequacy of first aid kits as Not Applicable, Not Satisfactory, or Satisfactory.

Adding a New Question Procedure to a Work Package

To define a question procedure on the audit preparation phase, go to a work program section, select a work package, and select AddQuestion in the Procedures section.

This figure shows the Procedures tab in SAP Treasury Operations, where users can add business rules, detections, tests, or questions.

Defining Title, Description, and Weight for the Question Procedure

Enter a title and description of the question procedure. During question procedure creation, it is mandatory to define a weight for the question procedure.

On the execution phase, a score of the question procedure is calculated by multiplying a rating and a weight. The score of an audit is calculated by summing up the scores of all question procedures in the audit. Thus, using weights, you can define to what extent a particular question procedure influences the score of the audit - for example, you set a higher value in the weight field for questions about critical processes and a lower value in the weight field for questions about minor processes.

This figure shows the SAP interface for creating a new question procedure about the approval process, ready to be saved.

Detection Procedure Definition

Detection procedures allow the use of the detection and investigation capabilities provided by SAP Business Integrity Screening to find irregularities in business data. The prerequisite for working with detection procedures is configuration of integration with SAP Business Integrity Screening. To create a detection procedure, go to the Work Program section, select a work package, select AddBusiness Rule in the Procedures section, define a title, description, and detection strategy, and select Save.

This figure shows adding a new detection procedure for vendor bank account in SAP by selecting Detection from the Add menu.

A detection strategy is an automated activity of SAP Business Integrity Screening that finds irregularities in business processes and generates alert items. On the audit execution phase an auditor will run a detection strategy from a detection procedure, then the detection strategy will be executed in SAP Business Integrity Screening. Results will automatically come to the SAP Audit Management detection procedure and can be viewed within the automatically generated working paper.

Creating and Executing Business Rule Procedures

Adding Working Papers and Links to the Preparation Folder of an Audit

In the Preparation folder of the Working Papers section, an audit lead can add files and links to an audit during the audit preparation phase to provide additional information for the audit team.

This figure shows the navigation from Treasury audit preparation working papers to a detailed list with review and download options.

There are functionalities to enter notes for each file, reply to the notes, add several versions of a file, edit online some of document types, and create references to other working papers. To find more information on working paper management, refer to the following link:

https://help.sap.com/docs/SAP_ASSURANCE_AND_COMPLIANCE_SOFTWARE_-_SAP_AUDIT_MANAGEMENT and navigate to: Use [section]SAP Audit ManagementWorking Papers