Home
Product
How It Works Security AI in BrizoConsol
Features
Group Reporting CTA / FCTR NCI Multi-Accounting Standards All Features
Integrations
Xero QuickBooks MYOB Zoho Books Excel Import Other Accounting Software
Solutions
For Accountants For SMB / CFOs Pricing See It in Action
Resources
Documentation Tutorials Month-End Guide Webinar Blog
Login Start Free Trial

CTA & NCI Consolidation Calculator

Simulate foreign currency translation adjustments and non-controlling interest splits — interactive, real-time, no login required. Built for group accountants.

What are CTA and NCI in Group Consolidation?

Two of the most complex adjustments in multi-entity financial consolidation — and the ones most prone to manual error.

Currency Translation Adjustment (CTA)

When a subsidiary operates in a different currency to the parent, its financials must be translated into the group's presentation currency at period end. Because different rates apply to different items — historical rates for equity, average rates for P&L, and closing rates for assets — a balancing plug called the CTA (or FCTR) arises in equity.

The CTA is not a profit or loss item. It sits in Other Comprehensive Income (OCI) and accumulates over time until the entity is disposed of.

Non-Controlling Interest (NCI)

When a parent owns less than 100% of a subsidiary, the remaining portion of equity belongs to minority shareholders — the Non-Controlling Interest. In the consolidated balance sheet, NCI is presented as a separate component of equity, and NCI's share of profit is separated in the income statement.

Under IFRS 10 and most local GAAP standards, NCI must be measured at either fair value or the proportionate share of identifiable net assets at acquisition, and updated each period thereafter.

How to use this calculator

Input your subsidiary's financials and exchange rates to get an instant CTA calculation and NCI split.

Step 1 — Enter subsidiary net assets

Input the total net assets of the subsidiary in its local currency. The calculator assumes 80% equity / 20% current-period profit split as a starting approximation — adjust using the sliders.

Step 2 — Set parent ownership %

Use the "Parent Holding Share" slider to reflect the group's ownership percentage. The NCI percentage is calculated automatically as the complement.

Step 3 — Input your three exchange rates

Historical rate — the rate when the equity/share capital was originally recognised. Average rate — the weighted average for the period (used for P&L). Closing rate — the spot rate at the reporting date (used for all balance sheet items).

Step 4 — Read the workpaper output

The CTA balancing plug is shown in the highlighted row — this is what you book to OCI. The equity attribution cards show the split between parent and minority shareholders after translation.

Interactive CTA & NCI Consolidation Workpaper

Adjust the inputs to simulate period exchange rate changes and see the currency translation adjustment (CTA balancing plug) and NCI equity split in real time.

LC
Parent Holding Share 80%
Historical Rate (Equity / Opening) 1.0000
Average Rate (P&L Movements) 1.0800
Closing Spot Rate (Reporting Date) 1.1500

Translation Workpaper (Presentation Currency)

Financial Line Item Local Balance (LC) FX Rate Applied Reporting Balance (PC)
Total Net Assets (Balance Sheet) 1,000,000 1.1500 (Closing) $1,150,000
Financed By Consolidated Equity Structures:
Opening Share Capital & Retained Earnings 800,000 1.0000 (Historical) $800,000
Current Period Net Income (P&L) 200,000 1.0800 (Average) $216,000
Cumulative Translation Adjustment (CTA Balancing Plug) Auto Reconciliation $134,000
Total Consolidated Group Equity 1,000,000 $1,150,000

Equity Ownership Attribution Split

Attributable to Parent Holding
$920,000
Based on 80% controlling interest
Non-Controlling Interest (NCI)
$230,000
Based on 20% minority interest allocation

⚠ Simplifications in this calculator

This tool uses a simplified model for illustration. In practice: (1) the equity/profit split within net assets will differ by entity; (2) goodwill and fair value adjustments at acquisition affect NCI measurement; (3) dividends paid during the period alter retained earnings before translation; (4) partial disposals trigger recycling of CTA through P&L. Always confirm calculations with your consolidation workpaper or accounting software.

Automate CTA & NCI — no more manual workpapers

BrizoConsol calculates currency translation adjustments and NCI entries automatically for every entity, every period — synced directly from Xero, QuickBooks, MYOB or Zoho Books.

See It in Action Start Free Trial

No credit card required · 14-day free trial