Roofing Sales Forecast Template
Project monthly revenue for your roofing company by job type, crew count, and season — with pre-built assumptions for residential, commercial, and repair work.
What's Inside This Roofing Sales Forecast Template
This template includes 7 worksheets, each designed for a specific part of your roofing financial workflow:
Revenue Assumptions
The driver sheet where you set the inputs that flow through the entire forecast. Enter your average job size by service type (full roof replacement, repair, commercial, gutters), your expected close rate on estimates, lead volume by month, and number of active crews. Change any assumption and the monthly projections update instantly. This is where you model what a good year, an average year, and a tough year look like for your company — without rebuilding formulas.
Monthly Sales Forecast
A 12-month revenue projection broken down by week and month, drawing directly from your assumptions. Each column shows estimated jobs completed, average job value, and total revenue by service category. Seasonal adjustment factors are pre-loaded based on roofing industry patterns — spring and summer weight heavier than November and January — but you can override any month to reflect your local market or a specific storm season. The row at the bottom shows cumulative year-to-date revenue against your annual target.
Service Mix Breakdown
A dedicated sheet tracking your revenue by service line: residential re-roofing, roof repairs and patching, commercial projects, gutter installation and repair, and insurance claim work. For each service type you see projected jobs, average revenue per job, total projected revenue, and percentage of total. This view is particularly useful for roofing contractors who want to shift their mix — for example, growing the commercial segment or reducing dependence on insurance claims — and need to see what the revenue impact of that shift looks like over 12 months.
Crew Capacity Model
Projects revenue capacity based on crew count, days worked per month, and average jobs per crew per day. Enter how many crews you're running, typical working days accounting for weather and weekends, and your average revenue per crew day — the sheet calculates your theoretical revenue ceiling each month. Use it to decide when to add a crew or when to turn down capacity. For contractors planning to scale, this sheet shows the revenue lift from each additional crew and the break-even point against labor costs.
Actual vs Forecast
Track your actual revenue alongside the forecast each month. Enter what you actually invoiced for each service category and the sheet calculates dollar and percentage variance against your plan. Green and red conditional formatting highlights where you're running ahead or behind. Over time this sheet becomes a calibration tool — you'll see which assumptions you consistently over- or under-estimate, and you can tighten your forecast accuracy by adjusting those inputs at the start of each quarter.
Scenario Planner
A side-by-side view of three scenarios — base case, upside, and downside — for your full year. Adjust the key drivers (lead volume, close rate, average job size) for each scenario and see how annual revenue changes. This is useful for planning conversations with a lender, investor, or business partner, and for your own decision-making around hiring, equipment purchases, and marketing spend. The three scenarios share the same structural model; only the assumption inputs differ.
Dashboard
A one-page visual summary with charts showing monthly revenue trend, service mix by category, forecast vs actual performance, and annual revenue progress against target. The charts update automatically as you enter data in other sheets. Designed to give you a fast read on how the year is going without opening multiple spreadsheets — useful for weekly check-ins or sharing with an operations manager or business partner.
Roofing Sales Forecast Template Features
- Driver-based model: jobs, crew count, close rate, and average job size feed all projections
- Pre-loaded seasonal weights for roofing (spring/summer peak, winter trough)
- Revenue split by service line: re-roofing, repairs, commercial, gutters, insurance
- Crew capacity calculator shows revenue ceiling per crew per month
- Three-scenario planner (base, upside, downside) for annual planning
- Actual vs forecast variance tracking with conditional formatting
How to Use This Roofing Sales Forecast Spreadsheet
Start with the Revenue Assumptions sheet. Enter your average job size for each service type — residential re-roofing is usually your largest ticket, followed by commercial and then repairs. Set your monthly lead volume, close rate on estimates, and number of active crews. These numbers are the foundation for everything else, so take 15 minutes to be realistic here. If you've been in business for a few years, use last year's actual job count and revenue per job as your starting point.
Once your assumptions are set, review the Monthly Sales Forecast and adjust the seasonal weights to match your local market. In the northern US, you might run 40% of your annual revenue in just three months (July, August, September). In the South or Southwest, you may work nearly year-round. The sheet ships with generic roofing seasonality built in — tweak it to reflect your actual experience. Then review the Service Mix Breakdown to see if your projected revenue by job type looks right relative to how you actually operate.
Come back at the end of each month and enter your actual invoiced revenue in the Actual vs Forecast sheet. This is where the template pays off — you'll quickly see whether your close rate is tracking your assumption, whether your average job size is higher or lower than expected, and which months are running ahead or behind plan. Most roofing contractors who use this consistently say the biggest value is catching a slow spring early enough to adjust their marketing or estimating pace before it turns into a cash problem.
15 minutes from download to your first roofing forecast
Download the template, enter your average job size and crew count, and see a full 12-month revenue projection for your roofing company.
Why Every Roofing Contractor Needs a Sales Forecast
Roofing revenue is lumpy in a way that catches contractors off guard. A storm rolls through, you book six weeks of work in two days, and it feels like a record year — until you realize the pipeline is empty in October. Without a forecast, it's impossible to know whether a slow month is normal seasonality or the start of a real revenue problem. Contractors who forecast their sales know what a normal April looks like, which means they can recognize when they're running 20% behind that baseline and respond before the slow quarter shows up in their bank account.
A good roofing sales forecast breaks revenue into the categories that behave differently from each other. Insurance claim work comes in waves tied to storm events — high margin, hard to predict. Residential re-roofing is your most predictable line if you have a steady lead flow and a consistent close rate. Repairs are lower ticket but higher volume and fill schedule gaps. Commercial jobs are fewer but larger and have longer sales cycles. Each of these has a different average job size, a different lead-to-close timeline, and different seasonality. Mixing them all into a single revenue line hides what's actually driving your growth or your shortfall.
The practical value of a forecast is in the conversations it enables. When you're deciding whether to hire a second crew in April, you need to know whether your projected revenue can carry an additional $15,000 a month in labor. When a lender asks about your revenue plan, you need more than last year's tax return. When your operations manager wants to know how many materials orders to place in March, they need some sense of how many jobs are coming. A roofing sales forecast gives you a shared number everyone on your team is working against — and a monthly process for updating that number as the year unfolds.
Roofing Industry at a Glance
Financial templates built for roofing contractors — from owner-operators running residential crews to multi-crew companies handling commercial projects. Pre-loaded with materials, labor, and job-cost categories specific to the roofing industry.
Revenue Drivers
- Residential re-roofing (full replacements)
- Roof repairs and patching
- Commercial roofing projects
- Gutter installation and repair
- Insurance claim work
- Emergency repairs
Key Cost Categories
- Roofing materials (shingles, underlayment, flashing)
- Subcontractor and crew labor
- Disposal and dumpster rental
- Permit fees
- Equipment and tools
- Insurance (liability, workers comp)
- Vehicle and transportation
- Overhead and office costs
Typical Margins
Gross: 25-40% · Net: 6-15%
Seasonality
Peak season runs spring through early fall (April–October); storm events drive unpredictable surges year-round. November through March is the slow season in northern markets, though southern markets work year-round.
Key Performance Indicators
Roofing Sales Forecast Template FAQ
More Roofing Templates
Roofing Balance Sheet Template for Excel
$29
Roofing Budget Template for Excel
$29
Roofing Cash Flow Template for Excel
$29
Roofing Financial Model Template for Excel
$29
Roofing Income Statement Template for Excel
$29
Roofing Invoice Template for Excel
$29
Roofing KPI Dashboard Template for Excel
$29
Roofing P&L Template for Excel
$29
Roofing Pro Forma Template for Excel
$29
Roofing Project Budget Template for Excel
$29
Roofing Business Valuation Template for Excel
$29
More Sales Forecast Templates
Roofing Sales Forecast Template
$29