Use DataSnipper's Invoice Extraction and Document Matching to perform expense testing, reconciling GL sample items to invoices and then matching those invoices against bank statements.
Video tutorial
What the video covers
How to extract invoice data using Invoice Extraction, copy results to a testing worksheet, and reconcile invoice data against bank statement entries using Document Matching.
Prerequisites
DataSnipper v6.0 or later
Advanced Document Extractions, available on the Accelerate or Elevate package
Scanned invoices for the selected General Ledger items
Bank statements
Steps
Import invoices and the corresponding bank statement into DataSnipper. Use Document Organizer to create two folders: Invoices and Bank Statement.
Open Invoice Extraction from the Document Extraction dropdown. Select all invoices and the fields to extract (Invoice ID, Invoice Date, Invoice Total), then click Extract.
Copy the extracted data from the Invoice Extraction-generated tab into your testing worksheet.
Open Document Matching and select Start new document matching. Select your sample (invoice number and amount).
Select the Bank Statement folder as the matching target.
Structure the input and output columns, then click Match all rows.
Review the output matches, investigate any discrepancies, and document your conclusions.