Forum Discussion

jreis's avatar
jreis
New Contributor II
3 years ago

Mid-Year Divestiture Reversing full YTD Data

Hi All, We have a client who wants to exclude a subsidiary from their reporting rollup starting mid year in May 2022. Unfortunately the consolidation view is set to YTD so it appears that when we s...
Consolidation
Metadata
Methodology
ChristianW's avatar
ChristianW
Icon for OneStream Employee rankOneStream Employee
3 years ago

Hi Joe

The easiest solution is just to load (or copy i.e. with a datamanagement job) the Mai's information forward till the end of the year.

How is the Mai's balance sheet of the deconsolidated company looking? Is it already deconsolidated in the ERP? Or was it deconsolidated with a rule, or manually? Is it an international company with a foreighn currency (this adds some complexity if you're currency conversion is YTD)?

For the BS, I'm using a business rule to copy all end balances to a dedicated deconsolidation flow, with the returned earnings as a plug.

I hope this helps and regards

Christian