{"id":1846,"date":"2026-10-11T17:09:17","date_gmt":"2026-10-11T14:09:17","guid":{"rendered":"https:\/\/fluidcrm.io\/blog\/?p=1846"},"modified":"2026-10-22T19:50:01","modified_gmt":"2026-10-22T16:50:01","slug":"sales-forecasting-for-small-teams","status":"publish","type":"post","link":"https:\/\/fluidcrm.io\/blog\/sales-forecasting-for-small-teams\/","title":{"rendered":"Sales Forecasting for Small Teams (With a Worked Example)"},"content":{"rendered":"\n

Someone on the team asks what you will close next month, and the honest answer is a shrug and a number that feels about right. Most guides answer that with six methods written for a company that has a finance department. You need one method and a table.<\/p>\n\n\n\n

Sales forecasting for a small team means multiplying each open deal’s value by the chance of closing for its stage, then adding the results by the month each deal should close. With about ten open deals, a team of 2 to 10 can do it in about 20 minutes from the board it keeps in a CRM like Fluid CRM.<\/strong><\/p>\n\n\n\n

This guide shows the method with a full example, how to pick the percentages when you have only a few closed deals and when you can skip forecasting altogether.<\/p>\n\n\n\n

<\/span>What Sales Forecasting Is and the One Method a Small Team Needs<\/span><\/h2>\n\n\n\n

A sales forecast is the amount you expect to close in each of the next few months, worked out from the deals you have open today.<\/p>\n\n\n\n

It helps to keep three numbers apart. Your target is what you want to sell, your pipeline value is every open deal added up at full price and your forecast is what you expect to close once you admit that most open deals will not.<\/p>\n\n\n\n

At Fenixtal we generated 12M\u20ac+ in pipeline for 50+ B2B clients. That figure is pipeline and not revenue, because a deal on a board is a chance and not a sale.<\/p>\n\n\n\n

The method that fits a small team is the stage-weighted forecast, which you will also see called a weighted pipeline or opportunity stage forecasting. You take each open deal, multiply its value by the chance that a deal at that stage ends up won and add the results together by the month you expect each deal to close.<\/p>\n\n\n\n

Forecast = sum of (deal value \u00d7 chance of closing for its stage)<\/strong><\/p>\n\n\n\n

You need three things for every deal, which are its value, its stage and the month you expect it to close. If you keep deals on a board in a sales CRM for small teams<\/a>, you already have the first two.<\/p>\n\n\n\n

The stages have to mean the same thing to everyone, or the percentages mean nothing. If yours are fuzzy, fix them first with this guide to sales pipeline stages<\/a>.<\/p>\n\n\n\n

<\/span>A Sales Forecast Example You Can Copy<\/span><\/h2>\n\n\n\n

Here is a made-up team of three with ten open deals. Their pipeline has four open stages and each stage has a chance of closing, with Enquiry at 10%, Discovery call at 20%, Proposal sent at 30% and Verbal yes at 50%.<\/p>\n\n\n\n

These percentages are a starting point and not a benchmark. No standard set exists, and the same stage gets a different number in every guide you read. The next section shows how to work out your own.<\/p>\n\n\n\n

Deal<\/th>Value<\/th>Stage<\/th>Chance<\/th>Weighted value<\/th>Close month<\/th><\/tr><\/thead>
Alder Dental<\/td>$10,000<\/td>Verbal yes<\/td>50%<\/td>$5,000<\/td>April<\/td><\/tr>
Birch Logistics<\/td>$8,000<\/td>Proposal sent<\/td>30%<\/td>$2,400<\/td>April<\/td><\/tr>
Cedar Accounting<\/td>$5,000<\/td>Proposal sent<\/td>30%<\/td>$1,500<\/td>April<\/td><\/tr>
Dune Fitness<\/td>$12,000<\/td>Proposal sent<\/td>30%<\/td>$3,600<\/td>May<\/td><\/tr>
Elm Property<\/td>$6,000<\/td>Discovery call<\/td>20%<\/td>$1,200<\/td>May<\/td><\/tr>
Fjord Hotels<\/td>$20,000<\/td>Proposal sent<\/td>30%<\/td>$6,000<\/td>May<\/td><\/tr>
Grove Legal<\/td>$10,000<\/td>Discovery call<\/td>20%<\/td>$2,000<\/td>June<\/td><\/tr>
Heron Vets<\/td>$4,000<\/td>Discovery call<\/td>20%<\/td>$800<\/td>June<\/td><\/tr>
Iris Solar<\/td>$15,000<\/td>Enquiry<\/td>10%<\/td>$1,500<\/td>June<\/td><\/tr>
Juno Brewing<\/td>$5,000<\/td>Enquiry<\/td>10%<\/td>$500<\/td>June<\/td><\/tr>
Total<\/td>$95,000<\/td><\/td><\/td>$24,500<\/td><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Now add the weighted values by month.<\/p>\n\n\n\n

Month<\/th>Open deals at full value<\/th>Forecast<\/th><\/tr><\/thead>
April<\/td>$23,000<\/td>$8,900<\/td><\/tr>
May<\/td>$38,000<\/td>$10,800<\/td><\/tr>
June<\/td>$34,000<\/td>$4,800<\/td><\/tr>
Total<\/td>$95,000<\/td>$24,500<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

<\/span>How to fill in the table<\/span><\/h3>\n\n\n\n

Start with a blank copy of the first table. These six columns are all it needs.<\/p>\n\n\n\n

Deal<\/th>Value<\/th>Stage<\/th>Chance<\/th>Weighted value<\/th>Close month<\/th><\/tr><\/thead>
<\/td><\/td><\/td><\/td><\/td><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    \n
  1. List every open deal with its value and its current stage.<\/li>\n\n\n\n
  2. Write the chance of closing for that stage in the fourth column.<\/li>\n\n\n\n
  3. Multiply value by chance to get the weighted value.<\/li>\n\n\n\n
  4. Write the month you honestly expect a yes or a no.<\/li>\n\n\n\n
  5. Add the weighted values for each month.<\/li>\n<\/ol>\n\n\n\n

    Deals you have already won stay out of the table. They are sales you have made, so they belong in this month’s results and not in a forecast of what is still open.<\/p>\n\n\n\n

    If you would rather not do the multiplying by hand, our free sales forecasting calculator<\/a> does it for you.<\/p>\n\n\n\n

    <\/span>How to read the result<\/span><\/h3>\n\n\n\n

    The team has $95,000 in open deals and should expect about $24,500 of it over three months. That gap is the whole point of a forecast, because planning a hire around $95,000 would be planning around money that mostly never arrives.<\/p>\n\n\n\n

    No single month will land on its number. A deal closes at full value or at zero, and with only ten open deals one deal landing a month late changes the whole month. Over several months the totals come out close when the percentages are honest.<\/p>\n\n\n\n

    June looks thin at $4,800, and that is useful to know in April. It tells the team that June depends on deals that are barely started, so the work this month is finding new ones.<\/p>\n\n\n\n

    <\/span>How often to redo it<\/span><\/h3>\n\n\n\n

    Rebuild the forecast once a month and update it once a week. The weekly update is quick if you do it during your pipeline review<\/a>, where stages and close months get corrected anyway. That same weekly slot is a good time to send the five numbers in our weekly sales report template<\/a>.<\/p>\n\n\n\n

    At the end of each month, put what you really closed next to what you forecast. After three or four months you will see if your percentages are too hopeful, and that comparison teaches you more than any formula.<\/p>\n\n\n\n

    <\/span>How To Choose Honest Stage Percentages From a Few Closed Deals<\/span><\/h2>\n\n\n\n

    A stage percentage tells you how many of the deals that ever reached a stage ended up won.<\/p>\n\n\n\n

    You can work it out from your own history, even a short one. Take your last 30 closed deals and follow two rules while you count.<\/p>\n\n\n\n