Uncategorized
July 7, 2026
Holding groups are not measured by a single company’s performance but by a consolidated one that reflects full economic control. When financial statements are aggregated manually in Excel, intercompany eliminations, currency translation, and non-controlling interests become chronic weaknesses. A consolidation-ready ERP builds an automated process under IFRS 10/11/12 that produces auditable group statements in days, not weeks. This guide sets out the scientific fundamentals of consolidation inside ERP, with reference to Tranquil’s multi-entity cloud solution.
What gets consolidated is not every entity the parent owns a stake in, but every entity it economically controls.
Power over the investee, exposure to variable returns, and the ability to affect those returns. All three are required for full consolidation.
Consolidated line-by-line (full consolidation), with non-controlling interest (NCI) shown separately in equity and income.
Treated using the equity method under IAS 28 — one line on the balance sheet, one line in income.
Below significant influence, measured at fair value under IFRS 9 without consolidation.
No consolidated statements without a unified chart of accounts and shared master data across entities.
Unified accounts at group level, allowing each company local sub-accounts that automatically roll up.
If an entity retains a different local COA, a mapping is defined from local to group — set once, applied always.
Customers, suppliers, items, cost centers — must be unified or linked by a shared identifier for correct comparison.
Any addition/change in the group COA passes central approval. Absent governance produces divergence that breaks consolidation.
Subsidiaries in different countries operate in different currencies, but group statements are issued in one presentation currency.
The currency of the primary economic environment for each entity. Determined per entity before consolidation begins.
The currency in which consolidated statements are presented (often SAR for Saudi groups).
Assets/liabilities at closing rate, income at period-average, equity at historical rate. The system applies them automatically.
Resulting differences flow to a separate equity account (OCI) without touching the income statement.
What happens inside the group must disappear from consolidated statements — no revenue or profit from oneself.
An invoice from Co. A to Co. B inside the group is eliminated: A’s revenue × B’s cost. The system auto-matches via a partner entity ID.
A’s receivable from B offsets B’s payable to A — any difference means a mismatch to be cleared before consolidation.
If A sold to B at a profit and the item is still in B’s inventory, the profit is eliminated on consolidation until sold outside the group.
Sale of an asset between sister companies at a profit is eliminated, and subsequent depreciation is adjusted to the group’s original cost base.
On consolidation, “investment in subsidiary” disappears from parent books and is replaced by the subsidiary’s actual assets and liabilities.
The excess of investment cost over the fair value of net assets acquired. Tested annually for impairment (IAS 36).
If the parent owns 80%, the remaining 20% belongs to non-controlling holders. Shown separately in equity.
Additional buys or partial disposals without loss of control are treated as equity transactions, not new acquisitions.
A disposal that reduces the stake below control creates a full gain/loss on disposal; the remainder is treated per equity method or IFRS 9.
Consolidation is not a year-end project; it is a disciplined monthly process producing group statements within the first 5 business days.
Every company closes by day 3. Parent starts consolidation on day 4. Statements ready on day 5.
Automatic in a unified ERP; in hybrid environments, via standard-format files with automated balance checks.
Group-level entries (not local books) to enforce unified policies not applied locally.
A dashboard shows any differences between sister-company claims. Consolidation does not close until they are all cleared.
The final deliverable is not just numbers; it is an integrated, auditable financial package.
All assets and liabilities after eliminations, with NCI prominently separated within equity.
Revenues and expenses after eliminations, with parent-share and NCI-share of net income shown separately.
Built by the indirect method from the consolidated income and balance-sheet, with acquisition and disposal adjustments.
Segment performance by operating segment or geography, on the same basis management uses in decisions.
Producing statements is not enough; the process itself must be measured.
From day zero to consolidated statements. Leaders finish in 5-7 days; laggards in 20+.
The higher it is, the higher the error rate. Automation should cover over 90% of recurring entries.
Differences not cleared before close — a direct indicator of cross-entity governance quality.
An outside indicator of consolidation quality. Repeated findings year after year signal a crisis.
A group that consolidates in Excel loses a week every month and risks errors that fail audit. A unified multi-entity ERP turns consolidation from a project into an automated, transparent process — freeing finance to focus on real value-adding work. To explore a structural solution, see Tranquil Cloud and the full ERP modules via the official site.
