Exchange rates

Access in Iziago: Settings > General settings > Exchange rates
 



Click to enlarge

Definition: an exchange rate determines the value of a currency in relation to the value of another currency.

This page allows you to:

  • Add currencies
  • Import exchange rates
  • Quickly enter exchange rates
  • View exchange rates
  • Add new groups of rates
  • Edit groups of rates
  • Delete groups of rates


ADD CURRENCIES

Access in Iziago: Settings > General settings > Exchange rates
 

Clicking the Add currency button allows you to add new currencies and enter their exchange rates:

  1. In the Exchange rates for drop-down list, select:
    1. Either Shared rates if the rate applies to all your companies
    2. Or only the company concerned by the rate
  2. In the Currency drop-down list, select the currency used by the company
  3. In the table:
    1. Select a date
    2. Enter the default rate for this currency
  4. To add additional values for the currency, click the Add new value button and repeat step 3
  5. Click the Save button


IMPORT EXCHANGE RATES

Access in Iziago: Settings > General settings > Exchange rate
 

You can import any files (csv files or files coming from your ERP software) into Iziago by clicking the Import button. This allows you to import exchange rates without having to manually create them one by one. During the creation of the a new file format, you need to perform data mapping so that Iziago can display data coming from external files.

To import exchange rates:

  1. In the Format field, select the format of the file you are about to import (to add a new file format, please read the procedure below)
  2. In the File field, click the Select a file button and browse the file to import
  3. Click the Import button
     

To add a new file format:

  1. Click theicon next to the Format field
  2. In the File format parameters section:
    1. Enter the name of the format
    2. Select a field delimiter, which will be used to indicate the end of one field and the beginning of the next (if you select Other, enter a delimiter in the blank field to the right)
    3. Select a text qualifier, which will be used to differentiate field data from the field delimiter (if you select Other, enter a delimiter in the blank field to the right)
    4. Indicate whether the first line contains headers or not by ticking Yes or No (If Yes, the first row will be used to extract field names and will be ignored during the data extraction process)
  3. In the Data mapping table, select the field to map to each column of the file:
    • Click the  icon to add a mapping
    • Click the  icon to remove a mapping
  4. In the Default data section:
    1. In the Company drop-down list, select a specific company or leave Shared Rates selected
    2. Select a rate group
    3. Enter a date
  5. Click the Save button


VIEW EXCHANGE RATES

Access in Iziago: Settings > General settings > Exchange rates
 

From the Exchange rates table, clicking the View button allows you to display the exchange rates by currency.

  1. In the Exchange rates for drop-down list, select:
    1. Either Shared rates if the rate applies to all your companies
    2. Or only the company concerned by the rate
  2. In the Currency drop-down list, select a currency
  3. In the Year drop-down list, select a year

The table automatically refreshes and displays the results of your search.
 

From this page, if you have the appropriate right, you can:

  • Add a new rate to the currency (Add new value)
  • Edit a value by clicking theicon in the Actions column
  • Delete a value by clicking the  icon in the Actions column


QUICK ENTRY OF EXCHANGE RATES

Access in Iziago: Settings > General settings > Exchange rates
 

Clicking the Quick entry button allows you to quickly add exchange rates to all existing currencies on the same page.

  1. In the Exchange rates for drop-down list, select:
    1. Either Shared rates if the rate applies to all your companies
    2. Or only the company concerned by the rate
  2. To apply the same rate date to all currencies:
    1. Tick the Use same rate date box
    2. Select the date to apply
  3. In the table, enter the rates
  4. Click the Save button