What this article covers: How to configure exchange rates in BrizoConsol — selecting the year and scenario, choosing between Profit & Loss Rate and Balance Sheet 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 — Profit & Loss Rate or Balance Sheet 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
Profit & Loss Rate
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 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 P&L Rate and Balance Sheet Rate grids are separate — switching the Exchange Rates 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. You can still override individual cells manually if a specific rate needs adjustment.
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 (JAN through DEC) for the selected year. 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.
