Consolidation of P&L

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 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.

Accepted answers

All comments

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

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 )

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)

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

Blueprint SS

repeated same method for Entity B

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

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.

please find Snapshots for all details

LIS mapping for consolidated PNL

Hope this helps.

Regards

Rahul Sharma

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.

Quick Links

Can you help?

Unanswered questions

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385