Free Sales Forecast Template (Excel)

Why a Simple Forecast-vs-Actual Table Beats a CRM Report

Most CRM forecast reports live behind a login and reset the moment you change plans. A spreadsheet forecast is the opposite: one row per month and product or rep, a forecast number you type in at the start of the period, and an actual number you fill in as sales come in. Nothing to configure, nothing tied to a specific CRM's pipeline stages.

If you landed here searching for a general forecasting Excel template rather than a sales-specific one, the mechanic is the same: plan a number, compare it to what actually happens, and let the spreadsheet calculate the gap. This file applies that pattern to monthly sales by product or rep, which is the most common way small teams and solo reps track a revenue forecast without a full sales-ops platform.

Because it's just a table with formulas, you can adapt the 'Product / rep' column to whatever you're forecasting against - a rep name, a product line, a region, or a single company-wide row if you just want one number per month.

What's Inside the Free Sales Forecast Template

One Sales Forecast sheet with 120 rows. Each row picks a month from a dropdown (Jan through Dec), names the product or rep, and takes a forecast amount and an actual amount in dollars.

Two columns calculate automatically per row: Variance ($) is actual minus forecast, and Variance (%) is that gap expressed as a percentage of the forecast. Leave a row's forecast or actual blank and the variance columns just stay empty instead of throwing an error.

Because the month is a dropdown rather than a real date, you can log the same month multiple times - one row per product or rep, all tagged 'Mar' for example - and the rollups below still sum correctly across every row tagged with that month.

Filling In Monthly Forecast vs Actual by Product or Rep

At the start of each month, add one row per product or rep with that month's forecast number. As the month closes, come back and fill in the actual column - variance updates the instant you type the number in, no formula to copy down.

For a team, that means one shared sheet where each rep's numbers sit in their own rows under the same monthly structure, so you can scroll the full list to see who's tracking ahead or behind forecast for the month.

There's no separate CRM-style pipeline stage or deal record here - this is a numbers-in, numbers-out forecast table, not a deal tracker. If you need to see why a forecast came up short deal by deal, that's a different kind of tool.

Reading the Quarterly Forecast Rollup and Annual Variance

The summary block sums your forecast column into four quarterly totals - Q1 through Q4 - by matching each row's month against the quarter, so you get a running view of how much revenue you've planned for each three-month stretch without adding a new sheet.

Below that, an annual forecast total and an annual actual total sum every row for the year, and an annual variance percentage shows the overall gap between what you planned and what came in. The quarterly rollup itself tracks planned forecast only; actuals roll up at the annual level, so check individual monthly rows if you need actual performance by quarter.