topic Re: Struggling to understand Deal revenue and Quote or Invoice revenue in a Deal record for reportin in Sales Hub Onboarding

Struggling to understand Deal revenue and Quote or Invoice revenue in a Deal record for reporting

TThayne — Wed, 22 Jun 2022 22:44:24 GMT

To start, I need to give some background, I'm coming for a prior system, where sales would create a proposal using line items by product type in the CRM, they could assign what stage it was at in the pipeline for a forecast, if it moved forwared in the pipeline the client would Docusign it, and then it would appear as closed won. There was only one proposal it was pulling from with only one record with dollar amounts, and you could have multiple products and line items on it, which were all reportable, accurate and tied to the one account record.

For HubSpot, I'm struggling to understand how Deals and Quotes or Invoices have the same accurate, reportable information.

I set-up my pipelines and I can go in and create a deal quickly for a total dollar amount and select a single product from a dropdown I created (although I may really need to select multiple products). What I don't understand, is that if I build out my product library with product line items and dollar amounts, but we send out through an accounting integration with Hubspot a quote that includes detailed product line items with descriptions, quantities, expirations and dollar amounts.

How does that information populate in Hubspot, when I pull reports, where is it pulling from? It feels like I might have two different records of the revenue in the Deal record??

How do I make sure if it's pulling from the Deals, the information is accurate and matching the quote we sent out?

Also, how can I make sure this will all be information I can report on? I want to be able to report on product type, number of customers purchased, for a specific industry, time period, etc (report using the custom properties I'm creating)?

Thank you in advance!

Re: Struggling to understand Deal revenue and Quote or Invoice revenue in a Deal record for reportin

kvlschaefer — Thu, 23 Jun 2022 19:12:42 GMT

Hi @TThayne,

Thank you for reaching out, and for writing this detailed post!

I would like to invite some of our subject matter experts to get their insight.

Hi @danmoyle, @Phil_Vallender, @Josh, @Mike_Eastwood, @karstenkoehler - Do you have any thoughts or suggestions for @TThayne? They recently moved over to HubSpot from another platform and have some questions surrounding reporting.

Thank you!

Best,

Kristen

Re: Struggling to understand Deal revenue and Quote or Invoice revenue in a Deal record for reportin

danmoyle — Fri, 24 Jun 2022 12:25:02 GMT

Hi @TThayne. At a glance, it sounds like the information you're looking for could be created in a Custom Report acorss multiple objects/sources. I'm thinking a contact based dataset with sources from line items and deals. Essentially any datapoint you bring in through a HubSpot property is a point you can report on. So if you're bringing that info in through a billing integration, if it's pushing that data into a HubSpot property (including custom properties) you can report on it.

I've used HubSpot products (also called line items) in Quotes, which then associate to a Deal. This keeps everything aligned in HubSpot and makes it relatively quick to report on the revenue.

I hope that helps!

Re: Struggling to understand Deal revenue and Quote or Invoice revenue in a Deal record for reportin

TThayne — Wed, 29 Jun 2022 17:37:51 GMT

Thank you for your help! This is really helpful.

Trina