three people in business suits reviewing printed documents
Function · Financial Consolidation · Pillar

AI for Financial
Consolidation

A translation reserve you cannot decompose is a plug with a respectable name.

Key takeaways
  • Consolidation decides what the group owns and earns. Reporting presents it. Get the first wrong and the second is a well presented wrong number.
  • Translation runs on three rate bases, and the historical rate for equity needs a schedule that most groups never kept.
  • A cumulative translation reserve derived as the residual is a plug. Built from its components it can be explained line by line.
  • Consolidation follows control, not ownership percentage. The entities that get it wrong are the ones where the shareholding was checked and the agreements were not.
  • Non controlling interest through a chain is effective interest, not the top level percentage. Eighty percent of seventy is fifty six, so the minority is forty four.

AI agents for financial consolidation work the accounting, not the presentation. ChatFin holds the rate basis per line class and per entity so the cumulative translation reserve is built from its components, computes effective interest through the whole ownership chain, and classifies what is left after elimination before it is posted.

That is a different job from reporting and it has a different owner. ChatFin surfaces the entities where holding percentage and accounting treatment disagree for the group controller to review, and leaves the control judgement with the person who signs it.

Financial consolidationGroup reportingCurrency translationNon controlling interestIFRS 10ASC 810EliminationsAI agents for finance
01

Consolidation is an accounting process, reporting is its output

These two get bought together and run by different people. Consolidation decides what the group actually owns and earns. Reporting presents it. ChatFin separates them because the failure modes have nothing in common.

QuestionConsolidation or reportingWho owns it
Do we control this entityConsolidationGroup controller
At what rate does this translateConsolidationGroup controller
What is the minority shareConsolidationGroup controller
Which eliminations remainConsolidationGroup controller
How does the board see thisReportingFP&A
What is the commentaryReportingFP&A

Get the first four wrong and the fifth and sixth are a beautifully presented wrong number. ChatFin works the accounting first and treats presentation as a separate job, covered on AI for financial reporting.

In ChatFin

ChatFin treats consolidation as accounting and reporting as presentation, because a translation error is not a formatting problem and cannot be fixed downstream.

02

Translation fails on the rate, and the rate is three rates

Every group accountant knows a balance sheet translates at closing and a profit and loss at average. What breaks the consolidation is the third case, equity, which translates at historical rate and therefore needs a history nobody kept.

Closing rate for assets and liabilities. Straightforward, and the only one most systems get right without help.
Average rate for income and expense. Which average, over which period, weighted how. A simple average and a transaction weighted average diverge in a volatile month and both are defensible.
Historical rate for equity and share capital. The rate on the day each tranche was contributed, years ago, which means the schedule has to exist. Where it does not, the balance is plugged and the plug is called a translation reserve.
Whatever rate the goodwill was recognised at. Goodwill is an asset of the subsidiary and retranslates, which surprises people every year.
The rate that closed the intercompany loan. A monetary item between two entities revalues on both sides and the difference belongs in the group result, not in the translation reserve.

ChatFin holds the rate basis per line class and per entity, so the cumulative translation reserve can be built up from its parts rather than derived as the number that makes the balance sheet balance. A translation reserve you cannot decompose is a plug with a respectable name.

a stock ticker board of green and red numbers
Three rate bases, and the historical one needs a schedule nobody kept.
In ChatFin

ChatFin builds the cumulative translation reserve from its components rather than as the residual, so it can be explained line by line.

03

The control test decides who consolidates, and it is a judgement

Under IFRS 10 and ASC 810 consolidation follows control, not ownership percentage. That distinction is where group structures get it wrong, usually at the edges, and usually because the shareholding was checked and the agreements were not.

HoldingWhat people assumeWhat decides it
Over 50 percentConsolidateUsually right, not always
Exactly 50 percentEquity accountThe shareholder agreement
Under 50 percentEquity accountWhether you direct the activities
Under 20 percentInvestmentBoard seats and veto rights
A structured entityNothing to consolidateExposure to variable returns

ChatFin does not make that determination. It surfaces the entities where the holding percentage and the accounting treatment disagree, and where an agreement or a board composition changed in the period, so the group controller reviews a short list rather than a register. The judgement stays with the person who signs.

Ask for every entity between 20 and 50 percent and what changed in its governance this year. That list is usually shorter than expected and rarely reviewed annually.
04

Non controlling interest is where the arithmetic quietly stops working

Minority interest is simple in a two entity group and stops being simple the moment there is a chain. ChatFin sees the same four errors across estates of every size.

1

Indirect holdings

A parent holds 80 percent of A which holds 70 percent of B. The effective interest in B is 56 percent and the non controlling interest is 44, not 30. Chains get computed by hand and hands make errors.

2

Changes in the period

A stake bought mid year splits the result before and after. Consolidating the full year and adjusting afterwards produces a different number from consolidating two stubs.

3

Losses beyond the interest

Under both standards losses are allocated to non controlling interest even when it goes negative. Systems often stop at zero, which quietly moves the loss to the parent.

4

Elimination against the wrong share

An intercompany profit eliminated fully against the parent when part of it belongs to the minority. Small, systematic, and it accumulates in retained earnings.

ChatFin computes effective interest through the whole chain, splits the period on any change in holding, and shows the non controlling share of each elimination rather than netting it into one figure.

In ChatFin

ChatFin computes effective interest through the ownership chain rather than multiplying at the top, which is where indirect holdings go wrong.

05

What is left after elimination is the real question

Consolidation systems report that eliminations ran. What matters is what did not eliminate and why, which is the same pair matching problem the intercompany function solves, arriving one level up.

ResidualWhat it actually isWhere it should go
Timing differenceTwo correct entries, one month apartNowhere, it reverses
Rate differenceOne relationship, two rate basesGroup result or reserve
Unrealised profit in stockReal, and it must be eliminatedAgainst inventory
A genuine disputeTwo entities disagreeTo the two entities
An omissionOne side never postedTo the entity that missed it

Only the third belongs in the consolidation adjustment. The other four are somebody's work and get treated as a consolidation problem because that is where they surface. ChatFin classifies the residual before it is posted, using the same five way split described on AI for intercompany accounting.

Take last year's consolidation adjustments and ask how many were unrealised profit. If it is under half, the rest were other people's errors absorbed at group.
06

Where this underperforms

Three, and the first is deliberate.

It does not determine control. Whether an entity is controlled is a judgement made against agreements, and ChatFin surfaces the cases worth reviewing rather than deciding them.
Historical rates cannot be invented. Where equity tranches were never dated and rated, the translation reserve cannot be decomposed retrospectively. It can be held correctly from now on, which is worth doing and is not a fix for the past.
A consolidation tool is not replaced. If you run a dedicated consolidation system it stays the book of record. ChatFin reconciles to it and reports where the two disagree rather than substituting for it.
Start with the composition of your cumulative translation reserve and the residual after elimination. Both are read only, both come out of one close, and both tend to contain something nobody has looked at in years.

Across the consolidation cluster

Where each part of the work sits.

Hubs under this pillar
Entity submission and group close · Consolidation and elimination automation · Multi currency accounting

Covered as sections here
Currency translation at three rate bases · Cumulative translation reserve · The IFRS 10 and ASC 810 control test · Non controlling interest through a chain · Elimination residuals

Neighbouring functions
Intercompany accounting · Financial reporting · Month end close

Questions group controllers ask

Why separate consolidation from financial reporting?

Because they are different processes with different owners. Consolidation determines what the group controls, at what rates it translates and what share belongs to minorities, and the group controller owns it. Reporting presents the result and FP&A owns it. A translation error is not a presentation problem and cannot be fixed downstream.

What is actually inside our translation reserve?

On most estates, nobody can say. The reserve is frequently derived as the figure that makes the translated balance sheet balance, which makes it a plug. ChatFin holds the rate basis per line class and per entity so the reserve is built up from closing, average and historical rate movements and can be decomposed.

Does ChatFin decide whether we control an entity?

No. Control under IFRS 10 and ASC 810 is a judgement made against shareholder agreements, board composition and veto rights. ChatFin surfaces the entities where the holding percentage and the accounting treatment disagree, and where governance changed in the period, so the review list is short and the decision stays with the group controller.

Why is our minority interest wrong in a chain?

Because the top level percentage gets used instead of the effective interest. A parent holding eighty percent of A, which holds seventy percent of B, has a fifty six percent effective interest in B and a forty four percent minority, not thirty. ChatFin computes through the chain and splits the period on any change in holding.

How ChatFin works on consolidation

Build the reserve from its parts, classify the residual.

ChatFin holds the rate basis per line class and per entity, so the cumulative translation reserve is decomposable rather than derived as a balancing figure.

It computes effective interest through the ownership chain and classifies each elimination residual before it is posted, so only unrealised profit lands as a consolidation adjustment.

Bring last year's consolidation adjustments.

Book a demo
AM
Ashok Manthena
CEO and co founder, ChatFin

Ashok Manthena is the CEO and co founder of ChatFin, an AI agent platform for enterprise finance that runs across NetSuite, Acumatica, JD Edwards, SAP and Dynamics 365. He works with CFOs and controllers on governed automation of the close, payables, receivables and reporting. Connect on LinkedIn.

Image credits. Header photograph: three people in business suits reviewing printed documents, sourced from Pexels and used under the Pexels licence.
Section photograph: a stock ticker board of green and red numbers, sourced from Pexels and used under the Pexels licence.
All images are served from the Pexels content network. No third party product screenshots, vendor logos or licensed media are used on this page.
Get started

Bring last year's consolidation adjustments.

We will run them through ChatFin and show you how many were unrealised profit and how many were somebody else's error absorbed at group.

✓Rate basis held per line class and entity
✓Translation reserve decomposed, not plugged
✓Effective interest computed through the chain
✓Elimination residuals classified before posting
Request a demo
Confidential & private