Constituent Entities Within Scope

This is the first step in the Pillar Two calculation to determine EBIT, CIT expense, interest, perform threshold and the De-Minimis check.

It comprises the following functions:

Prepare Data for EBIT, Interest and Corporate Taxes

This Join function is used to combine data into one data stream.

In the header of the Join function, the following settings were configured:

  • Join Type is set to the default value “Implicit Fields”. This way, all fields from the different data sources are included automatically.

  • Result Handling is set to “Include enriched data” as the output results should only include data records on which the rule (IIR or UTPR) was applied.

  • Suppress Initial Results is set to “No” to ensure that it can still be viewed later in reporting.

  • Include Original Input Data is set to “No” as only produced rows are needed for further calculations.

  • Auto Filling is set to “No” as all fields are assumed to be filled and left outer joins or lookups are not required to complete the calculation.

Check Revenue Threshold

This Join function is used to perform a threshold check based on the previous four years to determine whether a company should apply the Pillar Two Approach or not.

In the header of the Join function, the following settings were configured:

  • Join Type is set to the default value “Implicit Fields”. This way, all fields from the different data sources are included automatically.

  • Result Handling is set to “Include enriched data” to include all input data from the general ledger source, and union it with the plan and forecast data.

  • Suppress Initial Results is set to “No” to ensure that it can still be viewed later in reporting.

  • Include Original Input Data is set to “No” as only produced rows are needed for further calculations.

  • Auto Filling is set to “No” as all fields are assumed to be filled and left outer joins or lookups are not required to complete the calculation.

Identify De-Minimis

This Join function is used to check whether a company is eligible to De-Minimis.

In the header of the Join function, the following settings were configured:

  • Join Type is set to the default value “Implicit Fields”. This way, all fields from the different data sources are included automatically.

  • Result Handling is set to “Include enriched data” as the output results should only include data records on which the rule (IIR or UTPR) was applied.

  • Suppress Initial Results is set to “No” to ensure that it can still be viewed later in reporting.

  • Include Original Input Data is set to “No” as only produced rows are needed for further calculations.

  • Auto Filling is set to “No” as all fields are assumed to be filled and left outer joins or lookups are not required to complete the calculation.