Skip to content

FX rate loading on consolidation scenarios data processing

Introduction

The FX rate loading on consolidation scenarios data processing generates overridden FX rates on the consolidation scenario based on the FX rates entered in the ownership structure register. The type of loading to be performed is defined by the FX rate loading method indicated in the advanced conversion rules. For more details, see the Conversion rules page in the Data Processing section.

The FX rate loading method can also be overridden by process. For more details, see the .

Note: to enable the FX rate loading data processing, the data processing for the generation of the proportional, converted and consolidable amount must be enabled.

FX rate loading on amounts and entity journals

For financial investment and net equity variations present in ownership structure register events in a currency other than the consolidation currency, CCH Tagetik generates generic overridden FX rates. These are not associated with any category and are calculated as the weighted average of the FX rates inserted in the ownership structure register events with dates that fall within the validity period of the scenario/period to be processed.

The weighted average FX rate is calculated taking account of the fact that, if the amount of the data inserted in the ownership structure register is not equal to the amount stated in the financial statements, then the difference will be valued at the account FX rate.

FX rate loading on financial investment elimination/net equity from ownership structure register journals

For the rows of variations present in the financial investment elimination/net equity from ownership structure register journals (and relative reclassification) in which the event number is defined and which have a currency other than the consolidation currency, CCH Tagetik generates an overridden FX rate equal to the one inserted in the ownership structure register for the event of the row.

FX rate loading on amounts, entity journals and financial investment elimination/net equity from ownership structure register journals

CCH Tagetik defines the data as indicated for the previous loading. In in-memory consolidation, FX rate loading from the ownership structure register onto the amount and entity journals categories is performed by consolidation scenario, only for the data that exists for those categories on the proportional amount type and for the following currencies:

  • the row currency
  • the consolidation currency
  • the preferred currency

IMPORTANT: FX rate loading on amounts and entity journals is only performed if the preferred currency is defined in the currencies list.

IMPORTANT: The event scenario must be linked to the Process. Moreover, the financial investment and net equity from ownership structure register must be present in the process’s elimination logics.