CTA Report | BrizoConsol Documentation

What this article covers: How to view and analyse the Currency Translation Adjustment (CTA) Report in BrizoConsol — choosing the scenario, basis and period, reading CTA by company, and following one company’s workings, rates used and posting accounts.

The CTA Report shows the posted CTA journal amounts broken down by component for each CTA-enabled foreign subsidiary. It is a read-only view of what has already been calculated and posted — use Adjustments → Settings (under Currency translation) to configure rates and re-post CTA before reviewing this report.

1. Accessing the CTA Report

Go to Adjustments → CTA Report from the left navigation. The report is a Pro and Premium feature — a Pro Feature badge appears on Free subscriptions, and a subscription prompt overlays the page on Standard subscriptions.

2. Report Selectors

Selector Description

Scenario Actual, Forecast, or Budget. Determines which trial balance data the CTA calculation draws from.

Basis YTD (fiscal year-to-date) or MTD (month-to-date). Switches the report between the year so far and the single month.

As at period The reporting month-end period to view. Select any posted period from the dropdown.

Changing any selector navigates the report immediately — no separate submit button is required. There is no entity selector: pick a company in the CTA by company table to see its workings.

3. CTA by Company

Three figures head the report: CTA reserve in the balance sheet (the group’s share at the period end), Translation difference this year (or this month on MTD) for all companies, and Of which minority shareholders, posted to NCI - share of CTA. The CTA by company table below them has one row per translated company:

Column Description

Company The foreign company.

Currency The company’s own currency.

Closing rate / Average rate The rates for the period, as local currency per 1 unit of the presentation currency.

Opening / This year / Closing The CTA balance at the start of the period, the translation difference for the year (or month), and the balance at the period end.

Group’s share / Minorities’ share How the translation difference splits between the group and the minority shareholders.

Notes under the table list the companies that report in the group currency and have nothing to translate, and those that report in another currency but have no CTA settings yet.

4. A Company’s Workings

Clicking a company opens its card, with its currencies, the percentage held, and Change rates in Settings →. Where this year’s amount came from lists each posted component with its formula, ending in the translation difference for the period. Who it belongs to splits it between the Group and Minority shareholders, and CTA balance shows the opening, the movement and the closing balance.

The components are:

Component Formula

Non-P&L Equity Translation (Local balance / closing rate) − (Local balance / historical rate)

P&L-Related Equity Translation (YTD movement / closing rate) − (YTD movement / average rate)

Current Year Earnings CTA Monthly P&L translated at average rates − YTD P&L at closing rate

Retained Earnings CTA Closing translation − historical translation + fiscal carry

Two sections open below: Rates used — the closing rate, the average rate, each equity account’s historical rate and the retained earnings rate for each fiscal year — and Posting accounts, with each component’s source period, account and amount.

5. Exporting the Report

Use the PDF or Excel icons in the top-right header to export the CTA Report. Both export options are available on Free, Pro and Premium subscriptions. The export includes the CTA by company table and, for the selected company, the rates used, the component lines and its total CTA.