Consolidation - Monthly and Quarterly

[Former Member]

A client has some companies in ECC and which will be consolidated on a monthly basis as per USGAAP, on a YTD basis. For non-ECC companies they want to load data only on quarterly-basis via flat-file, aggregated to last period of the quarter.

Questions: Monthly IC matching will leave balances in Elim Accounts for transactions with Qtr Trading Partners? What challenges from USGAAP starter kit is suggested?

[Former Member · Accepted solution]

Hi Avi,

I will not answer specifically to the USGAAP starter it, but generally from a BPC consolidation perspective:

If you are only uploading non-ECC companies in periods 3,6,9,12 then you will indeed have imbalances in the elimination accounts in all the other periods in a YTD model. What I usually do in this case is create a logic script that pushes the latest non-ECC data from period 3 into 4 & 5 (for example) - thus when you run eliminations you may still have some differences but they will only represent movements in the current month. My logic would be something like this:

*SELECT(%NON_ECC_ENTITIES%,[ID],ENTITY,"[NON_ECC_FLAG]="Y"")

*XDIM_MEMBERSET TIME = %TIME_SET%

*XDIM_MEMBERSET ENTITY = %NON_ECC_ENTITIES%

*WHEN TIME.MONTHNUM

*IS 3,6,9,12

*REC(FACTOR=1,TIME=TMVL(1,%TIME_SET%))

*REC(FACTOR=1,TIME=TMVL(2,%TIME_SET%))

*ENDWHEN

*COMMIT

This approach allows you to run monthly consolidations for ECC entities, but not have huge imbalances with non-ECC entities in most of the months.

Thanks,

Tom.