Exchange rates

An exchange rate determines the value of a currency in relation to the value of another currency.

Adding a currency

  1. Select Settings > General settings > Exchange rates.
  2. Click on Add currency at the top of the screen. The Set exchange rates for new currency screen is displayed.
  3. In the Exchange rates for drop-down list, you can select:
    • Common rates if the rate applies to all your companies.
    • company concerned by the rate.
  4. Select the desired currency in the Currency field.
  5. In the table:
    1. Select a date.
    2. Enter the default rate for this currency.
    3. If you wish, you can enter a future rate.
  6. To add additional values for the currency, click on Add new value.
  7. Click on Save.

Importing exchange rates

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

  1. Select Settings > General settings > Exchange rates.
  2. Click on Import at the top of the screen. The Import exchange rates screen is displayed.
  3. Click in the File to import field and select the file you wish to import. New fields are displayed.
  4. In the Format name field, you can:
    • Select the importation format to be used. To modify the format, refer to Editing importation format.
    • Enter the name of the format if this is your first importation format.
  5. In the File format parameters section:
    • Indicate if your file contains a header.
    • Indicate the used field delimiter.
    • Indicate if your file contains a text qualifier. Otherwise, select Other.
    • Select a specific company or leave Common rates selected.
    • Select a rate group.
    • Enter a date. If this value is contained in the imported file, leave this field blank.
  6. Click on View before import.
  7. In the File structure section:
    • Select the fields of Iziago that correspond to the columns of your file.
    • Select the importation format of each field (when required).
    • Arrange the lines so that they match the order of the columns of your file:
      • Click on to delete a line.
      • Click on to add a line.
      • Drag and drop the  icon to arrange the lines in the order of your choice.
  8. Click on Import. The importation format is automatically saved. Once the importation completed, Iziago displays a report detailing the number of successful, failed and ignored rates. You can export the report in PDF format by clicking on .

Managing importation formats

Prerequisite: To create, edit or delete an importation format, you must have a file with a separator containing rates to import into Iziago.

Creating an importation format

To create your first importation format, refer to Importing exchange rates. To create a new format:

  1. Select Settings > General settings > Exchange rates then click on Import at the top of the screen. The Import exchange rates screen is displayed.
  2. Click in the File to import field and select the file you wish to import. New fields are displayed.
  3. In the Format field, click on + New. The Add new format screen is displayed.
  4. Define the format settings of your file:
    • Format name
    • Use the checkbox to indicate if the text file with separator contains headers.
      • Field delimiter: Indicate which character determines the end of a field and the beginning of the next one.
    • Text qualifier: If each field is surrounded by a character to be ignored during the importation, indicate what is this character.
    • Company: Select a specific company or leave Common rates selected.
    • Select a rate group.
    • Select a date.
  5. Indicate the parameters of the file structure, that is the information contained in the text file with separator and in which order the information is presented. This enables the information to be mapped into Iziago fields. Use the buttons in the Actions columns to add/remove lines in the table or change their order.
  6. Click on Save.

Editing an importation format

  1. Select Settings > General settings > Exchange rates then click on Import at the top of the screen. The Import exchange rates screen is displayed.
  2. Select a file to import.
  3. From the Format drop-down list, select the format you wish to edit.
  4. Edit the desired data. For information on each field and section, refer to Creating an importation format.
  5. Click on Import. Your rates are imported into Iziago and your modifications are saved.

Deleting an importation format.

  1. Select Settings > General settings > Exchange rates then click on Import at the top of the screen. The Import exchange rates screen is displayed.
  2. Select a file to import.
  3. From the Format drop-down list, select the format you wish to delete.
  4. Click on next to the Format field.
  5. In the Delete importation format window, click on Delete.

Displaying importation reports

The Importation history screen is made of a search panel at the top of the screen, and a result table which is displayed only if there exists at least one report which corresponds to the search criteria; otherwise, the message “No existing report” is displayed.

  1. Select Settings > General settings > Exchange rates then click on Import at the top of the screen. The Import exchange rates screen is displayed.
  2. Click on Importation history at the top of the screen.
  3. Select the desired year and month in the search panel.
  4. In the result table, you can see the following information regarding the listed reports: Importation date, user that imported the file, file name, number of rates contained in the file, importation duration, number of rates successfully imported, number of rates whose importation has failed, and number of ignored lines (empty lines for example are ignored).
  5. If you wish, you may:
    • Export as PDF the information of a report. To do so, click on on the appropriate line.
    • Click on a line to display the report into the Importation report screen.
      Note: The Importation report screen is also automatically displayed after each importation.

Displaying and editing an exchange rate

  1. Select Settings > General settings > Exchange rates.
  2. To display an exchange rate, you can:
    • In the Exchange rates for drop-down list, select:
      • Common rates
      • one company.
    • search it using the search field.
  3. Click on the line of the desired exchange rate. The rate is displayed in another screen. You can:
    • Add a new rate by clicking on Add new value.
    • Edit a value by clicking on in the Actions column.
    • Delete a value by clicking on X in the Actions column.
  4. Click on the save icon.

Entering exchange rates quickly

    1. Select Settings > General settings > Exchange rates.
    2. Click on Quick entry.
    3. In the Exchange rates for drop-down list, select:
      • Either Common rates if the rate applies to all your companies.
      • The company concerned by the rate.
    4. To apply the same rate date to all currencies:
      1. Select the Use same rate date option.
      2. Select the date to apply.
    5. In the table, enter the rates.
    6. Click on Save.