Attribute revenue from a child company to parent

[jpc0480]

Parents act as an umbrella to all child companies. The child is repsonsible for all revenue generated.

We are trying to figure out how a child can make a sale (deal) and then have this revenue be reported for the parent? 

Any help appreciated! 

[Josh · Accepted solution]

Hi @jpc0480,

You can accomplish this using a custom, cross-object report using companies and deals.  You'll need to add at least the values for the amount and parent company, as seen in the screenshot. 

Once you have the values and filters set up as you'd like to see them, you can adjust the visualization so it's showing the data as you need it for a report.

I hope this helps!

Josh

Thanks for the ping @JessicaH! 

[MatthewBoyd · Accepted solution]

@JessicaH Thanks for the mention here. 

@Josh That's an awesome resolution that I hadn't thought of. If you wanted to take it one step further (or one less step really) you should be able to achieve a similar result by using reporting on just Company Properties Total Revenue by Parent Company. 

One note for that is that it will only report on Closed Won revenue. 

Happy reporting!

[MatthewBoyd · Accepted solution]

@JessicaH Thanks for the mention here. 

@Josh That's an awesome resolution that I hadn't thought of. If you wanted to take it one step further (or one less step really) you should be able to achieve a similar result by using reporting on just Company Properties Total Revenue by Parent Company. 

One note for that is that it will only report on Closed Won revenue. 

Happy reporting!

[LaLokker]

@MatthewBoyd this was very helpful, thanks - really simple, clean solution. 

[Josh · Accepted solution]

Hi @jpc0480,

You can accomplish this using a custom, cross-object report using companies and deals.  You'll need to add at least the values for the amount and parent company, as seen in the screenshot. 

Once you have the values and filters set up as you'd like to see them, you can adjust the visualization so it's showing the data as you need it for a report.

I hope this helps!

Josh

Thanks for the ping @JessicaH! 

[TSJLD3M]

Hi @Josh - love this report, great way to get to an important metric.

I was wondering, have you tried this with multiple layers orparent hierarchies?

I if you had:

Tier 1: Company A - Parent
Tier 2: Company B & C - Sub Parents
Tier 3: Child Companies of B & C

Would you see the associated deal value rolled up from child to parent, or as I suspect, would it skew yor reporting as the tier 3 company deals aren't directly associated with the tier 2 companies, and so wouldn't be recognised at the tier 1 parent level?

My expectation is that you'd end up with the original issue but slightly condensed, showing columns for all three parent accounts with their direct child revenue only associated.

If I'm right, are there any other workarounds you could think of? shame you can't run workflows to copy data between parent & child accounts!

Cheers,
Joe

[Dan1 · Accepted solution]

Hi Joe, 

Our customers (which are also all HubSpot CRM users) kept on asking us for this capability. So we built it into our account mapping functionality.  It totals up all child company revenue to the parent and it doesn't matter how deep the connections go, sub parents on sub parents etc. 

Put on your headphones 🎧 and crank up the sound 🔊 to full power, to watch a quick overview: 

OrgChartHub has a free plan, the account mapping funcitonality is on the paid plans however if you want to trial the account mapping functionality with deal activity then let me know and we will look after you 🙂 

Kind regards,  

Dan Currin 

Co-Founder 

OrgChartHub 

GeoMapper 

OrgChartHub & GeoMapper named in the Top 30 HubSpot Apps 

[RSenor]

@Dan1 - Would you mind sharing your contact info so I can reach out about trialing the account mapping piece before we make the final decision to purchase.

[kvlschaefer]

Thanks for sharing, @Dan1!

[JessicaH]

Hi @jpc0480,

Thanks for reaching out.
I want to tag in some thought leaders to see if they can assist with this.
Hi @MatthewBoyd @markkofman @Josh, would you be able to share your thoughts?

Thanks,
Jess