Blog · Sales and revenue
How to Forecast Revenue for a Small Business: 3 Simple Methods and a Worked Example
The short answer
A useful small business revenue forecast adds three pieces: revenue you already have (contracts, retainers, repeat customers), your weighted pipeline (each open deal's value × its chance of closing), and new business you expect from your lead numbers (leads × close rate × average sale).
Forecast monthly for the next 12 months, update it once a month, and give a low, likely, and high case instead of one number. Then compare forecast to actual every month. Being within about 10% for the next quarter is a reasonable goal for most small businesses; if you miss by more, the cause is usually stale deals in the pipeline or close dates that keep slipping.
3 ways to forecast revenue
| Method | How it works | Best for | Watch out for |
|---|---|---|---|
| Trend (run rate) | Start from the same months last year or your recent monthly average, then adjust for growth and seasonality | Steady businesses with lots of small sales, such as retail, restaurants, and repeat services | Assumes the future looks like the past; misses big wins and losses |
| Weighted pipeline | Multiply each open deal's value by the probability for its stage and add them up for the month it should close | Businesses with a sales process and deals worth tracking one by one | Only as good as your CRM; stale deals and optimistic close dates inflate it |
| Driver-based | Build revenue from its drivers: leads × close rate × average sale, plus existing customers × retention × average revenue | Planning further out, recurring revenue, and testing "what if" changes | Needs a few months of reliable conversion and retention data |
Most small businesses get the best result by combining them: use what's committed for revenue you already have, the weighted pipeline for the next one to three months, and driver-based numbers for new business further out. Use the trend method as a sanity check on the total.
Starter stage probabilities
The weighted pipeline needs a probability for each stage. Your own history is best: of the deals that reached each stage in the last year, what share were won? Until you have that, these are reasonable starting points for a simple sales process.
| Stage | Starting probability |
|---|---|
| Qualified (real need, budget, timeline) | 10% |
| Discovery or needs meeting held | 20% |
| Proposal or quote sent | 40% |
| Negotiation or verbal yes | 70%–80% |
| Signed or paid | 100% |
Use the stage probability, not each salesperson's personal guess. Gut-feel percentages tend to be optimistic and change from rep to rep. If your proposal win rate is 25%, use 25% for that stage. How to calculate your close rate shows how to get the number.
A worked example: next quarter's forecast
A 12-person B2B service business is forecasting the next quarter.
| Piece | Calculation | Forecast |
|---|---|---|
| Committed revenue | Signed retainers and scheduled project work for the quarter | $180,000 |
| Pipeline: proposal stage | $120,000 in open proposals × 40% | $48,000 |
| Pipeline: negotiation stage | $60,000 in deals at verbal yes × 70% | $42,000 |
| Pipeline: discovery stage | $100,000 in early deals × 10% (adjusted down because few will close this quarter) | $10,000 |
| New business from new leads | 60 expected leads × 15% close rate × $4,000 average sale | $36,000 |
| Likely case | $316,000 |
Now add a range around it:
- Low case: $240,000. Committed revenue, plus only the negotiation-stage deals, plus half the new-lead business ($180,000 + $42,000 + $18,000).
- Likely case: $316,000. The full calculation above.
- High case: about $354,000. Pipeline converts 20% better than usual and new-lead business comes in 50% higher.
Plan spending and hiring on the low case, set goals on the likely case, and know what you'd do if the high case happens. If the low case doesn't cover your costs, check it against your break-even point now, while there's still time to act.
How to build your forecast in 6 steps
- Clean the pipeline first. Close out deals with no activity in 60 to 90 days, fix missing amounts and close dates, and make sure every deal is in the right stage. A CRM cleanup often changes the forecast more than any formula.
- List committed revenue by month. Contracts, retainers, subscriptions, and booked work. Subtract expected cancellations using your retention rate.
- Weight the pipeline. Apply your stage probabilities to each open deal and put it in the month it's expected to close. Push deals out if the close date has already slipped twice.
- Add new business from your drivers. Expected leads × close rate × average sale, timed by your typical sales cycle. A lead that comes in this month with a 60-day cycle is revenue two months from now.
- Adjust for seasonality. Compare each month with the same month last year. If December is always slow, the forecast should say so.
- Set the range and review monthly. Build the low, likely, and high cases, then compare last month's forecast with actual results before you update.
How to measure forecast accuracy
Forecast error = (actual revenue − forecast revenue) ÷ forecast revenue
If you forecast $100,000 and brought in $92,000, your error is −8%. Track it every month for the month just ended and for the quarter. Look at the direction as well as the size: if you're always above forecast, your probabilities are too low; if you're always below, deals are staying in the pipeline too long or salespeople are entering optimistic close dates.
Common forecasting mistakes
- Counting dead deals. A deal nobody has touched in three months isn't pipeline.
- Forgetting churn. Revenue from existing customers isn't guaranteed. Build in your normal cancellation rate.
- Ignoring the sales cycle. New leads rarely turn into revenue in the same month.
- One number, no range. A single figure hides the risk. A range shows how much you can safely commit.
- Forecasting revenue but not cash. Revenue booked isn't cash collected. Feed your forecast into a 13-week cash forecast.
Where AI and automation help
- Flagging stale deals with no recent activity or close dates in the past, before they reach the forecast.
- Updating the CRM automatically from calls, emails, and meetings, so stages and next steps are current.
- Calculating your real stage probabilities from past won and lost deals instead of using guesses.
- Building the monthly report and a plain-English summary of what changed since last month and why.
None of it works without consistent data, so fix the pipeline first. Add forecast versus actual to your KPI scorecard, and see AI use cases by department for more ideas.
Frequently asked questions
How do I forecast revenue for a small business?
Add three pieces for each month: revenue already committed from contracts, retainers, and repeat customers; your weighted pipeline, which is each open deal's value multiplied by the probability for its stage; and expected new business, which is expected leads multiplied by close rate and average sale. Adjust for seasonality and update the forecast monthly.
What is a weighted pipeline forecast?
A weighted pipeline forecast multiplies the value of each open deal by the chance it will close, based on its sales stage, and adds the results. For example, a $10,000 deal at a stage that closes 40 percent of the time counts as $4,000. Using your own historical win rates by stage gives the most accurate result.
How accurate should a small business revenue forecast be?
Being within about 10 percent of actual revenue for the next quarter is a reasonable goal for most small businesses. Track forecast error each month by dividing the difference between actual and forecast by the forecast, and look for a pattern of always missing high or low.
How far ahead should a small business forecast revenue?
Forecast monthly for the next 12 months and update it every month. The next one to three months should rely mostly on committed revenue and the weighted pipeline, while months further out rely more on lead volume, close rate, and retention assumptions.
What is the difference between a revenue forecast and a budget?
A budget is a plan for what you intend to earn and spend over a period, usually set once a year. A revenue forecast is an updated estimate of what you expect to actually earn, based on current pipeline and results. Comparing the two each month shows whether you are on track.
Why is my sales forecast always wrong?
The most common causes are stale deals that stay in the pipeline, close dates that keep slipping, probabilities based on gut feel instead of history, ignoring customer churn, and expecting new leads to close faster than your sales cycle allows. Cleaning the pipeline and using stage-based probabilities usually helps the most.
See what your numbers are really telling you
Pipeline health, forecast accuracy, and the data behind them are areas we review in every RevOps audit. The free Profit Check shows where your costs and margin stand against healthy ranges for your business type in about 3 minutes.
The Profit Snapshot ($2,500, about 2 weeks) finds the biggest quick wins. The AI Operations & Profit Audit ($7,500, about 3–4 weeks) covers your whole operation with a 30/60/90-day plan ranked by margin impact.
Take the Free Profit Check See audit optionsThis article is general guidance. Stage probabilities and accuracy targets are starting points; your own historical data is a better guide. For financial planning decisions, consult your accountant or financial advisor.