Step 3: Exporting Audit Data or Setting up a Template

Overview

This step differs between external and internal audits.

For an external audit, this is the step to export data in a CSV file showing the relationship between the objectives and controls. The CSV file can then be sent to external auditors who use it to structure the Document Request List (DRL). Once the DRL is received back from the external auditors, the audit manager can resume audit set up with Step 4: Setting up Audit Requests.

For an internal audit, this is the step to set up a template used for gathering information necessary for the type of internal audit being conducted.

External Audit - Exporting Audit Data

To export audit data for an external audit, complete the following steps:

1. Click Export Audit Data. The CSV file will open or download in the manner you've specified in your browser.
   
   
   
   
2. Click Close to pause the audit and wait for additional information.
   
   
   
   
3. Alternatively, click any of the circled step numbers at the top of the screen to continue with audit setup.

Audit Data

The audit data is structured to show your external auditors how your organization's controls map to the objectives in your compliance program. It can also help them arrange an interview schedule with relevant control owners.

The following are the column headings in the CSV file:

• Control Code
• Control Title
• Control Description
• Control Owner
• Objective Code
• Objective Title
• Objective Description

Exporting Data After the Initial Export

There may be several reasons for exporting a CSV file after it's been initially exported.

To generate another file with audit data, complete the following steps:

1. Click the circled number or green check mark.
   
   

   TIP

   If the step has been completed, a green check mark displays instead of the step number.

   
   
   
   

   NOTE

   For instructions on finding your audit, see Finding a Draft Audit.

2. Click Need to export audit data again?
   
   

Internal Audit - Setting Up an Assessment Template

To set up an assessment template for an internal audit, complete the following steps:

1. Select an assessor in the Default assessors dropdown menu. This is the person conducting the testing and defaults to Control owner.

2. Select a verifier in the Default verifiers. This is the person reviewing evidence supplied.
   
   

   TIP

   If the audit does not require custom assessment fields, click Next to continue audit setup.

Adding Custom Fields to the Assessment Template

To create custom assessment areas in the template, complete the following steps:

1. Enter a Field title. This describes the name of your customized field.
2. Select the Field type in the dropdown menu. This allows you to designate how the response will be handled in the template and include the following.
   • Text
   • Rich Text
   • Date
   • Checkbok
   • Dropdown
   • Map:Person
3. Click Make this field mandatory to require a response in the template.
   
   
   
   
4. Click Next to continue with audit set up.
5. Alternatively, click Add Field to continue creating customized fields.