Sales Forecasting with a CRM: A Practical Guide

Why forecasting matters

• Plan inventory and production.
• Manage cash flow and working capital.
• Decide when to hire.
• Set realistic targets for the team.
• Spot shortfalls early enough to act.

Build on a clear pipeline

A forecast is only as good as the pipeline behind it. Define clear stages — such as enquiry, qualified, proposal, negotiation and won — with criteria for moving between them. Our sales pipeline stages guide explains how to set them up.

Weighted pipeline forecasts

Assign each stage a probability of closing based on your past win rates. Multiply each deal value by its stage probability and add them up for a weighted forecast. For example, a deal at proposal stage with a historical 40% win rate contributes 40% of its value. Update the probabilities as you collect more data.

Use history and trends

Combine pipeline data with past sales patterns: seasonality, average deal size, sales cycle length and repeat business. Businesses with many small transactions may rely more on historical trends, while those with fewer large deals rely more on the pipeline.

Review regularly

• Hold a weekly or fortnightly pipeline review.
• Check deals with no recent activity or past close dates.
• Compare forecast with actual results monthly.
• Ask salespeople for evidence, not optimism.

Consistent lead follow-up keeps pipeline data fresh.

A simple monthly forecasting routine

• Clean the pipeline: close lost deals and update stages.
• Check expected close dates and deal values with each salesperson.
• Calculate the weighted forecast for the month and quarter.
• Add expected repeat business from existing customers.
• Compare with targets and agree actions to close gaps.
• Record the forecast so it can be compared with actual results.

Using forecasts across the business

A forecast is useful only when other teams act on it. Share it with purchase and production to plan inventory, with finance to plan cash and borrowing, and with HR to plan hiring. Update the forecast when large deals move or are lost. Over time, comparing forecasts with actual results shows how accurate your stage probabilities are and where the sales process needs improvement, such as qualification or follow-up.

Forecasting for new businesses

New businesses have little history, so forecasts rely more on pipeline data, market research and assumptions about conversion rates. Start with conservative estimates, document your assumptions and update them monthly as real data arrives. Within a few months, actual numbers will replace guesses and the forecast will become more reliable. Prepare a cautious scenario as well as an expected one, so that cash planning is not built on hope.

Common mistakes

Inflated pipelines with dead deals, inconsistent stage definitions and poor data entry all distort forecasts. Keep records clean using our CRM data quality guide. ATTPL CRM provides pipeline views and reports for growing sales teams. For broader business metrics, see Ashok Godara's founder dashboard, and for working capital planning, ATTPL Finance.

Frequently asked questions