Dear Calcy: Help! My Forecast Is a Work of Fiction

Dear Calcy,

I have three forecasts open right now. My gut. The CRM roll-up, which is "data" the way a Magic 8-Ball is data. And finance's model, which assumes every deal closes at full price on the exact day it's supposed to, a fantasy so pure it should come with a unicorn.

Every QBR I pick whichever number is least likely to get me yelled at, say it with my chest, and move on.

Then the quarter ends, the "commit" turns out to have been more of a vibe, and I'm in a room full of people asking how we missed it, like I pulled it from thin air instead of three disconnected systems that were never going to agree. Nobody asks why the quotas were built on untested assumptions. The story is simple: I said a number, the number was wrong, I am bad at numbers.

Meanwhile every VP runs their own shadow forecast, because nobody believes the official one, including me, and I'm the one who built it.

How do I stop being the fall guy for a process that was rigged to be wrong before I even opened the laptop?

Signed,
Forecaster Without an Umbrella

<hr>

Dear Forecaster Without an Umbrella, 

Three forecasts, zero agreement, and somehow you're the one standing in the QBR holding the bag? That's not a “you” problem. That's a design flaw wearing a blazer.

Here's what's actually happening: everyone knows the "commit number" isn't real. Sandbagging on one side, sniping on the other, until the "official" forecast is just whichever number survived the tug-of-war. You didn't rig that game. You just got handed the microphone.

Meteorologists get the same bad rap, for what it's worth. Nobody's mad that it rains. They're mad when the forecast called for sunshine and it rained anyway, even though the system worked exactly as designed. Sales forecasting has the same failure mode. The miss was never the problem. The false confidence was.

And this isn't just your team's weather pattern. Nearly 80% of organizations report a real, measurable consequence of misalignment between sales planning and incentive comp: territory disputes, budget overruns, and the kind of hiring-forecast errors that come from a number nobody trusted in the first place. Only 32% are immediately aware when quotas, territories, or capacity change. You're not forecasting badly. You're forecasting blind, by design.

So here's how to stop being the one everyone blames for the rain.

1. Stop forecasting a point. Forecast a range. A single number pretends to know the impossible. "We'll close $2.4M" is the sales equivalent of "72 degrees and sunny." Say instead: "$2.1M to $2.6M, assuming these three deals close on schedule and this one doesn't slip." Now when reality lands in that range, you weren't wrong — you were accurate. And when it lands outside it, everyone can see exactly which assumption broke instead of just blaming you.
   
   
2. Recalibrate on a schedule, before the quarter implodes. Organizations that adjust their plans weekly report being very prepared for market volatility at nearly 4x the rate of those that only adjust as-needed. The forecasters checking in constantly aren't doing more work for the sake of it. They're catching the drift before it becomes a miss.
   
   
3. Make quotas and territories move with the forecast. If your forecast says a segment is softening but nobody updates the quota or territory tied to it, you've just guaranteed next quarter's miss too. Treat the forecast, the quota, and the territory map as one system fed by one set of assumptions, not three opinions that occasionally collide in a Slack thread. That's the exact gap connected sales planning tools are built to close — capacity, quota, and territory models that update the moment the forecast shifts, instead of three spreadsheets that only sync when someone remembers to.
   
   
4. When the number moves, say why. Don't just update the forecast and let people notice on their own. Say what changed and which assumption drove it: "We moved from $2.4M to $2.1M because the EMEA renewal slipped two weeks." A number that changes without explanation reads as instability. A number that changes with a reason attached reads as a system that's paying attention.
   
   
5. Let people see it, so they stop building their own. Those shadow forecasts sitting in personal spreadsheets across the building exist because nobody trusts the official version enough to retire their backup plan. Give stakeholders visibility into the real forecast — ranges and assumptions included — and the shadow forecasts start to disappear. Not because you asked people to stop. Because they finally have something better to look at.

Forecasting will always involve some guesswork. Your pipeline is just as messy as a weather system, and pretending otherwise is exactly what gets you dragged into that room every quarter for a miss that was never really yours.

You were never bad at forecasting. You just didn't have an umbrella. Build the range, share the assumptions, get everyone looking at the same sky, so next time it storms, the whole team's prepared instead of standing around blaming you for the rain.

Good luck!
Calcy 🌦️

P.S. CaptivateIQ was recently named a Leader in the 2026 Gartner® Magic Quadrant™ for Sales Performance Management — one more forecast you can actually trust. Check out the full report to see why.