three people in business suits reviewing printed documents
Intercompany · Multi Entity · Hub

AI Agents for Multi Entity
Reconciliation

Entities rarely disagree about numbers. They disagree about definitions, and a mapped consolidation always balances anyway.

Key takeaways
  • Entities disagree about definitions rather than about figures, and a consolidation that maps mismatched definitions still balances.
  • Capitalisation thresholds, provision policy and recognition timing are set locally and are rarely aligned, which makes group comparisons unreliable.
  • Account mapping is built once and then decays silently, because nothing announces drift in a consolidation that always foots.
  • An unmapped new local account falls into a default line, producing a growing group balance with no explanation behind it.
  • Elimination failures cluster on transactions that are intercompany in substance and not flagged as such, which only a counterparty scan will find.

AI agents for multi entity reconciliation test whether entities are applying the same definition to the same mapped account, reconcile the mapping against the accounts actually in use, and scan third party ledgers for counterparties that are group entities. ChatFin checks the things a consolidation cannot check itself.

A consolidation always balances, which is the reason these problems persist. Mapping drift, definition differences and unflagged intercompany transactions all produce a group result that foots perfectly and cannot be explained at entity level. ChatFin tests the mapping and the definitions rather than only the totals.

Multi entityConsolidationAccount mappingEliminationsGroup reportingIntercompany accountingChart of accountsAI agents for finance
01

Entities do not disagree about numbers, they disagree about meaning

Multi entity reconciliation is usually described as making the figures agree. In practice the figures are fine and the definitions are not, and a consolidation that maps mismatched definitions produces a group result nobody can explain.

What differs by entityWhy it happensEffect at group
Local chart of accountsStatutory requirements differMapping absorbs the difference
Revenue recognition timingLocal practice or local GAAPGroup revenue moves periods
Capitalisation thresholdsSet locally, rarely alignedCost or asset, inconsistently
Provision policyLocal judgementGroup provisions are not comparable
Cost centre structureGrown organicallyGroup cost analysis is unreliable

None of that is an error at entity level and all of it distorts the group view. ChatFin tests whether entities are applying the same definition to the same account, rather than only whether the mapped totals foot.

In ChatFin

ChatFin tests whether entities apply the same definition to a mapped account, not just whether the mapped totals add up.

02

Mapping drift is silent and cumulative

The mapping from local accounts to group accounts is built once, usually carefully, and then decays. Nothing announces the decay because a mapped consolidation always balances.

A new local account with no mapping. It falls into a default or a suspense line, and the group sees a growing balance with no explanation.
An account remapped locally without telling group. Prior period comparatives silently stop being comparable.
An entity added without a full mapping review. Common in an acquisition, where speed beats completeness and nobody revisits it.
A group account retired but still mapped from. Balances arrive at an account that group reporting no longer uses.
Two local accounts mapping to one group account. Fine until somebody asks the group figure to be explained at entity level.

ChatFin reconciles the mapping itself against the accounts actually in use each period and reports what is unmapped, newly mapped or mapped to something retired.

three people in business suits reviewing printed documents
A mapped consolidation always balances, which is why drift goes unnoticed.
In ChatFin

ChatFin reconciles the mapping against the accounts actually in use each period, which is the check that catches drift before it reaches the group result.

03

Elimination completeness is a question nobody asks

Consolidation systems eliminate what they are told to eliminate. Whether that is everything which should be eliminated is a separate question and it is almost never tested.

TransactionShould it eliminateDoes it usually
Intercompany sales flagged as suchYesYes
Intercompany sales not flaggedYesNo, invisible
Profit in closing inventoryYesOnly if tracked
Intercompany dividendsYesUsually
Recharges booked as third partyYesNo, miscoded
A sale to a newly acquired entityFrom acquisition dateOften missed in year one

The failures cluster in the same place: transactions that are intercompany in substance and are not flagged as such. ChatFin identifies counterparties in the third party ledgers that are actually group entities, which is the only way an unflagged intercompany transaction is found.

In ChatFin

ChatFin scans third party ledgers for counterparties that are group entities, which is how an unflagged intercompany transaction is found at all.

04

Where this underperforms

Three.

There is no maintained entity register. Identifying group counterparties in a third party ledger needs a current list of entities and their trading names.
Local ledgers are not accessible. If group receives only a reporting pack, definition testing is impossible and only the mapped totals can be checked.
The group is two entities. Then this is a conversation rather than an analysis, and setting up tooling for it is not worth the time.
Start by reconciling the mapping against the accounts actually in use. It is read only, it runs in minutes, and unmapped accounts are the commonest cause of a group balance nobody can explain.

Deeper in multi entity reporting

The use cases this hub covers.

Worked on this page
Multi entity reconciliation

Covered as sections here
Definition alignment · Mapping drift · Elimination completeness · Unflagged intercompany

Questions group accountants ask first

If the consolidation balances, what is actually wrong?

Balancing is not the test. A consolidation maps local accounts to group accounts and adds them up, so it will balance whether or not the entities mean the same thing by an account. Different capitalisation thresholds, provision policies and recognition timing all survive that process untouched. ChatFin tests the definitions rather than the totals.

How does account mapping go wrong over time?

Quietly. A new local account is created and never mapped, so it lands in a default line. An account is remapped locally and comparatives stop being comparable. An acquired entity gets a fast mapping that is never revisited. ChatFin reconciles the mapping against the accounts actually in use each period and reports what is unmapped or newly mapped.

How do you find intercompany transactions that were never flagged?

By looking in the third party ledgers. A recharge booked as an external cost, or a sale to a newly acquired entity in the first year, is intercompany in substance and carries no flag. ChatFin scans counterparties against a current entity register, which is the only way those are found.

How ChatFin works on multi entity

Test the mapping, not the total.

ChatFin reconciles the account mapping against the accounts actually in use and reports what is unmapped, newly mapped or mapped to a retired group account.

It tests whether entities apply the same definition to a mapped account, and scans third party ledgers for group counterparties.

Bring your group mapping table and one period of entity ledgers.

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.
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 your group mapping table.

We will reconcile it through ChatFin against the accounts your entities actually used this period and show you what is falling into a default line.

✓Mapping reconciled to accounts in use
✓Definition differences tested, not just totals
✓Unflagged intercompany found by counterparty scan
Request a demo
Confidential & private