Monthly Sales Forecast — Free Calculator & Template for Any Business

A monthly sales forecast projects your future revenue based on historical sales data. You enter past monthly sales figures, the tool calculates the trend, and it extends that trend forward with a confidence band showing the best-case and worst-case range. This is the number your budget, hiring plan, and inventory orders should be built on.

12-Month Sales Data Example

Here is a sample dataset for a small business tracking monthly revenue:

Month	Revenue	Month	Revenue
January	$8,500	July	$15,200
February	$9,200	August	$16,800
March	$10,100	September	$17,500
April	$11,400	October	$18,200
May	$12,800	November	$19,600
June	$14,000	December	$21,000

This data shows consistent monthly growth averaging about $1,136 per month. Entering these 12 values into the forecast tool produces a clear upward trend line. The 3-month forecast projects January at roughly $22,100, February at $23,300, and March at $24,400 with a confidence band of plus or minus $1,500 to $2,000.

The Sales Forecast Formula Explained Simply

Behind the chart, the math is straightforward. Linear regression finds two numbers:

• Slope: How much revenue grows each month on average. In the example above, about $1,136 per month.
• Intercept: The starting point of the trend line. This is where the line would cross zero on the timeline.

The forecast formula is: Projected Revenue = Intercept + (Slope x Month Number)

For month 13 (January next year): Intercept + (1,136 x 13) = approximately $22,100. The tool does this calculation automatically and adds the confidence band based on how closely your actual data follows the trend line. Data that closely follows the line gets a narrow band. Data that bounces around gets a wider band.

How to Read the Forecast Output

• Blue solid line: Your actual monthly sales data plotted over time.
• Green dashed line: The forecast extending beyond your last data point. Each point is a projected month.
• Shaded green area: The confidence band. The top edge is the optimistic case. The bottom edge is the conservative case.
• Purple dashed line: The overall trend line running through all data and the forecast.
• Stats panel: Shows average monthly growth, trend direction, and the projected value at the end of the forecast period.

When to Use Midpoint vs Lower Band vs Upper Band

Decision	Which Number to Use	Why
Budgeting expenses	Lower band	Commit to costs you can cover even in the conservative scenario
Inventory ordering	Lower band	Avoid over-ordering. You can always reorder but cannot un-order
Hiring decisions	Midpoint	Hire for the expected case. Adjust if actuals diverge for 2+ months
Sales targets	Midpoint to upper band	Give the team a stretch goal while keeping it within the range of likely outcomes
Investor reporting	Midpoint with band shown	Shows you understand the range. Using only the upper band looks naive. Midpoint with context builds credibility

Monthly Forecast vs Quarterly Forecast

Monthly forecasts give you more actionable detail for short-term decisions like inventory orders, staffing schedules, and cash flow management. Quarterly forecasts are smoother and better for strategic planning because they average out month-to-month noise.

If your monthly data is noisy with big swings, try the Moving Average method which smooths the volatility. If your monthly data follows a clean trend, Linear Regression gives the most precise month-by-month projection.

Common Mistakes in Monthly Sales Forecasting

• Using too few months. A 3-month forecast from 3 months of data is unreliable. Wait until you have at least 6 months to get a meaningful trend.
• Ignoring seasonal patterns. If December is always your biggest month, a linear forecast from January through June will underestimate December. Use 12+ months of data to capture the seasonal cycle.
• Treating the midpoint as guaranteed. The forecast is a probability range, not a promise. Always plan expenses against the lower band, not the midpoint.
• Not updating monthly. A forecast made 6 months ago using data from a year ago is stale. Add each new month of actual data and re-run. The model self-corrects.
• Forecasting during a pivot. If you just changed your pricing, product, or market, your old data does not represent the new reality. Start a fresh forecast from the point of change.