Accountants usually master Excel and the use of formulas. The main way to validate a calculation like consolidation is to rebuild it in Excel. But there’s only so far you can go before replicating what a consolidation system does gets overly complex.

You’re finalizing the monthly consolidation. You export each subsidiary’s trial balance, sum them up, and compare to the parent’s consolidated report. The numbers don’t match — and you’ve already checked eliminations. The discrepancy isn’t necessarily an error.

Proportionalization and ownership management determine what gets consolidated and how much of it. This is the setup that runs before eliminations even start. Get this wrong, and every downstream calculation — intercompany eliminations, NCI, equity pickup — inherits the error.

The Logic Flow (Accountant’s View)

The Accounting Problem

IFRS 10 defines control as the basis for consolidation. If you control an entity, you consolidate 100% of it. But “control” isn’t always 100% ownership.

This is Pillar 2-3 of the FCCS Consolidation: The Eleven Pillars series. If you haven’t read Pillar 1: Currency Translation, start there — proportionalization runs after translation.

Parent Co owns three entities with different treatments:

Note on thresholds: The 20% and 50% thresholds are rebuttable presumptions, not absolute rules. Significant influence can exist below 20% (e.g., board representation, contractual rights) or be rebutted above 50% (e.g., passive investor with no voting rights). IAS 28.6 requires assessment of facts and circumstances, not just ownership percentage.

flowchart TD
    Start["Assess entity relationship"] --> Q1{Control >50%?}
    Q1 -->|Yes| Sub[Subsidiary method
100% consolidation + NCI]
    Q1 -->|No| Q2{Shared control?}
    Q2 -->|Yes| Q3{Rights to assets & liabilities directly?}
    Q3 -->|Yes| Prop[Proportional method
Line-by-line at ownership %]
    Q3 -->|No, shared control of entity| JV[Equity method
Single-line investment]
    Q2 -->|No| Q4{Significant influence?
Presumed 20-50%}
    Q4 -->|Yes| Equ[Equity method
Single-line investment]
    Q4 -->|No| NC[Not consolidated
Cost or fair value]

The Proportional Method Exception

Critical distinction: IFRS 11 (issued 2011) eliminated proportional consolidation for joint ventures. Joint ventures must use equity method. Proportional consolidation only applies to joint operations — a different classification.

Joint Operation vs. Joint Venture:

When does proportional consolidation apply?

IFRS 11 reserves proportional consolidation for joint operations — arrangements where parties have rights to assets and obligations for liabilities directly, not through an entity. Typical examples:

• Oil & gas joint ventures (undivided interests)
• Construction projects with direct asset ownership
• Real estate co-ownership

Entity D as a joint operation:

Parent Co and Partner Co share 50/50 ownership of a construction project with direct rights to assets and obligations for liabilities.

Each line item is multiplied by ownership percentage. No single-line investment. No NCI. The parent shows its share of each asset, liability, revenue, and expense.

What about joint ventures (the common case)?

If Entity D is a joint venture (shared control of a legal entity), IFRS 11 requires equity method — not proportional consolidation. The same economics, but presented as a single-line investment.

US GAAP nuance: Under ASC 810-10-45-14, proportionate consolidation is permitted for undivided interests and unincorporated entities in extractive industries (oil & gas, mining) and construction — but not for corporate joint ventures.

FCCS configuration note: FCCS doesn’t automatically classify entities. You must determine whether an arrangement is a joint operation (proportional) or joint venture (equity) based on the contractual structure, then set the consolidation method accordingly.

Where Equity Method Entities Live

Equity method entities don’t appear in the consolidated balance sheet line-by-line. FCCS holds them at the Contribution level as a single-line investment, with two system members tracking the balance:

The investment balance rolls forward through FCCS_Mvmts_Substantial_Investment (parent’s share of investee’s equity) and FCCS_Mvmts_Income_Substantial_Investment (parent’s share of investee’s P&L). These are the only members where equity method entities appear in the consolidation output.

Practical implication: When you run a Smart View query across Entity Input → Proportion → Contribution, equity method entities show zeros at Proportion and a single value at Contribution. This is expected, not a missing entity.

Now that we’ve covered the accounting logic, let’s see how FCCS implements it behind the scenes.

The Engine Room (Technical View)

Sequence: Where Proportionalization Fits

Proportionalization runs after currency translation, before eliminations:

1

Local Currency → Translated → Proportion → Elimination → Contribution

This sequence matters because ownership % applies to translated amounts, not local currency amounts.

Consolidation Dimension Members

FCCS uses the Consolidation dimension to track each step:

Key distinction: For subsidiary method, Proportion shows 100% (the ownership % is applied later via NCI calculation — see Pillar 6). For proportional method, Proportion shows the ownership percentage applied directly.

flowchart LR
    A[Entity Input] --> B[Proportion]
    B --> C[Elimination]
    C --> D[Contribution]

Where Ownership Lives

Ownership Management settings:

Movement tracking:

When ownership changes mid-year:

• FCCS_Mvmts_Acquisitions — increases in ownership %
• FCCS_Mvmts_Disposals — decreases in ownership %

These movement accounts tell FCCS to recalculate proportionalization from the change date forward.

Configuration Checklist

Before running consolidation, verify:

1. Consolidation method is set for each entity

   • Entity → Consolidation Method = Subsidiary | Proportional | Equity | Not Consolidated | Inactive

2. Ownership percentage is set for each entity

   • Entity → Ownership % = numeric value (0-100)

3. Holding company is flagged

   • Parent entity → Holding = Yes
   • Subsidiaries → Holding = No (or Yes if they have their own subsidiaries)

4. Movement accounts configured (if ownership changes mid-year)

   • FCCS_Mvmts_Acquisitions for increases
   • FCCS_Mvmts_Disposals for decreases

Multi-Level Hierarchies

For single-level structures, proportionalization is straightforward. Parent owns 80% of Sub B → Proportion shows 80% (proportional method) or 100% (subsidiary method).

Multi-level hierarchies calculate cumulative ownership:

1
2
3
4
5

Parent Co
├── Sub A (100%)
│   └── Sub A1 (80% owned by Sub A)
└── Sub B (80%)
    └── Sub B1 (60% owned by Sub B)

Sub B1’s data flows to Parent Co at 48% — the product of each ownership level from Sub B1 to Parent.

Common error: Sub B shows 80%, Sub B1 shows 60%, but Sub B1’s cumulative ownership is manually overridden to 60% instead of letting FCCS calculate 48%.

Circular ownership: If Entity A owns Entity B and Entity B owns Entity A (or indirect circular chains), FCCS flags this as a validation error. These structures require special handling — typically breaking the cycle through a specific consolidation method or manual adjustment.

The Validation Query (Smart View)

Layout:

Rows: Entity hierarchy (Parent + all subsidiaries) Columns: Entity Input, Proportion, Elimination, Contribution POV: Period (Current month, YTD), Scenario (Actual), Currency (Parent Currency)

What to verify:

Day 2 Maintenance

Ownership Changes Mid-Year

Scenario: Parent Co increases ownership in Sub B from 80% to 90% on June 1.

• Update Ownership % in Entity metadata to 90%
• Post 10% to FCCS_Mvmts_Acquisitions for June
• Re-run consolidation — FCCS recalculates NCI from June forward
• Verify NCI rollforward: Beginning 20% → Movement (10%) → Ending 10%

Common error: Updating ownership % without posting to movement accounts. The percentage changes, but NCI doesn’t roll forward correctly.

New Entity Added

Scenario: Parent Co acquires 70% of New Sub on March 1.

• Create entity, set Consolidation Method = Subsidiary
• Set Ownership % = 70%, Holding = No
• Post to FCCS_Mvmts_Acquisitions for March
• Configure intercompany partners (if any), run consolidation from March forward

Year-End Checklist

Before running year-end close:

• Ownership percentages match legal structure
• Movement accounts posted for mid-year changes
• Cumulative ownership calculated correctly for multi-level hierarchies
• Holding company flags set on parent entities only
• Consolidation method matches accounting treatment (see Logic Flow for thresholds)

The Trap: Proportional vs. Equity Method

You see a 30% investment. Should it be proportional or equity?

Answer: Depends on control structure, not ownership percentage. See the decision tree above.

Quick reference:

FCCS doesn’t decide for you. The consolidation method is a configuration choice based on your assessment of control, shared control, or significant influence.

What’s Next

This post covered the setup — ownership percentages, consolidation methods, and proportionalization. Next in the series:

• Pillar 4: Investment Elimination — Removing the investment account against subsidiary equity
• Pillar 5: Intercompany Eliminations — Automatic removal of intercompany transactions
• Pillar 6: NCI Calculation — Backing out the non-owned portion

Ownership management runs before eliminations start. Get this right, and the downstream calculations have a solid foundation. Get it wrong, and you’re debugging proportionalization errors in an NCI reconciliation at 11 PM on close night.