Consolidation

Consolidation lets you view financial data across all entities in your organisation as a single combined entity. 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. Produces a single set of reports, dashboards, and validations at the organisation level.

Enabling consolidation

Consolidation is set up once from Organisation Settings:

1. Go to Organisation Settings (sidebar → Organisations or Settings, depending on current view).

2. Scroll to the Consolidation section (marked with a "Premium" badge).

3. Toggle Activate Consolidation on.

   The toggle is disabled if: (a) your subscription tier is Lite, (b) you have fewer than 2 active entities, or (c) you don't have write permissions to organisation data.

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 based on your entity data, then review and adjust as needed.

6. Click Save at the top of the page to apply the changes.

Switching to consolidated view

Once consolidation is active, the sidebar and data views automatically respond to your current selection:

• Entity-level view: Click a specific entity in the organisation selector (top navigation) to see entity-level reports, dashboards, and forecasts.
• Consolidated view: Click the organisation name (not a specific entity) to see combined data across all entities.

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

• Organisation Dashboard (replaces entity dashboards)
• Organisation Reports (consolidated Profit & Loss, Balance Sheet, Cash Flow)
• Organisation Validations (cross-entity checks)
• Organisation Adjusting Entries (manual eliminations that only affect consolidated reports)

Reporting structure for consolidation

The consolidated reports use a reporting structure defined at the organisation level. You can:

• Create a separate consolidated reporting structure that differs from entity-level structures.
• Or inherit a common structure from one of your entities.

Configure this from Organisation → Reporting Structure (only visible in consolidation mode).

Intercompany eliminations

To prevent double-counting, intercompany transactions need to be eliminated. For example:

• Entity A (parent) bills Entity B (subsidiary) for management fees.
• Entity A shows management fee revenue.
• Entity B shows management fee cost.
• In consolidated reports, both should cancel out.

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 — no separate General Ledger account configuration is required.

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

Consolidation Groups

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.

Creating a Consolidation Group

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

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 the same automatic zero balance correction as entity-level reports. When the organisation's Balance Sheet validation passes, 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 despite validations passing, check 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

If your entities operate in different currencies, consolidated reports show values in the organisation's base currency. Monitr applies exchange rates to convert entity-level values. Configure the base currency and exchange rates in organisation settings.