How to perform Expense Testing with Invoice Extraction and Document Matching

Learn how to use DataSnipper to perform Expense Testing using Invoice Extraction and Document Matching

Video Tutorial

Example

Here you can download the workbook shown in the video including all of the sample data and documents. 

Expense Testing - example

Template

Here you can download a blank version of the workbook shown in the video to use or customise for your own procedures. 

Expense Testing - template

Prerequisites

  • DataSnipper version 6.0 or later
  • Advanced Extraction Suite add-on module
  • Scanned invoices for the selected General Ledger items;
  • Bank Statements

Start Procedure

  1. Obtain invoices as well as the bank statement corresponding to the General Ledger sample and import them into DataSnipper. 
  2. Using Document Organizer, create two folders for the Invoices and for the Bank Statement.
  3. Open Invoice Extraction from the Document Extraction drop down. Select all the invoices as well as the data fields you want to extract, i.e., Invoice ID, Invoice Date and Invoice Total, and click "Extract".
  4. Copy the extracted data in the Invoice Extraction generated tab, into your testing worksheet. 
  5. To match this data with the Bank Statement, open Document Matching in the DataSnipper ribbon and "Start new document matching".
  6. Select your sample, i.e., Invoice number and Amount. 
  7. Next, click on the Bank Statement folder so that DataSnipper knows to match you invoices with the bank statement. 
  8. Structure the input and out table as you desire the output to look like in your worksheet. Click Match all rows.
  9. To conclude, investigate your matches to assess for errors and accuracy.