Skip to main content

How to document a Test of Detail

Use Document Matching in DataSnipper to perform and document Test of Detail procedures, vouching sample data to invoices and bank statements.

DataSnipper helps you perform Test of Detail procedures directly in Excel. This article explains how to vouch your sample information to supporting documentation using Document Matching in DataSnipper for Excel.

Video tutorial

A video tutorial is available for this procedure.

Prerequisites

  1. Received documents from client.

  2. Sample data ready in Excel.

  3. Determine the data fields you would like to test.

Start procedure

  1. Start by importing your supporting evidence, including invoices and bank statements.

  2. Click on Document Organizer and create folders for each type of document.

    Create folders for each document type in Document Organizer
  3. Click on Document Matching and Start new Document Matching. Then select your sample data. If your sample data includes headers, check the First row includes headers option.

  4. Select Use document folders and check the Invoices and Bank statements folders.

  5. Cross check the output columns and adjust them according to your procedure. Click Match all rows and DataSnipper will automatically match the input and output columns for you.

    DataSnipper automatically matching input and output columns
  6. Once the match is complete, you can review the output by moving through the snipped cells.

    Reviewing the matched output through snipped cells

Increase the quality of your Test of Detail by enabling advanced features within Document Matching. See more information on Advanced Document Matching features.

Sharing the file

  1. You can choose to exclude all documents before saving the workbook in your audit file, by selecting the include/exclude documents toggle.

  2. You have some options to delete specific documents. To learn more, see How to remove documents from DataSnipper.

Did this answer your question?