Cumulative translation adjustment (CTA)

Understand how Control calculates, stores, and presents currency and elimination CTA.

Cumulative translation adjustment (CTA) is the group-level equity adjustment that keeps the consolidated balance sheet balanced after entity balances and eliminations are translated into the group currency.

Control calculates two separate components:

• Currency CTA for translated balance-sheet activity other than eliminations.
• Elimination CTA for translated automatic and manual elimination activity.

This page describes CTA on the consolidated balance sheet. The FX Revaluation Adjustment that can appear in a cash-flow statement is a separate cash-flow reconciliation calculation.

Why translation creates an adjustment

A balance sheet can balance in local currency but stop balancing after translation. This happens when different balances use different rate dates.

In Control’s standard setup:

• Assets and liabilities use the current rate at the balance-sheet date.
• Income-statement and equity activity use the period rate for the transaction’s accounting month.

You can change the default rate type by account type and add exceptions for specific accounts under .

If translated assets total 105 while translated liabilities and equity total 102, Control adds CTA of 3 to equity. The final group balance sheet then balances at 105 = 102 + 3.

How Control calculates CTA

For every accounting month present in the transaction data, Control performs the following calculation.

1. Build the month-end balance sheet

Control takes active transactions through the valuation month and keeps rows mapped to group accounts with an Asset, Liability, or Equity account type. Income-statement rows do not enter the CTA equation directly.

The calculation also includes Control’s system-generated balance-sheet rows, such as monthly entity profit posted to equity.

2. Translate each balance

The selected consolidation rate type determines the rate date:

Rate type	How the balance is translated
Current	The accumulated local-currency balance is revalued using the rate at the valuation month-end.
Period	Each movement is translated using the rate for its own accounting month, then the translated movements are accumulated.

Monthly FX overrides take precedence for the matching month and currency direction.

3. Calculate the cumulative imbalance

Control calculates each CTA component with the same balance-sheet equation:

Cumulative CTA = translated assets - translated liabilities and equity

The transaction population determines the component:

Component	Included activity
Currency CTA	Mapped balance-sheet activity other than automatic and manual eliminations, including system-calculated entity profit in equity.
Elimination CTA	Automatic and manual elimination activity that affects the balance sheet.

Total CTA is the sum of Currency CTA and Elimination CTA. Control does not create a third total-CTA transaction.

4. Store the monthly movement

Although CTA is cumulative, Control stores one movement transaction for each month and component:

CTA movement for month = cumulative CTA this month - cumulative CTA in the previous available month

For example:

Month	Cumulative CTA	Stored monthly movement
January	3	3
February	5	2
March	1	-4

A balance-sheet report accumulates those movements. The closing CTA after March is therefore 3 + 2 - 4 = 1.

A CTA transaction drilldown shows the movement for that month, not the complete closing CTA balance. Compare the accumulated movements when reconciling a balance-sheet value.

How income-statement eliminations affect CTA

Automatic income-statement eliminations can change group profit. Control creates a corresponding calculated equity entry so the group balance sheet’s retained earnings remains aligned with the post-elimination income statement. That equity entry is part of the Elimination CTA calculation.

Control does not create this retained-earnings entry for manual income-statement eliminations. If a manual income-statement elimination should also affect retained earnings, create the corresponding manual balance-sheet elimination. See the retained-earnings offset example for the entries to post.

Worked group example

Assume:

• The group currency is EUR.
• Entity A reports in EUR.
• Entity B reports in SEK.
• The month-end rate is 11 SEK = 1 EUR.
• Entity B’s retained earnings use an earlier period rate.
• The group has a 1,000 EUR intercompany receivable against a 10,500 SEK payable, which translates to 954.55 EUR.

The translated balances produce these two adjustments:

Calculation component	Assets before CTA	Liabilities and equity before CTA	CTA
Regular translated balances	2,454.55	2,504.55	-50.00 Currency CTA
Eliminations	-1,000.00	-954.55	-45.45 Elimination CTA

After eliminations, assets are 1,454.55. Liabilities and equity are 1,550.00 before CTA. Adding Currency CTA of -50.00 and Elimination CTA of -45.45 brings liabilities and equity to 1,454.55, so the group balance sheet balances.

Configure the destination accounts

Open and choose CTA settings.

Select an equity group account for each component:

• CTA Currency receives CTA_CURRENCY movements.
• CTA Eliminations receives CTA_ELIMINATIONS movements.

The standard Control chart of accounts uses 20075 – Currency-CTA and 20070 – Elimination-CTA. You can use different equity accounts when your group reporting policy requires it.

Keep the two components in separate group accounts. This makes it easier to distinguish expected currency translation from elimination differences that may need investigation.

Where CTA appears

CTA rows are:

• generated by Control rather than imported from a source system
• assigned to the group instead of an individual entity
• categorized separately as CTA, not as source or elimination transactions
• undimensioned because the adjustment applies to the group balance sheet as a whole

In transaction views, the entity may appear as Group CTA. The generated transaction description identifies whether the row came from currency conversion or elimination activity.

CTA is normally relevant only to a consolidated, multi-entity view. It is not allocated back to individual entity columns or dimension items.

Interpret Elimination CTA carefully

Elimination CTA is not necessarily a pure FX number. Without explicit transaction-to-transaction matching between both sides of every elimination, the residual can combine:

• currency translation effects
• timing differences
• incomplete or one-sided eliminations
• mismatched amounts
• non-intercompany activity included by an elimination rule

A non-zero Elimination CTA can therefore be correct, but a persistent or material balance should be investigated.

Start with the high-level picture:

1. Separate Currency CTA from Elimination CTA.
2. Compare the difference with total assets and total eliminations.
3. Compare monthly movements with the cumulative closing balance. Large monthly movements that reverse can indicate timing; a persistent cumulative balance deserves more attention.
4. Check whether the difference is explained by current-rate versus transaction-month translation.
5. If it is not, review the affected entities, group accounts, elimination rules, and underlying transactions.

Troubleshooting

CTA is missing from the balance sheet

Confirm that:

• The workspace has more than one entity.
• Both CTA destination accounts are selected under CTA settings.
• The selected destination accounts exist and are included in the balance-sheet layout.
• Relevant local balance-sheet accounts are mapped and have the correct account type.
• The report includes the CTA transaction category and uses a consolidated group scope.
• Source synchronization and consolidation processing have completed.

CTA changed after an FX configuration update

This is expected when a consolidation rate type, account exception, group currency, or monthly FX override changes. Control recalculates the translated month-end imbalance using the new rate configuration.

Check the override month and direction carefully: 1 Base = Rate To. An inverted pair can materially change both translated balances and CTA.

Elimination CTA is unexpectedly large

Review:

• whether both sides of each intercompany balance were eliminated
• whether the source amounts belong to the same accounting month
• whether an automatic rule includes external activity
• whether a manual income-statement elimination also needs a manual retained-earnings elimination
• whether the affected equity and balance-sheet accounts use the intended consolidation rate type

The completed month is off by a small amount

The report calculation rounds group-account balances to two decimals. For a completed month, Control can move a display-level residual of up to 2.00 in group currency into Currency CTA. Larger imbalances and partial-month differences remain visible for investigation.