Ask most small business owners how they predict next month’s revenue, and you’ll get one of two answers: “last year plus 10 percent” or “I just know my business.” Both are guesses dressed up as plans. The U.S. Chamber of Commerce’s small business resource hub recently walked through the basics of sales forecasting, and the gap it points to is real — forecasting is one of the most under-practiced disciplines in small business, even though it quietly drives almost every other decision an owner makes: how much to order, whether to hire, when to take on debt, and whether this is the month to finally fix the walk-in cooler.
The good news is that a usable forecast doesn’t require an MBA or expensive software. It requires picking a method that matches your business, feeding it real data, and revisiting it on a schedule. Here’s how to build one that holds up.
Why “last year plus X%” fails
Flat percentage growth assumes every month behaves like the same month last year, just a little bigger. That’s almost never true for a business with any seasonality, foot traffic dependency, or local event sensitivity. A landscaping company that grew 15% in April because of an unusually wet spring will not automatically grow 15% in April again. A restaurant near a stadium will not have a flat growth curve if the home team’s schedule shifts. Straight-line forecasting also hides the months that matter most — the slow ones where a cash crunch actually happens. If your forecast smooths over those dips, you’ll find out about the cash problem from your bank balance instead of your plan.
Pick a method that fits your sales pattern
There is no single “correct” forecasting method — the right one depends on how your revenue actually behaves.
Trailing average with a seasonal index. Take your last 12–24 months of actual sales, calculate the average, then build a seasonal index showing how far each calendar month typically runs above or below that average. This is the right default for most retail, restaurant, and service businesses with repeatable yearly patterns. The Small Business Administration’s business guide recommends this kind of rolling, data-based approach over static annual projections precisely because it adapts as real numbers come in, rather than locking in assumptions made months earlier.
Pipeline-based forecasting. If you sell B2B, do project work, or have a sales cycle with identifiable stages (quoted, negotiating, verbally committed, signed), forecast by weighting each open opportunity by its stage and expected close date. A $20,000 quote still in early conversation shouldn’t count the same as a signed contract waiting on a start date.
Run-rate forecasting. For a new business or one that just made a major change — a new location, a menu overhaul, a new service line — historical averages won’t help. Use the most recent 4–8 weeks of actual performance, annualize it, and adjust manually for known one-time effects (a grand-opening bump, a temporary road closure out front).
Most owners should combine the first two: a seasonal baseline for steady business, layered with pipeline detail for the large or unpredictable deals that don’t follow a pattern.
Feed it real data, not memory
A forecast is only as good as its inputs. Pull actual sales data from your point-of-sale system or accounting software rather than reconstructing it from memory — owners consistently misremember which months were strong and which were weak, especially across a year with any disruption. If you’re a restaurant or retailer, segment the data by day of week and by any recurring local driver: school calendars, weather patterns, nearby events, even road construction. The Federal Reserve’s Small Business Credit Survey has repeatedly found that cash flow volatility, not lack of overall profitability, is what pushes small businesses into financial distress — meaning the timing of revenue matters as much as the total. A forecast that only predicts the monthly or quarterly total without breaking it into weeks is missing the detail that actually protects your cash position.
Build it as a living document, not an annual exercise
The forecast that sits in a spreadsheet from January and never gets opened again is worse than useless — it gives false confidence. Set a recurring monthly review, ideally the same day you close your books, where you compare forecast to actual, note the variance, and ask why. Three consecutive months of forecast misses in the same direction is a signal, not noise: either your underlying assumptions changed (a competitor opened, a regular customer left, a cost went up and you passed it through) or your method needs recalibrating. SCORE mentors, available for free through the SBA’s network of resource partners, frequently cite forecast-versus-actual review as one of the simplest habits that separates businesses that catch problems early from those that don’t notice until a loan payment is at risk.
Let the forecast drive decisions, not just reports
The real payoff of forecasting isn’t the number itself — it’s what the number lets you do before you need to. A reliable forecast tells you when to place a larger inventory order ahead of a predictable seasonal spike, when to start recruiting before a staffing crunch rather than during one, and when a slow month is coming far enough in advance that you can trim discretionary spending instead of scrambling for a short-term loan. Used this way, forecasting stops being a reporting chore and becomes the tool that keeps every other decision ahead of the problem instead of reacting to it.
Start small: pull 12 months of actual sales by week, build a simple seasonal index, and put one recurring hour on your calendar each month to check forecast against reality. That single habit will tell you more about where your business is headed than any annual plan ever will.
