What to do with deals missing close dates

A deal without a close date is the most common pipeline data problem — and the one with the clearest, most immediate business impact. Here's why it matters and what to do about it.

Why Close Dates Matter

HubSpot's forecast tool only includes deals that have a close date. A deal without one doesn't appear in revenue projections, can't trigger date-based workflows (e.g., "send follow-up 30 days before close"), and can't be included in period-based quota tracking. If your forecast is consistently inaccurate, missing close dates are often a major contributing factor.

How to Fix Them

There are three approaches depending on scale:

1. Manual review (small numbers) — If you have fewer than 50 affected deals, assign them to the owning rep for review. Each rep should be able to set or confirm a close date in a short pipeline review meeting.
2. Bulk import (medium numbers) — Export the affected deals from HubDeck (Pro), fill in estimated close dates in the CSV, and use HubSpot's bulk import to update them. This is the fastest path for 50–500 deals.
3. Process enforcement (going forward) — Add close date as a required field on deal creation in HubSpot. Under Settings → Properties, you can mark it as required for the deal creation form. Combined with a validation workflow that flags deals without close dates after 7 days, you can prevent the problem from recurring.

A Word on Estimated Dates

An estimated close date is better than no close date. Even if a rep isn't certain when a deal will close, having a working date in the system enables forecasting to function. Build a culture where reps understand that the close date is a planning tool, not a commitment. It can always be moved — but it needs to exist.