Blog

Your Forecast Is Counting Money From Last Month

Written by Ryan Forrest | Nov 16, 2026, 1:00:00 PM
By Ryan Forrest, RevOps and sales

 

Short answer: An open deal with a close date in the past means one of two things. The deal closed and no one updated it, or it slipped and no one said so. Either way, your forecast is counting money in a month that is already over. Fix it with a 5-minute check every Monday.

Last week I filtered a demo pipeline for open deals with a close date before today.

Three came back. They added up to $81,500. One was still marked Verbal Commit. Its close date was October 23.

That one deal tells the whole story. The rep is not lying. The buyer is not lying. The date just got old, and no one went back to it.

I shared a short version of this on LinkedIn, and it got more views than anything else I posted that week. So here is the full check, step by step.

What does a past close date on an open deal mean?

It means the date no longer tells the truth.

A close date is a guess. It says, "I think this deal will sign by this day." That guess is fine when you make it. The trouble starts when the day comes and goes, and the deal is still open.

At that point, only two things can be true:

  1. The deal closed. It was won or lost, and no one moved it to the right stage.
  2. The deal slipped. The buyer needs more time, and no one changed the date.

Both are fixable. But if you leave them alone, they sit in your forecast like real money.

Why is a past close date bad for my forecast?

Because your forecast is built on dates.

When you look at "deals closing this month," HubSpot uses the close date to decide what counts. A deal with an October date will not show up in November. But it may still show up in your total open pipeline. It may even sit in a commit number someone made a few weeks ago.

So you get two problems at once:

  • This month looks smaller than it really is, because slipped deals are hiding in a past month.
  • Your total pipeline looks bigger than it really is, because dead or closed deals are still open.

Your boss sees one number. The real number is different. That gap is where bad surprises come from at the end of the quarter.

How do I find open deals with past close dates in HubSpot?

This takes about two minutes the first time. After that, it is one click.

Step 1: Open your deals list. Go to your deals in HubSpot and pick your sales pipeline. If you have more than one pipeline, start with the one your forecast uses.

Step 2: Filter by close date. Add a filter where Close date is before today.

Step 3: Remove closed deals. Add a filter so the deal stage is not Closed Won and not Closed Lost. Now you only see open deals with old dates.

Step 4: Save it as a view. Name it something plain, like "Past close date, still open." Now anyone on the team can open it.

That is the whole list. In most pipelines I have seen, something shows up the first time you run it.

What should I do with each deal on the list?

Ask the owner one simple question: "Closed or slipped?"

If it closed: Move it to Closed Won or Closed Lost today. If it was lost, add the reason. That reason is gold later, when you want to know why deals die.

If it slipped: Ask for two things.

  1. A new close date.
  2. One line on why it moved.

Keep the line short. "Legal review took longer." "Their CFO wants a second quote." "Champion left the company." You do not need a story. You need one true sentence.

That one line matters more than it looks. After a few months, you can read those lines and see the pattern. Maybe deals keep slipping at legal. Maybe one rep's dates slip every month. That tells you where to coach.

Should I also check next steps that are in the past?

Yes. Old next steps are just as bad as blank ones.

A next step that says "Thu 10/22: CFO pricing walkthrough" looks fine at a glance. But if today is November 13, that meeting already happened or never did. Either way, the deal has no real plan.

Demo data only. Six open deals, every next step dated in October.

Here is how to check it:

  • Add the Next step column to your deals view.
  • Sort it so the oldest dates come first.
  • For each deal with an old next step, ask the owner what happens next and when.

Most of the time, the past close date and the old next step show up on the same deal. Fix both in the same talk.

How do I stop deals from moving forward without proof?

Ask for buyer proof before a deal moves to a later stage.

A deal should move because the buyer did something, not because the rep feels good. For example:

  • Proposal Sent: The proposal went out, and the buyer agreed to a date to review it.
  • Verbal Commit: The buyer said yes out loud, and you know who signs.
  • Contract Sent: The buyer has the paper, and you know their legal steps.

You can write this into each stage in HubSpot. Some teams use required fields, like a next step and a next step date, before a deal can move. That way the deal cannot jump ahead with an empty or old plan.

Proof keeps dates honest. If you know who signs and when they review, your close date is a real guess, not a hope.

Can HubSpot AI help me catch old close dates?

Yes, but use it to read, not to decide.

Here are two simple ways to use Breeze, HubSpot's built-in AI:

  1. Before you ask the rep for a new date, open the deal and ask Breeze to sum up the recent emails, calls, and meetings. Now your talk starts from what the buyer actually did, not from memory.
  2. When you set up your Monday view, ask Breeze to help you list deals with no next step or with a close date in the past. Then check that list against your saved view.

One warning: do not let AI pick the new close date. The rep owns the date. The buyer owns the timeline. AI just helps you see the facts faster.

What does the 5-minute Monday check look like?

Do this every Monday, before your pipeline call.

  1. Open the "Past close date, still open" view.
  2. Open your Next step view, sorted oldest first.
  3. Send each owner one note: "Closed or slipped? If slipped, new date and one line why."
  4. Start the pipeline call with that list, not the forecast chart.
  5. Once a month, read the "why it moved" lines and look for a pattern.

That is it. It takes five minutes. It saves you from a lot of bad Friday surprises.

FAQ

What is a past close date in HubSpot? It is an open deal whose expected close date is before today. The deal is not marked won or lost, but the date has already passed.

How often should I check for past close dates? Once a week is enough for most teams. Monday works best, right before the pipeline call.

Should I just push all the old dates out a month? No. That hides the problem. Ask the owner if the deal closed or slipped, and get one line on why.

Who should fix the close date, the rep or the manager? The rep. They know the buyer best. The manager's job is to ask the question every week.

What if the same rep's dates slip every month? That is a coaching moment, not a punishment. Look at their "why it moved" lines. Often it is the same step every time, like legal or budget.

The bottom line

A past close date is not a big deal on its own. A pipeline full of them is.

Filter for open deals with old dates. Ask "closed or slipped?" Fix the date and the next step. Do it every Monday.

Run the view this morning. I bet at least one deal shows up.

If you want more short sales and HubSpot checks like this, I write about them in Fractional Insights, my free newsletter. And if your reps freeze when a buyer pushes back on price or timing, grab my free Objection Wheel guide.