Intercompany Matching

The Intercompany Matching Report provides a clear and comprehensive view of transactions between entities that belong to the same parent or holding company. This report allows you to identify entry recording mismatches across companies and accounts. Additionally, you can download this for reconciliation in Excel format.

This report is particularly useful during the close process to ensure elimination entries are accurate and balanced, and highlight variances that need attention, reducing the risk of reporting discrepancies.

Prerequisites

The following prerequisites are applicable:

• The Sub Consolidation Process flag must be configured and enabled from Administration > Configuration Task List. If not enabled, this report will not be available. To learn more about how to enable this process, click here.

• Elimination Rules must be configured. If not configured, this report will not show any data. To learn more about creating elimination rules, click here.

Note:

Initiating the consolidation process of an entity is not required to create an Intercompany Matching Report.

How to Create an Intercompany Matching Report

To create an Intercompany Matching report, do the following:

1. Navigate to Consolidation > Consolidation Control Panel > Processes.

2. In the left pane, under Process, click Eliminations.

3. In the right pane, under Reports, click Intercompany Matching. The Intercompany Matching Report window appears.

   

4. Scenario and Reporting field values default to Actual and CC (common currency).

5. Select values for the below fields:

   • Elimination Code - One or more elimination rules.

   • Companies - One or more entities for which you want to view the eliminations.

   • Month - Period during which you want to view the eliminations.

6. Click Preview. The report shows data for the selected configuration if available.

   

7. The following fields appear in the report:

   • Due From - Represents the amount one entity expects to receive from another, for example, receivables.

   • Due To - Represents the amount one entity owes to another, for example, payables.

   • Variance - Calculated as the difference between Due From and Due To values.

     

8. Click Download Report to export the report in the Excel format.

Note:

The following validations are applicable:

• All fields in the Intercompany Matching Report must be selected.

• If no data exists for the selected configuration, the system shows a message indicating that data is not available.

• This report is not dependent on running the consolidation process. It implies that the report displays standalone company data.