Document Matching automatically matches Excel data with supporting documents such as invoices, bank statements, and contracts. It finds the correct text, date or number in a source document, then creates a reference to your sample data. This makes it useful for test of detail and test of control procedures.
This article covers DataSnipper v5 and later, which includes v6, v25, and v26. For information on advanced settings and Partial Matching (v6.1+), see How to use Advanced Options in Document Matching.
Video walkthrough
What the video covers
The walkthrough demonstrates a full Document Matching run from start to finish: importing source documents into DataSnipper, opening the Document Matching panel from the automation ribbon, selecting the Excel sample data range, mapping input columns to the data fields to test, letting DataSnipper auto-suggest output columns, running Match all rows, and reviewing the produced Text Snips against the source documents. The example uses an invoice vouching procedure but the same flow applies to any test of detail or test of control.
Prerequisites
Received documents from the client.
Sample data ready in Microsoft Excel.
Data fields you want to test identified.
DataSnipper V5.0 or later.
Start Document Matching
Import documents by clicking Import Documents or via the Document Organizer button.
Click Document Matching, then Start new Document Matching.
Select the cells containing your sample data.
If your sample data includes headers, check the box First row includes headers.
Click Next Step.
Select documents to match against
Choose how to reconcile your documents:
One-way match: select all documents and click the next step.
Multi-way match: use document folders to segment documents by type. See How to use Document Matching with multiple document types for the full procedure.
Match all rows
DataSnipper automatically selects output columns based on your sample data. Adjust them manually if your procedure needs different placements.
Click Match all rows. DataSnipper matches the input data to the source documents and populates the output columns.
Once the match completes, review each output using your professional judgment to validate the results.
Review and adjust
When some rows are not matched, the values may have rounding differences or formatting variations. Use the advanced options to allow deviations or partial matches:
Threshold: allow a numeric or percentage difference for amounts.
Partial Matching (V6.1 and later): match parts of an input, useful when a longer name or value is shortened in the source document.
Fuzzy text matching: match similar but not identical text, useful for abbreviations and minor spelling differences.
Required field: ensure a row only matches when a specific field is found.
Full walkthrough: How to use Advanced Options in Document Matching.
Save as a template
If you reuse the same Document Matching setup, save it as a template:
Click Save as template.
Give the template a name and an optional description.
Click OK. The template appears in the My Templates tab.
To share templates across your organization, see How to create company templates in Document Matching.
Related FAQs
For common questions about Document Matching behaviour, see FAQs for Document Matching.