Weekly Sales Report Template for Small Businesses (Free, Copy-Paste)

Updated 2026-10-25 · AI Agent Starter Kit

Most sales report templates are built for sales teams: rep leaderboards, quota attainment, forecast categories. If you run a small service business, you are the whole sales team, and you need something much simpler. You need to know, once a week, whether enough work is coming in, whether anything is slipping, and what to do about it on Monday.

This page gives you a one-page weekly sales report you can copy, the numbers worth tracking, the Google Sheets formulas to fill it in, and a way to have it written for you.

What a small business sales report is for

A weekly sales report should answer four questions in under two minutes:

How much new interest came in? (new leads or inquiries)
How much of it turned into work? (quotes sent, jobs won)
What is stuck? (leads with no reply, quotes with no answer)
What should I do first this week?

If a number does not help answer one of those, leave it out. A short report you read every Monday beats a detailed one you stop opening by week three.

The 8 numbers to track

Number	What it tells you
New leads	Is marketing and word of mouth working?
Leads by source	Which channel to keep feeding
Median first reply time	How fast you respond (speed wins jobs)
Quotes sent	How much real opportunity you created
Jobs won	Count and total value
Win rate	Jobs won divided by quotes decided
Open quote value	Money still on the table
Stuck items	Leads with no reply in 2+ days, quotes with no answer in 7+ days

Compare each one with last week and with your 4-week average. Single weeks are noisy; the trend is what matters.

Copy-paste weekly sales report template

Weekly sales report: week of [DATE]

Headline: [One sentence, e.g. "Busy week for inquiries, slow on closing."]

Numbers - New leads: [N] (last week [N]) - Top source: [SOURCE] ([N] leads) - Median first reply: [TIME] - Quotes sent: [N], total [$] - Jobs won: [N], total [$] - Win rate (4 weeks): [%] - Open quote value: [$]

Wins - [Client, job, amount]

Stuck - [Lead or quote, days waiting, next step]

Top 3 for this week 1. [Action] 2. [Action] 3. [Action]

That is the whole report. If you can fill it in from memory, you probably have too few leads to need it; if you cannot, the sheet below does the work.

Fill it in with Google Sheets

Keep one tab called Leads with a row per lead and these columns: date received (A), name (B), source (C), first reply date (D), status (E), quote amount (F), quote sent date (G), decided date (H). Statuses: New, Replied, Quoted, Won, Lost.

Put the week's start date in a cell called WeekStart (Monday). Then:

Number	Formula
New leads	`=COUNTIFS(Leads!A:A,">="&WeekStart,Leads!A:A,"<"&WeekStart+7)`
Quotes sent	`=COUNTIFS(Leads!G:G,">="&WeekStart,Leads!G:G,"<"&WeekStart+7)`
Jobs won	`=COUNTIFS(Leads!E:E,"Won",Leads!H:H,">="&WeekStart,Leads!H:H,"<"&WeekStart+7)`
Won value	`=SUMIFS(Leads!F:F,Leads!E:E,"Won",Leads!H:H,">="&WeekStart,Leads!H:H,"<"&WeekStart+7)`
Open quote value	`=SUMIFS(Leads!F:F,Leads!E:E,"Quoted")`
Stuck quotes	`=COUNTIFS(Leads!E:E,"Quoted",Leads!G:G,"<"&TODAY()-7)`

For leads by source, a pivot table on columns A and C filtered to the week works well. For reply speed, see how to track email response time in Gmail. The lead tracking spreadsheet guide has a fuller version of this sheet, and a KPI dashboard in Google Sheets charts the numbers week over week.

How to read it

Leads up, wins flat: the problem is follow-up or pricing, not marketing. Check your stuck quotes first, and see how to follow up on a quote.
Leads down: look at the source column. One channel usually explains the drop.
Reply time creeping up: you are busy, which is good, but slow replies quietly cost jobs. Block 15 minutes twice a day for inquiries.
Open quote value growing: money is waiting on you. Those follow-ups are your highest-value task this week.

Pair it with a weekly review

The sales report tells you what happened. A short weekly review turns it into a plan. The weekly review template walks through it, and the automated weekly CEO report guide shows how to put sales, inbox and calendar on one page.

Have it written for you every Monday

You can automate the whole report without handing your numbers to a guessing machine. The safe pattern:

A scheduled workflow runs Monday morning.
Code counts every number from your lead sheet and your Gmail. Code does the math, so the numbers are exact.
An AI model writes only the headline, wins and top 3, using those numbers.
A check removes any number in the AI's text that the code did not produce.
The report lands in your Gmail Drafts, and a row is logged to a Weekly tab so you get a trend.

Skip the build

The Weekly CEO Report Kit does exactly this in n8n, Gmail and Google Sheets. Every Monday at 7 AM it counts your leads, stuck quotes, overdue replies and sent mail, writes a one-page summary with your top 3 for the week, strips any number it cannot back up, and saves it as a draft to you. It includes a sample mode so you can see a full report before connecting anything. Get the kit

Want the leads captured and followed up too? The Solo Ops Command Center bundles all three kits (Inbox Chief of Staff, Speed-to-Lead and the Weekly CEO Report) with a dashboard that charts your numbers week over week. Nothing sends without you.

Ready-made n8n kit

Weekly CEO Report Kit

Every Monday at 7 AM, one page in your Drafts: wins, pipeline numbers, stuck leads, overdue replies and your top 3 for the week.

Get the kit ($29)

Bundle: best value

Solo Ops Command Center

All three paid kits (Inbox Chief of Staff, Speed-to-Lead, Weekly CEO Report) plus a bundle-only dashboard sheet. $87 separately.

Get the bundle ($69)

Free weekly email

One tested AI workflow a week

Short, practical n8n and Gmail automations for one-person businesses. Drafts-only, human-in-the-loop, no hype. Unsubscribe anytime.

Subscribe free