How-to guide for sales ops leaders

How to create a sales forecast that forecasts accurately

A sales forecast is only useful when it survives contact with the first missed quarter. The output you want is a number leadership can plan payroll, hiring, and board commitments against, with enough signal around it to see what will break the number eight weeks before it breaks. Most teams can produce a forecast number. Fewer can produce a forecast number plus the three leading indicators that will blow it up, plus the manager-level accuracy history that tells you whose judgment to trust and whose to pressure-test. The difference is the difference between a forecast that gets ignored after the second miss and a forecast that becomes the operating heartbeat of the company. This guide walks through the whole build: pick the right method for your motion, gather the inputs that make the math honest, structure Commit, Best Case, and Pipeline categories so judgment and probability live side by side, run the weekly submit cadence, measure accuracy honestly, and recalibrate on a quarterly loop. Every step shows how to execute inside Strkr Forecasting, Strkr Pipeline, Flows, and Strkr AI, so you leave with a working rhythm, not a reading list. You can ship the system in a working day, but the operating muscle takes two to three quarters of weekly cadence to deliver sub-10-percent error. Plan the ramp.

Before you start

What you need.

Time: 3 hours to design the system, 2 to 3 quarters to stabilize weekly accuracy

  • A clean pipeline with defined stages, exit criteria, and required fields on every opportunity
  • At least two quarters of closed-won and closed-lost history, or sample history if the team is pre-revenue
  • A current quota per rep and a documented segmentation of new business versus renewal versus expansion
  • Buy-in from a sales leader and a finance partner who will consume the forecast weekly
  • Agreement on what time slice the forecast covers: typically monthly for ops, quarterly for the board
Create an accurate B2B sales forecast

Step by step.

  1. 1

    Choose a forecast method that matches your motion

    Forecasting methods are not interchangeable. Pipeline-weighted forecasting multiplies open opportunities by stage probability and is cheap to run but drifts fast when stages are soft. Historical trend forecasting projects next quarter from last quarter and works best when your motion is mature and seasonality is predictable. Opportunity-stage forecasting applies different conversion rates per stage and segment, which gives sharper numbers once you have at least four quarters of history. Intuitive forecasting is manager judgment overlaid on category commits and is the most accurate method in the first year of a new product line, but it does not scale beyond about 15 reps. AI-assisted forecasting uses live deal signals to adjust category calls, and Strkr AI runs this method inside Strkr Forecasting without exporting data to a separate system. Most teams run a blend: AI-assisted on the Commit and Best Case buckets, pipeline-weighted on top-of-funnel coverage, and historical trend as a sanity check on the quarterly roll-up. Pick the primary method before you build anything, because the method drives which inputs you need to clean. Document the method in a one-page forecasting charter stored inside Strkr so finance, sales leadership, and the board all read from the same definition. When methods change mid-year, trust in the number falls faster than the number itself does, which is why written methodology matters more than most teams expect.

    • Match the method to your sales motion length and segment mix
    • Default to AI-assisted for Commit and Best Case if you have at least two quarters of clean data
    • Fall back to intuitive manager judgment if you have fewer than 15 reps or less than two quarters of history
    • Document which method you are using so finance and sales speak the same language
    Tip: The best method is the one your managers trust enough to submit against weekly. Forecast methods that reps cannot explain to their own number do not survive the first miss.
  2. 2

    Clean the inputs: pipeline, stages, and required fields

    Any forecast is only as honest as its inputs. Before you compute a number, audit three things inside Strkr Pipeline. First, close dates: anything in the past needs an owner decision this week, pushed forward or marked lost. Second, next steps: anything older than seven days means the deal has no live buyer motion, and the probability on it is wishful. Third, required fields at each stage gate: if the decision maker or decision date fields are empty on late-stage deals, your Commit is built on fog. Strkr Flows can automate this hygiene audit nightly, flagging deals that fail any check and rolling the result into a Hygiene Score at the rep and team level. Hygiene Score becomes the first slide in your forecast review, because a forecast built on an unhygienic pipeline forecasts noise. Managers who open each weekly forecast with Hygiene Score see 30 to 50 percent lower forecast error inside two quarters, according to Bridge Group benchmarks on CRM data quality. Set a Hygiene Score threshold below which the rep is not allowed to submit a Commit; the threshold creates the forcing function that gets the data cleaned on Thursday night. The Hygiene Score should also factor in the quality of activity, not just the recency. A next step that reads "follow up with Jane" scores lower than one that reads "working session with Jane Smith, VP Ops, 2026-11-14 at 10am." Strkr Flows can parse next-step text and score it on specificity, which prevents reps from gaming the recency check by typing anything into the field once a week to clear the flag.

    • Audit close dates nightly in Strkr Flows; auto-task owners on anything in the past
    • Audit next-step staleness; flag anything older than seven days for manager follow-up
    • Audit required fields at each stage gate; block submits when fields are blank on late-stage deals
    • Roll flags into a Hygiene Score inside Strkr Pipeline and gate forecast submits on a threshold
  3. 3

    Design Commit, Best Case, and Pipeline categories

    Forecast categories are the judgment overlay on top of probability math. Commit is "I will deliver this unless something external breaks," Best Case is "there is a path if two or three things go right," Pipeline is "live but unqualified for the current period," and Omit is "parked for a future period." Each rep assigns every open opportunity to one category every week. Managers roll up the categories and submit a team forecast on Friday. The common mistake is letting probability alone drive category: a 90 percent deal with a one-day next-step gap and a weak sponsor is not a Commit, no matter what the math says. Strkr Forecasting shows probability and category side by side with the activity signals that matter: last meaningful activity, sponsor engagement, procurement status, and multi-threading count. Strkr AI flags category drift automatically when activity signals contradict the category call, which gives managers a short list of deals to challenge in the review rather than walking every opportunity on their team. Train managers to defend every Commit with evidence, not with a story about momentum. Build a short written definition of each category and publish it in the forecasting charter. Teams that leave categories undefined see per-rep interpretation drift within six weeks, which is why one team's Commit converts at 93 percent and another team's Commit converts at 72 percent in the same company. Written definitions pulled from the historical conversion data in Strkr Forecasting keep every rep calibrated to the same bar.

    Tip: A Commit survives one bad week of activity. A Best Case moves to Commit only when two external signals confirm the deal, never on vibes.
  4. 4

    Set coverage targets by segment and period

    Coverage is the ratio of open pipeline to the quota you need to hit. The healthy range depends on your win rate from first stage to closed-won. A 25 percent win rate implies four-times coverage at the start of the period. A 15 percent win rate implies closer to six. Calculate the actual conversion rate inside Strkr Forecasting across the last four quarters, invert it, add a 20 percent buffer, and that is your minimum coverage. Set coverage targets per segment, not just at the company level, because enterprise and SMB rarely have the same win rate. New business and expansion should also have separate coverage targets. Publish the number per segment on the sales floor dashboard inside Strkr Pipeline. Coverage is a leading indicator: if the number drops below target with eight weeks left in the quarter, prospecting is the only lever that still works, and the signal needs to reach reps on the Monday it appears, not during the end-of-month scramble. Strkr Flows can send a Slack notification to a sales leader when any segment drops below the coverage threshold, so coverage becomes an active control signal, not a vanity dashboard metric. Coverage ratios also need a time dimension. A segment that sits at 4x coverage at the start of the quarter is healthy; the same 4x coverage at week 10 of a 13-week quarter is a crisis. Build coverage decay curves inside Strkr Forecasting from your historical quarters so the dashboard shows the expected coverage at each week versus the actual, which turns a static number into a trajectory and surfaces trouble four to six weeks before quota slips.

  5. 5

    Build the weekly forecast submit cadence

    The forecast is a weekly artifact, not a quarterly guess. Every Friday, each rep updates category calls on every open opportunity, writes a one-sentence rationale for every Commit, and submits their number. Managers consolidate rep submits on the same day, apply their judgment overlay, and send the team number to leadership by Monday morning. The leadership rollup should land in a single Strkr Forecasting view with per-segment, per-manager, and per-rep breakdowns, plus the delta from the prior week. Record every weekly submit in Strkr so the delta from actuals becomes a tracked metric at the rep, manager, and team level. The weekly submit is where accuracy is built. Managers who skip the Friday discipline and submit only once a month see forecast error 2 to 3 times higher than teams running the weekly cadence, which is consistent with the Harvard Business Review research on forecast cadence and sales discipline. The forecast is a muscle that atrophies without weekly use. Protect the Friday submit from being hijacked by end-of-quarter heroics. Reps often rush to clean the pipeline the week quota is due; that pattern floods the submit with recategorizations that mask the real signal. Lock the Friday submit at a specific time, and require any post-lock change to go through a manager approval that is tracked in Strkr Forecasting. The approval friction is the forcing function that keeps the weekly discipline from degrading into end-of-period gymnastics.

    • Reps update category calls and submit numbers every Friday inside Strkr Forecasting
    • Managers consolidate submits, apply judgment overlay, and send the team number by Monday
    • Store every weekly submit so delta from actuals is a tracked metric at rep, manager, and team levels
    • Open each week with the delta from last week; investigate any swing bigger than 10 percent
    Tip: The weekly commit should drift less than 5 percent from week to week in the final two weeks of the quarter. Larger drift is a signal that the Commit discipline is weak, not that the business is volatile.
  6. 6

    Add a scenario layer: best, likely, worst

    A single-point forecast is a wish. The useful forecast is a range: likely, best case, worst case. Build each one from the same pipeline but with different assumptions. Likely is Commit plus 60 to 70 percent of Best Case, consistent with your historical Best Case conversion rate. Best is Commit plus 100 percent of Best Case. Worst is Commit minus a slip rate equal to your average Commit slippage over the last four quarters. Strkr Forecasting lets you store scenarios side by side and compute each one from live pipeline, so the three numbers update together when a rep moves a deal. The scenario layer protects finance and the board from the single-point fallacy and lets leadership plan hiring and spend across the range, not against the middle number. Share all three numbers with finance every month. The spread between best and worst is itself a signal: a widening spread means pipeline quality is deteriorating, even if the likely number holds. Treat the spread as a health indicator and investigate when it moves more than 15 percent in either direction over a four-week window. The scenario layer also protects you from the political pressure to inflate the forecast. When finance pushes for a higher number, you can show the best case and the inputs that would need to be true for best case to land, which converts the conversation from gut-feel bargaining to a shared view of what has to be true. That shift is where forecasting becomes a planning tool rather than a scoreboard.

  7. 7

    Measure forecast accuracy honestly

    Forecast accuracy has two components: direction and magnitude. Direction is whether you called the quarter up or down correctly. Magnitude is how close the Commit was to the actual. Track both. Measure accuracy at the rep, manager, and team level inside Strkr Forecasting, and track three windows: last week of the quarter, four weeks before close, and eight weeks before close. The eight-week number is the honest one, because by week 12 the Commit has been scrubbed and reshaped so many times that it is almost tautological to say it was accurate. Teams running weekly cadence with hygiene gating typically hit under 10 percent error at four weeks out and under 5 percent at one week out, which matches the forecast accuracy benchmarks published by Pavilion and Bridge Group across hundreds of SaaS sales teams. Set those as your targets. Publish accuracy per manager and per rep on a 90-day rolling basis, because accuracy that is not visible is accuracy that quietly drifts upward. Strkr AI generates a weekly accuracy narrative that identifies which deals moved the number and why, so coaching conversations happen on evidence instead of recall. Add one more signal: directional accuracy on sandbagging. A manager who consistently beats Commit by 15 to 25 percent is sandbagging, which is a quieter failure mode than missing but just as damaging to planning. Finance cannot hire against a forecast that is systematically light any more than they can against one that is systematically heavy. Treat sandbagging as a coaching conversation, not a win.

    • Track direction and magnitude at rep, manager, and team levels inside Strkr Forecasting
    • Measure three windows: last week, four weeks out, eight weeks out
    • Target under 10 percent error at four weeks out; use the eight-week number as the honest signal
    • Publish accuracy per manager on a 90-day rolling basis inside Strkr Pipeline
  8. 8

    Instrument leading indicators that break the forecast early

    The forecast is a lagging indicator; by the time Commit misses, the quarter is over. Instrument three leading indicators that break four to eight weeks before the number does. First, late-stage velocity: average days in Negotiation and Procurement across a four-week trailing window. If velocity doubles, something is wrong with pricing, legal, or sponsor coverage. Second, Commit conversion rate: percentage of Commit at week 8 that actually closes by week 12. If that number falls below 85 percent, your Commit discipline is loose and the number is softer than the dashboard shows. Third, next-step staleness on Commit deals: any Commit with a next step older than seven days is a soft Commit, and the volume of soft Commits predicts miss size with high correlation. Strkr AI monitors all three signals and surfaces them in a weekly leading-indicator view, with per-deal detail so managers can act on the signal, not just see it. Treat leading indicators as the alarm, not the forecast; the forecast is the number you commit, the leading indicators are the smoke that tells you to go look. Add a fourth indicator once the first three are stable: multi-threading depth on Commit deals. A Commit with only one named stakeholder is far more exposed to loss than a Commit with four. Strkr Pipeline tracks named stakeholders per opportunity and lets you set a weekly flag on any late-stage Commit with fewer than three named contacts. That flag often predicts loss two to four weeks before the deal shows up as softer in traditional velocity metrics.

    Tip: If Commit conversion at week 8 falls below 85 percent, the quarter is softer than the number says. Investigate the soft Commits individually before you let the week-12 story anchor the team to a false sense of safety.
  9. 9

    Review and recalibrate the forecast quarterly

    A forecasting system is a product; it ships, it drifts, and it needs iteration. Every quarter, pull the submitted weekly forecasts and compare them to actuals inside Strkr Forecasting. Ask three questions: which managers were systematically high or low, which stages had conversion rates that drifted more than 5 points from the trailing average, and which segments had the widest spread between Commit and actual. Managers who are systematically optimistic need coaching on category discipline. Stages whose conversion drifted need the exit criteria audited; something changed in the buyer journey, and the stage definition did not catch up. Segments with wide spreads need coverage targets recalculated. Share the retro findings with sales leadership before changing any configuration, and never change category definitions mid-quarter because it breaks the delta-from-last-week signal that the weekly cadence relies on. Treat the forecasting system the way a product team treats a shipping product: measured, iterated, and never finished. The quarterly retro is also where you decide whether to add or retire scenario buffers, probability updates, and segment coverage targets. Store every retro decision inside Strkr with the reasoning and the data that supported it, so a year from now the next revenue operations hire can trace why the forecast methodology looks the way it does rather than reinventing the configuration based on intuition.

Avoid

Common mistakes.

  • Building a forecast on an unhygienic pipeline. If close dates are stale and next-step fields are blank, the number is noise regardless of method, because the inputs are too dirty for any model to produce a trustworthy output.
  • Letting probability override category judgment. A 90 percent deal with weak sponsor coverage is not a Commit; probability math alone produces smooth-looking garbage without the manager overlay that catches late-stage softness.
  • Submitting a forecast monthly instead of weekly. Monthly cadence produces 2 to 3 times higher forecast error, because the Commit muscle atrophies without weekly use and reps lose calibration between submits.
  • Measuring accuracy only at week 12. By then the number has been scrubbed into shape; eight-week accuracy is the honest signal that tells you whether the forecasting system is actually catching slippage early enough to act on.
  • Running a single-point forecast instead of a range. Finance and the board need likely, best, and worst to plan hiring and spend across the range, not against a single number that collapses the pipeline quality signal.
  • Changing category definitions mid-quarter. Breaks the delta-from-last-week signal and resets the historical accuracy baseline, which costs you an entire quarter of comparability for a change that could have waited.
FAQ

Frequently asked questions.

What are the 7 steps of forecasting?

The classic seven steps are: define the objective, gather data, choose a method, build the model, generate the forecast, validate against actuals, and recalibrate. For sales specifically, add two more: layer manager judgment via forecast categories, and instrument leading indicators like late-stage velocity and Commit conversion. The seven-step framework is a scaffold, not a complete sales forecasting system.

How do I create a sales forecast in Excel?

Export open opportunities with stage, probability, amount, and close date, apply a weighted calculation of amount times probability per deal, roll up by close month, and compare the total against the quota. Spreadsheets drift fast because they lose their definitions within a quarter, and they do not catch stale next-step fields or category drift. Treat an Excel forecast as a one-time analysis, not a weekly operating system.

What is the formula for sales forecast?

The simplest formula is open-pipeline amount multiplied by stage probability, summed to a close-period total. The more useful formula layers category judgment on top: Commit plus 65 percent of Best Case equals the likely forecast. Add a worst-case by subtracting your historical Commit slippage rate. A single-number formula is less useful than a three-point range because the spread tells you about pipeline quality.

Can you provide an example of a sales forecast?

A team with 60 Commit deals totaling $4.2M, 90 Best Case deals totaling $5.8M, and historical Commit slip of 5 percent would forecast: likely $4.2M plus 65 percent of $5.8M equals $7.97M; best $10.0M; worst $3.99M. The three numbers are reported together with per-segment breakdowns, updated weekly, and compared against the team quota of, for example, $8.0M to see where coverage and conversion need to improve.

What is a Commit forecast versus a Best Case forecast?

Commit is the number a rep delivers unless something external breaks. Best Case is the stretch number if two or three things go right. Commit should be defensible with evidence on every deal. Best Case is the ceiling you plan upside against. The gap between Commit and Best Case tells you about pipeline quality: a healthy gap sits in the 30 to 50 percent range of Commit, wider than that signals thin coverage, narrower signals an over-cautious team.

How accurate should a sales forecast be?

Target under 10 percent error four weeks out and under 5 percent one week out, measured against actuals at close. Teams running weekly submit cadence with hygiene gating consistently hit those numbers. Measure accuracy on an eight-week-out basis as well, because by week 12 the Commit has been scrubbed and reshaped into something closer to the actual, which flatters the near-term accuracy metric.

Who owns the sales forecast?

Reps own their deal-level category calls. First-line managers own their team roll-up and the judgment overlay. The head of sales owns the number submitted to finance, which rolls up every team. Finance owns the planning number used for payroll, hiring, and board commitments, which is typically Commit plus a conservative portion of Best Case. Clear ownership at each layer prevents the common failure mode where everyone has an opinion on the number and no one actually owns the accuracy outcome.

Forecast to within 5 percent of actuals, every single week

Strkr Forecasting gives you the categories, the weekly submit cadence, the leading-indicator views, the three-scenario range, and the AI-assisted drift detection you need to run this entire playbook without exporting to a spreadsheet. Submit on Friday, land the quarter, and keep finance and the board on the same number instead of three different spreadsheet versions nobody fully trusts.

Try it free. Bring your team next week.

No sales call, no migration consultant, no four-month implementation. Enter your card, get 14 days of the full Pro tier, cancel any time before day 14 with zero charge. Spin up a workspace, import your CSV, and have something useful before lunch.