You can configure multiple currencies and rates of exchange in Fluid.



Currencies and rates can be managed and updated in one of two ways - both available in the Financial Administration console and both outlined in this article:

  1. Under Currency Management (Financial Settings)
  2. Via Data Management download/upload


To access the Financial Administration console navigate to 'Financial Administration' from the drop-down menu under your Avatar.





To access the Financial Administration console and edit currencies and rates you will need Application Administrator or Financial Administrator access.



1) Configuring Currencies and rates using Currency Management


From the Financial Administration Console select Currency Management under Financial Settings.




From here you can either EDIT currencies by clicking on the edit pencil icon in front of the currency entry or create a NEW currency entry by clicking on ADD CURRENCY




Make your changes and additions to the currency dialog and save your changes. See the table at the bottom of the article for a full description of each field.




2) Currency & Rate Download/Upload


On the same Financial Administration console, scroll down to the Data Management section of the page, and download the Currency & Rates to excel by selecting DOWNLOAD




Make your desired changes to the excel spreadsheet that you downloaded.  See the table at the bottom of the page for a full description of each column.


When you are happy with your changes, select UPLOAD and then UPLOAD DATA




Field and Column descriptions


There are 2 tabs on the download file. 

The table below describes the columns on the FIRST TAB.


Column & Title in upload file
Field title in on-screen dialog
Description
Data Type
What happens if field is left blank in upload file?
A. CodeN/AThe entries currency code (e.g. USD, GBP, etc)TextMandatory field. Must be populated for an entry to be created.
B. NameCurrency NameFull descriptive name for the currency entry. (e.g. United States Dollar, Great British Pount, etc)TextField is left blank.
C. IsDefaultDefault CurrencySet to TRUE (Yes) to identify the entry as the main/default reporting currency for the instance. Only one currency can be set as default.Yes/NoField is set to FALSE (No).
D. RateToDefaultConversion rate to default currencyThe current conversion rate to the default currency (see note below)NumericField is set to 0,00
E. RateToRestatedConversion rate to default restatedThe restated conversion rate to the default currency (see note below)NumericField is set to 0,00
F. LockedLockedThe currency is not available for selection by users of the system.Yes/NoField is set to FALSE (No).
G. ActiveActiveThe currency is Yes/NoField is set to FALSE (No).
H. SymbolSymbolThe currency symbol (e.g. $, £, etc)TextField is left blank.
I. GuidN/AThe unique string identifier for the currency in Fluid.AlphanumericA new currency is added.




  • RateToDefault: The current conversion rate to the default currency. RateToDefault is typically maintained and updated fairly regularly (monthly) for a more real-time FX value on project financials.
  • RateToRestated: The restated conversion rate is typically the spot rate to the default currency for the financial year. This allows project financials to be displayed at a single rate eliminating FX fluctuations from the reporting. Restated values can be seen by clicking on 'Show Restated' under the financials section of Project Workspaces and or on financial reporting. 





Below is a mapping of the column letters in the upload/download extract against the fields in the on-screen dialog.





TAB 2 in the download allows you to set month on month conversion rates for each of the currencies in turn for both default and restated rates.


Should no month on month conversion rates have been set yet - the second tab will not contain any content.




To configure specific rates month on month, add headers for each month in turn (enter the month headers by typing the first 3 letters of the month and the year - i.e. Nov 2019) and enter the required conversion values for each currency. Any values defined on the Rates tab will override the currency rate values set in the UI.




Column & Title
Description
Data Type
What happens if this field is left blank?
A. CurrencyThe full descriptive name for the currency entry. (e.g. United-States Dollar, Great British Pound, etc)TextMandatory field. Rates will not be updated without this field.
B. ConversionToThe rate to which the currency can be converted to. It may either be Default or Restated. TextMandatory field. Rates will not be updated without this field.
C - end. Monthly conversion Values
The rate conversions for each month.NumericNo value is uploaded