How to build a sales budget from CRM data

Short answer

Build a sales budget from CRM data in three steps: pull your win rate, average deal size and sales cycle length; split last year's revenue into existing-customer business and new-customer business; then convert the target into a monthly opportunity count. A budget is a decision; a forecast is how you measure it.

What is a sales budget?

A sales budget is the revenue you commit to closing in a period, broken down by month, customer type and product. A sales forecast is your expectation of what will actually land in that same period.

The difference matters. The budget is fixed at the start of the period and becomes the basis for commission plans, hiring and inventory. The forecast gets updated monthly. Mix the two and the budget is rewritten every month, so nobody can see what was missed.

Which numbers do you pull from your CRM?

Four numbers are enough, and your CRM or ERP already holds all of them:

Closed revenue: the sum of opportunities marked won in the last 12 months.
Average deal size: closed revenue divided by the number of won opportunities.
Win rate: won opportunities divided by won plus lost opportunities.
Sales cycle length: the average number of days from opening an opportunity to closing it.

If you cannot produce these four, the problem is not the budget — it is the data. When half the records are incomplete, the budget comes out half wrong.

How do you calculate the base from history?

Your base is the revenue that will arrive next year even if you win no new customers. Split last year's closed revenue in two: repeat and renewal business from existing customers, and customers you sold to for the first time.

Worked example: last year you closed 24 million. Fifteen million came from existing customers, nine million from new ones. If you retain 85 percent of your existing customers, your base is 12.75 million. Set a 30 million budget and you need to find 17.25 million in new business.

Without that split, the target stays one large number and nobody knows which part they own.

How do you convert the target into opportunities?

A revenue target is not a budget until it reaches a rep's calendar. The conversion order is: revenue, deal count, opportunity count, monthly opportunities.

In the example above you need 17.25 million in new business. At an average deal size of 250 thousand, that is 69 new deals. At a 25 percent win rate, you need to open 276 opportunities. Because the cycle runs 90 days, anything opened in the final quarter will not land inside the budget year — so in practice you need about 30 new opportunities a month across the first nine months.

That math makes the budget arguable. "Thirty opportunities a month is too many" is a far more concrete objection than "the target is too high."

How do you split the budget by product and customer type?

A single annual number is useless to everyone. Split the budget along three dimensions: month, customer type and product group.

When splitting by month, use last year's seasonality rather than dividing by twelve. In most B2B businesses summer drops off and the last two months of the year spike. An evenly divided budget creates needless panic in January and false comfort in December.

When splitting by customer type, keep the existing-versus-new distinction. When splitting by product, start from last year's product-level revenue mix; expecting all your growth from one product is the most fragile budget you can write.

Why do sales budgets miss?

Four causes explain most of the gap:

The base is inflated: customer churn is ignored and all of last year is treated as guaranteed.
Cycle length is skipped: an opportunity opened in December is budgeted as if it closes the same year.
The data is incomplete: lost deals are never closed out in the CRM, so the win rate looks better than it is.
Only one scenario is written: the downside was never calculated, so the first deviation makes the budget worthless.

Who writes the budget, and how often is it reviewed?

The sales manager produces the numbers, tests the assumptions with the team, and the founder or general manager approves them. Finance turns the budget into a cash flow plan.

The budget is set once a year and reviewed quarterly; the forecast is updated monthly. Do not change the budget at a review. Write down the gap between budget and forecast, and the reason for it.

If the gap runs the same direction for three quarters, the problem is not the budget but the assumption: your win rate or your average deal size does not reflect reality.

How many scenarios do you need?

Three are enough, and all three come from the same CRM data. For the downside, take 80 percent of your current win rate; for the upside, 120 percent; hold the opportunity count constant. The spread tells you the range your cash flow has to survive.

A budget that gives one number pulls every bad month into an argument about the target itself. A budget that gives three pulls the argument back to the assumption — and the assumption is the part you can fix.

FAQ

What is the difference between a sales budget and a sales forecast?

The budget is a decision made at the start of the period and it stays fixed. The forecast is your expectation of what will land, updated monthly. One is the target, the other is the measurement.

Can a new company build a budget with no history?

Yes, but start from activity rather than revenue. Write down how many meetings you can run, use your own first three months' win rate instead of an industry average, and revise every quarter.

How do I split the budget across the sales team?

Split it by portfolio size and customer type, not evenly by headcount. A portfolio heavy in existing customers has a high base and a lower new-business target.

What if my win rate looks wrong in the CRM?

Close out the stale open opportunities first. An open deal that has not been touched in more than 90 days makes your win rate look higher than it is.

What period should the budget cover?

The same period as your fiscal year, in the currency you sell in. Track currency effects on a separate line rather than rewriting the budget on every rate move.

Closync AI is an AI layer that turns sales conversations into high-quality CRM/ERP data and that data into sales decisions.

Last updated: 25 October 2026