Learn how to use DataSnipper's Document Matching and Snips to match invoices in multiple currencies to your general ledger data. This procedure applies to DataSnipper v5.0 or later.

The walkthrough shows three ways to test detail where the evidence is in a foreign currency, including recalculating amounts with an average exchange rate and matching with a threshold to absorb exchange-rate movement.

Option 1. Check whether your client records the foreign-currency amount in their general ledger. If they do, use that amount to run Document Matching.

Option 2. Run Document Matching on other fields (for example invoice number, invoice date, supplier name, or bank account number) and snip the amount manually.

Option 3. Recalculate the results in the foreign currency, then run Document Matching using the steps below.

1. Add an extra column to the input data and look up the average exchange rate for the year.

2. Use the extra column to recalculate the foreign-currency amount with the average exchange rate.

3. Click the Document Matching button in the DataSnipper ribbon and select Start new Document Matching.

4. Select your sample data. If it includes headers, check First row includes headers, click Next, and select All Documents.

5. In the Input/Output table, click the three dots beside the Amount input and activate Threshold Amount. Set it to 10, and adjust the threshold as needed to allow for exchange-rate fluctuations.

6. Run Document Matching and review the results.

You can exclude all documents before saving the workbook in your audit file using the include/exclude documents toggle. You can also delete specific documents if needed.