Vouch a sample against your documents with document matching
Run a document match from a sample in Excel, read the green, orange and red results, set column options and save the setup as a template.
Document matching vouches a sample in Excel against your documents. For each row, Blast Audit searches the selected documents for the values in your columns, writes what it found in result columns, and links each result to its page.
Open it with Match in the Automation group of the Blast Audit tab. The pane opens on Matching.
Before you start
Import the documents and wait until their text recognition has finished. Documents still being read, or whose reading failed, cannot be selected.
Put the sample in one block of cells, with a header row.
Run a match
- Select the sample in Excel, header row included, then click New matching.
- Sample: check the range. While this step is open, it follows your selection in Excel. Leave The first row holds the headers checked and click Next.
- Documents: keep All documents, or search only some with By folder or Choose documents. Every row is searched in every selected document, so select only the ones that belong to the sample. Click Next.
- Columns: each column of the sample has a line, with the result column it writes to. Change the result column in the list if needed. For a column that no document prints, such as your own reference, open its … menu and choose Don’t search this column.
- Click Match all. If the result columns already hold results, Blast Audit counts the rows already linked, the rows to redo and the rows filled by hand. Choose Overwrite all, or Only rows to redo to search only the rows not linked to a document.
- Blast Audit writes the results as it goes. Stop ends the run and keeps the rows already written. Resume then searches the remaining rows. While you edit a cell in Excel, the run waits.
- If some rows fit more than one document, Blast Audit shows them one by one under Rows to check. Pick the document and click Link the document. If none is right, choose None of these documents (No, no document when only one is shown) and click Leave without a document: the row turns red. Later moves on and writes nothing.
- The summary counts the rows linked to their document, the rows to check and the rows without a document. Click Finish, or Edit the setup to change the setup and run again.
Read the results
| Colour | Meaning |
|---|---|
| Green | Match found. |
| Orange | Uncertain, or the row could not be fully checked. |
| Red | No match found. |
Select a result cell to open the document at the matched value. The summary also tells you when a value appears in more than one place in its document, when an amount differs from its document within the accepted difference, and when a document was skipped.
Column options
Open the … menu of a column in the Columns step:
| Option | Effect |
|---|---|
| Value type | Text, Amount or Date. Blast Audit detects it; change it if it is wrong. |
| Required to validate the row | A row matches only if this field is found. |
| On the same page | The field must be on the page where the other fields were found. |
| Accept typos and abbreviations | For text. Accepts abbreviations, legal forms and OCR typos. On by default. |
| Accept part of the text | For text. Accepts "Jenny" for "Jenny Lam". |
| Accepted difference | For amounts. Left empty (the default), the amount must be exact. |
| Currency | For amounts, an optional three-letter code such as EUR. |
| Format in the documents | For amounts. Tells Blast Audit how the documents write numbers. |
| Order in the sheet, Order in the documents | For dates. Tells Blast Audit the order of day, month and year. |
Don’t search this column, at the bottom of the menu, leaves the column out. Search puts it back.
Invoice, purchase order and delivery note
In the Columns step, click Set up next to Several documents per row, then turn on Match invoice, purchase order and delivery note. Each row is then matched to its three documents, each proved by its own field. Under Document each column proves, give each document at least one column, and under Result column per document, a result column. This kind of match cannot be saved as a template.
Templates
In the Columns step, click Save as template to keep the column mapping, header row and matching rules. Type a Template name, and check Share with my organization to make it available to your colleagues. Templates do not store data, formatting or documents. You find them when the pane opens, under My templates and Firm: click one to start a matching with its columns and options.
Limits
One run reads up to 512 documents, 2,048 pages and 32 MB of OCR text. Above that, select fewer documents and run several matches.
Fewer matches than expected
See Fix document matching that finds fewer matches than expected.