Which stage takes the longest?

Bottomline breaks down your average days-to-close by deal stage so you can see exactly where deals are spending the most time.

What's the fastest path to close?

Bottomline identifies the journey pattern with the fewest days from first touch to Closed Won so you can replicate it.

How many touchpoints does it take to close a deal?

Bottomline counts every logged call, email, meeting, and ad interaction tied to each closed deal and shows you the median.

Where's the bottleneck in my sales funnel?

Bottomline shows conversion rates between every deal stage and flags the stage where deals stall or drop off most often.

What's the highest-revenue path?

Bottomline ranks your customer journey patterns by the average deal size they produce so you can double down on what works.

How many days does it take to close?

Your sales cycle length tells you how long it takes to turn a prospect into a paying customer. If you do not know this number, you cannot forecast revenue, staff your team, or spot deals that are stalling. Here is how to calculate it.

6 min read

The short answer

Your days-to-close is the number of calendar days between when a deal is created in your CRM and when it moves to Closed Won. To calculate it, export your closed deals, subtract the create date from the close date, and take the median. HubSpot and Salesforce both track stage duration automatically, but getting the full picture still requires manual work.

Why your sales cycle length is a leading indicator

If your average deal takes 28 days to close and you have $120,000 in pipeline, you know roughly when that revenue will land. If your cycle suddenly stretches to 45 days, your cash flow projection just broke and you might not have noticed yet.

Sales cycle length also tells you about your process. A cycle that is getting longer might mean your leads are less qualified, your pricing is causing more negotiation, or your reps are not following up fast enough. A cycle that is getting shorter could mean your marketing is attracting better-fit prospects or your demo process improved.

The number is only useful if you track it consistently. A single snapshot tells you where you are. Monthly tracking tells you where you are headed.

What goes into a days-to-close calculation

The basic formula is simple: Close Date minus Create Date equals days-to-close. But there are nuances that matter:

Deal creation vs. first touch.In HubSpot, the deal “Create Date” is when someone manually created the deal record, not when the lead first contacted you. Those can be days or weeks apart.
Stage duration.Both HubSpot and Salesforce track how long a deal spends in each stage. In Salesforce, this is the “Stage Duration” field available via Opportunity History reports. In HubSpot, use the “Time in Deal Stage” calculated properties.
Outliers. One deal that took 180 days to close will skew your average badly. Use the median instead of the mean, and consider filtering out deals that were reopened or sat dormant.

How to calculate days-to-close in HubSpot and Salesforce

In HubSpot

1
Go to CRM → Deals
Filter by “Deal Stage is Closed Won” and set the close date to the last 90 days. Export to CSV.
2
Calculate days for each deal
In your spreadsheet, subtract the Create Date column from the Close Date column. In Google Sheets: =DATEDIF(B2, C2, "D").
3
Optional: use HubSpot's stage calculated properties
HubSpot automatically calculates “Date entered” and “Time in” properties for each deal stage. Go to Settings → Properties → Deal properties and search for “Time in.” You can add these as columns in your deal view.
4
Calculate the median
Use =MEDIAN(range) to get your typical days-to-close. Also calculate by deal size bucket ($0-5K, $5-20K, $20K+) to see if larger deals take longer.

In Salesforce

1
Go to Reports → New Report
Select the “Opportunity History” report type. This gives you access to the Stage Duration field, which counts the number of days an opportunity spends in each pipeline stage.
2
Add Stage Duration to your columns
In the Fields pane, use Quick Find to search for “Stage Duration.” Drag it into the column area. Filter for Closed Won opportunities in the last 90 days.
3
Sum stage durations per opportunity
Group by Opportunity Name and sum the Stage Duration column. This gives you the total days-to-close for each deal. Export and calculate the median in a spreadsheet.

Total time: 30-60 minutes. The CRM has the raw data, but you still need to export, clean, and calculate. Segmenting by deal size, source, or rep adds another 30 minutes.

What it takes to track this every month

The calculation itself is not hard. The hard part is doing it consistently and segmenting the data enough to be useful. Every month you need to:

Export new closed deals and recalculate the median.
Compare to last month to see if the cycle is trending up or down.
Break it down by rep, deal size, and lead source.
Cross-reference with invoice and payment dates from QuickBooks to see the true end-to-end cycle (not just CRM close, but actual money received).

The CRM gives you half the story. The accounting software gives you the other half. Combining them is the monthly chore that never happens.

Or track your sales cycle length automatically

Bottomline connects to your CRM and accounting software and calculates your median days-to-close every month. It segments by deal size and source, shows the trend over time, and includes the full cycle through invoice payment.

Sales cycle length

Median: 24 days to close

Down from 31 days last month

By deal size

Under $5K12 deals14 days

$5K - $20K7 deals28 days

Over $20K3 deals42 days

From a real Bottomline report. Sales cycle is calculated from CRM deal stages and cross-referenced with invoice payment dates.

Because Bottomline also tracks when the invoice was paid in QuickBooks, you see the real end-to-end cycle: not just when the deal closed in your CRM, but when money actually arrived in your bank account.