Currencies and Exchange Rates

Cubix includes a currency module to convert original local currency data to a base reporting currency and further consolidation currencies if required.

The conversion functionality handles any number of currencies and conversion rate types and can also be configured to automatically calculate exchange differences.

If the currency module has been enabled, your model will have both a Local Currency view and a Base Currency view. It may also have additional Currency views if they were configured as part of the model design. If the currency module is not enabled in your model, you will only have one Local Currency view for all data.

!It is possible to view the data for all all entities in Base Currency.
In Local Currency, it is only possible to see the data form Input and Elimination type entities. Selecting a Consolidated Entity and Local Currency view will not display any data as this is an invalid data combination. It is not meaningful to consolidate multiple different local currencies.

The Currency Table

Exchange rates in Cubix are stored in a table called CurRates, separate from the Main data table.

The ‘Currency Rates’ table provides the conversion rates for all currency calculations. It contains four dimensions. These are: Version, Time, Rate Type and Currency
.

The Currency Rates table is accessible via a browser, in the same manner as a main table browser. Select the CurRates table.

Exchange Rate Input

Values are entered into Cubix for each exchange rate for each Rate Type, Version, Currency and Time period.

The Base Currency value is calculated by taking the Local Currency value and dividing it by the appropriate exchange rate value from the currency table.

*The configuration of which entities use which local currency and which variables are converted using which rate types is all managed as part of the model design and build. See The Currency Module
The only requirement of an end user is to ensure the exchange rate values are entered into the CurRates table.

FX Variables

Exchange differences resulting from the conversion of local currency values with differing rate types can be automatically calculated in Cubix. The differences are calculated on special variables, identified by being named ‘FXcalcvar’, where ‘calcvar’ represents the name of an existing calculate variable where the exchange difference needs to be included. See Exchange Differences

In the example below, Shareholders’ Equity is affected by an exchange difference. This is calculated on the variable FX_BS3010 and shows in the Base Currency column.