There are two options to eliminate intercompany accounts in ScaleXP.
The most common way to eliminate intercompany accounts is to move them into intercompany financial categories at the consolidated entity.
See How to consolidate intercompany accounts in ScaleXP.
However, if you prefer to keep accounts in their existing P&L and/or Balance Sheet categories and identify elimination accounts separately, this option is also available. To do this, go to the consolidated entity, Load Data (top bar)>Eliminated Accounts (left sidebar).
Select the specific revenue and/or balance sheet accounts you wish to eliminate. See screenshot below.
Selected accounts will still show at the subsidiary in the usual place. At the consolidated company level, however, the accounts are eliminated.
Eliminating P&L Accounts:
In theory, the total Eliminated accounts on the P&L should offset each other such that the balance is £0. In reality, there is always a small balance due to foreign exchange movements.
Show this amount on the consolidated P&L by adding a row with the metric 'FX Consolidation Reserve Profit & Loss.'
Eliminating Balance Sheet Accounts:
Similarly, assets and liabilities tagged for elimination at the consolidated entity remain in place in the subsidiary company but are eliminated from the parent.
To reflect the FX impact of eliminated balance sheet accounts, add the metric 'FX Consolidated Reserve Balance Sheet' as an account.
See this article for how to add rows to an existing report.
To remove an account from being eliminated, go to the Eliminated accounts section on the Load Data page, find the account to be removed, and select the three vertical dots at the far right.
hree dots and then select 'Remove'.
