Account Reconciliation (Intercompany) Overview report

On the Account Reconciliation (Intercompany) Overview report, you can view intercompany reconciliation differences across all consolidation processes, which streamlines analysis and reconciliation efficiency.

To access the Account Reconciliation (Intercompany) Overview report, select Rates and Reconciliation > Intercompany Matching > Account Reconciliation (Intercompany) Overview.

If a difference exists in the account balance between the entity and intercompany and the difference exceeds the defined threshold for a specific 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 specific 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.

To view threshold values for each consolidation process, hover over the Check column.

In the grid, you can select a display option for the Consolidation Process, Entity, and Intercompany columns. They can be displayed with an ID, name, or both. Select Columns > Show Columns and then select the required display option for a specific column. To show transaction data columns such as Other Differences and Currency Difference, select Columns > Show Transaction Data. To hide the transaction data columns, select Columns > Show Transaction Data again.

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.