topic Re: Attribute revenue from a child company to parent in Tips, Tricks & Best Practices

Attribute revenue from a child company to parent

jpc0480 — Fri, 02 Oct 2020 16:13:19 GMT

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!

Betreff: Attribute revenue from a child company to parent

JessicaH — Mon, 05 Oct 2020 08:48:00 GMT

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

Re: Attribute revenue from a child company to parent

Josh — Mon, 05 Oct 2020 12:38:20 GMT

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!

Re: Attribute revenue from a child company to parent

MatthewBoyd — Mon, 05 Oct 2020 19:54:23 GMT

@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!

Re: Attribute revenue from a child company to parent

TSJLD3M — Wed, 11 Aug 2021 19:21:38 GMT

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

Re: Attribute revenue from a child company to parent

Dan1 — Fri, 08 Jul 2022 13:00:03 GMT

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

Re: Attribute revenue from a child company to parent

kvlschaefer — Fri, 29 Jul 2022 10:52:03 GMT

Thanks for sharing, @Dan1!

Re: Attribute revenue from a child company to parent

RSenor — Thu, 20 Oct 2022 12:16:56 GMT

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

Re: Attribute revenue from a child company to parent

LaLokker — Fri, 09 Jun 2023 06:26:03 GMT

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