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
