Skip to main content
Contributor
January 22, 2025

Intercompany Report for Non-consolidating entities

  • January 22, 2025
  • 1 reply
  • 0 views

I am running into an issue with putting together intercompany reports. Basically, if an entity has an intercompany partner that is not a consolidating entity, no elimination would occur at the parent (as expected). However, this pair would still show up on my IC matching report. Has anyone dealt with this type of issue with the IC reporting and has any tips to put me in the right direction?

1 reply

T_Kress
OneStream Employee
OneStream Employee
January 22, 2025

I would think that your non-consolidating entities (e.g. JVs or what have you) would be IsIC = False in their entity dimension property.  Since they do not consolidate and thus will never eliminate, why would they need to be IsIC = True?  If they are IsIC = False, they would not show up on matching reports.

tuhlerAuthor
Contributor
January 22, 2025

Thank you for your reply. This works for certain cases, however I am running into an additional complexity. In this example, if Base 2 and Base 3 have intercompany, those should show up as they eliminate at Parent 2. However, if Base 2 has intercompany with Base 1, that is the instance where we wouldn't want to see on the report because no elimination will occur.

 

T_Kress
OneStream Employee
OneStream Employee
January 23, 2025

If Base 2 has intercompany with Base 1, it should eliminate at the "Total" parent so you would still want it on the report because Parent 1 and Parent 2 come together in "Total" correct?