Clay still life for a sales forecast you can trust

Revenue Strategy & Forecasting · 3 min read

Forecasting 101: How to Build a Sales Forecast You Can Trust

If next month is a guess, planning is a gamble. Here's a simple weighted forecast built on your own numbers, not your feelings.

By , Founder of KGL, Salt Lake City

I talk with a lot of owners whose work comes in waves - a big job, then a quiet stretch, then another big job. When next month is a mystery, so many decisions get harder - hiring a part-timer, ordering for the busy season, taking a week off in July.

A forecast is just your best, honest picture of what's likely to come in. It doesn't need to be perfect or fancy. It needs to be more truthful than a guess.

Here's the simple way I build one, using your own numbers instead of your feelings.

Most forecasts miss for very human reasons

None of these make anyone a bad person:

  • Owners guess. We count every warm conversation as a sure thing, because we're optimists. (That's part of why we started businesses!)
  • Salespeople overcommit. Nobody wants to tell the boss a quote is shaky.
  • Some people play it safe on purpose. They lowball so they can look like heroes later.

A forecast built on feelings will wobble. The fix is to build it on where each customer actually is in your process.

Weighting each lead by its stage keeps you honest

Every open quote or lead has two things: what it's worth if they say yes, and how likely it is to close based on its stage.

Early on - someone just reached out - the odds are low. After a real conversation where you know they're a fit, the odds go up. Once they've seen a quote and said it looks right, they go up more. Once you're sorting out final details, they're high. And once there's a deposit, it's done.

So instead of counting a brand-new inquiry at its full value, you count a small slice of it. A quote they've said yes to in principle counts for most of its value. Add everything up, and that's your weighted forecast.

Your own history beats anyone else's rule of thumb

Where do the odds come from? Look back at the last few months. Of everyone who got a quote, how many booked? Of everyone who had a first call, how many got to a quote?

If you don't have that yet, start with a reasonable guess for each stage and adjust every month as you learn. Your numbers will be better than anyone else's, because they're yours.

Picture a remodeling company in Cottonwood Heights with ten open projects. The owner used to look at the list and feel like most of them were happening, so next quarter looked amazing - right up until it wasn't. Now each project sits in a stage with its own odds. The brand-new inquiries count for very little, and the projects with signed-off designs count for a lot. The total is smaller than his old gut number, but it's real, and he can plan crews around it.

A forecast is only as honest as the stages under it

If a customer is sitting in a late stage but never really earned it, the whole forecast tips toward wishful thinking. That's why forecasting leans on two habits:

  • Exit criteria. Clear yes-or-no gates for moving a customer forward, so the stages mean something.
  • The 14-day rule. Anything that hasn't moved in two weeks gets reviewed, so stale quotes don't puff up your numbers.

A short weekly check sharpens the picture every month

Once a week, walk through every open lead:

  • Is it in the right stage? Be honest, and scoot it back if needed.
  • Has it moved since last week? If not, why?
  • Has anything changed - a new decision-maker, a delayed date, a budget question?
  • What's the new total?

Write the total down. At the end of each month, compare what you forecast with what actually came in. Too high? Your stage odds are probably too generous. Too low? Nudge them up.

Will you hit it exactly every month? Honestly, no. Life happens. The goal isn't to predict the future perfectly. It's to understand your pipeline well enough that surprises get smaller and planning gets calmer.

The goal isn't to predict the future perfectly.

Try this this week

  • List every open lead with what it's worth and the stage it's in.
  • Look back a few months and estimate how often each stage turns into a yes.
  • Multiply, add it up and write down your first weighted forecast.
  • Put a 15-minute weekly forecast check on your calendar.

Salt Lake City

Ready when you are.

You make it. I'll teach you how to help the people who already love it find you.

Evan, founder, waving