1. Set up access and organization settings
To begin consolidation, your group structure must be created in ScaleXP. Your Parent Organization sits at the top level of reporting and controls the consolidated view. Subsidiaries are added beneath it.
Step checklist:
Related Articles:
How to connect a new organisation (consolidated)
How to add team members; inviting others to access your ScaleXP
Basic setup: Settings to configure when getting started
2. Structure your financial reporting
To consolidate cleanly, entities must use a consistent reporting structure. ScaleXP allows you to cascade P&L and Balance Sheet formats from the Parent entity to subsidiaries for consistent roll-up.
Checklist:
Related Articles:
How to configure your P&L and Balance Sheet in ScaleXP (consolidated company)
How to move and group financials across entities using cascade from parent
Getting started with Reports: how to create and edit a report
3. Review and adjust exchange rate settings
If your group operates in multiple currencies, ScaleXP automatically converts subsidiary results into the Parent currency at month-end. Exchange rates can be adjusted if required for audit accuracy.
Checklist:
Related Article:
FX Rates: What foreign exchange rate is being used?
How to change historic FX rates and input custom foreign exchange rates
How to adjust foreign exchange rates: consolidated balance sheets
4. Set up intercompany accounts and eliminations
If group companies trade with one another, these internal balances must be eliminated in consolidation to avoid overstating revenue and costs.
Checklist:
Related Articles:
How to consolidate intercompany accounts in ScaleXP
How to eliminate intercompany accounts; How to add or remove accounts to be eliminated
5. Add a CRM and/or CRM Invoicing connection (if relevant)
If you use HubSpot, Salesforce or Pipedrive, connect at the parent level to generate group-wide metrics and reporting.
Integration with ScaleXP enables integrated billing, reporting, forecasting and subscription management. See these articles for more information.
How to connect Hubspot, Pipedrive or Salesforce
ScaleXP Invoicing: HubSpot Set Up - Step 1 of 2 - Installing
ScaleXP CRM Integration Best Practices
How to Configure Hubspot, Pipedrive or Salesforce for ScaleXP
6. Set up metrics and other reporting
Automated metrics pull information from the subsidiary organisations to a consolidated summary, customizable to meet your needs.
If you are using ScaleXP for automated revenue recognition, you may want to consolidate metrics such as MRR, ARR, churn, cohorts or customer reporting using reports on the consolidated Customer tab.
Alternatively, you may want to feed in metrics from a Google Sheet or CRM system.
Checklist:
Related Articles:
What is the ScaleXP Metric Library?
Customers Tab Revenue Recognition: MRR, ARR, and IFRS/GAAP Revenue Reporting by Customer
How to set up CAC (customer acquisition costs)
How do I create a new metric in the metric library?
How to add live metrics through Google Sheets
How to use data from Google Sheets in your ScaleXP metrics and reporting
7. Create your reports and dashboards
Once consolidation is configured, you can begin building group-level reporting. Reports and dashboards can combine both financial and operational metrics across entities.
Checklist:
How to build financial and metrics reports:
Getting started with Reports: how to create and edit a report
How to report on specific entities in a consolidated company
How to create a metric, report, or chart using Customer page reports
Add metrics from multiple customers pages to one report or dashboard
How to add budgets:
How to Set Up Budgets in ScaleXP (Overview)
How to add a budget to a consolidated company
How to add multiple budgets to a report
How to build charts and dashboards:
Getting started with Dashboards
8. Create your presentations and board packs
Use financial and KPI reports to build automated board packs. These update instantly each month from your consolidated data.
Related Article:
Summary
Once set up, consolidated reporting in ScaleXP allows you to:
- Roll up financials across entities
- Automate multi-currency conversions
- Eliminate intercompany balances
- Consolidate MRR/ARR and SaaS metrics
- Build group dashboards and board packs
- Sync monthly for automated reporting