Learn how to use DataSnipper to reconcile expense reports to receipts and clearly identify any relevant discrepancies.
Video walkthrough
What the video covers
The walkthrough shows importing employee receipts, running OCR, and using Document Matching to reconcile a sub-ledger extract to the receipts, then reviewing the matches.
Prerequisites
Expense receipts submitted by employees
Sub-ledger extract in Excel
Professional or Enterprise package
Start the procedure
1. Open your sub-ledger extract in Excel and create the table where you want the matching output to go.
2. Import all relevant receipts and run OCR.
3. Click the Document Matching button on the DataSnipper ribbon.
4. Select your sample data: the Receipt ID column and the local-currency amount column. Select the documents you want to match with, then click Match all rows.
5. Use your professional judgement to inspect the matches and their accuracy.
Additional procedures
To redact information, click Remove on the DataSnipper ribbon and select Redact Text, then snip over the information you want to hide. Finish by right-clicking your snip and selecting Apply all redactions. You can also remove specific documents or export your documents with snips and comments.