Cortex | Administration | Currency Conversions

Manage currency conversions (Administration)

  Only users who are set up as administrators in Cortex have access to this feature.

Use the conversion settings to convert the unit system or currencies and normalize the data for all the projects in Cortex Project History. You can see the converted values on the single project page and the Compare projects page.

How do I?

Open the Administration module

Click and select Administration from the menu. The Administration module opens in a new browser tab.

Set up currency conversions

  1. Select all the currencies your company has worked with in the past, currently works with, and plans to work with on the Currencies tab.
    • In the Administration module, click Factors > Currency conversions. (If this option is not available, click Factors > Settings and make sure the Use currency conversions check circle is selected.)
    • On the Currencies tab, drag the currencies your company works with from the Available list to the Selected list. Use the Search box at the top of the list to help locate specific currencies.
  2. Be sure to also select all the currencies your company has worked with in the past, as well as the currencies your company plans to work with in the future.
  3. Important. You cannot import exchange rates for currencies that aren't selected on the Currencies tab.
  4. Set the options to configure your exchange rate table on the Table properties tab.
    • Select the desired Rate frequency option to determine the date range frequency used in your exchange rate table:
      1. Monthly (default): Choose this option to maintain monthly exchange rates in the rate table.
      2. Quarterly: Choose this option to maintain quarterly exchange rates in the rate table.
      3. Annually: Choose this option to maintain annual exchange rates in the rate table.
    • For the Oldest project date field, select the date of oldest project you expect to store in Cortex. You will probably need to ask the appropriate manager for this date.

To look up the date of the oldest project currently stored in Cortex, click the What is the oldest project in Cortex now? link.

The system calculates the Table start date based on the Rate frequency and Oldest project date you specify.Examples(For example, if you select Monthly and enter 2/15/2005 for the Oldest project date, the Table start date will be 2/1/2005, the start of the month that the date falls within. Likewise, if you choose Quarterly and enter 5/20/2005 for the Oldest project date, the Table start date will be 4/1/2005, which is the start of the quarter that the date falls within.)

Tip

If you need to import an older project later, you can, but Cortex will not convert the currencies that project because the exchange rate table does not contain rates for the project's time period.

  • Import exchange rates into your exchange rate table on the Exchange rates tab.

How does Cortex configure the exchange rate table rows?

The system creates rows for the requested date periods rates table and selected currencies in the exchange rate table. It maps all the selected currencies with two entries for each currency pairing. For example, if you select USD and EUR, the exchange rate table includes an entry for USD to EUR and for EUR to USD.

    1. Click Export to export the exchange rate table to a Microsoft Excel workbook.
    2. Using your company's historical source of currency exchange rates, find the exchange rates you need and copy and paste them into the Exchange rate column on the Rates sheet within the Excel workbook. The Exchange rate column stores values with up to 9 decimal places.

When you finish entering currency exchange rates, save and close the workbook.

    1. Back in Cortex, click Import on the Exchange rates tab to import the exchange rates from the Excel workbook into the exchange rate table. Before performing the import, Cortex verifies that the Excel workbook content (i.e., makeup of the currencies, the date periods, etc.) aligns with your selections on the Currencies and Table properties tabs. If it doesn't, Cortex notifies you and you will need to repeat steps 2 and 3 of this procedure again.

Note that the entries in the Excel workbook and on the Exchange rates tab are in reverse chronological order.

  • Click Save on the Exchange rates tab to save the exchange rate table.

Your selected currencies are now available in the Apply Factors window for applying currency conversions. 

Maintain the exchange rate table (add exchange rates for new time periods)

After setting up your currency conversions initially, you maintain the exchange rate table by importing exchange rates for new time periods based on the Rate frequency you specified on the Table properties tab: Monthly (once a month), Quarterly (once a quarter), or Annually (once a year).

When it's time to add exchange rates for new time periods to the exchange rate table, do the following:

  1. On the Exchange rates tab (Administration > Factors > Currency conversions), click Export to export the current exchange rate table to a Microsoft Excel workbook.
  2. The Rates sheet in the Excel workbook provides new rows at the top where you can enter the exchange rates for the new time period. Enter (or copy and paste) the exchange rates for the new time period into Exchange rate column in the workbook.

Important. Cortex replaces the entire exchange rate table during the import—it doesn't just import the exchange rates you entered for the new time period. Be careful when you edit the Excel workbook. Typically, the only change you should be making in the workbook is entering exchange rates for new time periods on the Rates sheet.

  1. Save and close the Excel workbook.
  2. Back in Cortex, click Import on the Exchange rates tab to import the exchange rates from the Excel workbook into the exchange rate table.
  3. Click Save on the Exchange rates tab to save the exchange rate table.

Change the selected currencies

To change the selected currencies

  1. Click the Currencies tab (Administration > Factors > Currency conversions).
  2. To remove currencies, drag them from the Selected list to the Available list. Cortex removes the affected currency rows from the exchange rate table. It also removes these currencies from the Currency list in the Apply Factors window.
  3. To add new currencies, drag them from the Available list to the Selected list. Then you need to enter rates for the new currencies in the exchange rate table.

Enter rates for the new time periods

    1. On the Exchange rates tab, click Export.
    2. In the Excel workbook, enter (or copy and paste) the exchange rates for the new currency conversions into Exchange rate column.
    3. Save and close the Excel workbook.
    4. Back in Cortex, click Import on the Exchange rates tab to import the exchange rates from the Excel workbook into the exchange rate table.
  1. Click Save on the Exchange rates tab to save the exchange rate table.

Use project-specific currency exchange rates for certain projects

You can set up project-specific currency exchange rates for certain projects instead of using the default system currency exchange rates. When you create or update a project, you can import project-specific currency exchange rates for the project. See Create a new project for details.

What happens if...

I need to change the Rate frequency after I set up my currency conversions?

Changing the Rate frequency for the exchange rate table clears all the exchange rates in the table.

You need to perform step 3 in the "Set up currency conversion" procedure above to import exchange rates into your exchange rate table on the Exchange rates tab.

I need to change the Table start date after I set up my currency conversions?

  • If you enter an earlier Table start date, Cortex adds rows to the exchange rate table with blank rates. Then you need to enter rates for the new time periods to the exchange rate table.
  • Enter rates for the new time periods
    1. On the Exchange rates tab, click Export.
    2. In the Excel workbook, enter (or copy and paste) the exchange rates for the new currency conversions into Exchange rate column.
    3. Save and close the Excel workbook.
    4. Back in Cortex, click Import on the Exchange rates tab to re-import the exchange rates from the Excel workbook into the exchange rate table.
  • If you enter a later, more recent Table start date, Cortex removes the time period rows from the exchange rate table that predate your new Table start date.

 

The Factors > Currency conversions option is not available in Cortex 365. The currency conversion feature is not included in Cortex 365.