A four-step framework for CFOs to control AI token costs.

Read Now

SaaS Sales Forecasting - Christian Wattig’s Top Insights and Methods

Last updated: November 202660 min watch

Speakers

  • Christian Wattig, Founder, Inside FP&A

  • Kirk Kappelhoff, Senior Director of Strategic Finance, Drivetrain

Your sales reps have entered their calls for the quarter, and their bottom-up forecast of new bookings adds up to around $43.9M. Your sales managers, rolling up the same deals, submit $40.7M. Two weighted views of the same pipeline (one by stage, one by forecast category) land in the $42–48M range. One of these numbers has to go to the board.

Those are the figures from the demo Drivetrain's Saurav built in the session. The $3.2M gap between the rep and manager numbers isn't a data problem. Each number is right by the rules of its method, and each method has a blind spot the others don't.

Christian Wattig has run ten-plus budgeting cycles in which top-down and bottom-up never once matched. His argument is that the disagreement is where the accuracy comes from.

Christian is the founder of Inside FP&A and runs the Wharton School's FP&A Certificate Program. Saurav is Drivetrain's Head of Product & RevOps. This page follows the conversation, with Saurav's demo, the audience questions, and the full transcript at the end.

The short version

SaaS sales forecasting is the estimate of how much new business your sales motion will close in a period, built from the pipeline, from business drivers, or from history. Choose the method by how you sell and how far out you look, then run a second method against it.

For the mechanics of each method on its own, see Drivetrain's guide to SaaS sales forecasting frameworks.

Know what each of the four methods trades away

Kirk opened with the "four main methods we typically see Drivetrain customers use to forecast".

  • Judgment-based: A rep estimates what they will close from their pipeline.
  • Probability-weighted: Deals are weighted by stage, so yesterday's lead counts for far less than tomorrow's close.
  • Driver-based: Price times quantity (users times ACV, say).
  • Statistical: Linear regression or similar, projecting a trend forward.

Judgment-based methods give you nuance at the cost of bias

Christian said judgment-based forecasting, also called expert-led forecasting, asks the sales reps for their view on the likelihood of closing. On the plus side, reps bring context, nuance, and qualitative signals that other methods can't capture, and the forecast is quick and nimble to update. On the minus side, Christian listed human bias along with emotional and external pressures, inconsistency across reps of different seniority and training, and groupthink (assuming everyone at a stage is equally likely to close).

an experienced rep can sense, from how a demo went, whether something is urgent for the prospect in a way historical data alone never could.
Christian WattigFounder, Inside FP&A

Probability-weighted methods give you consistency at the cost of nuance

Christian described a probability-weighted pipeline forecast as the more data-based option. You take historical conversion rates at each funnel stage and apply them as a standardized probability to every opportunity at that stage. Its advantages are almost the inverse of judgment-based forecasting. It avoids human bias, since the probabilities are standardized and data-driven rather than expert-led, and it updates quickly without rep conversations. However, you lose the nuance a sales manager might have, "and that's often underappreciated". And when the sales process changes or more experienced managers arrive, the probabilities need revisiting, but "companies are often slow to do that", so the forecast runs high or low.

Driver-based methods give you understanding at the cost of error stacking

Christian said he is a big fan of driver-based forecasting because it forces you to understand your business. You can't have fifty drivers, so you narrow the list to your "five-to-twelve" highest-value ones and learn how each relates to sales.

The danger is error stacking. Each driver carries its own margin of error, and stacking many of them can multiply that error rather than average it out. So, the real work is in deciding which drivers to leave out.

a simpler model, even a back-of-napkin approach, can get you eighty percent of the way there — sometimes the extra effort to gain one more percent of accuracy actually makes things less accurate.
Christian WattigFounder, Inside FP&A

Statistical methods give you objectivity at the cost of data dependence

Saurav said people from more quantitative backgrounds often prefer this method for its "perceived rigor". The advantage Christian later gave it was "little human bias".

Two things make it tricky. The first is data availability, since companies with slower sales cycles or less data struggle. The second is data quality, where poor data means garbage in, garbage out. That said, Saurav has seen these models work "beautifully" for usage-based revenue forecasting.

Fit the method to your sales motion, horizon and volatility

Kirk framed the choice around two factors: your go-to-market motion and your forecast horizon, where the current quarter looks different from twelve months out. He also separated existing pipeline from new pipeline. With existing pipeline, you know the prospect's name and can gauge the probability from the conversation. With new pipeline, "I don't yet know who those future customers even are", and that's where statistical methods come in. With very reliable CRM data, a sales quota or capacity model fits too, which Kirk called "really just a variant of driver-based forecasting with more data behind it".

Christian added a third factor: how volatile your business environment is. At Squarespace (a large company he helped take public), during the pandemic, subscriptions rose, and the team had to work out how much of that was one-off and how much was sustainable.

basically all our existing forecasting methods fell apart as the business environment changed so drastically.
Christian WattigFounder, Inside FP&A

So, the company hired data scientists, who built a machine-learning model. After a lot of trial and error, feeding it geographic unemployment and even mortality rates alongside Squarespace's own data brought accuracy "back to almost where it was before."

Enterprise sales-led, few high-ACV opportunities: Christian said an expert-led, rep-level forecast makes the most sense here. The caveat, he said, is that the method is most accurate for the near term, since "reps simply don't have visibility ten months out."

Mid-market and SMB, many opportunities, maybe no dedicated sales lead yet: With many more opportunities, Christian said, expert-led forecasting becomes harder to manage. A top-down approach based on pipeline-stage probabilities makes more sense. It suits an earlier-stage business, "evolving toward more rep-level input as you move upmarket."

Product-led, large lead volume: With many leads, Christian said, look at your demand-gen funnel. On its own, it can be "a bit shallow", so he recommends combining it with a driver-based method that captures other growth factors, like product changes, in a broader triangulation.

Hybrid or multiple growth engines: Kirk asked whether hybrid meant SaaS revenue in its classic shape, accounts times a dollar figure, plus a usage-based component or a services and implementation fee on top. Christian said it could be that, or a consumer business with a B2B arm. Either way, "you end up needing multiple methods working together."

In other words, your sales motion points to the primary method, and your horizon decides how much weight the rep view can carry. Volatility decides how often you have to rebuild.

Triangulate, and treat the gap as the conversation

Drivetrain's guide to triangulating sales forecasting methods covers the mechanics. Christian defined triangulation as "a way to stress-test your forecast and improve accuracy by using multiple forecasting techniques in parallel", and said it matters which methods you combine. First, pair a judgmental method with a statistical one. Judgmental methods carry human bias but capture nuance, while statistical methods have little human bias but miss the nuance, so combining them finds a better middle ground. Second, combine top-down and bottom-up.

Across ten-plus budgeting cycles, they've never matched for me — top-down tends to be more aggressive, bottom-up more conservative … That mismatch isn't bad — it's actually a great conversation starter.
Christian WattigFounder, Inside FP&A

Kirk asked whether there's a reasonable threshold for how far apart top-down and bottom-up should be before you revisit one or both. Christian didn't give a number. Avoid a very large gap, he said, since that just leads to unproductive discussions. What he recommends, and what many companies do, is this:

not sharing your full top-down before the bottom-up is done, since that just influences people to match your number.
Christian WattigFounder, Inside FP&A

Instead, share guardrails: roughly how much you plan to invest in marketing, roughly what your headcount plan looks like, and roughly what investors expect in growth, as a range. That gives people direction "without collapsing the two plans into an artificial match."

The four numbers at the top of this page are rep and manager calls set against two weighted views of one pipeline: a judgment-based forecast next to the method whose advantage Christian called almost the inverse of it. The gap between them is where the conversation starts. Triangulation only works if the second method is allowed to disagree.

Take the bias out before you trust the number

Christian named six common sources of bias, in this order. The first is political or external pressure. The second is status-quo bias, or assuming that what worked before will keep working. The third is confirmation bias. The fourth is narrative fallacy. The fifth is Dunning-Kruger, where experts tend to underestimate their own ability while newcomers overestimate theirs. And the sixth is ignoring unknown unknowns, especially in sales, where something can derail a deal in a way you couldn't have foreseen, "so you build in an adjustment even when you feel confident."

Once you've identified them, Christian said, measure them first: "track your average variance between actuals and forecast over time." Then collaborate. Go back to whoever gave you the input, or interrogate the data behind a statistical method, and ask how much rigor went into the estimate and what influenced it.

I always ask people to walk me through, step by step, how they arrived at a number — that's usually where biases and gaps in thinking surface.
Christian WattigFounder, Inside FP&A

This is the same conversation the triangulation gap starts. It also changes what sales forecast accuracy means in practice. You measure bias as the variance between actuals and forecast over time, rather than arguing about it in the meeting.

What triangulation looks like once it's built

By the time Saurav shared his screen, two pains had come up in the conversation: probabilities nobody has revisited, and Kirk's unanswered threshold question.

Saurav's demo used an enterprise SaaS company forecasting new bookings for the current quarter. The forecast was built bottom-up at the rep and manager level, then triangulated against stage-weighted and forecast-category-weighted models in Drivetrain's sales forecasting software. The two weighted numbers sit alongside the rep number, broken down by how much pipeline sits in each stage or category. The tool doesn't give you a threshold either, but with the numbers side by side, the gap and its likely cause are visible.

The probabilities behind the weighted models are visible and adjustable. They can be pulled from CRM data or overridden by finance if you think a given stage's win rate is off. In other words, Christian's stale-probability problem has a place to be fixed.

To see it run on your own pipeline, book a demo.

Summary

  • Know what each method trades away: Judgment-based, probability-weighted, driver-based, and statistical forecasting each have a strength that is also a weakness.
  • Fit the method to your motion: Enterprise, mid-market/SMB, product-led, and hybrid motions each lean on a different method or combination, and your horizon and volatility change the answer.
  • Triangulate: Run a second method with the opposite weakness, or top-down against bottom-up. The gap between the two is where the conversation starts.
  • Take the bias out: Recognize the biases, measure variance over time, and walk people through how they got to their number.
Summarize with AI:

Questions from the webinar

How do you account for large outlier deals?

An outlier, Christian said, has a low probability by definition, and there's no crystal ball for when one will land. Look at the last three to five years, count the outliers, and divide by the number of years to get an expected annual contribution to bake in. "Yes, if it happens your forecast undershoots, and if it doesn't it overshoots", but it still gets you closer to reality in either scenario than ignoring outliers does.

How do you handle seasonality?

Christian said to use any base method, then apply seasonality as a second step. Forecast your total, "say, a hundred thousand new subscriptions over the next twelve months", then allocate it across periods using last year's monthly, weekly, or even daily distribution.

Speaker spotlight

Christian Wattig

Founder, Inside FP&A

Christian Wattig is an FP&A expert with 14+ years of experience in MNCs (P&G, Unilever) and high-growth tech startups (Squarespace). After earning his MBA from NYU Stern, he helped take Squarespace public. Now an entrepreneur, Christian directs the FP&A certificate program at Wharton and runs his firm, FP&A Prep, offering corporate training, online programs, and sharing insights through LinkedIn, newsletters, and his 'FP&A Tuesday' series.

Kirk Kappelhoff

Senior Director of Strategic Finance, Drivetrain

Kirk Kappelhoff is a financial modeling expert with a BBA in Finance & Accounting and nearly a decade of experience at Deloitte, EY, and KPMG, where he built models for pre-IPO companies, M&A transactions, and strategic planning initiatives. At KPMG, he led the Business Modeling Services team, specializing in equity stories and financial forecasts that help high-growth companies communicate their value to investors. At Drivetrain, Kirk writes about strategic planning, granular reporting, and modern FP&A best practices for rapidly scaling finance teams.

Ready to start your journey?

Fewer spreadsheets, faster planning, better decisions.

Book a Demo