What this article covers: How to set up and use the Currency Translation Adjustment (CTA) feature in BrizoConsol — which foreign companies are translated, choosing the CTA reserve account, mapping equity accounts, setting equity rates and retained earnings rates, and reconciling CTA journals before reporting.
The CTA page handles setup for foreign currency translation adjustments that arise when a subsidiary's functional currency differs from the group's presentation currency. CTA is calculated automatically during consolidation runs — this page is for configuration only.
🛈 When is CTA needed? CTA only applies to companies whose own currency differs from the group’s reporting currency. Companies already in the group currency are listed under Already in the group currency — nothing to set. When every company reports in the group currency, the page shows No currency translation needed.
1. Accessing CTA Setup
Go to Adjustments → Settings (under Currency translation) from the left navigation. Companies lists each foreign company with its currency and the group currency it is translated to (for example USD → SGD). A dot marks a company that needs something before posting. Click a company to show its settings on the right.
When something is missing — the reserve account, a rate, or an account mapping — a banner at the top says how many things there are to fix for CTA to post correctly, and lists them.
2. Enabling CTA for a Foreign Subsidiary
1
Select the company in CompaniesOnly companies whose currency differs from the group’s are listed. Every company in another currency is translated; same-currency companies are listed under Already in <group currency> — nothing to set.
2
Read the company’s noteThe note under the company’s name says which currency it keeps its books in and reports in, and that its figures are translated automatically. There is no switch to turn on.
3
Choose the CTA reserve accountClick the gear icon beside Companies to open CTA reserve account. Under CTA reserve, select the group equity account the CTA is posted to — e.g. 3500 - CTA Reserve — or click + Create to create one. Click Save. The CTA is re-posted to the new account straight away.
4
Map any equity accountsIf Equity accounts to map appears in the company’s settings, it lists the company’s equity and retained earnings accounts with no group account. Choose a Group account for each and click Save mapping.
5
Configure the ratesThe company’s settings have two rate tables — see Sections 3 and 4.
3. Equity Rates
The Equity — rate on the day it came in table shows each equity account movement with its historical rate — used to translate equity balances at the rate in effect when the equity was first recorded (share issuances, capital injections, etc.).
Column
Description
Date
The date of the equity movement — each movement is listed as a separate line
Account
The Common COA account code and name — e.g. Shares, Common Stock
Company currency
The amount of the equity movement in the company’s own currency
Rate
The exchange rate to apply for this movement, shown as company currency per group currency. Editable — type directly to override the system rate.
Source
System — rate was set automatically from Exchange Rates. Manual — rate has been manually overridden; Reset to system reverts it to the system rate. No FX rate — no rate is available yet; enter one.
From profit
Turn on for a reserve filled from retained earnings: it then follows the retained earnings rates.
Group currency
The movement amount translated into the presentation currency at the historical rate
💡 Tip: Override the historical rate only when you know the exact rate that was in effect on the movement date — for example, the rate recorded in the original share issuance agreement. Click the rate field to edit it directly; the Source badge will change from System to Manual.
4. Retained Earnings Rates
The Retained earnings — rate for each year table sets the translation rate for retained earnings accumulated in each fiscal year. Each year’s profit is added at that year’s average rate unless you enter another.
Column
Description
Year
The fiscal year the retained earnings relate to
Opening RE
The opening retained earnings balance for that year in the company’s own currency
Rate
The exchange rate used to translate retained earnings for this year. Editable — type to override.
Source
System — defaulted from yearly average Exchange Rates. Manual — manually overridden; Reset to system reverts it to the yearly average. No FX rate — no rate is available yet.
Group currency
The retained earnings translated into the presentation currency at the configured rate
⚠️ Applied straight away: Saving or resetting a retained earnings rate re-posts the CTA for the group, so the change reaches the consolidated reports without any further step.
5. How CTA Is Posted
There is no posting button. BrizoConsol posts the CTA automatically, as one journal per calendar month-end for every month the entity has trial balance data — for actuals up to the end of the current month, for budget and forecast to the end of the scenario data.
The auto CTA journals are removed and posted again from the current data:
- every time the group is recalculated — after the nightly data load, a mapping change or an elimination rule change;
- whenever a CTA setting on this page is saved — the reserve account, the account mapping, or an equity or retained earnings rate.
In a group with sub-groups or companies with companies under them, each company’s CTA is posted on the level that consolidates it: the sub-group it is in, or the company it is under. A company with companies under it posts its own CTA on itself. Each of these levels gets its own journal for the month, and the top group’s reports include every level’s.
6. Reconcile / Verify CTA
Go to Adjustments → CTA / FCTR (under Currency translation) to open the CTA Reconcile / Verify page. This view shows all CTA journals — both system-generated and manual — before they flow into consolidated reports.
Section
Description
Auto CTA Journals
System-generated CTA journals, one per calendar month. Each row shows: Date, Journal ID (e.g. CTA-AUTO-202712-ACTUAL-LOCAL), Journal Type, Organisation, Source (Auto CTA), Description (e.g. Auto CTA posting monthly 2027-12), Debit, Credit, Diff, and a link to Show entries.
Manual CTA Journals
Any manually posted CTA journals — same columns as Auto CTA Journals. Empty if no manual journals have been posted.
Use the Scenario selector and the Period selector (with its previous and next arrows) to choose the month. Switch By month to By year to list a whole fiscal year, or to Custom to choose a from and to month. A Diff of 0.00 on all rows confirms that all CTA journals are balanced. Click Show entries on any row to see the individual debit and credit lines.
💡 Workflow summary:
- Check each foreign company is listed under Companies
- Choose the CTA reserve account, and map any accounts listed under Equity accounts to map
- Check the equity rates — override where necessary
- Check the retained earnings rates — override where necessary
- Let the CTA post — it posts automatically on every recalculation and every settings change
- Open CTA / FCTR to confirm all journals are balanced (Diff = 0.00)