This is something I struggled with when I first started tracking deals.
For example, our business has several different revenue streams:
- One-off purchases from our store, templates, files, etc.
- Retainers on software with a standard, non-changing monthly fee. Things like website hosting and maintenance.
- Retainers on software with a standard, non-changing annual fee
- Fixed Retainers based on monthly services performed. This is usually done as one retainer contract per client.
- Variable retainers - these are longer-term contracts like 6months to a year, but the payment varies month to month based on the type of service being offered in a specific month. This is mostly due to our industry which is cyclical based on a legally set calendar - government and politics election cycles.)
The long and short of it is - I have not run across a single CRM (even one as detailed as HubSpot) that adequately tracks income ore revenue across all periods and deal types. I think this falls under the general idea that there is NO CRM that can be everything to everyone.
So we customize or make due. The latter, in my experience, leads to abandoning processes or tweaking things to a point where they become so cumbersome it adds too much inefficiency and complexity that salespeople can’t follow the process.
How I’ve handled this then is to think about what I really want to analyze or review on a regular basis. The answer is - I prefer to make sure my sales and marketing processes are set up properly and the reporting is then something we can review less often.
I’ve built custom deal fields to track things like annual deals and monthly deals. THat way the amount of the deal corresponds to the deal type. I can then filter pipelines on deal types and have a general idea (read: not perfect but good to go on) of revenue planned for the current month.
What this also means is that default contact properties HubSpot uses, like Lifetime Value, will not work as intended. For example, a contact at a company that pays us $3,000 per month gets entered as a single $3,000 deal. So HubSpot records that as lifetime value of $3,000 when in reality it might be $15,000 because they had a 5 month deal with us. We then use custom dashboards and reports to show the metrics we want to see with the click of a button. The reality is, we don’t look at this every day. Maybe once a week, usually less.
You could, of course, model that as a single $15,000 deal and put in the notes the contact length or create custom fields for start and end dates. But then the deal view will not show you accurate monthly numbers. If you have 3 of those deals at one time, your true monthly income is $9,000 but the closed deals view looks like $45,000.
So, for us, the Hubspot deals view is NOT really for projecting cash flow or monthly (or any other period) revenue. Because no matter which way you choose you run into an obstacle - either reporting is insufficient or the deal view is insufficient.
Another commenter on this post suggested checking out another app that grabs your deal data and pops it into a separate app of dashboard views and reports.
We do something similar. We use intuit quickbooks, which, coincidentally, in my opinion, is neither quick nor intuitive. But that’s a conversation for another time.
So we use Hubspot to track pure deals and the value of those deals to our company. That is more useful to our sales side of things and more closely models how we track those deals and what our customers are comfortable with. We’ve found selling a customer on $3,000 a month for five months is more palatable than closing them on $15,000 contract.
We then use custom reports and dashboards in Hubspot to show us quick views of estimated monthly or annual deal volume and revenue. But when we want to look at any real finance projections we model that in quickbooks and use those reports. Those typically become part of larger conversations of future revenue modeling and the subsequent conversations about sales tactics and how to close the deals that might have been lagging.
I recognize this super long winded response is probably not what you’re looking for, but, in my opinion, the important part is figuring out how you go about your sales processes. Test and figure out what works best and converts best and then design the reporting process around that. That will tell you whether hubspot can do it natively. If not, you know you have to wrap in another app to help with reporting and analysis.
But dont get stuck in analysis paralysis. Make an educated guess. Start. Test. Measure. Change up if necessary. Choose action over inaction.
Good luck!