What this article covers: How to configure exchange rates in BrizoConsol — selecting the year and scenario, choosing between Average Rate and Closing Rate, enabling Auto Exchange Rate, and manually entering rates per currency per month.

Exchange rates control how foreign currency balances are translated into the group presentation currency for consolidated reports. Go to Global Settings → Exchange Rates from the left navigation.

1. Selecting Year and Scenario

At the top of the page, two selectors control which rates you are viewing and editing:

Selector Description
The fiscal year you are configuring rates for. Change year to view or edit rates for past or future periods.
The rate type — Average Rate or Closing Rate. Each is configured separately. See Section 2.
The scenario these rates apply to — e.g. Actual. Rates are scenario-specific; configure rates separately for Forecast or Budget scenarios if needed.

2. Rate Types

BrizoConsol uses two separate exchange rate tables, each applied to different parts of the consolidated financial statements:

Rate Type Applied to
Income statement accounts — revenue, expenses, and profit. Typically uses the average rate for each month, reflecting the rate in effect during the period.
Balance sheet accounts — assets, liabilities, and equity. Typically uses the closing rate at period end, reflecting the exchange rate at the balance sheet date.
🛈 Note: Configure both rate types for each currency. The Average Rate and Closing Rate grids are separate — switching the Rate Type dropdown shows each one independently.

3. Auto Exchange Rate

The Auto Exchange Rate toggle automatically fetches and populates exchange rates from a market data source. It is only available when the Actual scenario is selected — it does not appear for Forecast or Budget scenarios, which always require manual rate entry.

Setting Behaviour
Rates are fetched automatically for the Actual scenario. The grid is locked while Auto Exchange Rate is On — turn it Off to edit individual cells manually.
All rates must be entered manually. Each currency row and month cell is editable.
🛈 Forecast & Budget rates: Auto Exchange Rate is not available for Forecast or Budget scenarios by design. You must enter exchange rates manually for these scenarios. Switch the Scenarios dropdown to Forecast or Budget and enter rates directly into the grid.

4. The Rate Grid

The grid shows one row per currency with monthly columns for the twelve months of the selected fiscal year (for example Jan-2026), starting at the group's fiscal year start month. The base currency (e.g. USD) always shows 1.0000 and cannot be edited. Foreign currencies show their rate relative to the base.

1
Select the Year, Rate Type, and ScenarioUse the three dropdowns at the top to navigate to the rates you want to edit.
2
Click any cell to edit a rateClick a month cell in any currency row and type the exchange rate directly. Rates are expressed as units of the foreign currency per 1 unit of the base currency.
3
Click SaveClick Save at the bottom of the page to apply the rates. The page shows No unsaved changes when all changes are saved.
⚠️ Remember to save: Rate changes are not applied until you click Save. Navigating away without saving will lose any manual edits.

Related Articles

Multi-Currency Consolidation CTA — Currency Translation Adjustment Organisation Detail