All applications583

Find your application

583 applications

Open full catalog

Browse applications by category or open the full catalog.

  1. Financial Consolidation
  2. Features
  3. Intercompany reconciliation
Feature · Intercompany reconciliation

Intercompany reconciliation

Match both sides of intercompany activity and retain an explanation for every difference.

OverviewPending Eliminations
Financial Consolidation · Intercompany reconciliation

Pending Eliminations

Elimination approval waits for the consolidation manager or group controller / corporate cfo

New
Elimination numberElimination typeFrom entityTo entityTotal debit USDTotal credit USD
ELM-87153ICAR-APAlder Pacific Operations LLCAlder Group Holdings LLC940940
ELM-91610IC revenue expenseAlder Treasury LLCAlder Canada Ltd190190
ELM-26296Investment-EquityAlder Group Holdings LLCAlder Group Holdings LLC960960
ELM-27896Intra group profitAlder Property LLCAlder Europe Ltd590590
ELM-81633IC loan interestAlder Property LLCAlder Canada Ltd730730
6 of 6 records
Alder Pacific Operations LLCEliminations · ELM-87153
ICAR-AP
To entityAlder Group Holdings LLC
Total debit USD940
Total credit USD940
Balance check0
Prepared byLina Haddad
Example screen with sample data

What you can do

Identify both sides of the activity

Capture the reporting entity, counterparty, period, account pair, currency and stable source document identity. Normalise entity direction when pairing reciprocal records so the same invoice does not become two independent matches. Similar totals or a shared counterparty name are insufficient to establish a match.

Each source balance belongs to one active reconciliation allocation within the close run. If several source documents are aggregated, retain their identities and amounts in the reconciliation evidence. A repeated inbound event or a second worker must not consume the same source side twice or produce another elimination for an already matched event.

Investigate the difference

The comparison preserves both reported sides and their signed reporting-currency amounts. Timing, missing entries, classifications and FX differences remain distinct reasons. Each Subsidiary Controller can see and respond to their side of a shared dispute without receiving general access to the other entity’s books.

A tolerance determines which discrepancies can follow the configured exception route. It does not turn unequal amounts into a balanced journal. A within-tolerance difference still needs an approved disposition and, where necessary, a separate balanced adjustment. An unexplained difference remains unresolved even if the display rounds it to zero.

Prepare balanced elimination entries

The matcher prepares elimination candidates linked to the reconciled source identities and selected calculation run. The proposal retains debit and credit lines in USD and the underlying account mapping. It affects the group consolidation layer; it does not send a journal back to either subsidiary ledger.

The Consolidation Manager independently reviews an analyst-prepared elimination revision. A manual entry prepared by the manager requires a different Group Controller / Corporate CFO as reviewer. Posted elimination lines are immutable, and a correction uses a linked reversal followed by a reviewed replacement. A change to the underlying reconciliation invalidates an unposted approval.

Separate ordinary matches from accounting workpapers

Investment and equity eliminations, intra-group profit and acquisition adjustments require the applicable approved workpaper. An ownership percentage alone cannot supply acquisition values, fair-value adjustments or a universal elimination formula. Retain the method and supporting evidence before bringing the candidate into the group result.

For an ordinary reciprocal receivable and payable, the accepted elimination removes the supported paired balances. If one side is absent, the software must not invent a matching posting. The team either obtains the missing source entry or records the authorised correction and explanation through the proper ledger or consolidation path.

Reconcile the final group effect

The consolidated trial balance includes the posted elimination history belonging to its chosen run. A reversed original and its posted opposite both remain in that history, giving a net zero effect when fully reversed; omitting only the original would create a false balance. Every debit and credit should trace back to a match or approved workpaper. Closed differences, overrides and reversals retain the actor, reason and earlier evidence. The report can show the amount removed from the group without presenting an override as agreement between the subsidiary ledgers. Publishing remains blocked while a required material exception lacks an approved resolution.

What your team sees

  • Unmatched IC Transactions — Review the work and supporting records for this module.

What it keeps track of

Data model
Intercompany transactions
IC AR / IC AP, IC sales / IC purchases, IC loans, IC interest, IC management fees — every transaction between two entities in the consolidated group. Reported by both sides; the matcher pairs them.
IC reconciliation
Match status of an IC pair. One row per (from entity, to entity, IC type, account pair, Period). Generated by intercompany-match-and-eliminate.
IC disputes
A retained difference between reciprocal source balances. An independently approved disposition may resolve the work item, but cannot fabricate a match or permit an unbalanced elimination.
Eliminations
Auto-generated (and occasionally manual) elimination journal entries that remove intercompany balances and the parent’s investment-in-sub against the sub’s equity. One header per elimination event; lines in EliminationLines.
Elimination lines
One Dr / Cr line per ConsolidationCoA target on an elimination JE. Always in USD (post-translation).
Consolidation runs
Immutable input snapshot and atomic output candidate for a financial revision.

Who uses it

Permissions
Subsidiary Controller
Supplies their entity’s side.
Consolidation Analyst
Investigates differences.
Consolidation Manager
Independently reviews elimination proposals.

Set up Financial Consolidation your way.

Start free, then use Proto to change fields, steps and approvals before your team goes live.

How to get started

A personal agent for your business

Get started with Proto

Your app is selected. Download Proto, then open it with this context.

Selected appFinancial Consolidation

Choose your computer’s platform.

Download Proto

Install Proto, then return to this panel.

Already installed? Open Proto

Free to use. Your own model provider may charge for usage.