Skip to main content

How to automate your Operational Audit procedures using DataSnipper

Automate sample testing for an operational audit in DataSnipper using Document Matching, then inspect judgemental aspects with Validation and Exception Snips.

Learn how to use DataSnipper to automate your sample testing procedures for an operational audit using Document Matching.

Video walkthrough

What the video covers

The walkthrough demonstrates an ESG readiness audit: arranging sample data in a table, importing letters of intent, running Document Matching to extract supplier details for GRI compliance, and inspecting judgemental aspects of the test with Validation and Exception Snips.

Prerequisites

  • Sample data

  • Supporting documents

  • Professional or Enterprise package

Start the procedure

1. Arrange your sample data in a table format, ensuring you have all the relevant details you want to inspect. In this example, the test inspects supplier details to verify compliance with GRI requirements as part of an ESG readiness audit.

Sample data arranged in a table

2. Import your supporting documents. In this example, the documents are letters of intent.

Importing supporting documents

3. Click the Document Matching button in the DataSnipper toolbar.

Document Matching button in the DataSnipper toolbar

4. Configure your test by clicking Start new document matching and selecting your sample data.

Configuring a new Document Matching test

5. Select the documents you want to reconcile.

Selecting documents to reconcile

6. Select the output columns in which the snipped outputs should be included.

Selecting output columns

7. Click Match all rows. Once matching is complete, review the output by moving through the snipped cells.

Reviewing matched output in the snipped cells

8. Navigate through the snips and use the Validation or Exception Snip to inspect your samples for the judgemental aspects of your tests.

Using Validation and Exception Snips on judgemental aspects

Sharing the file

You can exclude all documents before saving the workbook in your audit file by using the include/exclude documents toggle. You can also delete specific documents if needed.

Did this answer your question?