Subsidiary balances to group calculation

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

6 stages · 3 approvals

Roles and responsibilities

Consolidation Manager System 1 Review accountmappings ChartOfAccountsMapping 2 Open the close ConsolidationPeriods 3 Accept subsidiarybalances SubsidiaryTrialBalances 4 Review requiredrates FXRateRequirements 5 Translate acceptedinputs ConsolidationRuns 6 Build consolidatedresults ConsolidationRuns
  1. Step 1Review account mappings
    Mapping ReviewSubmitted
    Legal EntityLocal Account CodeConsolidation AccountEffective From
  2. Step 2Open the close
    Close CalendarOpen
    PeriodStatusStart DateEnd Date
    Pending TBs
  3. Step 3Accept subsidiary balances
    Trial Balances Awaiting AcceptanceSubmitted
    Submission NumberLegal EntityPeriodAs Of Date
  4. Step 4Review required rates
    Missing FX RatesMissing
    Requirement NumberFrom CurrencyRate TypeEffective Date
    Average Month
  5. Step 5Translate accepted inputs
    Translation Run HealthComplete
    Balance NumberLegal EntityConsolidation AccountLocal Amount
  6. Step 6Build consolidated results
    Consolidated Trial BalanceComplete
    Balance NumberConsolidation AccountTranslated Subtotal USDCTAAmount USD
Red diamonds require approval.Rows show responsibility for each step.

Process steps

Follow the process from start to finish. Select a step to see who acts and what changes.

Approval required

Review account mappings

Consolidation Manager: Independently approve nonoverlapping local-to-group mappings; unresolved accounts remain exceptions rather than silently receiving a suspense mapping.

Responsible
Consolidation Manager
Records
ChartOfAccountsMappingConsolidationCoA
Effect
Independently approve nonoverlapping local-to-group mappings; unresolved accounts remain exceptions rather than silently receiving a suspense mapping.

Open the close

Consolidation Manager: Create or idempotently receive the period from an authorised close integration. Record the reporting dates and revision. Neither an external period event nor an Admin setting certifies readiness.

Responsible
Consolidation Manager
Records
ConsolidationPeriodsConsolidationRuns
Effect
Create or idempotently receive the period from an authorised close integration.
Approval required

Accept subsidiary balances

Consolidation Manager: Independently accept a frozen submitted revision only after balance, source period, currency and mapping checks. Count distinct required entities with current Accepted submissions; Submitted and Imported do not satisfy readiness.

Responsible
Consolidation Manager
Records
SubsidiaryTrialBalancesTrialBalanceLines
Effect
Independently accept a frozen submitted revision only after balance, source period, currency and mapping checks.
Approval required

Review required rates

Consolidation Manager: Resolve each required rate and independently approve manual replacements. Freeze approved rate and rule versions at the accepted source-layer granularity; missing historical layers stop translation.

Responsible
Consolidation Manager
Records
FXRateRequirementsFXRatesFXTranslationRules
Effect
Resolve each required rate and independently approve manual replacements.

Translate accepted inputs

Consolidation Manager: Calculate atomically from the frozen source set. The closing CTA is the reviewed balancing amount; period movement equals closing less prior published opening. Repeated runs do not add the closing amount again.

Responsible
Consolidation Manager
Records
ConsolidationRunsTranslatedBalancesCumulativeTranslationAdjustment
Effect
Calculate atomically from the frozen source set.

Build consolidated results

Consolidation Manager: Build one result set from the same complete run. Include the closing translation adjustment, posted elimination history and its linked reversals, and approved balanced adjustment and allocation effects. Validate account totals, entity coverage and movement reconciliations before review.

Responsible
Consolidation Manager
Records
ConsolidationRunsConsolidatedTrialBalanceConsolidatedFinancials
Effect
Build one result set from the same complete run.
Approvals and controls

3 approvals required in this process

  • Review account mappings Consolidation Manager signs · open the close waitsChartOfAccountsMapping, ConsolidationCoA
  • Accept subsidiary balances Consolidation Manager signs · review required rates waitsSubsidiaryTrialBalances, TrialBalanceLines
  • Review required rates Consolidation Manager signs · translate accepted inputs waitsFXRateRequirements, FXRates, FXTranslationRules
  • Require independent decisions on the current prepared revision.
  • Keep source identitiesCommand keys stable through retries.
  • Preserve earlier accepted inputs and published outputs.
  • Treat missing evidenceUnknown integration outcomes as unresolved.

Validate the close population

The accepted submission count uses distinct entities in the frozen reporting population. A second file from one subsidiary does not replace a missing entity. Preserve the source-close identity, functional currency and account mapping evidence before acceptance. Unmapped lines remain exceptions even when the trial balance balances numerically.

Freeze the source and approved rate versions together when starting calculation. A replacement mapping or late ledger correction requires a new candidate and review. Partial calculation output must not become current merely because one entity finished successfully. Compare the replacement with the earlier run so reviewers can identify what changed.

Records and postings

StageRecordsEffect
1 Review account mappings ChartOfAccountsMappingConsolidationCoA Independently approve nonoverlapping local-to-group mappings; unresolved accounts remain exceptions rather than silently receiving a suspense mapping.
2 Open the close ConsolidationPeriodsConsolidationRuns Create or idempotently receive the period from an authorised close integration.
3 Accept subsidiary balances SubsidiaryTrialBalancesTrialBalanceLines Independently accept a frozen submitted revision only after balance, source period, currency and mapping checks.
4 Review required rates FXRateRequirementsFXRatesFXTranslationRules Resolve each required rate and independently approve manual replacements.
5 Translate accepted inputs ConsolidationRunsTranslatedBalancesCumulativeTranslationAdjustment Calculate atomically from the frozen source set.
6 Build consolidated results ConsolidationRunsConsolidatedTrialBalanceConsolidatedFinancials Build one result set from the same complete run.
Data model →

Process reports

All reports

Consolidated Trial Balance

Explain each group balance through translated inputs, the reviewed closing CTA effect, retained elimination and reversal history, supported allocation entries and approved top-sides.

Consolidated Income Statement

Compare reviewed period and cumulative group results with the approved parent and non-controlling allocation.

Consolidated Balance Sheet

Reconcile group assets, liabilities and equity at the selected published revision.

Consolidated Cash Flow Statement

Explain cash changes with reviewed operating, investing, financing, currency and non-cash movement evidence.

Statement of Equity and CTA Roll-Forward

Tie opening equity and translation adjustment through supported movements to the closing balances.

Per-Entity Translation Detail

Trace each source layer through its frozen approved rule, rate and reporting-currency amount.

Run by an agent

Agent support

Proto cannot override entity scope, approve its own preparation, invent missing accounting evidence or publish on an unreviewed calculation. Financial decisions remain with the authorised people.

Start now Download agent
# Example after configuration $ curl -fsSL https://www.erp.ai/skill.md | paste into your agent › subsidiary balances to group calculation · review account mappings on ChartOfAccountsMapping, ConsolidationCoA ⏸ approval · waiting for the consolidation manager # 5 more stages after approval: open the close, accept subsidiary balances, review required rates, translate accepted inputs, build consolidated results

Other processes

3 more

Reviewed results to publication

Turn the reviewed financial revision into a locked published pack and a controlled audit trail.

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

Customize Subsidiary balances to group calculation. With Proto, your desktop AI agent.

Ask Proto to help you customize Financial Consolidation.

Customize
Subsidiary balances to group calculation. Ask: “Review “Review account mappings”.” ProtoYour desktop AI agent
Download nowFree install · ~1 GB · AI usage extra