v25.09: Intercompany Movement Calculation
The Intercompany Movement Calculation enhancement introduces a standardized approach to calculating movements for intercompany transactions across Balance Sheet and P&L account types.
Previously, balance sheet movement metrics relied on a basic formula comparing base values and aggregated totals. With this enhancement, the system supports a refined calculation flow that incorporates designated intercompany members—I9999, I_ALL, and I_CALC—into the logic for both Balance Sheet and P&L account types.
How intercompany movement calculation works
Balance Sheet account types (Assets and Liabilities)
When intercompany members are present, the system aggregates all relevant base values and subtracts them from the designated closing input to compute the movement. If no base members exist, the full closing input is posted as movement.
P&L account types (Income and Expenses)
For P&L account types, there is no dependency on flow movements. The system calculates and posts the difference amount directly to I_CALC using the following formula:
I_CALC = | I9999 – I_ALL |
Note: Note: The standard intercompany dimension members required for this feature are I9999, I_ALL, and I_CALC. These are auto-generated when a new intercompany dimension is created.
Account type behavior summary
Account type |
Calculation logic |
Result posted to |
|---|---|---|
Balance Sheet (Assets, Liabilities) |
Aggregates base values and subtracts from the closing input to derive movement. If no base members exist, the full closing input is posted as movement. |
I_CALC and I_ALL |
P&L (Income, Expenses) |
No flow movement dependency. Posts the difference amount directly using: I_CALC = | I9999 – I_ALL | |
I_CALC |
Key benefits
Automates intercompany movement calculations for Balance Sheet and P&L account types.
Integrates standardized members (I9999, I_ALL, I_CALC) into the calculation flow.
Posts movement values directly to designated reporting members.
Handles scenarios with and without base members.
Applies a dedicated P&L formula without flow movement dependency.
Auto-generates master data for intercompany dimensions.
Reduces manual reconciliation and improves audit readiness.
Use intercompany movement calculation
-
Go to the Actions tab of the relevant sheet and select the Auto Mapping feature.
The Feature Details panel opens on the right.
-
In the Feature Details panel, select the Movements (Balance Sheet only) & Interco Sync check box.
[Replace with screenshot of Feature Details panel]
-
In the Applicable Metrics list, select the relevant metric for the intercompany dimension.
Note: Note: Ensure that system-generated members I9999, I_ALL, and I_CALC are available. These are auto-created when a new intercompany dimension is added.
Enter the closing values and aggregated totals for the mapped metrics.
-
Save the configuration. The system automatically calculates the movement based on the account type:
Balance Sheet: Compares base and aggregated values to derive movement and posts results to I_CALC and I_ALL.
P&L: Applies I_CALC = | I9999 – I_ALL | and posts the result directly to I_CALC.
Review the posted results in I_CALC and I_ALL for reporting, reconciliation, and audit purposes.
If required, adjust the input values or metric mappings and recalculate.