Forum Discussion

tsequeira's avatar
tsequeira
New Contributor II
1 year ago

Consolitation Relationship Properties

Hi,

I want the hierarchy illustrated below. Entity B owns 90% of entity C, and in the consolidation of entity B we calculate minority interests of 10%. At this step, I have no doubts.

However, entity A owns entity B 100% and also owns entity C 100% (90% direct + 10% indirect). So, in the consolidation of entity A, we need to eliminate the calculation of minority interests done previously in the consolidation of entity B.
I don't know how to set the properties to do this. Can someone help me?

 

Consolidation

1 Reply

  • ChristianW's avatar
    ChristianW
    Icon for OneStream Employee rankOneStream Employee
    1 year ago

    This (or similar) is how you normally would set up the consolidation tree:

    Cons Total A
        |
        +---Entity A (Cons 100, Own 100, Type Holding)
        |
        +---Empressa C (Cons 0, Own 10, Type Full (or CustomX))
        |
        +---Cons SubTot B (Cons 100, Own 100, Type Full)
                   |
                  +---Entity B (Cons 100, Own 100, Type Holding)
                  |            
                  +---Empressa C (Cons 100, Own 90, Type Full)

    With this setup, Empressa C will have a nci% of (0-10) = -10. You might need to adjust your consolidation rules a little to make it work. OS consolidation experts can help you with it.