How to perform VAT Testing on Invoices for Government Audits using DataSnipper

Learn how to use DataSnipper to perform VAT testing on Invoices using Document Matching and Snips

Video Tutorial

Example

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

Invoice Testing - Example

Template

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

Invoice Testing - Template

Prerequisites

• Batch of Invoices 

Start Procedure

1. Start by importing your Invoices into DataSnipper.
2. To reconcile the GL data with the Invoices open Document Matching and "Start new document matching".
3. Select the sample data as well as the folders with the relevant documents. 
4. Structure your input and output table to tailor the result in excel to your liking.
   
5. To flag the unmatched data investigate the respective invoices and use Exception Snip to do so.