How Do You Forecast Commission Expense?

Commission expense is forecast by running each rep's plan against that rep's expected attainment and adding up the results. The common shortcut, multiplying a blended commission rate by the total revenue forecast, produces a number that is close enough to pass review and wrong in a predictable direction. The gap comes from the shape of the attainment distribution, which a blended rate cannot represent.

Build it rep by rep

Start with a bookings forecast segmented to the rep level, then apply the actual plan each rep is on, including tier breakpoints, accelerators, any reduced rate below a threshold, and split credit rules. Sum the individual payouts.

The reason this matters is that accelerated rates concentrate cost at the top of the distribution. A team where every rep lands near 100 percent costs less than a team averaging the same 100 percent through a few reps at 160 percent and several at 70 percent, because the overperformers are paid on accelerated dollars while the underperformers still consume base plan cost. Any method that starts from an average will understate the second case.

Split credit deserves specific attention. When two reps are paid full rate on the same dollar, the effective commission rate is higher than the plan document implies, and that difference is invisible until the accrual arrives.

Use a forecast of what closes, not what is entered

The revenue input controls everything downstream. ORM finds that deals routinely close for less than the value carried in the CRM. As an illustration, take a pipeline carrying an 80,000 dollar average deal size against 40,000 dollars on closed-won business. A commission model fed from pipeline face value inherits that inflation on both sides of the calculation.

Coverage is not a usable input either. ORM's customers run pipeline coverage from 1.4x to 5x with most around 3.5x, and coverage says nothing about which deals convert, at what value, or in which period. Only about 20 percent of the value carrying an in-quarter close date on day one closes in that quarter, so a model that treats the visible pipeline as the source of the quarter will misstate both the revenue and the payout. Start from a sales forecast built on conversion behavior rather than from the coverage ratio.

Separate accrual from cash and reserve for clawback

Commission accrues when a deal books and pays out on a different schedule, sometimes after the first invoice clears and sometimes after a retention milestone. Forecast both. The accrual follows bookings and drives the expense line, while the cash outflow follows the payment calendar and drives the cash forecast, and reporting one as though it were the other creates variance that nobody can explain later.

Then reserve for reversal. Size the reserve from your own history of early churn and non-payment inside the clawback window rather than a round percentage, because a plan with a twelve month clawback and material first-year churn will see a meaningful share of accrued commission come back.

Re-forecast as the quarter moves

A compensation forecast built once at the start of the period ages the same way a revenue forecast does. Attainment shifts, deals move between reps, and the mix of accelerated and base dollars changes with them. Update the model on the same cadence as the revenue forecast so the two never disagree, and track variance between forecast and actual commission by rep. Persistent variance on the same rep usually points at a plan mechanic being applied differently than intended rather than at the forecast accuracy of the bookings number itself.