Consolidation of P&L

Options
CHSJ
CHSJ Member, ALL USERS Posts: 5 Occasional Contributor
in Planning & Modeling

Hi, 

I am sure this is very basic but much appreciate any advice. 

 

I need to consolidate 2 P&L say Entity A and Entity B. Assuming both P&Ls are in 2 different modules (Module A and B) and both have different P&L line items.  Module C is the consolidated module. I need to bring A and B onto C's P&L (assuming all 3 P&L line items are different, so A and B need to be mapped to C's P&L line items). In module C, I would like to see Entity A, B and Consolidated P&L. 

How do I go about doing that? I am stuck cos if I set up entities as a List, I cant bring in the P&L of A and B from different modules cos the formula will apply to just 1 module. Thank you. 

Tagged:

Comments

  • Raul2104
    Raul2104 Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor

    Hi,

     

    Not sure if this works for you, but I would have made  Subsets and new List .

     

    example Entity A has 3 line item Rev, Exp and gross profit(Gp) and Entity B has 3 line item Rev1 , Exp1, Gp1 . the Goal is to bring it to Entity C.

     

    Made modules and made LIS for each module( you can  consolidate both in 1 also )

    Raul2104_0-1636450367002.png

    Made a new list which will be used as  dimension in module C viz, New Pnl line item ( total Rev, Total Exp, Total Gp). 

    I made a mapping modules where I have taken this list and 2 line items as Entity A and Entity B each with LIS format and made maintained mapping in front of each one( goal is to use collect)

    Raul2104_1-1636450507664.png

    Further after Making a Mapping module I made 2 modules each for one entity to stored collected flow from source.

     

    Raul2104_2-1636450617882.png

    Blueprint SS

    Raul2104_0-1636451352616.png

     

    repeated same method for Entity B

    Raul2104_3-1636450666920.png

     

    once done all what we need is to bring this data in Entity C. 

    Raul2104_4-1636450790342.png

     

    in Entity C i have use new list and line items, have made Line item subsets for both entity in one for consolidation. and used sum as mapping to get the data.

     

    Raul2104_5-1636450865599.png

     

     

    please find Snapshots for all details 

    Raul2104_6-1636450924986.png

     

    LIS mapping for consolidated PNL 

    Raul2104_7-1636450958492.png

    Raul2104_8-1636450988290.png

     

    Hope this helps.

     

    Regards

    Rahul Sharma

     

Categories