Using Your CRM to Forecast Revenue

Most small business owners have a rough sense of how next month might look financially. But “rough sense” is not a strategy. When you are deciding whether to hire someone, invest in marketing, or take on a new office, you need more than gut feeling.

Your CRM already holds the data you need to forecast revenue. Every deal in your pipeline, every conversion rate, every average deal value tells a story about what is coming. The trick is learning to read it.

Why revenue forecasting matters for small businesses

Revenue forecasting is not just for large corporations with finance teams and board meetings. For a small business, knowing what is likely to land over the next 30, 60, or 90 days affects real decisions:

Cash flow management. If you know a quiet month is coming, you can tighten spending or chase outstanding invoices earlier. If a strong month is approaching, you can plan investment with confidence.

Hiring decisions. Taking on a new team member is one of the biggest financial commitments a small business makes. A reliable forecast helps you determine whether you can sustain the cost.

Growth planning. Whether you are considering a new service line, a marketing push, or expanding to a new area, a forecast grounds those decisions in reality rather than optimism.

Stress reduction. The uncertainty of not knowing what is coming is one of the hardest parts of running a small business. Even an imperfect forecast replaces anxiety with information.

The data your CRM already holds

If you have been managing a sales pipeline in your CRM, you already have the raw materials for forecasting. The key data points are:

• Deal values. The expected revenue from each opportunity in your pipeline
• Pipeline stages. Where each deal currently sits in your sales process
• Historical conversion rates. What percentage of deals at each stage eventually close
• Average deal cycle. How long deals typically take from first contact to signed agreement
• Win/loss history. Which deals closed and which did not, along with the reasons

If some of this data is missing, that is a sign to start tracking it now. Even three months of consistent data gives you a foundation to work with.

Weighted pipeline forecasting

The most practical forecasting method for small businesses is weighted pipeline forecasting. It works by assigning a probability to each stage of your pipeline, then multiplying each deal’s value by that probability.

Here is an example. Suppose your pipeline has five stages, and you have tracked enough deals to know the approximate conversion rate at each stage:

Pipeline stage	Probability of closing	Deal example	Deal value	Weighted value
Initial enquiry	10%	Website redesign for a retailer	8,000	800
Discovery call completed	25%	Branding project for a startup	4,500	1,125
Proposal sent	40%	Monthly retainer for an accountancy firm	12,000	4,800
Verbal agreement	75%	E-commerce build for a clothing brand	15,000	11,250
Contract sent	90%	SEO package for a dental practice	3,600	3,240
Total pipeline value			43,100	21,215

The total pipeline value is 43,100 pounds, but the weighted forecast is 21,215 pounds. That weighted figure is a far more realistic projection of what will actually land.

The key insight is that not every deal in your pipeline will close. Weighting forces you to acknowledge that reality and plan accordingly.

Calculating your stage conversion rates

Your probabilities should not be guesses. They should come from your own data. Here is how to calculate them:

1. Export your closed deals from the last 6 to 12 months
2. For each pipeline stage, count how many deals passed through it
3. Divide the number of deals that eventually closed by the total number that reached each stage
4. That percentage becomes your stage probability

For example, if 50 deals reached your “Proposal sent” stage over the past year and 20 of them eventually closed, your conversion rate for that stage is 40 percent.

If you are just starting out and do not have enough historical data, use conservative estimates. It is better to forecast low and be pleasantly surprised than to forecast high and face a cash shortfall. The Xero small business guide to cash flow forecasting ↗ offers useful benchmarks for businesses building their first projections.

Building a 30, 60, and 90 day forecast

A single forecast number is useful, but a time-based forecast is far more powerful. Break your pipeline down by expected close date:

30 day forecast. Include deals you expect to close within the next month. These should be at your later pipeline stages (verbal agreement, contract sent). This is your most reliable number.

60 day forecast. Add deals at mid-pipeline stages (proposal sent, discovery completed). Apply the appropriate weightings. This number is less certain but still useful for planning.

90 day forecast. Include earlier-stage deals as well. This gives you a longer-term view, but treat it as directional rather than precise.

Review these forecasts weekly. As deals move through stages, stall, or drop out, your projections update automatically if your CRM data is current.

Seasonal adjustments

Raw pipeline data does not account for seasonality, and most small businesses have seasonal patterns. You might close more deals in January when businesses set new budgets, or see a slowdown in August when decision-makers are on holiday.

To adjust for this:

• Track your monthly revenue for at least 12 months
• Calculate each month’s revenue as a percentage of your annual total
• Apply a seasonal multiplier to your weighted forecast

If August historically accounts for only 5 percent of your annual revenue (compared to an even 8.3 percent per month), you should discount your August forecast by roughly 40 percent. Conversely, if January is consistently strong, adjust upward.

Seasonal adjustment turns a decent forecast into a reliable one. The GOV.UK guidance on managing cash flow ↗ reinforces why understanding these patterns is critical for smaller firms.

Common forecasting mistakes

Even with good data, forecasting goes wrong when you fall into these traps:

Counting stale deals

That deal worth 10,000 pounds that has been sitting at “Proposal sent” for three months? It is probably dead. If a deal has not moved stages within your normal cycle time, either update it or remove it from your forecast. Stale deals inflate your projections and lead to disappointment.

Using aspirational deal values

It is tempting to log the maximum possible value for each deal. The client mentioned they might want the premium package, so you log the premium price. Be honest. Log the most likely value, not the best case. You can always adjust upward if the scope genuinely expands.

Ignoring lost deals

Your forecast is only as good as your conversion rates, and your conversion rates are only accurate if you properly record lost deals. If you only track wins, your conversion rates will be artificially high and your forecasts will be too optimistic. Make sure you are tracking the metrics that matter and recording every outcome.

Forecasting without updating

A forecast is not a one-time exercise. It needs to reflect the current state of your pipeline. If you built a forecast on Monday but three deals changed by Thursday, your forecast is already wrong. Keep your pipeline current and your forecast updates itself.

Using your forecast to make better decisions

The point of forecasting is not to have a spreadsheet. It is to make better business decisions. Here is how your forecast connects to real choices:

Hiring. If your 90 day forecast shows consistent growth and your pipeline is healthy, you can hire with confidence. If it shows a plateau, hold off and focus on filling the pipeline first. Understanding how to convert enquiries into clients becomes even more important when your forecast reveals conversion gaps.

Marketing spend. If your pipeline is thin, your forecast gives you an early warning. Invest in marketing now so that new leads start entering the pipeline before revenue dips. If your pipeline is overflowing, you might reallocate budget elsewhere.

Pricing. If your forecast consistently exceeds capacity (more work coming in than you can handle), that is a signal to raise prices. If it is consistently below target, examine whether your lead scoring is attracting the right prospects.

Cash reserves. Your forecast helps you determine how much cash buffer you need. If seasonal dips are predictable, you can set aside reserves during strong months to cover the quieter ones.

Setting up forecasting in your CRM

Most CRMs support forecasting natively or through custom reports. Here is what to configure:

Step 1: Ensure every deal has a value

Go through your current pipeline and make sure every opportunity has a realistic deal value attached. No value means no forecast.

Step 2: Add expected close dates

Each deal should have a target close date. This does not need to be exact, but it should be honest. Review and update these dates during your weekly pipeline review.

Step 3: Define your stage probabilities

Based on your historical data (or conservative estimates if you are starting fresh), assign a probability to each pipeline stage.

Step 4: Build your forecast view

Create a dashboard view that shows your weighted pipeline value broken down by time period. Many CRMs offer this as a built-in report. If yours does not, a simple export to a spreadsheet works just as well.

Step 5: Review weekly, refine quarterly

Check your forecast every week as part of your pipeline review. Every quarter, compare your forecast to actual results. Adjust your stage probabilities based on what really happened.

Start forecasting this week

You do not need perfect data to start. If you have a pipeline with deal values and stages, you can build a weighted forecast today. It will not be perfectly accurate, but it will be vastly better than guessing.

The businesses that grow steadily are not the ones with the best products or the most leads. They are the ones that see what is coming and plan accordingly. Your CRM already holds the data. Use it.

Start with your current pipeline. Apply conservative weightings. Review weekly. Refine as you learn. Within three months, you will wonder how you ever made financial decisions without it.