Commission Forecast

What is a commission forecast?

A commission forecast is a projection of expected commission based on the pipeline and closed deals that exist right now. It answers the question what am I on track to earn?, or, from the other side of the house, what are we on track to owe?

Those are the same calculation viewed by two different people, and that dual audience is the whole character of the term. A rep's earnings forecast and a CFO's commission expense forecast are built from the same pipeline, the same plan, and the same rates. They just get used for opposite purposes: one to motivate, one to fund.

It is probabilistic, not hypothetical. That is what separates it from a commission estimator, which models a deal the rep invents. A forecast starts from deals that already exist and weights them by the likelihood they close. The estimator asks if. The forecast asks how likely.

The two audiences

The gap in the bottom two rows is where most forecasting pain lives. Reps forecast the pipeline they want. Finance needs the pipeline that will actually convert. When both parties build from the same underlying data, that difference becomes a conversation about probability, which is productive. When they build from different spreadsheets, it becomes an argument about whose numbers are real, which is not.

A worked example

Maya is at $150,000 of her $200,000 quarterly quota, paying 8% up to quota and 12% above it. She has three open deals: $30,000 at 90% probability, $40,000 at 50%, and $60,000 at 20%.

Maya is planning her year around $25,600. Finance is accruing around $17,000. Neither is lying. They are applying different weightings to the same pipeline, and nobody has ever put the two numbers next to each other. The reconciliation, when it eventually happens, is a true-up and a difficult conversation.

What this means?

For Finance, the commission forecast is what makes the commission accrual defensible. An accrual is only as good as the pipeline projection underneath it, and a forecast built by hand from a CRM export, once a quarter, will be stale before it is finished. It is also a cash planning instrument: commission is a real cash outflow with a lag, and the forecast is what tells you how large the outflow will be and when.

For RevOps and sales leadership, the forecast is an early warning system. If the projection says the team lands at 70% of quota, that is knowable now, while there is still time to act, rather than at the end of the quarter when it is only reportable. And if the projected commission expense is running well ahead of plan, the plan may be paying out more than it was designed to, which is far cheaper to discover in week four than in month three.

Common mistakes

1. Forecasting on unweighted pipeline

Counting every open deal at full value produces a number that is reliably wrong and reliably too high. It is the most common forecasting error and the easiest to fix.

2. Applying a flat rate to projected revenue

Commission is not linear. Multiplying forecast revenue by an average rate ignores tiers, accelerators, thresholds, and caps, and the error compounds precisely when it matters most, which is when the team is near or above quota.

3. Reps and Finance forecasting separately

Two forecasts built from two datasets will never agree, and the disagreement will surface as a variance rather than as a conversation.

4. Forecasting only revenue, never commission expense

Most companies forecast bookings carefully and commission not at all, then treat the resulting expense as a surprise every quarter. It is the most predictable large expense in the business, and it is routinely the least predicted.

How Visdum handles commission forecasting

Commission expense is usually forecast, if at all, by exporting the pipeline to a spreadsheet and applying an average rate to it. That method cannot see tiers or accelerators, which means it is least accurate exactly when the numbers are largest.

Visdum forecasts commission by running the real pipeline through the real plan. Tiers, accelerators, splits, thresholds, and caps all apply as they would in an actual calculation, so a projected payout is produced the same way a real one is. Reps see what they are on track to earn from the deals they actually hold, and Finance sees the projected commission expense underneath the same pipeline, from the same source, which means the accrual rests on something defensible rather than on an average. When the pipeline moves, the forecast moves with it, so the number is current rather than a quarterly artifact.

Take a self-guided product tour to see this in action, or read the complete commission close playbook.

Related terms

Commission Estimator · Commission Accrual · Quota Attainment · Accelerator · Commission True-Up