Intercompany Matching Reports in Hyperion Enterpirse

Intercompany Matching Reports:

Intercompany matching reports list the intercompany transactions that are to be eliminated during consolidation for one period. These reports help you to track intercompany transactions for analysis and auditing in the currency that you specify.

You perform the following tasks to produce intercompany matching reports:

● Define intercompany account matching groups

● Define the partners for which you want to report transactions

● Specify the currency options

● Specify the report information to include

● Specify the report information to suppress

● Customize your report

Note: You need to consolidate before you run intercompany matching reports.

Intercompany Group Selection

The system produces reports based on the intercompany account matching groups that you define in the Accounts module. You select the entity or entities for which you are processing the report in the Consolidation window, either by single entity or branch, and then you select one or more partner entities.

Note: If you select more than one period for processing, the system processes only the period that contains the cursor. A parent entity at the top of a branch is usually not an intercompany entity and is excluded from the entities that the system processes.

Partner Selection

After you select the entity or entities for which you are processing the report, you define the partners for which you want to report transactions. You can define partners using the following options:

1) Specified partners means either a specific partner entity or all the intercompany entities within a branch

2) Within the group means all transactions between entities in the currently selected branch

3) Outside the group within the organization means to report all transactions except those that take place between entities in the currently selected branch

4) Outside the group within the Application means to report transactions with the additional organization (assume that you have the additional organization within the same application) in the same application.

You can specify whether to display data in the following ways:

1) For either a specific partner entity or all the intercompany entities within a branch; that is, for specified partners

2) For all transactions between entities in the currently selected branch; that is, within the group

3) For all transactions except those that take place between entities in the currently selected branch; that is, outside the group within the organization

4) Outside the group within the application

Example:

For Example, in the sample organization shown the following figure, DIV1 is the entity for which you are processing the report.

Fig: Sample Organization

Note: Assume FRANCE, GERMANY, C1, C2, C3 and C4 are Intercompany Entities

If you choose the partner option as Within the Group, your report includes all transactions that take place between the following entities:

1. France and Germany

2. France and C1

3. France and C2

4. Germany and C1

5. Germany and C2

6. C1 and C2

If you select Outside Group within Organization, your report includes all transactions that take place between the following entities:

1. France and C3

2. France and C4

3. Germany and C3

4. Germany and C4

5. C1 and C3

6. C1 and C4

7. C2 and C3

8. C2 and C4

If you choose Outside Group within Application, assume that you have the additional organization shown in the following figure.

Your report then includes all transactions that take place between the following entities:

1. France and C3 France and C4 France and C5 France and C6 Germany and C3 Germany and C4 Germany and C5 Germany and C6 C1 and C3 C1 and C4 C1 and C5 C1 and C6 C2 and C3 C2 and C4 C2 and C5 C2 and C6

If you choose the partner option as Specified Partner and select the partner as DIV2, your report includes all transactions that take place between the following entities:

1. France and C3 France and C4 Germany and C3 Germany and C4 C1 and C3 C1 and C4 C2 and C3 C2 and C4

Entity Code Option

You can specify an entity code to filter the list of entities and the list of the matching partners for which you are processing the report. You can select multiple entity codes for a filter.

Currency Option Selection

After you specify the partner transactions to include in your intercompany matching report, you specify one or more types of currency on the report:

1. The currency of the entity for which you are processing the report The currency of the partner The currency of the parent Another currency that you select

For each currency you select, the system generates a Difference column. An optional Status column appears on the report.

Currency Translation

Currency translation is performed using the rate specified in the application module for translating balance or flow accounts. You can also specify to translate flow accounts using balance account rates for an intercompany set.

The system does not translate accounts if you specify to use child rates in your application. If your application stores the rate account data in an account group other than GLOBAL, the system uses the rate data of the parent entity.

Parent Currency

In the Consolidation window, if you select only one entity for processing and apply the parent currency, the system uses the currency of the selected entity. If you select a branch or group for processing and apply parent currency, the system translates each dependent using the currency of the parent, which is the top node of the branch.

Report Information to Include

The intercompany matching report includes columns for the entity for which you are processing the report, the partner entity, accounts, entity and matching entity values, the difference between accounts, and the status of the matching transaction.

You use the matching currency as a conversion factor in defining the matching tolerance for the report. The matching currency for the report is the parent currency by default, which is the currency of the top node of the branch selected for processing. You can specify another matching currency.

You use the matching tolerance to specify the range of values for which to report status. The matching tolerance for the report is based on the matching currency you select. The report scale that you select also is the scale for the Matching Tolerance amount.

You can specify whether to display the entity description for entities in the intercompany matching set, whether to display account detail, account totals, and accounts in rows instead of columns. You can select to generate a one report for each entity for which you are processing the report. You can also select the report scale, and the number of decimal places to display on the report.

The system processes and stores values based on the account types. When you calculate the difference, the system applies the signs shown in the following table to accounts. When calculating the Total column, the system considers the sign for the account attribute, and then applies the sign of the first account in each column to the result. Therefore, the sign of the total may change, depending upon the sign of the first account that is specified in each column.

Report Information to Suppress

You can suppress the following report information:

1. Status, which provides status information based on the matching tolerance that applies to the entire report. Currency, which provides information on the current and partner entity currencies for each currency you select. For example, if you have different currencies assigned to each partner entity, the currency for each partner is different on each row. Subtotals, which the system generates after processing each entity for which you are processing the report, and a grand total for the entire report. You might want to suppress totalling and subtotalling if they are not meaningful because of currency differences. For example, if you have a report that shows both current entity and partner currencies, each subtotal might appear in a different currency. In this case, you might want to suppress the grand total.

4. Matching values, which are transactions that fall within the range of values you specify for matching tolerance.

Running Intercompany Matching Reports:

After you define intercompany matching groups, you can use intercompany matching reports to list the intercompany transactions that are eliminated during consolidation and to identify unmatched intercompany transactions. These reports document an organization's transactions so you can analyze or audit the data in the currency that you specify. The system saves the check box options that you select and displays them the next time you run intercompany matching reports.

To run intercompany matching reports:

1. From the Consolidation window, select the entity or entities and period for which you want to run the report. Select Task > Run Intercompany Matching Reports. On the Intercompany Group tab, select the intercompany group for which you want to run intercompany matching reports. On the Matching Options tab, select the partner transactions, currency options, and filter options that you want to use. On the Reporting Options tab, select the desired report and suppress options to include, then do one of the following:
   1. To print the report, select Print. To preview the report, select Preview.