Simulate the CTA balancing plug for a foreign subsidiary — historical, average, and closing rates applied by account type, calculated in real time. No login required.
One of the most technically demanding adjustments in multi-entity consolidation — and the one most prone to manual error.
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.
Enter your subsidiary's financials and exchange rates to see the CTA balancing plug calculated automatically.
Input the total net assets of the subsidiary in its local currency. Use the equity/profit split slider to reflect how much of net assets represents accumulated equity versus current-period profit.
Historical rate — the rate when 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).
The CTA balancing plug is shown in the highlighted row — this is the amount you book to OCI as the currency translation reserve.
Adjust the inputs to simulate period exchange rate changes and see the Currency Translation Adjustment balancing plug in real time.
| 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 |
This tool uses a simplified model for illustration. In practice: (1) the equity/profit split within net assets will differ by entity and period; (2) dividends paid during the period alter retained earnings before translation; (3) partial disposals trigger recycling of CTA through P&L; (4) prior-year CTA must be carried forward as opening equity at the closing rate of the prior period. Always confirm calculations with your consolidation workpaper or accounting software.
Have a partially-owned subsidiary? Use the NCI Calculator → to split the translated equity between the parent and minority shareholders.
BrizoConsol calculates currency translation adjustments automatically for every entity, every period — synced directly from Xero, QuickBooks, MYOB or Zoho Books.
No credit card required · 14-day free trial