Consolidation Agent
Prepare group financial statements - automate capital, debt and expense elimination.
Checks reporting packages from subsidiaries, converts currencies, performs capital, debt and expense consolidation and calculates minority interests - with human decision for first-time consolidations.
Score Dashboard
What This Agent Does
Group consolidation is one of the most complex financial processes. Reporting packages from subsidiaries in different countries, currencies and sometimes different charts of accounts must be combined. Intercompany transactions must be eliminated, unrealised profits removed and minority interests calculated. For acquisitions, first-time consolidation with purchase price allocation and goodwill valuation is added.
The Decision Layer breaks consolidation into twelve decision steps. Routine steps like currency conversion, debt consolidation and expense elimination run rule-based. Strategic decisions like the consolidation scope and first-time consolidation for acquisitions remain with the human.
The result: mechanical consolidation steps are automated. Errors in currency conversion and IC elimination drop to near zero. And the consolidation report for the statutory auditor is a by-product of the process.
Micro-Decision Table
Determine consolidation scope Which entities are fully, proportionally or equity-consolidated? Human Auditor
Strategic decision, changes with participations
Decision Record
Challengeable: Yes - via manager, works council, or formal objection process.
Challengeable by: Auditor
Check reporting packages Are reporting packages from all subsidiaries complete? Rules Engine
Checklist check against mandatory fields
Decision Record
Challengeable: Yes - rule application verifiable. Objection possible for incorrect data or wrong rule version.
Chart of accounts mapping How are local accounts mapped to the group chart of accounts? Rules Engine Auditor
Standard mapping = R, new accounts = A
Decision Record
Challengeable: Yes - rule application verifiable. Objection possible for incorrect data or wrong rule version.
Challengeable by: Auditor
Currency conversion At which rate are balance sheet and P&L converted? Rules Engine
IAS 21 / HGB Paragraph 308a - closing rate for balance sheet, average rate for P&L
Decision Record
Challengeable: Yes - rule application verifiable. Objection possible for incorrect data or wrong rule version.
Capital consolidation Is the subsidiary's equity eliminated? Rules Engine Auditor
Deterministic for stable participation structure
Decision Record
Challengeable: Yes - rule application verifiable. Objection possible for incorrect data or wrong rule version.
Challengeable by: Auditor
Debt consolidation Are IC receivables and IC payables eliminated? Rules Engine
Offsetting entry of IC balances
Decision Record
Challengeable: Yes - rule application verifiable. Objection possible for incorrect data or wrong rule version.
Expense and income consolidation Are IC revenues and IC expenses eliminated? Rules Engine
Offsetting entry of IC transactions
Decision Record
Challengeable: Yes - rule application verifiable. Objection possible for incorrect data or wrong rule version.
Unrealised profit elimination Are unrealised intercompany profits eliminated? Human Auditor
Standard cases = R, valuation questions = H
Decision Record
Challengeable: Yes - via manager, works council, or formal objection process.
Challengeable by: Auditor
Calculate minority interests What share falls on minority shareholders? Rules Engine
Arithmetic calculation per participation quota
Decision Record
Challengeable: Yes - rule application verifiable. Objection possible for incorrect data or wrong rule version.
Record translation differences Are translation differences recognised in OCI? Rules Engine
IAS 21 - accumulated differences in equity
Decision Record
Challengeable: Yes - rule application verifiable. Objection possible for incorrect data or wrong rule version.
First-time consolidation for acquisition How is a newly acquired entity consolidated for the first time? Human Auditor
Purchase price allocation and goodwill valuation require human judgement
Decision Record
Challengeable: Yes - via manager, works council, or formal objection process.
Challengeable by: Auditor
Create consolidation report Is the report created and prepared? Rules Engine
Data = R, commentary = A
Decision Record
Challengeable: Yes - rule application verifiable. Objection possible for incorrect data or wrong rule version.
Decision Record and Right to Challenge
Every decision this agent makes or prepares is documented in a complete decision record. Affected parties (employees, suppliers, auditors) can review, understand, and challenge every individual decision.
Prerequisites
- Group consolidation system (SAP BPC, OneStream, LucaNet or equivalent)
- Standardised reporting package format for subsidiaries
- Group chart of accounts with mapping tables for local charts
- Access to closing and average exchange rates (ECB or equivalent)
Governance Notes
GoBD-relevant for tax consolidation. Commercial consolidation is subject to HGB Paragraph 290 ff. (obligation to prepare group financial statements) and HGB Paragraph 308a (currency conversion). IFRS consolidation follows IAS 21 and IFRS 10.
First-time consolidation for acquisitions requires purchase price allocation per IFRS 3 - this always remains with the human. Goodwill valuation and impairment tests are strategic discretionary decisions with significant balance sheet impact.
§203 StGB-relevant data is encrypted end-to-end and never passed to AI models in plain text.
Process Documentation Contribution
Infrastructure Contribution
The Consolidation Agent uses the Intercompany Agent infrastructure (IC reconciliation, elimination entries) and the Close Checklist Agent (orchestration). The chart of accounts mapping framework becomes the standard for all cross-entity reporting. The currency conversion engine is reused by treasury.
Builds Decision Logging and Audit Trail used by the Decision Layer for traceability and challengeability of every decision.
Related Agents
Reconciliation Agent
Reconcile subledgers against general ledger - continuously instead of at period-end.
Intercompany Agent
Match IC balances, clarify timing differences, prepare elimination entries.
Close Checklist Agent
Orchestrate the month-end close - check dependencies, monitor deadlines, create protocol.
Frequently Asked Questions
Can the agent perform IFRS and HGB consolidation in parallel?
Yes. The agent supports parallel accounting standards. Consolidation rules are configured per standard. Differences between HGB and IFRS are documented and shown in the reconciliation.
What happens with an acquisition mid-fiscal-year?
First-time consolidation requires human decisions: purchase price allocation, goodwill calculation, determining the first-time consolidation date. The agent prepares the data basis and performs the mechanical steps once the strategic decisions are made.
How are different fiscal years of subsidiaries handled?
When subsidiaries have different fiscal years, interim financial statements are prepared. The agent identifies the discrepancy and requests the corresponding reporting packages for the group reporting date.
Implement This Agent?
We assess your finance process landscape and show how this agent fits your infrastructure.