Sales Operations
Sales Forecasting for Small BusinessHow to Actually Predict Revenue
Stop guessing and start forecasting. Here's the practical system small businesses use to predict revenue accurately — without a complex CRM or a data analyst.
Sales Operations
Stop guessing and start forecasting. Here's the practical system small businesses use to predict revenue accurately — without a complex CRM or a data analyst.
Most forecasting mistakes aren't about the math — they're about missing the inputs the math requires.
What you think will close and what the data says will close are almost never the same. Forecasting requires actual pipeline metrics — not optimism.
A verbal yes is not a closed deal. Many small businesses count revenue from deals that haven't signed, haven't paid, or haven't passed legal. This inflates forecasts and creates cash flow surprises.
Without clear stages and conversion rates between them, you can't forecast. You need to know: how many deals enter each stage, how many convert, and how long they take.
If your average deal takes 45 days to close, a deal that entered the pipeline yesterday is not closing this month. Sales cycle data is the engine of accurate forecasting.
This is the model I use with every client. It takes about 30 days to set up and starts producing reliable predictions within one quarter.
Create 4–6 stages with clear entry and exit criteria. Every rep should be able to stage a deal consistently and without debate.
What percentage of Stage 2 deals become Stage 3? Stage 3 to closed? Once you have 60 days of data, you can start forecasting with math.
From first contact to signed — how many days on average? By deal size, by rep, by channel. This determines what's actually closeable in any given month.
A deal in Stage 2 is not worth full contract value. Weight by your actual conversion rate per stage. $100K × 20% conversion = $20K forecast contribution.
Forecast without a weekly review is a spreadsheet exercise. The review is where you catch deals that stalled, update stages, and make real decisions about what will close.
Need help building your pipeline first? How to build a sales team after $1M ARR →
I'm Louie Bernstein — I have 50 years in business experience, including 22 as a bootstrapped founder. My Fractional Sales Leadership business has been helping founders since 2017.
I work with founders at $1M–$15M ARR to build the pipeline systems and forecasting models that turn revenue prediction from guesswork into a repeatable process.
Stage-weighted pipeline forecasting. Assign a close probability to each pipeline stage based on your actual historical conversion rates. Multiply each deal's value by its stage probability and sum the total. Review and adjust weekly. It's not perfect, but it beats gut feel every time.
Divide your revenue target by your overall pipeline close rate. If you close 25% of all deals that enter your pipeline and you need $500K, you need $2M in pipeline. Most small businesses are operating with 2–3x. High-performing teams run 4–5x coverage.
You need at least 60–90 days of consistent pipeline tracking before your conversion rates stabilize. Most small businesses can build a working forecast model in one quarter if they start tracking the right data now.
The best CRM is the one your team actually uses. HubSpot's free tier works for most sub-$5M companies. Salesforce is overkill until you have 5+ reps. What matters more than the tool is whether you have defined stages, consistent data entry, and someone running weekly reviews.
In 30 minutes I can show you exactly what's missing from your current forecasting system and what it would take to predict revenue with confidence.