All pages
Powered by GitBook
1 of 6

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Confirm uploaded reference rates

You must only confirm the uploaded currency reference rates if the skipConfirm parameter value in the uploaded file was false.

After uploading currency reference rates, Tuum will navigate you to the New currency reference rates page.

  1. Select the currency reference rates you want to confirm and click the Confirm button.

  1. On the Confirmation modal, click the Yes button.

Currency reference rates

The currency reference rates define the reporting (base) currency against other currencies on a specific date. Financial institutions or central banks typically set them daily.

To add a new set of reference rates, follow the steps outlined below.

To ensure that transactions and events in other currencies get converted into the reporting currency during the report creation, you must set the daily routine for currency reference rate upload.

Upload a file with currency reference rates

  1. Go to Administration > Reference data > Currency reference rates to upload the currency reference rate file.

  1. On the Currency reference rates page, click the Upload button.

  1. On the Upload new currency rates modal, click the Choose file button to locate the currency reference rate file on your computer, and after selecting the file, click the Submit button.

If the skipConfirm parameter value in the uploaded file is true, you have completed the currency reference rates upload.

View the latest currency reference rates

Go to Administration > Reference data > Currency reference rates to see the list of the latest reference rates per base currency.

You can filter that view by filling in the filtering parameters and clicking the Search button.

that includes the base currency and reference rates for one or more currencies.

to Tuum through the BackOffice.

. You can skip this optional step if your organisation does not require additional confirmation.

Create a file
Upload the created file
Confirm the uploaded reference rates

Create a file with currency reference rates

To set the reference rates for currencies, you must create a file containing the rates in JSON format. Below, you will find the file's structure, an explanation of its parameters, and a sample file with exchange rates for multiple currencies.

File structure

Here, you will find a JSON file structure.

{
  "rates": [
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "AUD",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 1.6377
    }
  ],
  "skipConfirm": false
}

File parameters

Below, you will find explanations about parameters in the currency reference rates file in JSON format.

  • baseCurrencyCode: The base currency code is the reporting currency, formatted as ISO 4217, e.g., EUR.

  • quoteCurrencyCode: The transaction currency other than reporting currency, formatted as ISO 4217, e.g., AUD.

  • quotationTime: The date the currency rate is between the reporting and transaction currency is applicable, formatted as ISO 8601 DateTime, e.g., 2024-12-05T12:30:00Z.

  • rateType: The parameter defining the rate purpose in the Tuum. The value in the current context must be REPORTING.

  • rateSource: The name or the identification of the entity that has defined the rate quote, e.g., ECB.

  • rate: The exchange rate of the reporting currency to the transaction currency.

  • skipConfirm: The boolean value indicates whether the uploaded exchange rates need confirmation. A value of true means confirmation is not required, while false means it is required.

Sample file

A sample file with the reference rates for multiple currencies is below.

Sample file with all ECB quoted currencies
{
  "rates": [
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "AUD",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 1.6377
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "BGN",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 1.9558
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "BRL",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 6.3219
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "CAD",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 1.4809
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "CHF",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 0.9305
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "CNY",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 7.6577
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "CZK",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 25.1460
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "DKK",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 7.4579
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "GBP",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 0.8280
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "HKD",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 8.2027
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "HUF",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 411.8000
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "IDR",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 16711.1700
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "ILS",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 3.7981
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "INR",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 89.2543
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "ISK",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 145.5000
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "JPY",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 158.5200
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "KRW",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 1494.6100
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "MXN",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 21.3860
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "MYR",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 4.6666
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "NOK",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 11.6600
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "NZD",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 1.7985
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "PHP",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 60.9460
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "PLN",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 4.2745
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "RON",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 4.9774
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "SEK",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 11.5095
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "SGD",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 1.4133
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "THB",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 35.9730
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "TRY",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 36.5975
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "USD",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 1.0540
    },
    {
      "baseCurrencyCode": "EUR",
      "quoteCurrencyCode": "ZAR",
      "quotationTime": "2024-12-05T12:30:00Z",
      "rateType": "REPORTING",
      "rateSource": "ECB",
      "rate": 19.0427
    }
  ],
  "skipConfirm": false
}

Currency rates

It is a placeholder for the text about two different currencey rate processes.

  • Currency reference rates

  • Currency commercial rates