Sales Forecast Template
Generate a sales forecast template for monthly and quarterly planning. Built for contractor and home improvement companies.
Built by Tim Nussbeck — 20 years in home improvement sales, 1,000+ reps trained, founder of GhostRep
Enter your details
Built by Tim Nussbeck
Founder of GhostRep · 20+ years in home improvement sales · Trained 1,000+ reps
Every tool on this page is based on real field experience, not AI-generated templates.
What Is a Sales Forecast Template?
Most sales forecasts are fiction because they count pipeline volume, not probability. A manager looks at $1M in the funnel and reports $1M to ownership — but at a 20% close rate, that pipeline is worth $200K, not $1M. The gap between those numbers is where missed targets, bad hires, and budget shortfalls live.
A sales forecast template converts your revenue goal into probability-weighted pipeline math that every manager and rep can understand and act on. As McKinsey on sales pipeline management makes clear, the companies that grow predictably are the ones that manage leading indicators, not lagging revenue numbers.
Whether you run a roofing company, solar operation, HVAC team, or general contracting business, the math works the same way. This tool builds a forecast from your actual team size, average deal size, close rate, and business model — producing weekly activity targets per rep, stage-by-stage pipeline requirements, and leading-indicator KPIs you can review every Monday morning. Job Intel feeds real customer data into your forecast so it's based on signals, not gut feel.
How to Use This Tool
Enter your actual average deal size from trailing data
Use 60-to-90-day actuals, not what you want deals to be worth. If you enter $15K because that is your target but you are actually averaging $11K, the forecast understates the activity volume your team needs. Honest inputs produce a usable plan. Aspirational inputs produce a plan that looks fine on paper and fails in the field by week three.
Set your committed monthly revenue goal
Anchor the forecast to a number you are genuinely held to — not a stretch goal and not a sandbagged floor. If you need a stretch scenario, build it separately. Mixing committed and aspirational numbers produces a forecast that is neither accurate enough to manage against nor ambitious enough to change behavior.
Enter your current close rate honestly
If you are not tracking close rate yet, use 30% for insurance restoration and 25% for retail as conservative starting points. These are industry medians — top performers run higher, new teams run lower. The moment you start measuring, replace the assumption with your actual number. A forecast built on a 35% close rate when you are running 22% will leave your team permanently short on inspection activity.
Select your business type for pipeline shape
Storm and retail have fundamentally different conversion patterns. Storm runs higher inspection-to-contract rates because visible damage creates urgency. Retail requires more touchpoints and longer follow-up windows. The template adjusts stage ratios based on your model — selecting the wrong one produces incorrect volume targets at every stage.
Share the forecast with the team on Monday
Distribute weekly activity targets by rep and review actuals versus forecast at Friday standup. A forecast nobody sees is a document. A forecast your team reviews twice a week becomes the operating rhythm that replaces "work harder" with specific, correctable activity gaps.
What Makes a Good Sales Forecast Template
Built on trailing actuals, not aspirations. A forecast using your hoped-for close rate instead of your actual close rate will underestimate the inspections you need in the funnel. When reps miss quota, you will not know whether the problem is activity volume, conversion rate, or deal size — because the forecast was never accurate enough to separate those variables.
Weekly activity targets, not just monthly revenue goals. A rep cannot influence a monthly revenue number on a Tuesday afternoon. They can influence whether they set three more appointments before end of day. Effective forecasts break monthly goals into weekly activity counts — contacts made, inspections set, estimates submitted — that reps can act on right now.
Pipeline stage visibility at every level. Knowing you closed 28 deals last month against a goal of 33 tells you what happened. Knowing you had 74 estimates submitted against a required 105 tells you where to focus this month. Without stage-level visibility, every revenue shortfall looks the same and every correction attempt is a guess.
Documented assumptions that can be updated. Your close rate, average deal size, and seasonal adjustments should be documented inside the forecast, not kept in someone's head. When market conditions shift — storm event, new competitor, carrier policy change — you need to update one number and watch the whole plan recalculate instead of rebuilding from scratch.
Common Mistakes to Avoid
| What Most Reps Do | What Works Better |
|---|---|
| Forecasting from pipeline volume instead of stage-weighted close probability | A pipeline full of early-stage leads looks impressive and closes at 5%. Weight your forecast by stage and historical close rate — that number is your real forecast. Volume without stage data is fiction. |
| Relying on rep self-reported pipeline data without validation | Reps inflate pipelines, consciously or not. Spot-check five pipeline entries per rep each week against actual contact history. Forecasts built on unvalidated rep data miss by 30-50% consistently. |
| Running one forecast for the full team instead of individual forecasts rolled up | A team forecast hides the fact that two reps are carrying the number and eight are behind. Build per-rep forecasts first, then aggregate. The aggregate is the output; the per-rep view is where you actually manage. |
| Never revisiting or adjusting the forecast within the period | A forecast you set Monday and don't touch until Friday is a budget document, not a management tool. Update it mid-week as deals move, die, or accelerate. The value is in the revision, not the original number. |
Pro Tip
Forecast from close rates, not from pipeline volume. $1M in pipeline at a 20% close rate is $200K, not $1M — and managing your team as if it were $1M is how you miss quarter after quarter. Weight every deal by probability and your forecast becomes a math problem with a real answer. For more on building data-driven forecasts, read our AI forecasting guide and how to build rep performance plans from forecast data.
Frequently Asked Questions
How do I calculate how many estimates I need to hit my revenue goal?
Divide your monthly revenue goal by your average deal size to get the number of closes needed. Then divide closes by your close rate to get required estimate volume. Example: $400K goal at a $12K average deal = 33 closes needed. At a 35% close rate, you need 95 estimates submitted. Go one stage further — if 60% of inspections produce a submitted estimate, you need about 158 completed inspections. That pipeline math is the entire forecast, and it works the same whether you sell roofing, solar, HVAC, or windows.
What close rate should I use for my sales forecast?
Use your actual trailing 60-day close rate — nothing else is accurate enough to forecast against. If you are not tracking it yet, start with 30-35% for insurance restoration and 20-28% for retail full-price work as conservative medians. The most important step is to stop guessing and start measuring. Even 30 days of tracked data produces a more useful forecast than any industry benchmark.
How far out should I forecast sales?
Monthly forecasts with weekly breakdowns are your primary operating tool — they are close enough to influence with real activity adjustments. Layer quarterly forecasts on top for hiring decisions, material procurement, and capacity planning. Annual forecasts matter for ownership-level goal-setting and investor conversations. The annual goal is the destination, the quarterly forecast is the route, and the monthly forecast with weekly targets is the turn-by-turn navigation your team actually drives by.
What KPIs should be on my sales forecast dashboard?
Track five leading indicators per rep and per team: contacts or door knocks per day, appointments set per week, estimates submitted per week, contracts signed per week, and pipeline value by stage. Revenue is a lagging indicator — it confirms what already happened. Leading metrics tell you whether next month will hit the number while there is still time to adjust. Any manager who only tracks revenue is always managing last month's problem.
How do I adjust my forecast after a major event like a storm?
Post-storm, pipeline velocity compresses — homeowners move faster, adjuster timelines shorten, and inspection-to-contract conversion rates climb because visible damage removes the "do I really need this" objection. Update your average deal size upward if you are running full replacements instead of repairs. Build a separate event scenario rather than modifying your base model so you can compare normal-market and event-market performance cleanly across the season.
Should each sales rep have their own individual forecast?
Yes, without exception. Individual forecasts create personal ownership in a way that team totals never do. Each rep should know their required weekly activity count and monthly close count — not just what the team collectively needs. Individual forecasts also make 1-on-1 coaching data-driven: instead of a vague conversation about effort, you are looking at the specific gap between a rep's actual inspections and their required inspections and building a concrete plan to close it.
why is weekly pipeline cleaning the number one forecasting habit?
Stale leads in the pipeline inflate your forecast and create a false sense of security. A manager who looks at 40 open estimates and projects 12 closes is making a dangerous bet if 15 of those leads have gone cold. Weekly pipeline reviews where every rep must update the status of every open deal — moved forward, stalled, or dead — produce forecasts that match reality. The discipline also forces reps to follow up on dormant leads or remove them, which itself drives revenue that would otherwise have been lost to neglect.
Forecast With Real Data, Not Guesses
Job Intel tracks every deal in your pipeline with customer intelligence — so your forecast reflects reality, not optimism.
Learn MoreStart 14-Day Free TrialNo credit card required
Go beyond documents
GhostRep trains your reps live — not just generates documents.
AI-powered objection mastery, role play, and real-time coaching that actually changes close rates.
Start 14-Day Free Trial