Use DataSnipper's Invoice Extraction and Document Matching to perform Indirect Tax Testing, including extracting invoice details and reconciling ledger data to invoices.
Prerequisites
Invoices and ledger details
DataSnipper v5.1 or later
Extracting details from invoices
Open your tax workpaper and import the invoices you want to extract data from.
Click Document Extraction in the Automation section of the ribbon and select Invoice Extraction.
Select the invoices and the data elements you want to extract, then click Extract. The selected data appears in tabular form in your workbook with cross-references to the source invoices.
Copy and paste the snips into your tax workpaper. The embedded formulas perform the calculations automatically.
Reconciling ledger details to invoices
Paste your ledger data into the workpaper and import the invoices you want to reconcile.
Click Document Matching, configure a new test by selecting your sample data and invoice documents, select the output columns, then click Match all rows.
If a row fails to match due to a small amount discrepancy, navigate back to Document Matching, click the three-dots menu on the Amount input, and define a tolerance threshold. Re-run the match to include rows within the threshold.