Skip to main content

Manage currency settings

Learn how to manage currency settings.

Add fixed rates manually​

To add several periods, you must follow these steps for each period. The periods cannot overlap, even if they include different currencies.

If you have existing fixed rates, Add fixed rates manually is populated with a period starting the day after your latest period's end date, with the same currencies from you latest fixed rates, which you can edit as required. If your most recent period has no end date, you must first close that open period before you create your new period.

  1. On the Snow Atlas settings menu, under Account, select Currency settings.

  2. Select Add fixed rates manually.

  3. In Period, select the date range to apply to the fixed rates that you want to add. You can enter a period without an end date.

  4. Select the currency that you want to add for that period, and enter the exchange rate to apply.

  5. Do one of the following:

    • If you want to add another currency, select Add currency, and repeat step 4.
    • If the fixed rates that you want to add are complete, select Save.

Add fixed rates using CSV files​

To add several periods at a time, you can upload fixed rates using a CSV file. You can only upload one CSV file at a time. The periods cannot overlap, even if they include different currencies.

  1. On the Currency settings page, select Add fixed rates.

  2. Select Download template.

    tip

    Make your changes to the template in a text editor, for example, Notepad. MS Excel can give incorrect formatting.

  3. In the CSV file, enter comma-separated values for each header. You must only use the headers provided in the template, and ensure that you remove any commented lines from the template.

    HeaderValue required
    Base currencyThe base currency code for the fixed rate. The code must be three characters in upper case, for example, EUR for Euros. Ensure that you enter the base currency shown on the Currency settings page in Snow Atlas.
    Target currencyThe target currency code for the fixed rate. The code must be three characters in upper case, for example, EUR for Euros. Refer to the currency codes in ISO 4217.
    Exchange rateThe exchange rate to apply to convert your base currency to your target currency. The decimal separator must be a period.
    Start dateThe start date from when the fixed rate applies in Universal Time Coordinated (UTC). The date format must be YYYY-MM-DD.
    End dateThe end date for the fixed rate in UTC. This is up to and including the entire last day of the period. The date format must be YYYY-MM-DD. If you have no end date, leave this blank after the comma.
    Example
    Base currency,Target currency,Exchange rate,Start date,End date
    EUR,USD,1.1925,2023-04-15,2023-04-22
    EUR,AUD,0.7231,2023-07-01,2023-12-31
    EUR,AUD,0.7523,2024-01-01,

  4. Save your file.

  5. In Add fixed rates, drag and drop, or browse for the CSV file that you want to import.

  6. When a green check mark appears next to the name of your file, do one of the following:

    • To upload your file to import your fixed rates, select Upload and close.

      When your file has uploaded, the window closes, and processing of your file begins.

      note

      After you select Upload and close, you cannot cancel the process of adding your fixed rates.

    • To delete the file, select the trash icon to the right of the file. Repeat steps 3, 4, and 5, or select Cancel or X.

    • To cancel the operation, select Cancel or X.

When you upload a file, the status of the file processing appears in Fixed rates. For more information on the file status that appears, select Details or Import history. For more information on getting the details of errors in your files, see Check file import status.

The fixed rates that you have successfully imported appear in Fixed rates.

Check file import status​

You can check the status of your imported CSV files in Import history. The status of the file imports can be Scanning, Success, and Failed. For files that have errors, you can also get the details of the errors.

Files are automatically cleared after 30 days.

  1. On the Currency settings page, select Import history.

  2. If a file has the status Failed, select the file name.

    Details of the errors in the file appear.

Edit fixed rates​

You can edit the periods, currencies and exchange rates for fixed rates.

caution

If you edit the period for fixed rates, this can affect the data using these rates for all users in your Snow Atlas system.

  1. On the Currency settings page, select the period for the fixed rates that you want to edit.

  2. From Actions, select Edit.

  3. Optional: To change the period, select the date range that you want to apply to the fixed rates.

  4. Optional: In Currencies, do any of the following:

    • Update the exchange rates for the currencies.
    • To delete a currency, select the trash icon to the right of the currency.
    • To add another currency, select Add currency. Select the currency that you want to add, and enter the exchange rate to apply.

  5. Select Save.

Delete fixed rates​

When you delete fixed rates for a period, you can affect the data using these rates for all users in your Snow Atlas system. For more information, see the information on currency management in the applications that your organization is entitled to use. For SAM Core on Snow Atlas, see Currency management. For SaaS, see Currency.

  1. On the Currency settings page, select the period for the fixed rates that you want to delete.

  2. From Actions, select Delete.