This report displays data related to intercompany transactions in the consolidation system, and it enables you to set tolerance amounts for the differences of the matching items. 

You can generate the report for a given set of accounts, such as accounts receivable and accounts payable, or you can select all Accounts. You can also select the entity and currency based on your needs.

When intercompany data is loaded, the data can also be loaded in the transaction currency of the entity/trading partner. This is done by loading the data to the TransactionCurrency Dataview, where the DataViewType property equals TransactionCurrency. If data is loaded at this level, a Details link is shown in the intercompany matching report. You can view the data in the transaction currency instead of the currency selected for the report.

Prerequisites

The system requires these member tags for the report:

DimensionElementTag
CurrencyAll currency#AllCurrency
EntityTotal group (Main entity structure)#TotalGroup
ScenarioActual#Actual

Note: Member tagging is done within the Anaplan Financial Consolidation Model Manager.

To use the Intercompany Matching report, the parent Intercompany Matching member in the Accounts dimension must be tagged as #IntercompanyMatching.

The system also requires global variables for the report.

Variable NameValue
CurrentPeriodThis should be set to the name of the current period element. For example: 2026 P3.

Access the report

To access the report:

  1. Select the Explorer module.
  2. Expand the Global > Consolidation > Reports > Web Reports folders.
  3. Right-click the Intercompany Matching report and select Open. Alternatively, double-click the report to open it.

Parameters

The parameters act like filters for the report.  You can search for the desired parameter. 

The key parameters of the report are:

Variable NameValue
Report

Select an option:

  • Report: This is the standard reporting format option.
  • Sort by Couple: Sorts each pairing of entity and intercompany together. For example, Houston and Los Angeles, and the next section would be Los Angeles and Houston.
  • By Account: Sorts by intercompany matching account, such as balance sheet, current, long-term, P&L, etc.
  • Unify: Like the Sort by Couple option, it groups items together. Instead of being one item on top of the other, it's all grouped together. 
AccountSelect an account member.
ScenarioIt defaults to the scenario tagged as #Actual.
DateIt defaults to the value set in the global variable CurrentPeriod.
EntitySelect an entity member.
CurrencySelect the required currency.
AuditSelect an audit member, such as Contribution.
DataViewSelect a DataView member.