A consolidated group rolls several entities up under one parent, so you set up the group, group the accounts at the parent and copy that to each subsidiary, then deal with intercompany accounts, exchange rates and adjustments.
What this guide covers
- Creating the parent and its subsidiaries and connecting each one.
- Grouping accounts at the parent and copying the groupings to each subsidiary.
- Eliminating intercompany accounts.
- Checking exchange rates and posting group-level adjustments.
Set up in six steps
- Set up the group, its connections and its users: How to set up consolidated reporting in ScaleXP.
- Select the consolidated parent and group its accounts under Load Data > Configure P&L, BS: How to configure your P&L and balance sheet in ScaleXP (consolidated company).
- Copy the groupings to each subsidiary with Transfer Settings from Consolidated: How to move and group financials across entities using cascade from parent.
- Eliminate intercompany accounts, either by moving them into the intercompany categories (How to consolidate intercompany accounts in ScaleXP) or by listing them under Eliminated Accounts (How to eliminate intercompany accounts and add or remove accounts from elimination).
- Check the exchange rates on the Load Data tab of the parent: FX rates: What foreign exchange rate is being used?
- Post group-level adjustments, such as goodwill, through an adjustment entity: How to add consolidation adjustments.
Important: Transfer Settings replaces all category names and groupings in the subsidiary with the parent's, and can't be undone.
What you get
- A consolidated P&L and balance sheet in the parent's currency, translated at the monthly average rate for the P&L and the month-end rate for the balance sheet.
- Intercompany accounts eliminated at the consolidated level.
- The transactions behind any consolidated account row. See How to see transaction detail behind account balances.
- Group reports, dashboards and board packs built from your consolidated data.
Where to go next
- Show single entities or eliminations in a report: How to report on specific entities and eliminations in a consolidated company.
- Add a budget: How to add a budget to a consolidated company.
- Use your own exchange rates: How to change historic FX rates and input custom foreign exchange rates.
- Use your consolidated reports in a board pack: Board packs.