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
Year
The fiscal year you are configuring rates for. Change year to view or edit rates for past or future periods.
Exchange Rates
The rate type — Average Rate or Closing Rate. Each is configured separately. See Section 2.
Scenarios
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
Average Rate
Income statement accounts — revenue, expenses, and profit. Typically uses the average rate for each month, reflecting the rate in effect during the period.
Closing Rate
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
Auto Exchange Rate — On
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.
Auto Exchange Rate — Off
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.