Sales forecasting consulting

Sales forecasting consulting
that carries the forecast through to commission expense.

Our sales forecasting consulting connects pipeline to bookings, attainment and the commission expense that follows. Finance gets an accurate forecast of variable pay by period. Sales leaders see which reps will reach quota. Both come from the same pipeline data and plan rules, and from over a decade inside ICM systems.

Where sales forecasting loses the comp line.

Most forecasts stop at bookings. The cost of those bookings, and who earns what, comes later and from a different model.

01

Commission expense as a flat percentage

Many finance models forecast commission expense as a fixed share of bookings. Real plans don't pay that way. Accelerators raise the rate above quota, thresholds pay nothing below them, and SPIFs add cost in specific quarters. When attainment skews high, the flat percentage understates expense, and the gap shows up at quarter close.

02

A bookings forecast without attainment

A forecast that says the company will book $12 million says nothing about which reps will hit quota. The same total can come from a broad middle or from two enterprise deals. Those produce different payouts, different accelerator spend and different hiring decisions for next year.

03

Pipeline data that doesn't match crediting

The CRM forecast counts opportunities at their amount. The comp plan may credit first-year ARR only, split credit with an overlay, or pay on invoice in a later period. A forecast built on raw pipeline misstates both attainment and the timing of commission payments.

04

Accruals that ignore the payment trigger

Under ASC 606 and the cost rules in ASC 340-40, commissions that are incremental costs of winning a contract are usually capitalized and amortized. Some commissions are earned in one period and paid in the next. A forecast that skips payment triggers and amortization puts expense in the wrong period, and cash flow plans miss.

05

Most teams run three forecasts

Sales forecasts the quarter in the CRM. Finance forecasts revenue in its planning model, and the comp admin estimates payouts in a spreadsheet. Each uses different data sources and assumptions. When they disagree, the meeting goes to reconciling numbers instead of making strategic decisions.

06

No scenarios before the plan launches

A new plan or quota change gets approved on a single expected case. Nobody models what it costs at 80%, 100% and 130% attainment. The first time anyone sees the cost of a strong year is when finance closes the books on it.

How our forecasting models connect revenue forecasting and comp.

We forecast in the order money moves: pipeline to credited bookings, bookings to attainment, attainment to payout, and payout to expense and cash.

Step 01

Historical data and past performance

We pull two or more years of historical data, including closed opportunities, stage history, credited bookings, attainment and payouts. We measure how past forecasts compared with results by stage, segment and rep, so you know where forecast accuracy breaks down today.

Step 02

Choose the forecasting method

We match the model to your motion. A bottom up model from current pipeline data and stage conversion fits most B2B sales. Time series analysis on historical revenue data helps with run-rate and renewal business. Predictive analytics on deal attributes can help where the history supports it. Many businesses blend these with a manager's call, and we measure each against actuals.

Step 03

Forecast attainment with the plan rules

We run the forecast through your comp plan's crediting, splits, thresholds, accelerator tiers, SPIFs, draws and clawbacks. The output is forecast attainment by rep, and the commission each rep earns at that attainment, by period. It uses the same rules your ICM platform applies.

Step 04

Commission expense for finance leaders

We turn forecast payouts into commission expense and cash, using your payment triggers and your ASC 606 capitalization and amortization schedule. Finance gets expense by period and by segment, plus the gap between earned and paid, ready for budgeting.

Step 05

Scenario planning for better decisions

We model what happens at different attainment levels and under plan or quota changes. That covers the cost of a strong year, the effect of a new accelerator tier, and what added headcount does to quota capacity and commission expense. Each scenario lists its assumptions, and finance gets lead time to adjust the accrual before more deals land above quota.

Step 06

A forecasting process that runs every period

Forecasting is an ongoing process, so we set the model to refresh from new data each week or month and compare forecast to actual. When economic conditions, market trends or other external factors shift, the assumptions are written down and easy to change. Your team gets the model, the documentation and training to run it.

What you get, and who it is for.

You end up with one forecast that sales, comp and finance all read from, and the model behind it.

What you get

A forecast of bookings and attainment by rep, team and segment

A commission expense forecast by period, using your real plan rules

Accrual and amortization schedules that match your ASC 606 policy

Scenario models at different attainment levels and plan changes

A forecast accuracy report comparing past forecasts with actuals

A documented model your team can refresh each period

Who it is for

Finance leaders whose commission expense forecast misses at quarter close

CFOs budgeting variable pay for next year's plan and quotas

RevOps teams whose CRM forecast and finance forecast never agree

Comp teams asked what a plan change will cost before it launches

Sales leaders making hiring decisions from quota capacity

Companies whose accelerators have pushed variable pay past budget

Related revenue analytics and planning services.

A forecast is only as good as the quotas and pipeline data behind it. These pages cover both.

Revenue analytics

Revenue analytics

The hub for analytics over comp and pipeline data, and the services next to this one.

Revenue analytics consulting

Quota attainment analysis

Commission dashboards

Planning and data

Quotas, territories and pipeline data

Forecast attainment depends on how quota was set and how clean the pipeline is.

Quota setting

Territory design

Revenue data engineering

Further reading

Background

What comp costs, and how the plan decides it.

The ROI of incentive compensation

What goes in a commission plan

What is sales performance management?

Sales forecasting questions.

What is sales forecasting?

Sales forecasting estimates the bookings or revenue the sales team will close in a given timeframe, usually a month, quarter or year. It draws on current pipeline data, historical close rates and the judgment of reps and managers. Finance uses it for budgeting, hiring decisions and cash flow planning, and revenue forecasting builds on it.

What is revenue forecasting?

Revenue forecasting estimates future revenue as it will be recognized, including new bookings, renewals, expansion and churn. A sales forecast estimates bookings, which feed the revenue forecast. A commission expense forecast sits between the two, because commissions usually follow bookings while revenue follows delivery.

What are the three types of forecasting?

The usual split is qualitative, time series and causal. Qualitative forecasting relies on judgment, such as a manager's call. Time series uses historical patterns. Causal models link revenue to drivers like pipeline, headcount and win rate. Most sales forecasts combine a pipeline-driven model with judgment.

What is a commission expense in accounting?

Commission expense is the cost of commissions earned by salespeople, recorded as a selling expense. Under ASC 606 and ASC 340-40, commissions that are incremental costs of obtaining a contract are generally capitalized and amortized over the expected benefit period. A practical expedient allows expensing when that period is one year or less. Your auditors set the policy, and we model to it.

Why does the sales forecast matter beyond sales?

The sales forecast feeds the business plan. Budgeting, hiring decisions, cash flow and strategic planning all depend on it, and so does the commission budget. When the forecast misses, decision making across the company runs on the wrong number until the next quarter's results correct it.

What external factors should a sales forecast include?

Market conditions, industry trends, pricing changes and customer behavior such as renewal timing or budget freezes in a segment. Most of these affect conversion rates and sales cycle length rather than pipeline volume. We add them as explicit assumptions in the model, so anyone can see what changed when the forecast moves.

Is commission a fixed or variable expense?

Variable. Commission rises and falls with bookings and attainment, and accelerators make it rise faster than bookings above quota. Base salary is the fixed part. That's why a flat percentage forecast fails in a strong year. The effective rate itself changes with attainment.

Should commission be based on gross or net?

It depends on what the company wants to pay for. Paying on net, after discounts or returns, protects margin and discourages heavy discounting. Paying on gross is simpler to calculate and explain. Whichever you pick, the forecast has to use the same basis, or forecast expense won't match payouts.

How does the forecast help set goals for next year?

It shows what the current team can produce at realistic attainment, which tells you how much quota to assign and how many reps you need. The same model shows what next year's sales goals will cost in commission expense, so finance and sales set goals and the comp budget from one set of numbers. Our quota setting work picks it up from there.

How accurate should a sales forecast be?

It depends on cycle length and deal mix. A business with many small deals can forecast the quarter closely by mid-quarter. A business that depends on a few enterprise deals will swing more. Measure forecast accuracy by segment over time, and check whether misses run consistently high or low. Consistent bias is easier to fix than noise.

What is the difference between forecast attainment and forecast accuracy?

Forecast accuracy measures how close the forecast came to the result. Forecast attainment is the share of the forecast the team delivered. A team can beat its forecast and still have poor accuracy. For comp, forecast attainment by rep is what drives the commission expense forecast.

What does a sales forecasting consultant do?

A sales forecasting consultant reviews how the current forecast gets built, measures its accuracy against past performance, and designs a forecasting process and model that hold up better. On our engagements the model also carries the forecast through to attainment and commission expense, which most forecasting work leaves out.

What are the four forecasting methods?

Lists vary. Four common sales forecasting methods are historical run-rate, opportunity stage weighting, time series analysis and multivariable models that combine pipeline, headcount and win rates. Each fits a different motion. We test the candidates against your past performance and keep the one that would have called recent quarters most closely.

How long does it take to build the forecast?

It depends on data quality and plan complexity. A forecast on clean CRM and ICM data with one or two plans can be working in a few weeks. Several plans, messy stage history or a new ASC 606 schedule take longer. We give a timeline after reviewing the data.

Tell us what your forecast leaves out.
We will tell you what it takes.

Bring your current forecast, your comp plan and last year's commission expense by quarter. We'll show you where the numbers diverge.

Start a conversation