If Hubspot was able to calcuate gross margin from margin and amount fields it would make the inputting of deals a much more efficient process for our business. It would also make reporting on these figures much simpler, its a basic requirement of any sales director and should be easy for Hubspot to implement. We currently use 2 custom made free-text properties to facilitate our reporting, it just seems a clunky and time consuming way of doing things.
@HubDoPete I know I'm still hanging out for it. All our margins are calculated offline; as far as I'm concerned any opportunity to move away from spreadsheets is a good one. Being able to calculate average margin in addition to margin on a single deal would be very helpful.
We join the masses on still absolutely needing this function (Ability to drive cost-to-sell calculations based on a GP Margin field driving the 'sell' factor) inside the platform.
Like so many of your customers, this has to be done in offline spreadsheet 'workbooks' and translated over as copy/paste values (which is incredibly inefficient and can contain rounding errors and occasional data entry errors).
We are HubSpot Power users (according to one of your in-country top HubSpot Partners) and would be more than happy to be directly consulted on the best-practice approaches for this fix?
Kind regards
Chris Peterson General Manager Of Sales
Commercial-in-Confidence
Disclaimer
The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.
This email has been scanned for viruses and malware, and may have been automatically archived by Mimecast, a leader in email security and cyber resilience. Mimecast integrates email defenses with brand protection, security awareness training, web security, compliance and other essential capabilities. Mimecast helps protect large and small organizations from malicious activity, human error and technology failure; and to lead the movement toward building a more resilient world. To find out more, visit our website.
I have posted previously on this ... still a need. We moved from SForce which managed this well. When we moved to Hub, we then had to create a 'spreadsheet for margin calcs' which the sales team do for every deal closed, its time consuming and pointless when the CRM/Sales shoudl handle this. Need to be able to see overall GP£, Overall GP% and also visibilty on where the discounts are applied - at a deal level, not messing around with the products on the deal.
We actually just managed to create a work around for this. It's rather "MacGyverish" solution but it works non the less. It uses worklfows and calculative fields to do the trick. This means that you need to have workflows and calculative fields available to be able to leverage it.
With this we have been able to pull Margin (TCV) value and copy it automatically to a Deal Property. Technically you can copy other totals or some other info from the Line Items too but we have not tested in enogh solutions to say if it would work on that. We have used it to push this information to Deal Properties:
Unit/Unit category/Total quantativity, net totals (€) and margin (€)
Unit price
Unit pricing
Product type
Some of these could of course be reported through Line Items reporting of course but in our case we especially needed the Margin to be added to the Deal Properties.
Idea was to leverage the calculative fields type: rollup and use that to sum wanted line item property (and refine the summed values based on Line item category properties) and then use a workflow to automatically update the value on a deal if anything changes on the Line Items.
This of course is not a perfect model because you are restricted by the number of calculative field you have available.
@HubDoPete no custom code is needed so this is available solution for Pro subscriptions forward.
Workflow is deal based and is being triggered by checking that either the number of Associated line items on a deal is known or the Amount is known as often this also results in change in margin. We also have a manual trigger for rest of the usecases where we need to trigger the workflow.
Looping happens with the calculated properties (which is the setback of this solution as these are pretty restricted - just five (5) in Pro subscription). When using "Rollup" with SUM it sums distinct values (i.e. margin) per row and that comes out as the sum of all Line item Margins. With some filtering you can even get those done by product category.
We've managed to achieve all we require utilising the 5 x calculated custom fields you're allowed with the professional sales license.
These are simply custom deal fields that use line item values. Roll up is used for the Total Contract Value Margin and Monthly Recurring Margin. This just adds up all the line items values for those fields on any deal.
We then rollup all the Upfront Margin line items, but deduct it from the new Monthly Recurring Margin field (This leaves the Upfront Margin left over as it currently includes all the monthly recurring margin when viewed in line items)
The margin percentage is simply Total Contract Value Margin / Total Contract Value (see below)
Because we have run out of calculated fields, i now calculate the commission value below using Zapier (Very Easy) and make sure the 'Amount' value is updated in Zapier to automatically to reflect the Monthly Recurring Margin value. Monthly Recurring Margin is what we build and forecast our commcercials on so is the most important metric. Having it in the amount field, means we can use the 'Weighted Amount' metric on our pipeline view (and reports)
I'm so pleased we've found this, it has made our lives a lot easier! Hopefully this helps someone else.
Bringing this back up again, it would be great if we could report on margin in the forecasting tool as well. Our companies LOB's bring in wildly different profit margins and it would be nice to see this rather than just revenue as a goal that can be set.
Nudging this post again. Critical information that's needed from a forecasting perspective. We are having to work out our GP in an offline document, which is plenty painful considering we target out sales team based on GP, rather than revenue. Working out commission based on GP which we can't forecast within Hubspot? Don't get me started.
HubSpot - please listen to your subscribers! This is a persistent issue that prevents you being considered as a mid-enterprise grade CRM. Your platform is so good in most areas, but features to support commercial acumen are essential for your subscribers to run their businesses successfully (and continue as subscribers). All businesses run on making profit - so the ability to interact across the CRM platform at a Gross Margin level is essential. We too have made custom calculation fields etc to get around this for some time, but we must work in offline Excel workbooks to do margin gross up calculations efficiently (at a product level) and then manually copy and paste over to HS line items.
We cannot report on GP Margin easily either (other than super high-level net income from the custom ‘Deal’ calculation property) so that our Sales Reporting Data aligns to the financial back-end reporting. We cannot set Sales Goals, which in most Sales business units are Margin based not Revenue. and reporting on retirement of goals is therefore cumbersome (dashboards become shelfware).
We are a HubSpot power user organisation (believers in the overall value)…help us continue to be believers…this needs to be addressed.
(note: I contributed to this thread in January 2023 and since, and raised directly with HS Support several times as well).
Hubspot - are you quite mad? We've been using this tool for 4 months and it's driving us all nuts A CRM system MUST,MUST,MUST,MUST,MUST have this feature. The whole sales organisation needs GP - we don't give 2 Sh*ts about revenue, it's 100% about GP.
We moved from Connectwise SELL, and into the whole Hubspot ECO-System, and while the marketing is awesome, the Sales piece has some major issues, this being one of the biggest.
Could you answer why you don't do this please. it would be pretty simple to do it.
Você deve ser um usuário registrado para adicionar um comentário aqui. Se você já estiver registrado, faça logon. Se você ainda não estiver registrado, registre-se e faça logon.
