Consolidation

Consolidation lets you view financial data across all entities in your organisation through a single consolidated set of reports. Instead of switching between individual entity reports, you see one set of consolidated Profit & Loss, Balance Sheet, and Cash Flow statements.

Premium feature

Consolidation is available on the Premium subscription tier.

What consolidation does

When consolidation is active, Monitr:

1. Combines General Ledger data from all entities in the organisation.
2. Eliminates intercompany transactions (to avoid double-counting).
3. Applies organisation-level adjusting entries — manual corrections and eliminations that only affect the consolidated view.
4. Converts multi-currency entity data into the organisation's base currency for unified reporting. If your entity's currency is not supported, contact Monitr support.
5. Produces a single set of reports, dashboards, and validations at the organisation level.

You can also create sub-consolidations: use Consolidation Groups to define custom subsets of entities (e.g. only the Dutch entities), and apply proportionate consolidation by setting each entity's consolidation percentage (e.g. 50% for a jointly held subsidiary).

Enabling consolidation

Two requirements must be met before you can enable consolidation:

• Your organisation must have at least 2 active entities.
• Your organisation must be on the Premium plan (or a Premium trial).

Consolidation is set up once from Organisation Settings:

1. Go to Organisation Settings.
2. Scroll to the Consolidation section (marked with a "Premium" badge).
3. Toggle Activate Consolidation on.
4. An Entity to Entity Relation Mapping matrix appears below the toggle. For each entity pair, select the relationship between them — this tells Monitr which transactions are intercompany and should be eliminated from consolidated reports.
5. Click Pre-fill Relations to have Monitr suggest relationships automatically. Pre-fill works by matching the VAT number of each entity against the VAT numbers of relations in the general ledger. Review and adjust the suggestions before saving.
6. Click Save at the top of the page to apply the changes.

Switching to consolidated view

Once consolidation is active, a toggle at the top of the screen lets you switch between consolidated view and entity view.

In consolidated view, the sidebar shows organisation-level features:

• Organisation Dashboard (replaces entity dashboards)
• Organisation Reports (consolidated Profit & Loss, Balance Sheet, Cash Flow)
• Organisation Structures (the consolidated reporting structure — for mappings and editing)
• Organisation Validations (cross-entity checks)
• Organisation Adjusting Entries (manual eliminations that only affect consolidated reports)

Consolidated reports

Consolidated reports have two ways to view the data, selectable from the pivot dropdown in the top-left of the report table:

• Per period: Shows figures with ICO (intercompany) eliminations and organisation-level adjusting entries already applied. This is the fully consolidated view.
• Per entity: Shows each entity in a separate column. Eliminations and adjustments are not applied per-entity — this view lets you see each entity's individual contribution before consolidation.

Reporting structure for consolidation

Unlike entity-level reporting structures — where you can define multiple structures — you can only define one reporting structure at the organisation level. This structure can either be copied from one of your entities, or built from scratch.

Configure it from Organisation → Reporting Structure (only visible in consolidation mode). The drag-and-drop builder works the same way as for entity-level structures — see Reporting Structures for instructions on how to build and map one.

Reporting anchors

Make sure the required Report Anchors are set in the organisation reporting structure (e.g. Total Balance Sheet, Net Result). If your organisation has entities in different currencies, you also need to set the FX Rate Difference (P&L) and FX Rate Difference (BS) anchors — reports will not load without them in a multi-currency consolidation.

Smart Mapping for consolidation

When configuring your consolidated reporting structure, you can use Smart Mapping to automatically suggest reporting lines for your unmapped accounts. Smart Mapping analyses your unmapped accounts and proposes the most appropriate reporting lines based on your existing structure.

1. Navigate to the Reporting Structure page in consolidation mode.
2. Click Edit to enter edit mode.
3. In the Accounts panel, click Smart Mapping.
4. Review the AI-generated suggestions and apply them to your reporting structure.

Intercompany eliminations

When two entities within the same consolidation transact with each other, those transactions need to be eliminated to avoid double-counting in the consolidated totals.

Example: Company A invoices Company B for €100 in management fees. Both are part of the consolidation and correctly mapped in the Entity to Entity Relation Mapping matrix.

In the consolidated report, you will see:

• Company A column: €100 revenue
• Company B column: €100 cost
• Total column: includes both the €100 revenue and the €100 cost
• ICO Eliminations column: reverses both entries (−€100 revenue, −€100 cost)
• Consolidated total: €0 — the transaction is fully eliminated

Setting up eliminations

Intercompany eliminations are controlled by the Entity to Entity Relation Mapping you configure when enabling consolidation (see above). Once entity relationships are mapped, Monitr automatically identifies and eliminates intercompany transactions from consolidated reports.

For amounts that fall outside the standard elimination logic, create Adjusting Entries at the organisation level to manually cancel out specific values.

Consolidation Groups and Proportionate Consolidation

Consolidation Groups allow you to create custom groupings of entities within your organisation for reporting purposes. This is useful for viewing consolidated reports for specific subsets of your entities, rather than always consolidating all entities.

You can also use Consolidation Groups to apply proportionate consolidation: set an entity's proportion to less than 100% (e.g. 50% for a jointly owned subsidiary) so only its proportionate share is included in consolidated reports.

Creating a Consolidation Group

1. Navigate to any Organisation Report (e.g., Organisation Reports → Profit & Loss).
2. Click the Consolidation Group dropdown.
3. Select Create new consolidation group.
4. In the dialog that appears, enter a Group name.
5. Select the entities you want to include in this group and define their proportion (e.g., 100% for fully consolidated, 50% for proportionally consolidated).
6. Click Save.

Using a Consolidation Group

Once created, you can select your custom Consolidation Group from the Consolidation Group dropdown in any Organisation Report or Dashboard to view reports specific to that group.

Balance Sheet zero balance correction

Consolidated Balance Sheet reports apply an automatic zero balance correction — but only when the Balance Sheet validations of all underlying entities pass. When they do, a Monitr mapping – Result Carried Forward row appears under the Result Carried Forward line in the consolidated Balance Sheet. This entry offsets the Total Balance Sheet total to zero, confirming that the consolidated assets balance against consolidated liabilities plus equity.

The correction is applied automatically — no action is required. If it does not appear, check that all individual entity Balance Sheet validations pass and that both Total Balance Sheet and Result Carried Forward are configured as Report Anchors in the organisation's reporting structure.

For the full explanation of how the correction works, see Automatic zero balance correction.

Consolidated features (Premium)

Feature	Description
Organisation Dashboard	KPIs and charts across all entities combined
Organisation Reports	Profit & Loss, Balance Sheet, Cash Flow consolidated
Organisation Validations	Run all validation checks across all entities at once
Organisation Forecasts	Budget at the group level
Organisation Adjusting Entries	Journal entries that affect only consolidated reports
Booklet Export (org level)	PDF documents with consolidated data
Consolidation Groups	Create custom groups of entities for specific consolidated reports

Consolidation scope

All active entities in the organisation are included in consolidation by default. If you want to exclude an entity (e.g. a dormant subsidiary), mark it as inactive or contact support.

Currency considerations

Monitr supports multi-currency consolidation for the following currencies: EUR, USD, GBP, AUD, SEK, BRL, CHF. If your entity's currency is not on this list, contact Monitr support to request it.

When entities operate in different currencies, consolidated reports show all values in the organisation's base currency (EUR). Monitr converts entity-level amounts using daily exchange rates sourced from currencyapi.com, updated automatically each day.

How FX differences are calculated

Monitr uses the closing rate (the most recent exchange rate on or before the report end date) to convert Balance Sheet amounts. Because individual GL transactions were originally recorded at the rate in effect at the time of booking, a difference arises between the closing-rate conversion and the original transaction amounts. Monitr surfaces this as a "Monitr mapping – Transaction rate difference" row in the consolidated Balance Sheet and a corresponding movement in the P&L.

Required report anchors for multi-currency

If your organisation has entities in more than one currency, you must configure two additional Report Anchors in the organisation's consolidated reporting structure:

• FX Rate Difference (BS) — the Balance Sheet line where the transaction rate difference is posted
• FX Rate Difference (P&L) — the P&L line where the month-by-month movement in the BS FX difference is posted

If either anchor is missing, consolidated reports will not load. Assign them in Organisation → Reporting Structure → Report Anchors.