Posted on 17 December 2025
Free Weekly Sales Report Template Download in Excel, Google Sheets, Word and PDF
- Available to download for free in Excel, Google Sheets, Word and PDF formats
- Logs each rep’s calls, meetings, deals and revenue daily, then totals the week
- Compares revenue with target and the prior week
- Shows which meetings turn into deals and whether the month is on pace
A weekly sales report template is a ready-made sheet that records a sales team’s activity, deals and revenue for one week, then compares the total with the weekly target and the week before. It shows each rep’s progress, where meetings stall before deals, and what to fix next week.
Last updated: November 18, 2026
What it is
A weekly sales report template that turns a short daily log into a one-page report with revenue against target, the prior week and each rep's progress.
When you need it
When Monday's sales meeting starts with "so, how did last week go?" and nobody has the same number.
What's inside
A daily log, a one-page weekly report, a team table by rep, conversion rates, month-to-date pace and a 12-week trend.
Formats
Excel, Google Sheets, Word and PDF. The Word and PDF form is one sideways A4 page for filling in by hand.
Want to see it filled in first?
Make your own copy of the filled sample in Google Sheets.
What Is the Weekly Sales Report Template?
Monday, 9:02 a.m. Your sales manager asks how last week went.
One rep says "pretty good". Another opens a spreadsheet nobody else has seen. A third says the big order is "basically closed".
A weekly sales report template is a ready-made sheet that records a sales team's activity, deals and revenue for one week, then compares the total with the weekly target and the week before. It shows each rep's progress, where meetings stall before they become deals, and what has to change next week.
You'll hear it called a weekly sales report format, a sales weekly report, a weekly sales activity report, a weekly sales tracker or simply the Monday sales update. The job is the same: one week, one set of numbers everyone agrees on.
calls, emails, meetings
leads and visits
orders closed
against target
what changes
What isn't it? It isn't your sales ledger, a commission statement or a forecast. It's the weekly checkpoint that tells you whether those other numbers are heading where you need them.

Weekly Sales Report vs Daily, Salesman and Monthly Reports
These reports get mixed up all the time. Each one answers a different question for a different reader.
| Report | The question it answers | Covers | Who reads it |
|---|---|---|---|
| Weekly sales report | Are we on target this week, and why? | The whole team, one week | Sales manager and owner |
| Daily sales report | What did we sell today? | One day, often one store | Store or shift lead |
| Salesman report | How is this one rep doing? | One rep, any period | The rep and their manager |
| Monthly sales report | Did the month hit its number? | Four or five weeks | Leadership and finance |
| Sales plan | What will we sell, and how? | A quarter or a year | Owner and sales manager |
A daily report counts sales, a weekly sales report explains them, and a monthly report judges them.
Need the counter view for a shop? Use the daily sales report template. Want one rep's record over time? The salesman report template is built for that.
Which Weekly Sales Report Format Fits You?
Start with who will read it, then pick the format.
| If your situation is... | Use this | Where to find it |
|---|---|---|
| You manage 2 to 20 reps and want one team view | Weekly Report sheet, set to All Reps | Excel or Google Sheets |
| You need a sales update for one rep | The same report, set to one rep | Pick the rep on Weekly Report |
| Your reps fill in paper on the road | One-page weekly sales report form | Word or PDF |
| You want to see whether weeks are getting better | 12-Week Trend sheet | Excel or Google Sheets |
| You run a shop and report each day | A dedicated daily report | The daily sales report template |
| You're setting next quarter's targets | A plan, not a report | The sales plan template |

What Does the Weekly Sales Report Template Contain?
Every field from our earlier weekly sales report template stayed. What changed is how they're filled: one row per rep per day, and the week adds itself up.
| Field | What goes in it | Why it matters |
|---|---|---|
| Cold calls and follow-up calls | Outbound calls, split by new and existing contacts | Shows prospecting effort |
| Emails sent | Sales emails, not newsletters | Written outreach volume |
| Meetings arranged | Meetings booked with buyers | The first sign interest is real |
| Visits completed | Site or showroom visits that happened | Separates booked from done |
| Leads generated | New contacts worth following | Feeds next week's calls |
| Deals closed | Orders won | The outcome everything else serves |
| Products sold | Units out the door | Volume behind the revenue |
| Sales revenue | Value of the week's sales | The number the target is measured against |
| Target and variance | Weekly target per rep, then revenue minus target | Turns a number into a verdict |
| Notes | Stalled quotes, lost deals, wins | The context numbers can't carry |
The field that matters most isn't revenue. It's meetings arranged, read beside deals closed. Revenue tells you what happened. Meetings to deals tells you why.
What the Enerpize Weekly Sales Report Template Includes
We rebuilt our weekly sales report template around one idea: type each number once, on the day it happens. Everything else is formulas, with no macros, so it opens cleanly in Excel and Google Sheets. Yellow cells are the only ones you touch.
A Monday Report That Writes Itself
Type any date in the week and pick All Reps or one rep. Weekly Report fills one printable page: revenue, target, variance, % of target, prior week, week-over-week change, deals, a team table, a day-by-day table, conversion rates and notes pulled from the log. There's room for 20 reps and 2,000 log rows.

Busy Isn't the Same as Productive
The team table puts every rep's calls, meetings, deals and revenue side by side, with a meetings-to-deals rate and a Met, Close or Behind status. In our sample, Maria Santos arranged the most meetings, 18, and closed 5 deals. Daniel Reyes turned 13 meetings into 9.

A Log, Not a Memory Test
Daily Log takes one row per rep per working day. A Check column catches missing dates, unknown reps, text in number cells, the same rep logged twice for one day, and revenue with no deal against it.

Twelve Weeks Instead of One Mood
One strong Friday proves nothing. Trend lines up 12 weeks of revenue against target, week-over-week change, deals and meetings-to-deals rate, with a chart.

The Month Hiding Inside the Week
A good week can still leave the month behind. Month to Date compares revenue so far with each rep's monthly target and with how much of the month has passed, then says Ahead of pace or Behind pace.

Reading the Status Colors
Agree on what each word means before the first Monday meeting.
| Status | What it means | What to do |
|---|---|---|
| Met | Revenue at or above the weekly target | Find out what worked and repeat it |
| Close | At 90% of target or more (you can change the threshold) | One or two orders decide it |
| Behind | Below the Close threshold | Look at meetings to deals first |
| Behind pace | Month-to-date share below the share of the month passed | Act this week, not on the 28th |
| No target | No weekly target in Settings | Set one, or the status means nothing |
Weekly Sales Report Sample: A Filled Example
Want to see a weekly sales report example before you type anything? Make your own copy of the filled sample in Google Sheets. It follows a fictional company, Cedar Street Supplies, with 3 reps and 192 daily log rows from 24 August to 15 November 2026. The screens on this page use the same sample data.
How to Read the Sample
Open Weekly Report, set to week 46, 9 to 15 November. The team sold 21,010.00 against 22,250.00, or 94.4%, and 10.6% more than the week before.
334
39, or 11.7%
21, or 53.8%
21,010.00
Close
Now read the reps. Daniel Reyes hit 104.5% of target. Olivia Grant reached 97.1%, which shows as Close. Maria Santos made the most calls, 158, and arranged the most meetings, 18, yet finished at 80.0% and Behind.
Her problem isn't effort. Only 27.8% of her meetings became deals, against Daniel's 69.2%. Her note on Friday says it plainly: four meetings, one order. That's a coaching conversation about proposals, not a lecture about making more calls.
Then look at Month to Date. Half of November has passed and the team has 42.0% of its 95,197.82 monthly target. To finish on target, it needs about 5,000 a working day for the rest of the month.
Weekly Sales Report Formulas
Every formula is built in. If you're building your own weekly sales report in Excel or Google Sheets, these five do most of the work.
Weekly Revenue for One Rep
=SUMIFS(Revenue, Week Start, $Q$4, Rep, B12)
In plain English: add the revenue rows where the week and the rep match. Daniel's comes to 10,450.00.
% of Target and Variance
% of Target = Revenue / Target | Variance = Revenue - Target
Team: 21,010.00 / 22,250.00 = 94.4%, and a variance of minus 1,240.00.
Week-over-Week Change
Week-over-Week = (This Week - Prior Week) / Prior Week
(21,010.00 - 18,990.00) / 18,990.00 = 10.6%. It stays blank when the prior week had no sales, so a first week can't show a fake jump.
Meetings to Deals
Meetings to Deals = Deals Closed / Meetings Arranged
Maria: 5 / 18 = 27.8%. Key accounts can pass 100%, because repeat orders often need no meeting.
Week Start
=First Week + 7 * INT((Date - First Week) / 7)
Type any date and it lands in the right week. Set your first week in Settings, and your week can start on any day.
How to Use the Weekly Sales Report Template
Five minutes a day for each rep, five minutes on Monday for the manager. Here's the routine.
1- Set Up Your Sales Team
In Settings, enter your company, currency and the first day of your first sales week. Pick what counts as revenue: invoiced, paid or booked. Then list each rep with a weekly and a monthly target.
⚡ Tip: Choose one revenue basis and never mix them. Paid sales lag invoiced sales, so switching makes a good week look bad.
2- Log Each Rep's Day
Add one row per rep per working day in Daily Log: calls, emails, meetings, visits, leads, deals, units and revenue. Why daily? Because Friday memory rounds everything up.
⚡ Tip: Keep the log open in a tab. Thirty seconds at 5 p.m. beats ten minutes of guessing on Monday.
3- Add a Note When Something Moves
Use Notes for stalled quotes, lost deals or a big win. Weekly Report pulls up to 6 of them onto the page.
⚡ Tip: Write notes a manager can act on: "quote stalled on price, asking for 5% discount approval".
4- Check the Log
Scan the Check column before Monday. Anything other than OK needs fixing: a missing date, a rep not in Settings or revenue with no deal.
⚡ Tip: A deal with no revenue usually means the invoice hasn't been raised yet. Find out which.
5- Run the Weekly Report
Type any date in last week, pick All Reps, and print or save the page as PDF. Pick one rep for a one-to-one.
⚡ Tip: Start the meeting with the team table, not the headline number. The story is in the rows.
6- Agree Next Week's Actions
Type up to three actions at the bottom of the page before you print, each with a name and a day.
⚡ Tip: One action per rep who's Behind. More than three and none of them happen.
7- Read the Trend Monthly
Open Trend once a month for the team and for each rep. Two Behind weeks in a row is a pattern. One is noise.
⚡ Tip: Prefer paper? The one-page Word or PDF form has the same fields, with the totals worked out by hand.
Common Weekly Sales Report Mistakes
A weekly sales report rarely fails loudly. People just stop believing it.
✕ Mixing invoiced and paid revenue
Why it matters: One rep reports orders, another reports cash, and the total means nothing.
Fix: Pick one basis in Settings and write it on the report.
✕ Judging reps on calls alone
Why it matters: The busiest rep can be the one whose meetings never close.
Fix: Read meetings to deals beside activity.
✕ Typing weekly totals from memory
Why it matters: Friday estimates drift, and nobody can check them later.
Fix: Log each day, then let the sheet add up the week.
✕ Comparing weeks of different lengths
Why it matters: A four-day week looks like a slump next to a six-day one.
Fix: Use the same week start and note short weeks.
✕ Watching the week and missing the month
Why it matters: Five Close weeks in a row can still miss the month.
Fix: Check Month to Date every Monday.
Importance of the Weekly Sales Report Template
Why one more report? Because selling time is already scarce. Salesforce's sixth State of Sales report, based on a 2024 survey of 5,500 sales professionals in 27 countries, found reps spend 70% of their time on non-selling tasks. A weekly sales report should cost minutes, not hours.
The same research found that 67% of sales reps don't expect to meet their quota this year, and 84% missed it the year before. So what? A miss you spot in week 2 can still be fixed. A miss you spot on the 30th can only be explained.
Creates Immediate Performance Visibility
Three reps, one table, one week. In our sample you can see 104.5%, 97.1% and 80.0% before your coffee cools.
Highlights Conversion Bottlenecks
The team made 334 calls, arranged 39 meetings and closed 21 deals. When one stage drops, you know exactly which conversation to have.
Supports Data-Driven Coaching
"Sell more" isn't coaching. "Five of your eighteen meetings closed, so let's look at your proposals" is.
Aligns Teams With Revenue Targets
A monthly target of 95,197.82 feels far away. A weekly target of 22,250.00, checked every Monday, doesn't.
Enforces Consistent Weekly Reporting
Same fields, same week start, same revenue basis. Only then does week 46 compare fairly with week 45.
Spreadsheet vs Software for Weekly Sales Reporting
A spreadsheet is a good home for activity: calls, meetings and notes. Revenue is a different story, because it already lives in your invoices.
| What you need | Weekly sales report template | Enerpize |
|---|---|---|
| Cost | Free | Free trial, then a paid plan |
| Calls, meetings and notes | Logged by each rep | Keep these in the template |
| Weekly revenue | Typed by each rep | Weekly Sales report built from invoices |
| Revenue by rep or client | Formulas on what was typed | Revenue by Sales Person and by Client reports |
| Targets and commission | Weekly and monthly targets in Settings | Commission rules, sales periods and commission per invoice |
| Paid vs unpaid | One basis you choose | Paid, unpaid and refund columns on each report |
Plenty of teams use both: the template for the conversation, the system for the revenue.
How Enerpize Handles Weekly Sales Reporting
Your report says 21,010.00. Where did that number come from? In Enerpize, it comes from the invoices themselves. The screens below use sample data.
Weekly Sales Report: Last Week, From Your Invoices
Under Reports, Sales Reports, the Weekly Sales report groups invoices by week, with a Summary view for totals and a Details view for each invoice. You can filter by date range, status (paid, unpaid or returned), client, invoiced by, currency, work order and branch, then print it or export to CSV, Excel or PDF. It's part of Enerpize sales management.

Revenue by Sales Person: The Rep Table, Already Done
The same report can switch to daily, monthly, yearly, by client or by staff. Revenue by Sales Person gives each rep's paid, unpaid, refund and total for any period. In the sample, October closed at 43,240, 27,900 and 18,010.

Revenue by Client: Who Bought This Month
Revenue by Client shows which accounts carried the period. In the sample, Hartwell Hardware leads November with 9,860 of 40,000.

Weekly Product Sales: What Actually Left the Shelf
Group product sales by week and filter by item, category, brand, supplier, store, client, invoice status, entered by, currency and branch. That's the products sold column without anyone typing it. Selling over the counter too? The Enerpize POS has its own sales reports.

Commission Rules: Targets Set Once
With targets and commissions, each rule holds a target amount, a period, a commission type and the employees it covers. The sample counts fully paid invoices toward a monthly target.

Sales Periods: Progress Against Target, Live
Each sales period shows sales against target as a percentage, with a status of Open or Approved. Daniel Reyes sits at 44.8% for November, the same figure our template's month-to-date view gives.

Sales Commissions: Every Invoice Counted
Each invoice shows the rep, the target it counts toward and its achievement amount, so a rep can trace their number line by line.

Weekly Sales Report Template for the United States
Selling to US retailers? Your week may not match theirs.
The National Retail Federation's 4-5-4 calendar splits the year into months of 4, 5 and 4 weeks, so comparable months have the same number of Saturdays and Sundays. NRF adds a 53rd week when needed and lists 2006, 2012, 2017 and 2023 as 53-week years.
What to add:
- Your buyers' fiscal week start as the first week in Settings
- Revenue before sales tax, since the tax isn't yours to keep
- A note on any 53rd week before comparing years
⚑ Practical note: Comparing this November with last November? Compare the same retail weeks, not the same dates, or a weekend shift will look like growth.
Weekly Sales Report Template for the Philippines
Since 2024, the document behind a Philippine sale has changed name.
Under the Ease of Paying Taxes Act, PwC Philippines notes that the invoice has become the principal document for the sale of both goods and services. The BIR's Revenue Regulations No. 7-2024 put the invoicing rules into effect on April 27, 2024.
What to add:
- Invoiced as the revenue basis, so the report matches your invoices
- Revenue net of VAT, the same way on every row
- The invoice number in Notes for any large order
⚑ Practical note: An old official receipt is now a supplementary document. If a sale has no invoice yet, flag it in Notes rather than counting it as invoiced revenue.
Weekly Sales Report Template for the United Kingdom
Your weekly sales report can warn you about VAT before HMRC does.
GOV.UK says you must register for VAT if your total taxable turnover for the last 12 months goes over £90,000, or if you expect it to go over £90,000 in the next 30 days. That test is rolling, not by tax year.
What to add:
- Revenue net of VAT, so the weeks compare fairly
- A running 52-week total kept beside the Trend sheet
- GBP as the currency in Settings
⚑ Practical note: The Trend sheet shows 12 weeks, not 52. Add up the Daily Log for the last 52 weeks, and ask your accountant which sales count as taxable turnover.
Weekly Sales Report Template for India
Two reps, two numbers for the same sale: one with GST, one without.
Under Section 15 of the CGST Act, the value of a taxable supply includes other taxes and charges but leaves GST out, as Taxmann's summary of Section 15 explains. Its example: goods listed at ₹40,000 plus a ₹2,000 municipal tax give a value of ₹42,000, and 18% GST comes to ₹7,560.
What to add:
- Revenue at taxable value, before GST, on every row
- INR as the currency in Settings
- Branch or state in Notes if you sell across states
⚑ Practical note: A weekly sales report doesn't replace your GST returns or tax invoices. Use the same pre-GST value your invoices show, so the two agree.
Who Can Use the Weekly Sales Report Template?
Sales Representatives
Log your day in a minute and walk into Monday with your own numbers. When your meetings-to-deals rate dips, you'll see it before your manager does.
Sales Managers
Run the Monday meeting from one page. Start with whoever is Behind, then ask what their meetings need. For the wider job, browse the sales guides on the Enerpize hub.
Business Owners
No CRM, no dashboard project. Just a page every Monday that says whether the month is on pace.
Trade and Wholesale Suppliers
Selling to builders and stores on account? Log visits as well as calls, because a site visit often closes the order.
Retail and Showroom Teams
In a retail business, the day-by-day table shows your best and slowest trading days, so you can staff for them.
Weekly Sales Report Glossary
| Term | What it means |
|---|---|
| % of target | Revenue divided by the weekly target. |
| Variance | Revenue minus target. Negative means short. |
| Week-over-week | The change from the prior week, as a percentage. |
| Meetings to deals | Deals closed divided by meetings arranged. |
| Revenue basis | What counts as a sale: invoiced, paid or booked. |
| Month pace | Month-to-date share of target compared with the share of the month passed. |
Key Takeaways
- A weekly sales report template records a week's activity, deals and revenue, then compares them with target and the week before.
- Log one row per rep per day. The sample's 192 rows build every number on the report.
- Our sample team sold 21,010.00 against 22,250.00, or 94.4%, up 10.6% on the prior week.
- Read meetings to deals beside activity: Maria's 27.8% against Daniel's 69.2% explains her 80.0%.
- Set Close at 90% of target, so a week that's one order short doesn't read like a failure.
- Check the month every Monday. Half of November gone and 42.0% of target means about 5,000 a working day to finish.
- Pick one revenue basis and keep it: invoiced, paid or booked.
- Match your country's rules: net of VAT in the UK, before GST in India, invoice-based in the Philippines.
Frequently Asked Questions
What should be included in a weekly sales report?
Revenue against the weekly target, the variance, the prior week and week-over-week change, deals closed, and activity such as calls, meetings and visits. Add a table by rep, conversion rates and short notes on stalled or lost deals. End with next week's actions.
What is the best weekly sales report format?
One page, the same every week: headline numbers at the top, a table by rep, revenue by day, conversion rates and actions. Keep the same week start and the same revenue basis so weeks compare fairly. Our template prints in this format from the Weekly Report sheet.
Can you give an example of a weekly sales report?
In our sample, a 3-rep team sold 21,010.00 against a 22,250.00 target, or 94.4%, up 10.6% on the week before. One rep hit 104.5%, one reached 97.1% and one finished at 80.0%, because only 27.8% of her meetings became deals.
How do I make a weekly sales report in Excel?
Log one row per rep per day with date, rep, activity and revenue. Add a week start column, then total each rep's week with SUMIFS. Divide revenue by target for % of target. Or download our weekly sales report template, which already does it with no macros.
What are the most important KPIs in a weekly sales report?
Revenue against target, week-over-week change, deals closed, meetings to deals and average deal value. Activity counts like calls and emails matter only next to these outcomes. Add month-to-date pace so a good week can't hide a slow month.
What is a weekly sales activity report?
It's a weekly sales report focused on effort: calls, emails, meetings, visits and leads for each rep. On its own it can reward being busy. Our template puts activity beside deals and revenue, so you see both effort and results.
Is there a free weekly sales report template in Word?
Yes. You can download a free one-page weekly sales report form in Word and PDF, along with the Excel workbook and a Google Sheets copy. The Word form has a daily grid and a results box filled in by hand. Choose Excel if you want the totals worked out for you.
How do I write a weekly sales update for my manager?
Lead with revenue against target and the change from last week. Then give one line per rep, name the biggest blocker and list two or three actions with owners. Our Weekly Report sheet gives you every number for it in one page.
About the Author
Omar El Bahr is a Senior Digital Growth Specialist at Enerpize, where he leads SEO, content strategy, and organic growth across international markets. He is a Forbes Communications Council contributor and has written for Entrepreneur on business communication and digital strategy.
Disclaimer
The template and the information on this page are for general guidance only and are not tax, legal or accounting advice. Tax and invoicing rules differ by country and change over time, so confirm your position with a qualified adviser. A weekly sales report is a management tool, not a tax invoice, return or statutory record.
