Most small business revenue forecasts are wrong because they’re built on optimism rather than data. A useful forecast is one you can act on — one that connects to real pipeline activity and historical patterns.
Two Types of Revenue Forecasting
Bottom-up: Build from individual deals, clients, or units. Add up all known upcoming revenue. More accurate for businesses with a known client base or active sales pipeline.
Top-down: Start with market size or historical performance, then apply growth assumptions. More speculative, better for long-range planning than monthly operations.
Most small businesses should use bottom-up forecasting for the next 90 days and top-down for anything beyond that.
The Bottom-Up Forecast: Sales Pipeline Method
For service businesses and B2B companies with identifiable deals:
Build a pipeline tracker with these columns:
- Client/deal name
- Expected value
- Stage (Prospect → Proposal → Negotiation → Won)
- Probability (% by stage — e.g., Proposal = 30%, Negotiation = 70%)
- Expected close date
- Weighted value (= Expected value × Probability)
Your 90-day forecast = sum of weighted values for deals expected to close in that period.
Update the pipeline weekly. As deals move through stages, probabilities update and your forecast becomes more accurate.
The Historical Pattern Method
For product businesses or recurring-revenue companies:
- Pull 24 months of revenue history by category
- Calculate month-over-month growth rates
- Identify seasonal patterns (e.g., December always 40% above average)
- Apply these patterns to project forward
Formula approach:
- Base forecast = Last year same month × (1 + average YoY growth rate)
- Seasonal adjustment: multiply by seasonal index if applicable
This isn’t prediction — it’s a baseline. Layer in known changes (new product launches, lost accounts, price changes) on top of the baseline.
The Spreadsheet Layout
Sheet 1: Revenue by Category
Rows: Revenue categories (products, service lines, or client types) Columns: Jan through Dec (current year), then Jan-Dec (forecast year)
Sheet 2: Assumptions
Document what’s driving each forecast line:
- Growth rate used and why
- Known large client situations
- Planned price changes
- New product launch timing
Assumptions rot fast. Date them and review monthly.
Sheet 3: Variance Tracking
Each month: Forecast vs. Actual vs. Variance ($ and %)
A forecast that’s never checked against reality provides no value. The variance analysis tells you whether your assumptions are working — and forces you to update them when they’re not.
Rolling 12-Month Forecast
The most useful format: always maintain a forecast for the next 12 months, updated monthly. As January ends, add December of next year. As your actual January revenue comes in, update the model with actuals and adjust forward months based on what you learned.
This rolling structure ensures you always have a 12-month view — not just a fixed annual plan that’s obsolete by March.
Revenue Forecast Red Flags
All growth, no risk scenarios. What if a key client leaves? What if a product launch is delayed? Model the downside.
No connection to pipeline or capacity. A forecast that assumes 50% revenue growth with no new sales staff, no new marketing, and no identified pipeline is aspirational, not analytical.
Never reviewed against actuals. If you’re never checking forecast vs. actual, you’re not getting smarter about your business. The feedback loop is the whole point.
Build your 12-month rolling forecast this month. If you have 24 months of historical data, use it. If you have a pipeline, use that. If you have neither, start with your best estimate and track actuals relentlessly — in 6 months you’ll have enough data to build a real model.
5 Google Sheets Every Small Business Needs
Cash flow, P&L, mileage log, invoice tracker, and payroll — all free.
No spam. Unsubscribe any time.