Creating a consolidated Income statement from the consolidating entities

[Alhamdan1995]

Hi All,

I am looking to create a workflow that will combine multiple schedules together. There are multiple entities and I want to create a consolidated income statement. Some entities might have the same account, so the total will be the sum of both, but in some cases, each entity will have unique accounts, so the combined one should include all of those, ideally under the same mapping, I also attached the mapping file (i.e. operating expenses). The unique ID for each account would be the account number. Thanks in advance for the help!

To illustrate, the below is an excerpt from entity 1:  

The below is an excerpt from entity 2:

The schedule I am looking to create using a workflow would look like this:

Mapping file

[HomesickSurfer]

Hi @Alhamdan1995 

Here's a start...

Workflow attached.

[JoeHerbert]

Hi @Alhamdan1995 have you tried joining on Account ID & then unique to tidy up nulls: