Sales Report Template
Generate a sales report template for weekly or monthly reviews. Built for roofing, solar, HVAC, and home improvement teams.
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 Report Template?
Most sales reports are data dumps that nobody reads. The average home improvement close rate is 20%, but a report that just shows the number without breaking down activity-to-outcome ratios gives managers nothing to act on. A manager pulls numbers from the CRM, pastes them into a spreadsheet, and sends a wall of metrics to the owner — who scans for the revenue number, ignores everything else, and replies "looks good" or "what happened." The data exists, but it does not drive a single decision.
The problem is not a lack of data. It is a lack of story. As HBR's research on data presentation shows, the most effective reports connect metrics to causes and causes to actions. If you use the same format every period, you can see that close rate has dropped two months in a row, that one rep's pipeline has tripled while another's has gone to zero, or that average contract value is declining — all before these patterns hit the bank account.
This generator creates a report template sized for your team and structured for your specific audience — whether you run a roofing company, solar installer, HVAC contractor, or multi-trade operation. Coach Rex pulls performance data across all reps and generates formatted reports with insights automatically. For more on running effective reviews, see our guides on 15-minute sales meetings and AI-powered forecasting.
Common Mistakes to Avoid
| What Most Reps Do | What Works Better |
|---|---|
| Leading with a data table instead of a headline number | Put revenue versus target in the first line. Let the reader see the most important number immediately, then use the rest of the report to explain why. |
| Showing only team totals without rep-level breakdown | One rep closing $130k while another closes $20k averages to a $75k number that looks fine. Rep-level data makes coaching obligations visible. |
| Ending with observations instead of actions | "Close rate is down" is an observation. "Close rate is down — manager to ride-along with two lowest-performing reps this week" is an action. Every observation needs an owner. |
| Changing the report format every period | Use the same structure every cycle. Trends only become visible when the format is consistent across multiple periods. |
What Makes a Good Sales Report Template
The headline number is first. Revenue versus target for the period belongs in the first line. Not in section three, not buried in a table. Whoever reads the report needs to see the most important number immediately — and then use the rest of the document to understand why it is where it is.
Pipeline is separate from closed revenue. Closed revenue tells you what happened. Pipeline tells you what is coming. A report that only shows closed revenue is a rear-view mirror. You need the forward-looking pipeline view to understand whether next month is going to be a problem before next month arrives.
Rep-level data, not just team totals. Team totals hide individual performance. One rep closing $130k while another closes $20k averages to a $75k team number that looks fine. The $20k rep is a problem that will not get addressed if it is invisible in the aggregate. Rep-level data makes coaching obligations visible.
Ends with actions, not observations. A report that says "close rate is down" and stops there is an observation. A report that says "close rate is down — manager to ride-along with two lowest-performing reps this week to diagnose root cause" is actionable. Every observation in the report should connect to an action item assigned to a named person.
Pro Tip
Lead with the story, not the spreadsheet. "Revenue dropped 15% because our close rate dropped, and close rate dropped because we stopped doing ride-alongs" is a story that produces a specific corrective action. "Revenue is $85k vs $100k target" is a number that produces a shrug. Every report should answer three questions in order: what happened, why it happened, and what we are going to do about it. For more on structuring meetings around reports, see our guide on the 15-minute sales meeting format.
Frequently Asked Questions
what should a contractor include in a weekly sales report?
Revenue closed versus weekly target, new leads added, inspections or consultations run, contracts signed, current pipeline value by stage, and a rep-by-rep activity summary. Keep it to one page. Whether you run a roofing, solar, HVAC, or general contracting team, the weekly report is for quick visibility and course correction — save deeper trend analysis for the monthly where you have enough data to draw real conclusions.
how do I present a sales report to my team?
Lead with wins before gaps — recognize what went well before drilling into what did not. Walk through the numbers from pipeline health to closed revenue. End with two to three specific actions for the week, each assigned to a named individual. Keep the full team portion under 30 minutes. Anything longer and reps check out mentally, especially during busy season.
what is a good monthly sales target for a home improvement rep?
It varies by trade. For roofing insurance restoration, a productive rep closes $80,000–$150,000 per month during active storm season. For retail roofing or HVAC, $60,000–$100,000 per month is typical for experienced reps. Solar reps often hit $50,000–$120,000 depending on market size and average system value. Set your targets based on your top performers' historical output in your specific market.
how do I track sales without a CRM?
A spreadsheet with one row per deal and columns for pipeline stage, contract value, rep name, last contact date, and expected close date works for teams under five reps. The key is updating it consistently — stale data makes forecasting impossible. Once you are managing more than five to seven reps, the time you save with a dedicated CRM will more than offset the monthly cost.
should I share individual rep performance publicly in team meetings?
Share individual performance publicly only if your team culture actively supports it and reps have opted into that norm. For some teams a public leaderboard drives healthy competition. For others it creates resentment that damages retention. When in doubt: share team totals in group meetings and review individual numbers in 1-on-1 settings. Let reps opt into public comparison rather than making it mandatory.
how far ahead can a sales report forecast revenue?
A well-maintained pipeline can forecast 30–60 days ahead with reasonable accuracy when stage probabilities are calibrated to your actual close rates. Beyond 60 days, accuracy drops because seasonality, lead source variability, and market conditions introduce too many unknowns. Use the 30-day weighted pipeline number for staffing and materials decisions and treat anything beyond 60 days as directional only.
Coach Rex Generates Reports From Real Data
AI Sales Coach pulls performance data across all reps and generates formatted reports with insights — no spreadsheet assembly required.
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