topic Re: Report showing active MRR by month in Dashboards & Reporting

Report showing active MRR by month

charliepinker — Fri, 03 Apr 2020 13:16:44 GMT

Hi all, I'm trying to create a report that shows the sum of all active MRR (e.g. from deals) by month.

The first thing I did was to create a report that showed closed won deals by month, and make it cumulative so it adds up past deals into each month. This looks fine... until someone cancels. When they cancel, there's way of telling the cumulative report to reduce the mrr from a particular month onwards.

So I could try adding a new deal with a corresponding negative value to offset the cancelled revenue. That might work. But it wouldn't allow for suspended subscriptions. What if the subscription was going to resume in 6 months? If I then deleted the negative value deal, the past 6 month revenue reduction would be removed. So I'd have to add a second deal for the same value as the original! Which sounds bonkers and I don't think I want to go down that road.

So what I need is for Hubspot to somehow remember the date a deal status or custom property changes, so it can report accurately on the state of all deals in any given month.

Does anyone have any experience building a report like this or could offer any tips?

Thanks!

Re: Report showing active MRR by month

sharonlicari — Thu, 23 Apr 2020 09:00:30 GMT

Hey @charliepinker

Apologies for the delayed answer. Do you still need help on this matter?

Thank you

Sharon

Re: Report showing active MRR by month

charliepinker — Thu, 23 Apr 2020 13:31:45 GMT

Hi @sharonlicari thanks for the reply. I haven't resolved this no, but I've sort of given up - I don't think Hubspot is going to be able to do this. I had a suggestion from the support team to upgrade to Enterprise (ticket 3249090) so that wasn't that helpful! We're going to be implementing a subscription management tool to handle billing and subscriptions so my intention is to get this information from there. If you have any ideas about how I can track monthly MRR using Hubspot though I'd be all ears 🙂

Re: Report showing active MRR by month

sharonlicari — Thu, 23 Apr 2020 14:45:55 GMT

Hey @charliepinker

Thank you for getting back to me on this! What my colleague said is correct, however, I'll tag a few experts to see if they have found any workaround 🙂

Hey @Phil_Vallender @MikeLawson @Mike_Eastwood could you please share your thought and experiences with @charliepinker?

Thank you & Stay Safe!

Sharon 🙂

Re: Report showing active MRR by month

Mike_Eastwood — Fri, 24 Apr 2020 02:40:53 GMT

Hi @charliepinker

I don't know how to do it inside HubSpot without writing custom code, which requires time and budget.

Personally, I use a manual hack, I have a deal pipeline for my recurring revenue. I create a new deal for recurring projects, and delete it when the recurring income ends. So my total pipeline always shows my recurring total (MRR).

Sounds like you may get something sensible out of your external system (which could *probably* be hooked up with custom code).

Cheers

Mike

p.s. @sharonlicari thanks for the heads up!

Re: Report showing active MRR by month

charliepinker — Fri, 24 Apr 2020 12:37:51 GMT

Thanks for the tip @Mike_Eastwood 👍🏼. I do something similar - I have a field in the original deal called "subscription status" and mark is active when won, which I can then use to report on in a few ways (sum value all deals that are active, for example). Also this lets me have a calculated "total MRR" field at company level which sums all active deals of that account, so I can see the total spend of each account.

All of this still doesn't allow either of us to ask Hubspot what the active MRR was, for example, "in February" - its just point-in-time reporting. Hence why I'm hoping the subscription management tool will help here.

Thanks for the reply!

Re: Report showing active MRR by month

Stagring-Bao — Sat, 28 Nov 2020 12:17:52 GMT

Hi,

im working for a company who needs subsription and billing solution. What did you go for? Or what solution did you consider?

Thanks!

Re: Report showing active MRR by month

LAB — Wed, 13 Jan 2021 14:52:47 GMT

I have the same task, after some playing and support requests the things are more clear now - where is no any working solution for this moment:(

Waiting for functionality in nearest future I hope so so much:)

Re: Report showing active MRR by month

HelenaBolton — Fri, 10 Sep 2021 10:24:31 GMT

Hi Charlie,

Thanks for this!

I'm not sure if this is because I am on the Professional Package, rather than the Enterprise one, but I can't see how to make a report cumulative - at the moment I just have the new MRR in each month. Is there any easy way of doing this that I'm missing?

Thanks!