Skip to Content
0

Calculating Closing Flow in Consolidation YTD model

Dec 15, 2017 at 05:53 AM

34

avatar image
Former Member

Dear Expert,

I am working on the consolidation YTD model for the first time.

We are using the following logic for Flow dimension.

Op TB - F100 (At start of the Year)

Movements from SAP gets booked in F120 & F121 (For Assets addition & Reduction)

All Blank Flows come in F_Input (Will include P&L And BS accounts)

Consolidation works on F999 (i.e Closing flow).

Question:

1. I am not sure whether i am required to calculate the closing flow every month and carry forward to calculate the opening flow.

2. If it is required to calculate the closing flow every month then can it be done through Business rule or we have to write a script.

Regards

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers