Skip to main content

How to review intercompany transactions using DataSnipper

How to use Form Extraction and Document Matching with mandatory field constraints to review intercompany transactions and reconcile transaction summaries to supporting documents in DataSnipper.

Use DataSnipper's Form Extraction and Document Matching to review intercompany transactions, extract invoice details, and reconcile transaction summaries to supporting documents.

What the video covers

The video demonstrates the transfer pricing workflow for intercompany transactions in DataSnipper, showing how to extract invoice details with Form Extraction and copy the results into a workpaper. It also covers reconciling an intercompany transaction summary to supporting documents with Document Matching, including using the Mandatory field option so only documents with a matching amount are reconciled.

Prerequisites

  • Intercompany transaction documentation from your client

  • Supporting evidence: intercompany invoices, agreements, financial statements, and tax filings

  • DataSnipper Professional or Elevate package

Extracting details from invoices

  1. Open your transfer pricing workpaper and import the invoices to extract.

  2. Click Document Extraction in the Automation section and select Form Extraction. Click Start new form extraction and select the relevant invoice files. Note: all documents in a single Form Extraction run must have a consistent layout.

    Starting a new form extraction and selecting invoice files with a consistent layout

  3. Add extractions for each data element you need, drawing over the relevant area in the first document. Name each extraction clearly.

    Preview of extracted data fields shown on the right side of the screen
    Three-dots menu for editing, renaming, or deleting an extraction

  4. Click Save as template to reuse the configuration for future engagements.

    Saving a Form Extraction configuration as a template

  5. Click Export to Excel. Copy and paste the snips into your workpaper.

    Exporting extracted invoice data to a new workbook
    Snips pasted into the transfer pricing workpaper

Reconciling transaction summaries to supporting documents

  1. Paste the intercompany transaction summary data into your workpaper and import the supporting documents.

    Intercompany transaction summary data pasted into the workpaper alongside imported supporting documents

  2. Click Document Matching.

    Opening Document Matching from the DataSnipper toolbar

    Configure a new test selecting your sample data and supporting document folder.

    Configuring a new Document Matching test by selecting sample data
    Selecting the supporting documents to reconcile in Document Matching
    Selecting the output columns for the snipped results in Document Matching

    Then click Match all rows and review the output.

    Reviewing matched rows after clicking Match all rows in Document Matching

  3. If a row fails to match because the amount is not present in any document, use the Mandatory field option to enforce that only documents with a matching amount are reconciled. Click the three-dots menu on the Amount field in Document Matching and select Mandatory field.

    Selecting the Mandatory field option on the Amount field in Document Matching

    Re-run the match to apply the constraint.

    No snip made on the row after re-running Document Matching with the mandatory field constraint applied
Did this answer your question?