Consolidation of P&L

CHSJ
CHSJ
in 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:

Answers

  • Sai_Bharadwaj_Venati
    Sai_Bharadwaj_Venati
    Hi,

    Not super sure whether i understood question completely or not.

    My suggestion would be create one Entity list -> Use Subsets for Entity A, Entity B, Another Subset with both together or complete Entity itself

    By doing this all modules will have same dimension -> Entity, Different P&L items.

    U can add different P&L items into consolidated module and can refer data from Module A, B by direct reference

    You can manage updating subset by using import actions

    V.Sai Bharadwaj

    Connect on LinkedIn

  • Raul2104
    Raul2104

    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

     

  • ChrisAHeathcote
    ChrisAHeathcote

    @CHSJ 

    Create three line item subsets (LISS) for each of the three modules; LISS_A, LISS_B and LISS_C. 

    If module A and B contain the same dimensions it may be possible to create one LISS and assign the line items from both modules; this LISS could be called LISS_AB. 

    Create a mapping module for each LISS, LISS_A and LISS_B. Create two modules if these can not be combined or one if they can. If they can be combined then a single mapping module for LISS_AB.

    Add a line item to these module and format it as a list assigning the LISS_C from module C.

    Now select from the pick list a line item from module C to each item in the LISS_A and LISS_B or the combined LISS_AB.

    In modules A and B add a new line item, adding the corresponding LISS for that module.

    Add the formula; COLLECT()

    In module C reference these line items in modules A and B and use SUM function, using the line items in the mapping modules to sum the data in each source module into the target line item in module C. 

    The formula will look something like this;Module A.NewLineItem[SUM:LISS_AMapping.LISS_C] + Module B.NewLineItem[SUM:LISS_AMapping.LISS_C]

     

    If modules A and B have different dimensions to the target module C then you will need to build in additional mappings. However, this is not stated so please elaborate if this is the case.

Categories