Audit Templates

Audit templates are reusable templates that include saved sets of audit controls.

Read the following for information about audit templates:

• Creating Audit Templates

• Importing Audit Templates as CSV files

• Audit Templates List Page

• Applying Filters to the Audit Templates List

Creating Audit Templates

Before using audit templates on audits, you must first make one.

You can import an audit template when creating an audit, which automatically adds the included controls.

To create an audit template:

1. From the Compliance 360 sidebar, go to Audit Documentation > Audit Templates.

2. Click Create Audit Template.

3. In the Primary Information section:

   1. In the Template Name field, enter a unique name for your audit template.

   2. In the Template Description field, enter a brief description for your audit template.

4. In the Audit Controls section:

   1. In the Audit Control ID field, enter a unique and alphanumeric ID for an audit control.

   2. In the Title field, enter a title for the audit control.

   3. In the Description field, enter a description for the audit control.

   4. Click Add.

   5. (Optional) To add another audit control, repeat steps 4a to 4d.

5. Click Save.

   To save the audit template and create a new one, click Save and New.

Note:

If you created a new audit template and have already applied filters to the Audit Templates list page, you must click Apply Filters again to update the list and display your newly created audit template.

For more information, see Applying Filters to the Audit Templates List.

For instructions on importing an audit template to your audit, see the step 3 of the procedure in Creating Audits.

Importing Audit Templates as CSV files

Another option of creating an audit template is to by importing one as a CSV file.

The following CSV files are provided in the File Cabinet:

Use	File Name	Path in File Cabinet
Sample CSV – use this file as reference when creating your CSV file.	CSVImportData.csv	SuiteApps > com.netsuite.compliance360 > Audit Template CSV Import > Sample CSV Data
Template CSV – download this file and use it as a template.	CSVImportTemplate.csv	SuiteApps > com.netsuite.compliance360 > Audit Template CSV Import > Sample CSV Template

After creating your CSV file, you must import it using the Import Assistant.

To import an audit template as a CSV file:

1. Go to Setup > Import/Export > Saved CSV Imports.

2. From the Saved CSV Imports list, click Comp360 Audit Template Import.

3. In the Import Assistant Step 1: Scan & Upload CSV File screen:

   1. Click Select.

      Select the CSV file that you want to import and click Open.

   2. Click Next.

4. In the Import Assistant Step 2: Import Options screen:

   1. From the Data Handling list, select Add.

   2. Click Next.

5. In the Import Assistant Step 4: Field Mapping screen, click Next.

6. In the Import Assistant Step 5: Save mapping & Start import screen, click Run.

The imported audit templates will be visible in the Audit Templates list page.

When creating the audit template CSV files, you must consider the following:

• For Audit Control IDs, the only alphanumeric values that are accepted are:

  • Numbers from 0 to 9

  • Alphabets from A to Z

  • Underscore ( _ )

  • Hyphen (-)

  • Hash (#)

• Ensure that there are no duplicate Audit Control IDs.

• The fields are not case-sensitive. Both uppercase and smaller cases will be considered.

Audit Templates List Page

The Audit Templates list page displays all the audit templates created in the account.

The following screenshot shows the Audit Templates list page:

The following icons on the Actions column let you do the following:

• – Edit

• – Delete

• – Export into a CSV file

Applying Filters to the Audit Templates List

The Audit Templates list page is filterable. By default, the page does not display any audit templates. Apply appropriate filters to display the relevant audit templates.

To apply filters to the Audit Templates list:

1. Go to Compliance 360 > Audit Documentation > Audit Templates.

2. Select one or more filters to apply to the Audit Templates list. The following table lists the filters that can be applied:

   Filter	Function
   Created By	Filters the list based on audit template creator.
   Last Modified By	Filters the list based on the last modifier of the audit template.

3. (Optional) In the Search By Name field, you can type and search for a specific audit template title.

4. Click Apply Filters.

   To reset the filters applied to the list, click Reset Filters.

You can customize the number of audit templates displayed in the list page. From the Show list, select the number of templates to show in the Audit Templates list page.

The Audit Templates list page is also sortable. You can sort the list page by clicking either one of the following columns:

• Created On – Sorts the list according to creation date, ascending or descending.

• Audit Template Number – Sorts the list according to audit template number, ascending or descending.

• Template Name – Sorts the list alphabetically according to template name, ascending or descending.

• Created By – Sorts the list alphabetically according to template creator, ascending or descending.

• Last Modified By – Sorts the list alphabetically according to template's last modifier, ascending or descending.

• Last Modified On – Sorts the list according to modification date, ascending or descending.

Note:

If you created a new audit template and have already applied filters to the Audit Templates list page, you must click Apply Filters again to update the list and display your newly created audit template.

You also have the option to export the list page in CSV format by clicking the icon.

Related Topics

• Audits in Compliance 360
• Audits

General Notices