How to Forecast Revenue With Just 3 Months of Historical Data
- Most small businesses make major financial decisions without any revenue forecast
- The three-month baseline method
- Adjusting your forecast for seasonality with limited data
- Building assumptions your forecast explicitly depends on
- What your forecast should actually drive in your business
- Using your connected data to refine forecasts over time
Revenue forecasting is not just for large businesses with years of data. Even with three months of history, you can build a directionally accurate forecast that helps you plan stock levels, staffing, and cash position. This post covers the method, the assumptions to make explicit, and how to update your forecast as new data arrives.
- Most small businesses make major financial decisions without any revenue forecast
- The three-month baseline method
- Adjusting your forecast for seasonality with limited data
- Building assumptions your forecast explicitly depends on
- What your forecast should actually drive in your business
Most small businesses make major financial decisions without any revenue forecast#
A survey by the Federation of Small Businesses found that 61% of UK SMEs do not prepare a formal revenue forecast, even annually. They stock inventory based on instinct. They hire staff based on how busy they currently feel. They negotiate supplier terms without knowing whether revenue is trending up or down. The predictable result is either over-investment when business slows or under-investment when a growth period arrives. Forecasting does not require complex modelling or years of historical data. With three months of clean sales data, you can build a forecast accurate enough to make better stock, staffing, and cash decisions — which is the entire point of the exercise.
The three-month baseline method#
Start with your last 90 days of sales data, broken down by week. Calculate your average weekly revenue. Then calculate the week-on-week growth rate by dividing each week's revenue by the previous week's and taking the average across all weeks. Apply that growth rate forward to build a 12-week projection. For example: average weekly revenue of £8,500 with a 1.8% week-on-week growth rate gives you a projection of £12,100 by week 12. This is your base case. It assumes current conditions continue. Now build two variants: a conservative case using half the current growth rate, and an optimistic case using 150% of it. Operating with awareness of all three scenarios is dramatically more effective than operating with no forecast at all.
Adjusting your forecast for seasonality with limited data#
With only three months of data, you cannot calculate your own seasonal patterns. You can use industry seasonality as a proxy. If you sell consumer goods, apply retail seasonality indices — most product categories see a 30 to 50% revenue uplift in Q4 relative to Q2, and a dip in January and February. Your trade association or industry body will often publish seasonality data for your specific sector. Apply these as multipliers to your base forecast: if your base case projects £10,000 in October and the retail index suggests October runs 40% above a typical July, your Q4 forecast should reflect that uplift. After your first full year in operation, replace industry proxies with your own historical patterns.
Data-backed guides on AI, eCommerce, and SME strategy — straight to your inbox.
Building assumptions your forecast explicitly depends on#
Every forecast depends on assumptions. Making those assumptions explicit prevents you from treating a projection as a fact. Document the key assumptions your forecast rests on: your marketing spend stays constant, your average selling price does not change, no major competitor enters your market, your top three products remain in stock. If any of those assumptions changes, update the forecast immediately. A business that launched a new product line in month four of a three-month forecast baseline will have a significantly different growth rate than the baseline suggests. The forecast is not wrong in that case — the assumption changed and the model needs updating. Operators who treat forecasts as living documents, revised monthly, get far more value from them than those who build one annually and file it.
What your forecast should actually drive in your business#
A revenue forecast is only valuable if it changes your behaviour. Specifically, it should drive three decisions. First, stock purchases: if your forecast projects 20% higher revenue in six weeks, you need to order inventory now, not when the orders arrive. Second, cash requirements: a growing revenue forecast means growing receivables and growing cost of goods outlays. Map your forecast against your cash conversion cycle to identify whether you will need a credit facility during growth. Third, staffing decisions: customer service capacity, fulfilment headcount, and marketing resource all need to scale ahead of demand, not in response to it. These three decisions are where a revenue forecast pays back its construction cost many times over.
Using your connected data to refine forecasts over time#
The accuracy of a revenue forecast improves as you add more data and refine your assumptions. Connecting your Shopify, Stripe, or Xero data to a centralised analytics tool means your historical baseline updates automatically and your growth rate calculations reflect the most recent period rather than a snapshot you manually captured weeks ago. AskBiz lets you ask questions like "What is my projected revenue for the next four weeks based on recent trends?" and get a specific number derived from your actual data. As your data accumulates, the forecast becomes more precise. After 12 months, you have seasonal patterns, a stable growth trend, and enough data to build a genuinely reliable model. Start now with three months, and the forecast gets better every week you run the business.
Connect your accounts and AskBiz surfaces cash flow warnings, margin trends, and profit drivers — automatically. No spreadsheets.
12 metrics every SME owner should review monthly — download in 10 seconds.
Our team combines expertise in data analytics, SME strategy, and AI tools to produce practical guides that help founders and operators make better business decisions.
See your real cash position right now
Connect your accounts and AskBiz surfaces cash flow warnings, margin trends, and profit drivers — automatically. No spreadsheets.
Connects to Shopify, Xero, Amazon, QuickBooks, Stripe & more in minutes