Account Reconciliation (Intercompany)

Select Rates and Reconciliation > Intercompany Matching > Account Reconciliation (Intercompany).

Based on the context criteria, you can view the comparison of the balances of the entity accounts with the balances of the entity's all contra, intercompany accounts.

If a difference exists in the account balance between the entity and intercompany and the difference exceeds the defined threshold for the selected consolidation process, the difference is highlighted in orange and the Warning icon is displayed in the Check column.

To verify the details of the difference, click the difference amount in the Net Difference column. The Intercompany Matching Detail Overview page for the selected consolidation process is displayed.

Caution:

A threshold is a fixed value that is not group currency-specific and applies uniformly across all group currencies. In multi-group or subgroup environments with differing group currencies, a non-zero threshold can cause inconsistencies. If a threshold is 0, no issues occur. To configure a threshold, select Business Modeling > Modules > Consolidation > Processes, click the Debts or Expenditures / Revenue tab, and edit a specific elimination.

On the Account Reconciliation (Intercompany) page, this message is displayed by default:

This report highlights entity and intercompany balances that exceed a configured threshold in the reporting currency. Use the bottom panel with account-level details to help identify and resolve mismatches quickly.

To hide this message, click Show Less. To show the message again, select Rows > Show Moderation Message.

The Show Below Threshold option is enabled by default. When enabled, all values, including those below and above the threshold, are displayed in the grid. If you disable this option, only above-the-threshold net difference values are displayed.

You can filter the Net Difference and Difference columns by the difference ranges. For example, greater than or less than.

By default, the grid shows the Difference Calculation (Without The Global Sign) row, which provides formulas on how the net difference and entity-to-intercompany and intercompany-to-entity differences are calculated for the selected consolidation process. To hide this row, click Hide Hint. To show the row again, select Rows > Show Calculation Hint.

The Accounts and Contra Accounts columns show the total value of all entity accounts and intercompany contra accounts for entity-intercompany and intercompany-entity relations. You can expand these columns by clicking the plus icon. The values of individual accounts and contra accounts that contribute to the total value are displayed in separate columns. Individual accounts and contra accounts can be displayed with an ID, a name, or both. To choose a display option, select Columns > Show Columns > Group Account and Group Contra Account.

When you select an entity-intercompany row in the grid and expand the Transaction Currencies Data Entry panel at the bottom of the page, the Intercompany Matching Detail report for the selected consolidation process and entity-intercompany relation is displayed.

Note: If you do not select an entity-intercompany row in the main grid, no data is displayed in the Transaction Currencies Data Entry panel.

In the panel, the above-the-threshold difference in the balance of the entity and intercompany accounts is marked with the Warning icon. To verify the details of the difference, click the difference amount or the icon. Depending on the selected consolidation process, the Transactions Data Entry Detail – Consolidation Debts or Transactions Data Entry Detail – Consolidation Expenditure / Revenue page is displayed.

In the Transaction Currencies Data Entry panel, you can also click an underlined value in the Group Currency (currency ISO code) column for a specific account and, in the displayed dialog box, specify the transaction currency values for applicable currencies. You can also specify values in local currencies, but this is only for informational purposes and does not affect any data. By default, the selected level in the dialog box is HB I manual - Data Entry Manual. You can change the level but then the grid is read-only and you cannot specify any values.