Skip to main content Enter
ERP.AI Financial Consolidation

Financial Consolidation

Start now
Pricing Questions about Financial Consolidation Get started
Build with Proto

Modules

Entity and ownership managementKeep the reporting group, ownership changes and account mappings ready for the next close. Trial balance collectionCollect complete subsidiary balances and resolve exceptions before group calculation. Currency translationTranslate accepted balances using reviewed rates and explain the currency movement.
Intercompany reconciliationMatch both sides of intercompany activity and retain an explanation for every difference. Group adjustments and reportingReview group-only adjustments and build statements with a traceable financial basis. Close publication and auditPublish the reviewed close and give each reader the evidence they are allowed to see.

Financial Consolidation

Start now
Pricing Questions about Financial Consolidation Get started
Build with Proto

Processes

Subsidiary balances to group calculationBring accepted subsidiary balances and approved translation inputs into one complete group calculation. Intercompany difference to eliminationResolve reciprocal source differences before posting a balanced consolidation-layer elimination.
Ownership change to group reportingCarry the approved effective ownership basis into translated, allocated group results. Reviewed results to publicationTurn the reviewed financial revision into a locked published pack and a controlled audit trail.

Financial Consolidation

Start now
Pricing Questions about Financial Consolidation Get started
Build with Proto

Industries

Multi-entity corporate groupsCorporate finance teams collecting results from separately maintained subsidiary ledgers. Groups with foreign subsidiariesUSD-reporting groups reconciling accepted balances from entities with other functional currencies.
Acquisitive business groupsGroup controllers adding businesses while preserving the evidence behind ownership and reporting changes.

Financial Consolidation

Start now
Pricing Questions about Financial Consolidation Get started
Build with Proto

Reference

Roles and permissionsGive each close participant the access and decisions their work requires. Consolidation reportsExplain the group result and the source evidence behind it. Data modelFollow accepted source balances through the selected calculation and published financial revision.
IntegrationsConnect subsidiary ledgers, reviewed rate inputs and published financial artifacts. ImplementationConfigure one reconciled corporate close before extending the rollout. Use Proto with Financial ConsolidationUse Proto to configure the close and investigate its evidence within your authority.

Financial Consolidation

Start now
Pricing Questions about Financial Consolidation Get started
Build with Proto
All systems
Modules
Entity and ownership managementKeep the reporting group, ownership changes and account mappings ready for the next close.Trial balance collectionCollect complete subsidiary balances and resolve exceptions before group calculation.Currency translationTranslate accepted balances using reviewed rates and explain the currency movement.Intercompany reconciliationMatch both sides of intercompany activity and retain an explanation for every difference.Group adjustments and reportingReview group-only adjustments and build statements with a traceable financial basis.Close publication and auditPublish the reviewed close and give each reader the evidence they are allowed to see.
Processes
Subsidiary balances to group calculationBring accepted subsidiary balances and approved translation inputs into one complete group calculation.Intercompany difference to eliminationResolve reciprocal source differences before posting a balanced consolidation-layer elimination.Ownership change to group reportingCarry the approved effective ownership basis into translated, allocated group results.Reviewed results to publicationTurn the reviewed financial revision into a locked published pack and a controlled audit trail.
Industries
Multi-entity corporate groupsCorporate finance teams collecting results from separately maintained subsidiary ledgers.Groups with foreign subsidiariesUSD-reporting groups reconciling accepted balances from entities with other functional currencies.Acquisitive business groupsGroup controllers adding businesses while preserving the evidence behind ownership and reporting changes.
Reference
Roles and permissionsGive each close participant the access and decisions their work requires.Consolidation reportsExplain the group result and the source evidence behind it.Data modelFollow accepted source balances through the selected calculation and published financial revision.IntegrationsConnect subsidiary ledgers, reviewed rate inputs and published financial artifacts.ImplementationConfigure one reconciled corporate close before extending the rollout.Use Proto with Financial ConsolidationUse Proto to configure the close and investigate its evidence within your authority.
Sign in
Sign in Start now
Financial Consolidation Modules
Intercompany reconciliation4 of 6
  • Entity and ownership management1 of 6
  • Trial balance collection2 of 6
  • Currency translation3 of 6
  • Intercompany reconciliation4 of 6
  • Group adjustments and reporting5 of 6
  • Close publication and audit6 of 6

Intercompany reconciliation

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

Unmatched IC TransactionsICReconciliation
Entity and ownership managementTrial balance collectionCurrency translationIntercompany reconciliationGroup adjustments and reportingClose publication and audit
StatusUnmatchedDisputedWithinTolerance
Unmatched
ICR-81346LE-9539700 difference
ICR-32674LE-3558140 difference
Disputed
ICR-56551LE-3246540 difference
ICR-55640LE-5709650 difference
WithinTolerance
ICR-49828LE-3211120 difference
ICR-44131LE-640130 difference
Records in this module
  • IntercompanyTransactions
  • ICReconciliation
  • ICDisputes
  • Eliminations
  • EliminationLines
  • ConsolidationRuns

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.

Modules

  • Ownership Change ReviewSubmitted
    Change NumberParentSubsidiaryEffective Date

    Entity and ownership management

    Keep the reporting group, ownership changes and account mappings ready for the next close.

  • Trial Balances Awaiting AcceptanceSubmitted
    Submission NumberLegal EntityPeriodAs Of Date

    Trial balance collection

    Collect complete subsidiary balances and resolve exceptions before group calculation.

  • Translation Run HealthComplete
    Balance NumberLegal EntityConsolidation AccountLocal Amount

    Currency translation

    Translate accepted balances using reviewed rates and explain the currency movement.

  • Unmatched IC TransactionsUnmatched
    Reconciliation NumberFrom EntityTo EntityDifference

    Intercompany reconciliation

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

  • Pending Top-Side ApprovalsSubmitted
    Adjustment NumberPeriodConsolidation AccountOffset Account

    Group adjustments and reporting

    Review group-only adjustments and build statements with a traceable financial basis.

  • Published FinancialsPublished
    Statement NumberPeriodStatement TypeReporting Currency
    Balance Sheet

    Close publication and audit

    Publish the reviewed close and give each reader the evidence they are allowed to see.

Reports

All reports

Intercompany Reconciliation Summary

Identify reciprocal balances, remaining differences and the reviewed elimination or exception disposition.

Unmatched IC TransactionsICReconciliation
StatusUnmatchedDisputedWithinTolerance
Unmatched
ICR-81346LE-9539700 difference
ICR-32674LE-3558140 difference
Disputed
ICR-56551LE-3246540 difference
ICR-55640LE-5709650 difference
WithinTolerance
ICR-49828LE-3211120 difference
ICR-44131LE-640130 difference

Roles and permissions

Group Controller / Corporate CFO

Review all authorised group financial records.

Permissions and records
  • Review all authorised group financial records
  • Independently approve OwnershipChanges, TopSideAdjustments, MinorityInterest workpapers, ConsolidationMovements and Disclosures
  • Sign and publish ConsolidatedFinancials
  • Authorise a reasoned new restatement revision
  • Eliminations
Ownership Change ReviewOwnershipChanges
Submitted
  • OC-53074 LE-3682 94 5 d
  • OC-34820 LE-2847 93 in 8 d
  • OC-88775 LE-6736 81 12 d
  • OC-58703 LE-7755 77 in 3 d
  • OC-80852 LE-7677 77 in 4 d
OC-53074
Parent
LE-3682
Subsidiary
LE-8713
EffectiveDate
12 Sep
OwnershipPctBefore
94
OwnershipPctAfter
97

Approval conditions.

Consolidation Manager

Manage ConsolidationPeriods and run preparation.

Permissions and records
  • Manage ConsolidationPeriods and run preparation
  • Independently approve ChartOfAccountsMapping and reviewed FXRates
  • Accept or reject SubsidiaryTrialBalances
  • Prepare manual Eliminations and independently approve analyst-prepared Eliminations
  • Eliminations
Trial Balances Awaiting AcceptanceSubsidiaryTrialBalances
Submitted
  • STB-65330 LE-5196 0 2 d
  • STB-50317 LE-4447 0 3 d
  • STB-46310 LE-1481 0 in 2 d
  • STB-61561 LE-3482 0 8 d
  • STB-70688 LE-5954 0 8 d
STB-65330
LegalEntity
LE-5196
Period
CP-1734
AsOfDate
15 Sep
TotalDebits
90
TotalCredits
90

Approval waits for the consolidation manager.

Consolidation Analyst

Prepare imported SubsidiaryTrialBalances and draft TrialBalanceLines.

Permissions and records
  • Prepare imported SubsidiaryTrialBalances and draft TrialBalanceLines
  • Prepare FXRates, IntercompanyTransactions, Eliminations, TopSideAdjustments, ConsolidationMovements and Disclosures
  • Investigate exceptions and view authorised group working reports
  • No acceptance, independent approval, publication or unrestricted source-ledger access
  • IntercompanyTransactions
  • Eliminations
Missing FX RatesFXRateRequirements
StatusMissingPendingReview
Missing
FR-78612FC-275
FR-46454FC-219
FR-16690FC-682
PendingReview
FR-56629FC-129
FR-49355FC-610
FR-25129FC-346
Subsidiary Controller

Manage own LegalEntity draft SubsidiaryTrialBalances and TrialBalanceLines.

Permissions and records
  • Manage own LegalEntity draft SubsidiaryTrialBalances and TrialBalanceLines
  • Submit own validated trial balance
  • Propose own ChartOfAccountsMapping and IntercompanyTransactions
  • Respond to ICDisputes involving own entity
  • IntercompanyTransactions
  • ICDisputes
Open IC DisputesICDisputes
StatusOpenInReview
Open
ICD-60132LE-8484470 difference usd
ICD-46108LE-6081100 difference usd
ICD-78283LE-9293950 difference usd
InReview
ICD-72499LE-8682840 difference usd
ICD-62860LE-5605170 difference usd
ICD-14793LE-8308300 difference usd

Related processes

Mapping ReviewSubmitted
Legal EntityLocal Account CodeConsolidation AccountEffective From

Subsidiary balances to group calculation

Bring accepted subsidiary balances and approved translation inputs into one complete group calculation.

6 stages · 3 approvals

Trial Balances Awaiting AcceptanceSubmitted
Submission NumberLegal EntityPeriodAs Of Date

Intercompany difference to elimination

Resolve reciprocal source differences before posting a balanced consolidation-layer elimination.

3 stages · 2 approvals

Ownership Change ReviewSubmitted
Change NumberParentSubsidiaryEffective Date

Ownership change to group reporting

Carry the approved effective ownership basis into translated, allocated group results.

4 stages · 2 approvals

ERP•AI workspace

Start now Financial Consolidation

Create your ERP.AI account and get started with Proto.

Start now Download agent
Previous · module 3 of 6Currency translationNext · module 5 of 6Group adjustments and reporting

Customize Intercompany reconciliation. With Proto, your desktop AI agent.

Ask Proto to help you customize Financial Consolidation.

Customize
Intercompany reconciliation.
Ask: “Review IntercompanyTransactions fields.”
ProtoYour desktop AI agent
Download nowFree install · ~1 GB · AI usage extra
macOSWindowsLinux

Bring your first idea to Proto.

Keep this page open while you install Proto. Connect your account and model, then paste this into a new chat.

AI usage is paid separately. You can edit the prompt before copying.

ERP.AI

Business apps and the Proto desktop agent.

  • Business Apps
  • Proto
  • Workflows
  • Headless SaaS
  • Enterprise
  • Pricing
  • Contact
  • Terms of Service
  • Privacy Policy
  • Cookie Policy
© 2026 ERP•AI. All rights reserved.
System status

Your Privacy, Your Choice

We use essential cookies to run the site and optional cookies for features, analytics, and relevant content. See Cookie policy

Manage Your Cookie Preferences

We use cookies to enhance your experience, analyze site traffic, and serve relevant content. By clicking "Accept All," you agree to our use of cookies. You can customize your preferences at any time.

Learn more about how we use cookies

These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.

These cookies enable additional features that enhance your experience, such as live chat, video playback, personalized content recommendations, and remembering user preferences.

These cookies help us understand how visitors interact with our site by collecting anonymous usage data. This allows us to measure performance, detect issues, and continuously improve the user experience.

These cookies allow us and advertising partners, including X, to deliver ads tailored to your interests. They track browsing habits across sites to provide relevant advertising and measure ad effectiveness.