Currencies
  • 3 Minutes to read
  • Dark
    Light
  • PDF

Currencies

  • Dark
    Light
  • PDF

Article summary

Interim Currency Calculations to Include Directly Posted Common Currency Data

You can report in ANY currency no matter what currency or currencies your organization currently uses for reports. For example, an organization in the United States has its common currency as USD. The organization’s subsidiaries are in USD and EURO. Now the organization can report on all entities (those in USD and EURO) in EURO, USD, or some other currency entirely (e.g., Canadian dollar).

How to Convert Reporting Currencies

In this example, the currency for an organization reporting in USD is converted to Canadian dollar.

1. Access the Segment Hierarchies page by navigating to Maintenance > Hierarchy > Hierarchy Management.

  1. Select the Reporting dimension and hierarchy.

  2. Click Add to create a reporting member and a child.

  3. In the Properties pane on the right side of the screen, set the Currency Type to Account Based.

  4. Set the Currency Code to CAD (Canadian dollar). Note that exchanges rates must be defined.

  5. Select Yes or No depending if there are currency exceptions applicable to the conversion. Exceptions can be defined on the Currency Exception page.

  6. Set the Calculation Type to Account Based.

    imagea3jz123hz123.png

  1. Click OK and Save your selections.

  2. Run the Consolidation Process by navigating to the Consolidation Control Panel, selecting the Consolidation process, and clicking the Process action.

At this point, you can generate a report with the converted currency (which is Canadian dollar in this example) by selecting the newly created reporting member in the reporting dimension.

Change the currency associated with the reporting member on the Segment Hierarchies page and run the Consolidation process again to report in GBP. You can continue to change the currency and rerun the Consolidation process to produce reports in any currency as long as conversion rates are defined.

Note:
No more than 5 reporting members may be selected at once for conversion. Currency Conversion may be applied from the Currency Exchange Rate page or Consolidation Process.
Note:
When you run the Consolidation Process for the first time after you’ve completed the steps above, it’s important to process all periods in the current financial year as well as the last period of the previous financial year. This will ensure that month-to-date (MTD) and year-to-date (YTD) values are computed correctly. For example, if the current financial year is January 2018 to December 2018 and you’ve configured a reporting member in June 2018, you will run the Consolidation Process for December 2017, and all periods from January 2018 through June 2018.

How to Set Up Interim Currencies

To learn about Interim Currency, click here

The example below provides a calculation for Interim Currency:

USD = Common Currency     GBP = Local Currency    EUR = Interim Currency
1 GBP = 1.4119 USD = A
1 EUR =1.2661 USD  = B
1 GBP =1.11515678 Euro = A/B
960.18  GBP  X 1.115157 =  1,070.75  correct amount in verify data as Interim Currency

How to Set Up Entity Currency

The Entity Currency option allows you to generate Cash flow reports in a Local Currency. Add an Entity Currency to a reporting member as follows:

  1. Navigate to Maintenance > Hierarchy > Hierarchy Management.

  2. Access in Edit mode.

  3. Select Finance Hierarchies as Type, then select Reporting for both Dimension and Hierarchy.

  4. Click Show. Select the Reporting Currency node you want to apply an Entity Currency to.

  5. From the Segment Properties section of the Properties pane, select Entity Currency as the Currency Code as shown below.

    imagea3jz123hz122.png

    When the reporting member is added to a Dynamic Report, the Entity Currency is displayed.

    image5604.png

    Additionally, the following options are available in the Segment Properties section:

    Do Not Consider Opening Balance —Select if you want YTD values calculated in the first period to exclude the opening balance of the previous period.

    Do Not Consider CC Data —Select if you do not want the common currency value to be converted and reported in local currency.

    image5614.png

Was this article helpful?