Weekly Sales Report: What to Include & How to Use It

What's a Weekly Sales Report, and Why Does It Matter?

You already know your gut feeling about how the week went. But gut feeling doesn't tell you why a job fell through, which jobs are actually profitable, or whether you're on track to hit your monthly number. That's what a weekly sales report does.

A weekly sales report is a snapshot of your business's sales activity and results from the past seven days. It tracks what you closed, what's in the pipeline, how many leads came in, and what's blocking deals from moving forward. The best ones fit on one page - or one text message - so you can actually read them.

Most owners don't need another report to file away. You need a report that tells you what to do this week based on what happened last week. That's the difference between a report that sits in a folder and one that actually changes how you run your business.

What Should a Weekly Sales Report Include?

Not every metric matters every week. The ones that do fall into two buckets: lag indicators (what already happened) and lead indicators (what's about to happen). You need both, because if you only watch revenue, you're always one week behind fixing problems.

Core Sales Metrics to Track Weekly

Revenue Closed The money that hit your account last week. For an HVAC company, that might be a mix of furnace replacements and maintenance contracts. This is your lag indicator - it tells you what happened, but it's too late to change it this week.

Deals Won (Count) How many jobs did you actually close? This shows velocity. If you're closing fewer deals but revenue is up, you're selling bigger jobs - which is good, but it also means your pipeline is thinner.

New Leads Generated How many new potential customers came in? This is a lead indicator. If it drops sharply, you've got a prospecting problem that'll show up in next week's revenue.

Quotes Sent How many estimates did you send out? If quotes drop but revenue stays flat, you're living off old pipeline - and it'll dry up soon.

Conversion Rate What percentage of your quotes turn into jobs? If you sent ten quotes and closed three deals, that's a 30% conversion rate. If that number slides week over week, something changed: pricing, messaging, or follow-up.

Pipeline Value Add up the dollar amount of all deals you're working on right now. If your monthly target and your pipeline don't line up, that gap is your early warning system.

Activities Completed How many calls, texts, emails, or site visits did you actually do? If activity drops but you're still closing deals, you're coasting on old work. That won't last.

Average Deal Size Divide total revenue by deals won. If this number trends down over a few weeks, you're probably discounting to close faster - a sign of pipeline pressure or qualification problems.

No-Shows and Cancellations One cancellation is noise. Two in a week means something's wrong - maybe your scheduling process, pricing, or follow-up.

Win Rate by Source Where did your closed deals come from? You might find that referrals close at a much higher rate than cold calls. That tells you where to spend your time.

Qualitative Sections Worth Adding

Top Wins This Week - What went right and can be replicated.

Blockers and Problems - What got in the way. If price is the blocker two weeks in a row, you've got a positioning or qualification problem.

Next Week's Priorities - What you're focusing on. This keeps you accountable and gives your team direction.

How Do You Structure a Weekly Sales Report?

The best structure is simple: header, metrics, deals, blockers, next week. Here's what it looks like filled in.

Week of November 3 (HVAC Company Example)

Revenue closed: $11,200 | Deals won: 5 | New leads: 14 | Quotes sent: 12 | Conversion rate: around 40% | Pipeline value: strong | Activities: 38 calls, 12 site visits | Average deal size: approximately $2,200

That one line tells you almost everything. You're on pace for a strong month. Your conversion rate is solid. Your pipeline is healthy.

Top Wins

• Furnace replacement for Acme Corp (referral)
• Maintenance contract renewal (past customer)
• Emergency AC repair (Google search)
• Two maintenance contracts (referrals)

Blockers

• One quote rejected on price - customer wanted to come in lower than your estimate
• One job delayed, waiting on parts delivery
• Two leads haven't returned calls yet

Next Week

• Follow up on 4 pending quotes (due by Wednesday)
• Schedule 2 site visits for Monday/Tuesday
• Make 30 cold calls to past customers about maintenance plans

That's it. Learn more about Tire Kickers: How to Spot and Handle Them in Sales. One page. Same metrics every week. Same format. After four weeks, you'll spot patterns. After eight weeks, you'll know what normal looks like - and you'll notice problems the moment they show up.

How to Actually Use Your Weekly Sales Report to Drive Decisions

Start by comparing week-over-week, not absolute numbers. Context matters.

Watch for patterns that signal specific problems:

Conversion Rate Drops Two Weeks in a Row One week of decline might be noise. If it's down again the next week, you've got a real problem - not a lead volume issue, but something in your qualification, pricing, or follow-up.

Activity Up, Revenue Flat You made more calls, sent more quotes, but closed the same revenue. That's an efficiency problem. Maybe your qualification is weak - you're quoting jobs that won't close. Maybe your follow-up is slipping.

Pipeline Shrinking Your pipeline was healthy last week and noticeably thinner this week, and you didn't close enough deals to explain the drop. Deals are falling out without closing. Next week's revenue will drop unless you fix it now.

High Close Rate, Low Deal Volume You're closing a great percentage of your quotes, but only sent a handful this week. You're selling well; you're just not prospecting enough.

Managers look at team-level trends: Is conversion dropping across the board, or just one rep? Is pipeline healthy overall? A rep looks at their own numbers: Am I on track? What do I need to do this week?

Here's the rule on escalation: one week of decline is noise. Two weeks of the same pattern is a signal that warrants a coaching conversation.

Weekly Sales Report Templates: Which Format Fits Your Team?

Google Sheets or Excel Best for teams under five reps or if you don't have a CRM. Free, customizable, easy to share. The downside is manual data entry takes real time each week and numbers can drift if someone forgets to update them.

LocalRestart's Automated Weekly Report Best for home-service businesses that want their numbers without the manual work. LocalRestart pulls your data automatically, formats it consistently, and delivers a ready-to-use summary every Monday morning. It takes minimal setup and runs itself after that, giving you the accuracy of a CRM-generated report with none of the enterprise complexity. Other platforms like Jobber, ServiceTitan, HubSpot, and Salesforce offer reporting features as part of broader software suites, but they're built for general use rather than the specific needs of home-service owners.

Written Narrative Best for solo owners. It forces you to think deeply about what happened and captures the context that numbers alone miss. Budget about half an hour a week.

For most home-service owners, a hybrid works best: use your job software to auto-generate the core metrics, then add a short paragraph about wins, blockers, and next week's focus. That takes fifteen minutes and gives you the best of both worlds. LocalRestart makes this easy by handling the data side so you can focus on the decisions.

Common Weekly Sales Report Mistakes to Avoid

Tracking Too Many Metrics - Aim for somewhere between seven and ten. More than that and you're drowning in data instead of making decisions.

No Comparison to Targets - A number by itself is useless. Always show the target and the variance. That's where the action is.

Inconsistent Cadence - Pick a day (every Monday morning) and stick to it. Consistency is what makes patterns visible.

Reports Never Reviewed in Meetings - Schedule fifteen minutes every Monday to walk through last week's numbers. That's when the report becomes a coaching tool instead of a compliance exercise.

No Qualitative Context - Raw numbers are data. Adding the story of what drove them and what's blocked is insight.

Frequently Asked Questions

How long should a weekly sales report be?

One page, or a few hundred words. Your team should be able to scan it in five minutes and understand what happened and what to do next.

What is the difference between a weekly and monthly sales report?

Weekly reports focus on activity and pipeline health - leading indicators. Monthly reports focus on quota attainment and trends - lagging indicators. Weekly is tactical: are we doing the work? Monthly is strategic: did we hit our target?

How do you write a weekly sales report if you missed your targets?

Be honest and focus on what you're fixing. Something like: "We missed target this week. Conversion rate dropped noticeably - we're investigating why. We're increasing follow-up calls and re-qualifying all pending quotes."

Which metrics matter most in a weekly sales report for small teams?

Revenue closed, deals won, new leads, quotes sent, and conversion rate. Those five tell you almost everything: Did I make money? How many deals did I close? Do I have enough pipeline? Are my quotes converting?

Can a weekly sales report be automated with a CRM?

Yes. LocalRestart can set this up for you, pulling your numbers automatically every week and sending you a summary you can actually use. You set it up once, and every Monday morning the report lands in your inbox with no manual entry required.

The Real Problem: You're Losing Money on Data You Already Have

Most home-service owners have all the data they need. It's in your job software, your email, your calendar. But it's scattered. You're not seeing it as a weekly picture, so you can't act on it.

You close a job on Tuesday and forget about it by Friday. You send a quote on Wednesday and don't follow up because you didn't write it down. You hit Friday with no idea if you're on pace for the month.

A weekly sales report fixes that. It forces you to look at what actually happened, not what you think happened. It shows you patterns you'd miss otherwise. It tells you what to do this week based on last week's data.

If you're already using job management software, you can pull these numbers in just a few minutes. If you're not using software yet, a Google Sheet doesn't take much longer. Either way, it's worth it.

LocalRestart is built specifically for home-service businesses, pulling your numbers automatically every week and delivering a clear summary you can act on. That's the fastest way to go from scattered data to confident decisions, every single week.