Why past-due close dates are the cleanest forecast signal
Past-due close dates are the single cleanest signal that your forecast is wrong. Either:
- The deal is going to close — but the rep hasn't updated the date, so your forecast is showing it in the wrong period.
- The deal already closed lost — but nobody marked it, so it's polluting your weighted pipeline number.
- The rep has been pushing the date repeatedly, hoping the deal recovers, and at this point you should mark it lost and move on.
All three are forecast-distorting. Reps tend to push dates instead of marking deals lost (it doesn't show up in their loss-rate). A deal that was originally scheduled to close last quarter but is still open this quarter is almost always one of the three above.
What three categories of past-due deals tell you
The community's standard view is Close date is more than 0 days ago AND Deal stage is not closed won/lost. That's the entire signal. No fancy logic needed.
Some teams add a stricter "extreme overdue" cohort — close date more than 60 days past — for the deals that are clearly abandoned. The 60-day threshold catches deals that have been pushed multiple times, which historically have a near-zero close rate.
Why finding the deals doesn't fix the rep behavior that creates them
The view itself is straightforward. The problem is what happens after you find these deals.
Reps tend to push the date by another two weeks rather than mark the deal lost — which solves the symptom (the deal disappears from your filter) but not the underlying issue. To catch repeat-pushers, you need a separate property tracking pushes-over-time, populated via property history, and another view filtered on it. Some teams build a "Closed-Lost reason: forced by close-date hygiene" status to track which deals were marked lost only because the rep ran out of pushes.
Past-due close dates are easy to find. Hard to fix the behavior that creates them.
The manual HubSpot recipe
This is one of the few hygiene views that works on every HubSpot tier. The filter is two conditions and you're done.
- Open the Deals tabNavigate to Sales → Deals in the main HubSpot nav. Click 'Create view' in the top right.
- Add filter: Close date is more than 0 days agoFilter by Deal properties →
Close date→ 'is more than' → 0 days ago. This catches every deal whose close date is in the past. - Add filter: Deal stage is not closed won/lostAND group →
Deal stage→ 'is not any of' → 'Closed Won', 'Closed Lost'. Only open deals — closed-already deals don't need recovery. - Sort by amount, descendingSort the view by
Amountdesc so the biggest slipping deals surface first. Triage starts at the top. - Save and pin to your dashboardSave the view as 'Past due close dates'. Pin it to your sales-ops dashboard for weekly pipeline review.
What Bloated does instead
Every past-due close date, with the rep behavior context to act on it.
Bloated flags every open deal whose close date is in the past — and tags repeat-pushers separately so you know which deals are real slips vs. zombies. The repeat-push tag is the strongest signal in your data that a deal won't close. Pair it with the suggested recovery action (push, mark lost, log reason) for a clean weekly pipeline review.
closedate · HubSpot deal property