Calculate days between Closed Won on Deal, and Invoice Created in Invoices

[LULUDEDE]

Main goal: we want to track how long it takes between when a Deal Closes till when we have the Invoice Created, since we often need to back and forth with customers for details, POs, etc. which then slows down our revenue generation. If there are other ways to do it then below, please feel free to let me know, but this is what I've tried. Thank you!

I've tried doing this via Reports but I could only get the dates, not the calculations. I tried it with Custom Objects, also didn't work. Now I've tried setting it up via Workflows but when I come to the IF-THEN action, the THEN action doesn't seem to be able to "Create Invoice Creation Date" to the deal level (which I would need to include it in Custom Objects, as that only uses Deal Properties, not Invoice properties). 

[EmmaAtKiwi · Accepted solution]

Hi @LULUDEDE! What I've seen some users do it create a separate Deal Pipeline just to track the post-sales process, including stages for "Invoice Created," "Paid," "Onboarding Session 1," and whatever other account management milestones there are.

Deal Stages are pretty cool for tracking progress past just deals:

• you can require specific fields in order to progress to the next stage
• can trigger workflows based on stage and/or how long a "deal" has been in a specific stage
• default "date entered X stage" fields
• and more!

[Wesimplifi_]

Hi @LULUDEDE,

You can achieve this by creating a custom Deal property and using a Workflow to calculate the number of days between Closed Won Date and Invoice Created Date. Here's how:

Step 1: Create a Custom Property

1. Go to Settings > Properties

2. Create a new Number property under the Deal object (e.g., "Days to Invoice").

Step 2: Use a Workflow to Calculate Days

1. Go to Automation > Workflows and create a new Deal-based Workflow.

2. Set the enrollment trigger:

   • Deal Stage is Closed Won

   • AND Invoice Created Date is Known

3. Add an action: Set Property Value

   • Select "Days to Invoice"

   • Use the "Calculate" function: Invoice Created Date - Close Date

[tverdokhlib1 · Accepted solution]

Hi @LULUDEDE I think you can consider the following solutions:

1 Option. Create a second Closed Won Deal Stage, Invoice Sent. In this case, you can move Deals there when the invoice is sent (either manually or with the help of workflow). Thus, you can easily track time using HubSpot standard properties: Date entered Closed Won/Date Exited Closed Won

2 Option. Create a custom Deal Property (Date picker) "Invoice Created Date" (for example).

1. Create a custom Deal Property - Create Invoice Date. 

2. Update this property with the help of workflow triggered - Invoice Create Data is known - copy to Deal Property Create Invoice Date. (instead of the workflow, you can also create a Property Sync property - and choose the Invoice property Create Date)

3. Create a Deal calculated property with the formula Time between and choose between Close Date and Create Invoice Date. 

Let me know if you have any questions.

[EmmaAtKiwi · Accepted solution]

Hi @LULUDEDE! What I've seen some users do it create a separate Deal Pipeline just to track the post-sales process, including stages for "Invoice Created," "Paid," "Onboarding Session 1," and whatever other account management milestones there are.

Deal Stages are pretty cool for tracking progress past just deals:

• you can require specific fields in order to progress to the next stage
• can trigger workflows based on stage and/or how long a "deal" has been in a specific stage
• default "date entered X stage" fields
• and more!