1. Working with Financial Consolidation and Close
  2. Working with Reports
  3. Managing Intercompany Matching Reports
  4. Setting Up Intercompany Matching Reports

Setting Up Intercompany Matching Reports

To set up Intercompany Matching reports, you select the POV members, accounts, and matching accounts that you want to display. You can also select whether to suppress display of dimension members and data cells associated with a specific variance.

Selecting the Point of View for Intercompany Matching Reports

The Point of View dimensions are displayed in the header section of the generated report. You can select one member for each of the following dimensions:

  • Scenario

  • Year

  • Period

  • View

  • Consolidation

  • Currency (Must be a Reporting Currency)

Selecting Accounts for Intercompany Matching Reports

You can specify the account and matching accounts for which you want to match transactions or select a plug account.

A plug account is an account that, when eliminations are complete, stores the difference between two intercompany accounts. When you select the plug account for a report, the system uses the account and matching account that the administrator specified when defining the plug account.

For each plug account, the accounts that are associated with it and that have the same Account type are displayed. For example, Asset and Expense account types are associated, and Liability, Revenue and Equity account types are associated.

If you select plug accounts for the report, the report displays an additional row for the Grand Total of each plug account. The Grand Total is included for each of the account columns, and the Variance and Total columns of the report. If the report contains multiple plug accounts, each report section (by plug account) will have its own Grand Total line.

If you do not select a plug account, but instead select specific accounts and matching reports, then the system displays one Grand Total for the report.

For the Intercompany Partner selection, you can select from the Intercompany dimension or from the Entity dimension. If you use the Entity dimension as the selection for the Intercompany Partner, the system filters out any non-Intercompany entities from processing, as these entities should not be included for an Intercompany Matching report. You can check the report log to see any entities that were not included in the report process.

Selecting Suppression Dimensions

The Data Source, Movement and Custom-defined dimensions are considered suppression dimensions. With these dimensions, you can select multiple members, using either the Member Selector or by specifying member names in text, with member names delimited by a comma. The Member Selector provides these member categories:

  • Ancestors

  • Children

  • Descendants

  • Siblings (All, Left, Right, Previous, Next)

  • Parents

  • Level 0 Descendants (All, Previous, Next)

  • Left Siblings

  • Generation (Previous, Next)

The Suppression dimensions are listed in the generated report header.

You can select one of the following Suppression options:

  • Not Suppressed—This is the default selection. The dimension is included as a column in the Report Grid. There is a row of all combinations of outer-dimensions (dimensions to the left) members against each member of the Not Suppressed dimension.

  • Suppressed—The dimension is not included as a column in the Report Grid. Each row data point implies a summation of all the members selected for the specified suppression dimension. All dimensions suppressed are treated as though they were at the end (right-most inner) dimensions in the grid.

  • Group—This is the same as Not Suppressed, with the addition of summation rows. All outer-dimensions (dimensions to the left), together with the grouped dimension, form a group. When a group is displayed against all of its inner dimension members (all members to the right of the grouping), a summation of values will is added as the next row.

    Note:

    The Group option limits the dimension selection members to base members only. The Intercompany dimension (Partner dimension) is automatically groups, and a summation of values is derived for each Entity/Partner combination.

Selecting Suppression Matches

In Intercompany Matching reports, you can suppress the display of data cells associated with a specific variance, as well as the variance itself, if a set of conditions are met. Suppressing the data in a data cell means that the system shows no value (a blank value) in that cell. If both variances are suppressed in the row, the system does not display the entire row.

You can suppress data by specifying a tolerance value (amount) or percentage. For example, if an Entity has an amount of 299 and the Partner Entity has 200, the difference is 99. If the matching tolerance is 100 and the difference between the Entity and Partner is less than 100 as in this example, the system suppresses the transactions because it is within the matching tolerance.

If you select not to suppress the Entity/Partner transactions, the system does not suppress them even if the Entity and Partner amounts are within the matching tolerance amount or percentage. Using the previous example, even if the difference amount is 99 and if it is within the matching tolerance, the system does not suppress the transactions. The matching tolerance is displayed in units.

You can suppress matches using one or both of these options:

  • Tolerance Value - You can enter a Tolerance value. The value must be a positive number. If the absolute value of a specified variance is less than or equal to the Tolerance value, the system suppresses the variance, accounts, and matching account data cells for the specified variance in that row. By default, the Tolerance value is 0.

  • Tolerance Percent - You can enter a Tolerance percent. The value must be a positive number less than or equal to 100. Determine the absolute value of the portion of the variance that was accounted by the Accounts. Determine the absolute value of the portion of the variance that was accounted by the Matching Accounts. Take the minimum of these two values (if there are no Matching Accounts, then just use the portion from Accounts only), and apply the Tolerance Percent. This is the Tolerance Percent Value. If the Tolerance Percent Value is greater than the absolute value of the variance, then the Variance, Accounts, and Matching Account data cells for the specified Variance in that row are suppressed.

  • Both Tolerance Value and Percent - Take the minimum of the Tolerance Value and the Tolerance Percent Value. If this minimum is greater than the absolute value of the Variance, then the Variance, Accounts, and Matching Account data cells for the specified Variance in that row are suppressed.

    Note:

    A row that has no data for both transactions is automatically suppressed, regardless of whether any of the suppression options are enabled.

The Suppression Match options are displayed in the header section of the generated report.

Suppression Options

In addition to Tolerance Value and Tolerance Percent, you can also choose to suppress these types of rows on the report:

  • Reversals - If you select this option, the reversal Entity/Partner rows are not included in the report.

  • Blank Columns - If you select this option, columns with no values are not included in the report. The column is suppressed if the entire column has no data. If the report is set up by Plug Account, the suppression option applies to all accounts within each plug account. If the report is by specific Matching accounts, the suppression applies to all accounts within the matching set.

    If you do not select this option, the report displays all account columns, regardless of whether they contain data.

The Suppression options are displayed in the header section of the generated report.

Selecting Display Options

You can modify these default display options for the report:

  • Scale Factor - You can enter a value between 0 and 9. The default value is 0. The scale factor is applied to each data cell. For example, if the value is 1000 and the scale factor is 3, the value will be displayed as 1. All unsuppressed data cells are multiplied by the Scale Factor. The system performs the calculation and suppression operations prior to applying the Scale Factor.

  • Decimal Override - You can specify the number of digits shown in the fractional portion of a decimal. You can enter an integer between 0 -6. The default value is 0.

  • Member Display - Specify whether to display members using their Name, Description, or both.

  • Report Title - You can enter a report title. The default title is Intercompany Report.

  • Report Type - You can generate reports in HTML, PDF, or XSLX format.

Note that the settings specified in your user preferences for formatting are ignored in Excel. When you run the report and save it as an Excel report type, you can use a Substitution Variable to automatically display the values in number format, rather than cell text. The substitution value is called EnableExcelNumberFormat, and when set to True, when you save the report as an Excel report type, the values are automatically displayed in numeric values.