Sales forecasting: methods and tools for very small and small businesses

Anticipating sales for the next month, the following quarter, or the entire year: this is one of the most strategic exercises a small business owner can undertake. Yet, according to a Gartner study cited by several industry experts, the average accuracy of sales forecasts is only around 57%. In other words, nearly half of projected revenue either doesn't materialize or wasn't anticipated.

This figure is not inevitable. It simply reveals that sales forecasting is often approached as an intuitive exercise rather than a truly structured process. For very small businesses and SMEs, which have limited resources and a Treasury More sensitive to shocks, rigorous forecasting is not a luxury reserved for large groups. It is a condition for survival and growth.

This article gives you the keys to understanding what sales forecasting really is, why it is vital for your business, which methods to use depending on your profile, how to build it step by step and which mistakes to absolutely avoid.

Definition and challenges of sales forecasting for very small and small businesses

What is sales forecasting?

Sales forecasting involves estimating the revenue a company will generate over a given period: a month, a quarter, a year. It relies on concrete data such as sales history and current opportunities in the sales pipeline, conversion rates, seasonality and market trends.

It differs from the sales target, which represents what you want to achieve. The sales forecast, on the other hand, represents what you estimate you will actually achieve based on real-world conditions. A good forecast can be lower or higher than the target: that's precisely its value, because it provides an honest rather than an aspirational view.

Cash flow: the number one issue

For a very small business (TPE) or a small or medium-sized enterprise (SME), cash flow is the lifeblood of any operation. According to the 2025 report from the Business Financing Observatory published by the Bank of France, the median cash flow of micro-enterprises represented 65 days of revenue in 2024, a level certainly higher than the pre-Covid period, but one that masks significant disparities. At the same time, 78% of TPEs surveyed by the Independent Business Owners' Union (Syndicat des Indépendants) in January 2025 reported experiencing cash flow difficulties, with 22% describing them as significant.

Reliable sales forecasting allows you to anticipate cash inflows, plan cash outflows, and avoid cash flow gaps that force you to seek emergency, often costly, financing. Without this visibility, a manager is navigating blindly, making spending commitments that actual revenues will not cover.

Inventories and supplies

For companies that sell physical products, sales forecasting directly impacts inventory management. Overestimating sales ties up capital in unsold goods. Underestimating them risks stockouts that drive customers to the competition. Accurate sales forecasting allows companies to calibrate supplier orders, negotiate better purchasing terms, and reduce storage costs.

Recruitment and team sizing

Anticipating sales also means anticipating human resource needs. If forecasts indicate a sustained increase in activity, recruitment can be planned several weeks in advance, allowing sufficient time to find the right candidate and integrate them into the team. Conversely, if the forecast indicates a slowdown, it's possible to adjust the workload before the situation becomes critical.

Bpifrance's July 2025 business survey confirms this direct link: 60% of very small and small businesses cite weak demand as the primary obstacle to investment, and only 38% of local businesses made hires in the first half of 2025, compared to 16% in the same period in 2024. Better sales forecasting would have allowed some of them to prepare for these adjustments rather than be affected by them.

Business objectives and team motivation

Poorly calibrated sales targets can demotivate teams or create counterproductive pressure. Realistic sales forecasting allows for setting ambitious yet achievable goals, aligned with the actual capacity of the pipeline. It avoids the classic pitfall: demanding higher results without verifying whether the sales environment allows for their achievement.

Sales forecasting methods

There is no one-size-fits-all method. The right choice depends on your company's commercial maturity, the quality of your data, the length of your sales cycle, and the stability of your market. Here are the four approaches best suited to very small businesses and SMEs.

The historical method

This is the natural starting point for any company that has been in operation for at least a year. It involves analyzing past sales to project future sales, incorporating a growth rate and seasonal adjustments.

Concrete example : If your company generated €80,000 in revenue in the second quarter of the previous year and your average growth is 10%, you project €88,000 for the same period this year.

This method works well in stable environments, with a recurring customer base and few structural changes. Its limitations become apparent as soon as the market changes rapidly, you launch a new offering, or your sales team undergoes significant changes. It should never be used in isolation: it indicates what has happened, not necessarily what will happen again.

The weighted pipeline

This is the most widespread method in B2B and one of the most powerful for SMEs that havea CRMIt consists of assigning a probability of closing to each stage of the sales cycle, then multiplying the value of each opportunity by this probability.

Example of weighting by stage:

The weighted value of €41,500 is much more realistic than the gross total of €90,000. This is the figure that should form the basis of your sales forecast.

The effectiveness of this method depends entirely on the quality of the data in your CRM. If the opportunities are not up-to-date or if the probabilities are too optimistic, the forecast will be inaccurate. The probabilities must be calibrated on your actual historical data, not on theoretical estimates.

Seasonality

Many businesses are subject to predictable seasonal variations. An accountant's business booms in March and April with tax returns. A business services provider experiences a lull in August. A retail business generates a significant portion of its revenue in November and December.

To incorporate seasonality into your sales forecast, calculate a seasonal coefficient for each month or quarter. The simplest method is to divide the average monthly revenue by the average monthly revenue for the year. A coefficient of 1,3 for December means that this month historically generates 30% more revenue than the monthly average.

These coefficients allow you to adjust your baseline forecasts and anticipate peaks and troughs to smooth cash flow, adapt stocks and plan human resources accordingly.

Market analysis (qualitative method)

This approach is essential when you have limited historical data, are launching a new product or service, or are entering a new market. It relies on external data: target market size, competitor behavior, industry trends, and the purchasing intentions expressed by your prospects.

It can draw on publicly available financial statements from competitors filed with the commercial court, publications from professional associations, sector-specific market research, or even direct surveys of your target clientele. The goal is not to obtain an exact figure, but to reduce uncertainty and establish a likely revenue range.

This method is often used in conjunction with a quantitative approach to challenge assumptions and incorporate market signals that internal data do not capture.

Building your sales forecast step by step

Here is a six-step process applicable by any micro-enterprise or SME, regardless of its size or sector.

Step 1: Centralize the available data

Before building anything, gather all sources of business information: sales history from the last 12 to 24 months, a list of current opportunities with their stage of development, quote awaiting response, recurring contracts to be renewed, and marketing data (number of leads generated, conversion rate).

If your data is scattered between an Excel spreadsheet, your email, and your mind, start by centralizing it. A forecast is never better than the data that feeds it.

Step 2: Choose the method that best suits your situation

Use the historical method if you have at least 12 months of data and relatively stable activity. Add the weighted pipeline if you have a CRM with well-documented opportunities. Incorporate seasonal coefficients if your business has pronounced cycles. Supplement with a market analysis if you are launching a new offer or entering a new segment.

The golden rule: a simple method with clean data is better than a sophisticated model fed by incomplete or outdated information.

Step 3: Segment your data

Don't create a single, overarching forecast. Segment by product or service, customer type, salesperson, acquisition channel, or geographic area. A 40% conversion rate for your repeat customers is nothing like a 15% rate for your cold prospects. Aggregating these different realities produces a flawed forecast.

Step 4: Apply the conversion rates and weightings

For each segment, apply the actual historical conversion rates. If you know that 55% of your sent quotes result in an order within 30 days, multiply the total value of your open quotes by 0,55 to obtain your weighted forecast for that segment.

Next, compare the sum of your weighted forecasts to your sales target. The difference between the two indicates whether you need to intensify prospecting, improve your conversion rate, or revise your objectives.

Step 5: Build three scenarios

Rather than a single figure, develop three scenarios: conservative (only very advanced opportunities materialize), realistic (historical conversion rates apply), and optimistic (above-average conversion rates, new opportunities that result in sales). This scenario-based approach allows you to prepare action plans tailored to each situation and to communicate a credible range to your financial partners.

Step 6: Review regularly

A fixed annual forecast quickly loses its value. Markets evolve, deals shift, and budgets change. Conduct a pipeline review at least monthly, ideally weekly for active sales teams. Systematically compare your forecasts to actual results and analyze the discrepancies: Did you overestimate certain opportunities? Have decision times lengthened? This feedback loop progressively improves the accuracy of your future forecasts.

Common mistakes that skew your sales forecasts

Excessive optimism

This is the most frequent and well-documented mistake. According to a Gartner analysis, less than 50% of sales managers are confident in the reliability of their own forecasts, and excessive optimism among sales teams is one of the main causes.

An interested prospect is not a customer. A sent proposal is not a signed contract. Advanced negotiations can still be lost. Basing your probabilities on gut feeling rather than actual historical data consistently produces overestimated forecasts. The solution: calibrate your conversion rates on the last 12 to 24 months of actual data, not on your hopes.

Incomplete or outdated CRM data

If opportunities aren't updated, if amounts are approximate, or if pipeline stages don't reflect the reality of the deal, your forecast will be flawed from the start. "Zombie opportunities"—deals inactive for weeks that remain in the pipeline—artificially inflate the forecast and create an illusion of visibility.

Implement a disciplined update process: each opportunity should have a realistic closing date, a precise amount, and a recent activity rating. Some CRMs allow you to configure automatic alerts for deals that have been inactive for a certain number of days.

Confusing pipeline and forecasting

Your pipeline represents all current opportunities. Your sales forecast represents what you expect to actually close over the period. Simply adding up all open opportunities without weighting them is confusing the two. A small business's raw pipeline might show €200,000 worth of opportunities, while a realistic weighted forecast is only €70,000. The difference between the two is the margin of error you allow yourself.

A forecast that has never been revised

Creating an annual forecast in January and leaving it untouched until December is one of the riskiest practices. The economic landscape shifts, deals move from one quarter to the next, and new opportunities emerge. A forecast that isn't regularly reviewed quickly becomes a fictional document that no longer helps anyone make decisions.

According to the SDI survey of January 2025, one in two micro-enterprises recorded a decrease in turnover in 2024 compared to 2023, and 17% were even considering ceasing their activity in the first half of 2025. For many, an earlier updated forecast would have made it possible to anticipate the difficulties and activate corrective levers in time.

Tools to manage your sales forecast

From spreadsheets to CRM: choosing according to your maturity level

For a very small business with few current opportunities, a well-designed Excel spreadsheet may be sufficient to get started. However, as soon as business activity grows, the limitations quickly become apparent: time-consuming manual updates, risk of errors, lack of automatic history, and conflicting versions between colleagues.

A CRM connected to your communication tools allows you to track the pipeline in real time, automate follow-ups, and generate forecast reports without re-entering data. Most modern solutions include dashboards that display the weighted pipeline, conversion rates per stage, and forecasts by period in real time.

Djaboo: the all-in-one CRM designed for very small businesses and SMEs

Djaboo is a CRM solution designed specifically for small and medium-sized businesses, which connects in a single space the tracking of sales opportunities, the management of quotes and invoices, and the management of customer relationships.

In practical terms, Djaboo allows you to:

Track your sales pipeline in real time. Each opportunity is positioned within the sales cycle, along with its value, stage of development, and probability of closing. dashboard It instantly displays the weighted value of the pipeline and the forecast of future sales, without having to build formulas manually.

Link quotes and invoices to your forecast. When a quote is sent from Djaboo, it automatically enters the sales pipeline. Once accepted, it becomes an invoice and contributes to your revenue figures. This seamless integration between sales and finance eliminates data re-entry, reduces errors, and ensures your forecast always reflects actual sales.

Start without initial investment. Djaboo offers a €0 Starter plan that allows very small businesses and freelancers to begin structuring their commercial activity without any financial commitment. Customer relationship management, opportunity tracking, and invoicing features are accessible from the start, without requiring any technical or accounting skills.

More than 1,000 teams are already using Djaboo to implement smooth business processes and gain visibility into their business.

Comparative table: manual method vs. tool method

The manual method may be suitable for starting out or for very simple activities with few opportunities. As soon as sales volume increases or several people are involved in the sales process, tools become essential to maintain the reliability of forecasts.

FAQ: 5 frequently asked questions about sales forecasting

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

The sales target is what you want to achieve. The sales forecast is what you estimate you will actually achieve based on current data. A target is aspirational; a forecast is realistic. Both are necessary but should not be confused: relying solely on the target without a reliable forecast is like navigating without instruments.

How often should you update your sales forecasts?

A monthly review is the minimum recommended for a very small business (TPE) or small and medium-sized enterprise (SME). Active sales teams benefit from a weekly pipeline review, focusing on the most advanced deals, changes since the previous week, and high-risk opportunities. An unrevised annual forecast loses its value within the first month.

Is it possible to forecast sales without a CRM?

Yes, using a structured spreadsheet, by listing each opportunity with its amount, stage, and probability of closing. But this approach quickly reaches its limits as soon as the volume of opportunities increases or several people are feeding the pipeline. A CRM automates the weighting, history, and alerts, which significantly improves accuracy and reduces the time spent on the task.

Which forecasting method should a very small business (TPE) that is just starting out choose?

Start with the historical method if you have at least six months of activity. Add the weighted pipeline as soon as you have multiple opportunities in progress. If you're starting without historical data, rely on market data and industry studies to build your initial assumptions, then refine them quarter after quarter as your internal data accumulates.

How to improve the accuracy of your sales forecasts?

Three main levers: improve data quality in the CRM by keeping opportunities up to date, implement regular pipeline reviews to challenge probabilities and detect optimism biases, and systematically measure the gap between forecasts and actual results to adjust assumptions over time. Accuracy improves with discipline, not with sophisticated tools.