Sales Forecast Template

A forecast nobody checks afterwards is a wish. This template builds the forecast and then holds it to account.

Each of five product lines is forecast separately from the average of its last three real months, grown at a rate you set, adjusted by a base uplift, then shaped by a seasonal factor for each month. Growth compounds, which is how businesses actually grow, rather than applying a flat annual percentage.

As each month closes you enter the actual figure. Variance appears only for months you have filled in — a month with no actual yet is left blank rather than counted as a total miss, which is the mistake that makes most forecast trackers useless by March. The accuracy line tells you how far out you have been and over how many months.

Any forecast cell can be typed over when you know something the model does not. The totals still add up.

What you get

• Five product lines, each with its own growth rate and uplift
• Twelve monthly seasonal factors
• Three-month-average base, compounding growth
• Year-on-year growth comparison against history
• Forecast vs actual tracking with a stated accuracy figure
• Forecast and actual trend chart
• Configurable currency — no currency is hard-coded
• No country’s tax rates or statutory rules built in
• Sheets protected without a password
• No macros, no add-ins, no internet connection required

Who it is for

Business owners, sales managers and finance teams who need a sales number they can defend to a bank, a board or themselves.

In the download

• Excel workbook, fully formula-driven
• README with the full usage guide
• Licence covering commercial and client use
• Worked sample data throughout, clearly labelled

Sheets in the workbook

• Instructions — How to use the file, colour key, assumptions and limitations.
• Setup — Currency, business name and the first forecast month.
• Historical Sales — The last twelve months of real sales, by product line.
• Assumptions — Growth rate and uplift per product, plus monthly seasonality.
• Forecast — The forecast itself, by product and in total.
• Forecast vs Actual — Fill in actuals as they land; see the accuracy.
• Trend Chart — Forecast against actual across the year.

Requirements

• Microsoft Excel 2016 or later, or Microsoft 365
• Also opens in LibreOffice Calc, Google Sheets (import) and Apple Numbers
• No macros, no add-ins, no internet connection required

Please read

• A forecast built from your own history and your own assumptions. It is arithmetic, not prediction, and it cannot know about a contract you are about to win or lose.
• It assumes the future broadly resembles the recent past. A step change in the business breaks that assumption — override the affected months directly.
• Five product lines are provided.
• General information only, not financial advice.
• Sample data is included and clearly labelled. It is illustrative only.
• This is a tool, not financial, accounting, tax or legal advice.