A weekly sales report template for a field team needs five parts on one page: visits against plan, orders and wins, accounts at risk, what blocked the week, and next week's plan. Copy the template below. Keep it under 15 minutes to fill in by taking the numbers from records, not memory.
Most weekly sales reports fail in one of two ways. They're so long that reps write them from memory on Friday afternoon, and managers skim them. Or they're so thin, "good week, busy", that nobody learns anything. The templates here sit between the two. Each field earns its place by answering a question a manager would otherwise ask by text on Monday.
What a weekly sales report should answer
Start from the manager's questions, and then give each one a field. Managers of field teams need to answer these every week.
| Question | Field in the report | Best source |
|---|---|---|
| Did the rep do the planned work? | Visits done against visits planned | Visit log |
| Did it produce sales? | Orders won, quotes sent, new accounts | Invoices and the rep's notes |
| Who is at risk? | Accounts ordering less, a competitor seen, a complaint | Invoice data and visit notes |
| What is in the way? | One blocker, and who can remove it | The rep |
| What happens next week? | Top three accounts to see, and why | The rep |
Notice what is missing. There is no list of every visit, no diary of the week, no hours worked, and no free text asking how the week felt. The visit log already holds the list. The report holds only what the log can't tell you: judgment.
Weekly sales report template
Give each rep this page. Fields marked with a source should be filled in before the rep sits down, from the visit log and the invoice report. The rep writes only the bottom half.
Rep: ____________ Week of: ____________ Territory: ____________ 1. THE NUMBERS (from the visit log and invoices) Visits done / planned: ____ / ____ (____%) Accounts on schedule (A / B / C): ____% / ____% / ____% Orders or sales this week: $________ Same week last year: $________ New customers won: ____ Prospects visited: ____ 2. WINS (up to 3: customer, what happened, value) a. ____________ b. ____________ c. ____________ 3. ACCOUNTS AT RISK (up to 3: customer, why you think so, what you will do) a. ____________ b. ____________ c. ____________ 4. COMPETITOR OR MARKET NEWS (one line, or none) ____________ 5. ONE BLOCKER and who can remove it ____________ 6. NEXT WEEK: top 3 accounts to see, and what I need from each a. ____________ b. ____________ c. ____________ 7. HELP I WANT from my manager (one line) ____________
Daily sales report template
Most teams don't need a daily report from every rep. Use one in three cases: a rep in their first 60 days, a rep on a performance plan, or a short push, such as a launch or a reorder drive. Outside those, the visit log is the daily report.
When you do ask for one, it must take three minutes, and the rep should write it in the car at the last stop.
Rep: ____________ Date: ____________ Visits done / planned today: ____ / ____ Best thing that happened: ____________ One customer to follow up, and what by when: ____________ Anything I could not finish or reach: ____________ Tomorrow's first stop: ____________
A daily report is an activity report. Keep the sales activity report to what the log can't hold: the best moment, the follow-up, the thing that got stuck. The rest, the visit count and the stops, comes from the record.
Roll the team up into one page
Who has time to read eight full reports every Monday? A manager who does spends as long reading as the reps spent writing. Make a one-page roll-up, and read the individual reports only for what the roll-up flags.
| Rep | Visits done / planned | A accounts on schedule | Sales vs last year | Accounts at risk | Blocker |
|---|---|---|---|---|---|
| Rep 1 | 27 / 28 | 90% | +6% | 2 | None |
| Rep 2 | 21 / 28 | 70% | -3% | 4 | Truck in the shop two days |
| Rep 3 | 26 / 30 | 85% | +1% | 1 | Waiting on a quote |
Read the roll-up top to bottom in two minutes. In the example, Rep 2 is below plan, below last year and has the most accounts at risk, and has a blocker the manager can fix, so that rep gets the first call. The report did its job.
Week of: ____________ Team sales: $________ vs last year $________ (____%) Visits done / planned: ____ / ____ Accounts at risk across the team: ____ Top 3 by size: ____________ Wins worth knowing: ____________ Blockers I need help with: ____________ Decision needed from you: ____________ (or none)
Track the pipeline and a simple forecast
A field team with repeat customers sells in two ways. Most of the week's sales are reorders from accounts that buy on a rhythm. The rest come from opportunities: an open quote, a sample on trial, a new product, a new account. The pipeline section of the report covers the second kind, and the forecast adds the two together without counting any sale twice.
Give every open opportunity one line and one stage. Four stages are enough for a team that quotes.
| Stage | It sits here when | It leaves when |
|---|---|---|
| Quote sent | The customer has a price in writing and has not answered | They ask for changes, start a trial, say yes or say no |
| In trial or review | A sample, a demo or a price check is under way | The trial ends with an answer |
| Verbal yes | The buyer has said yes but there is no order yet | The order arrives, or a week passes with no order |
| Won or lost | The order is in, or the customer said no | Never. Record the date and, for a loss, the reason |
Each week, roll the pipeline forward with one sum: the open value at the start of the week, plus new quotes, less what was won, less what was lost, equals the open value at the end. If the sum does not balance, a line was added twice or dropped.
| Line | Quotes | Value |
|---|---|---|
| Open at the start of the week | 14 | $84,000 |
| New quotes sent | 5 | $22,000 |
| Won | 4 | $18,000 |
| Lost | 2 | $9,000 |
| Open at the end of the week | 13 | $79,000 |
For a forecast, weight each stage by how often quotes at that stage have turned into orders for your team. The percentages below are placeholders. Replace them with your own won rate by stage after a quarter of records.
| Stage | Open value | Chance of winning | Weighted value |
|---|---|---|---|
| Quote sent | $40,000 | 20% | $8,000 |
| In trial or review | $25,000 | 40% | $10,000 |
| Verbal yes | $14,000 | 80% | $11,200 |
| Total | $79,000 | $29,200 |
To forecast the month, add the reorder baseline to the weighted pipeline. Take the baseline from your invoices, such as the average of the last eight weeks times four. In this example, a baseline of $48,000 a week gives $192,000, and adding the $29,200 gives a forecast of $221,200, if the pipeline closes inside the month.
Four rules keep the forecast from counting the same sale twice.
- One line per opportunity. When a quote is revised, change the line. Do not add a second one.
- One stage at a time. An opportunity is in a single stage and counted once in the weighted total.
- A quote that replaces a standing order is not new. If the customer would have reordered the same goods anyway, the baseline already holds that money.
- One owner per customer. If two reps quote the same account, only one line counts.
Add these four lines under section 2 of the report, and the manager's summary can quote them as they stand.
Open quotes: ____ worth $________ (start of week: ____ worth $________) New quotes this week: ____ worth $________ Won: ____ worth $________ Lost: ____ worth $________ Main reason lost: ____________ Biggest open quote: ____________ Stage: ____________ Decision expected: ____________
Stop reps spending Friday afternoon on reports
Say eight reps each spend 90 minutes on the weekly report. That's 12 hours a week, and about 600 hours across 50 weeks, spent writing about the week when they could be selling in the next one. Cut each report to 15 minutes and the team gets back about 10 hours a week, roughly 500 hours a year.
Four changes make that cut.
- Capture at the visit, not on Friday. A note typed or dictated at check-out takes 30 seconds, while the same visit recalled on Friday takes five minutes and loses detail. Teach reps to write the note before they start the car.
- Fill the numbers from records. Visits done, accounts on schedule and sales come from the visit log and the invoice report. A rep shouldn't count visits by hand.
- Cap the length. The template above has seven fields. If a manager adds an eighth, remove one.
- Move the deadline to Monday morning. A report written on Friday at 4 pm is written to be done. A report written Monday at 8 am, from the weekend's notes, is written to plan the week. Pair it with a 20-minute one-to-one.
A weekly report template works best with a standard note format. Use the one in the sales call report template, so each visit note already holds what goes into the weekly wins and risks.
Fill the report from records, not by hand
Automating a weekly report means the numbers arrive in it without anyone counting. It does not mean a tool writes the judgment. Sort every line of the report into one of two piles: a number a system already holds, and a view only the rep has.
| Line in the report | Record it comes from | Who still writes it |
|---|---|---|
| Visits done and planned | Check-ins and the planned routes | Nobody. A rep who explains a gap adds one line |
| Accounts on schedule | Visit dates against each account's call cycle | Nobody |
| Sales this week and last year | The invoice or order export | Nobody |
| Open and new quotes | The quote list or CRM | The rep updates the stage when it changes |
| Wins, risks, blocker, next week | The rep's notes from the visits | The rep, in a few lines |
A spreadsheet can do most of this. Keep one tab for each export, such as visits, invoices and quotes, and paste or import the new week at the same time every Monday. Keep one summary tab with formulas that count and add by rep and week. Some teams use a no-code tool or a CRM integration to copy the export in on a schedule. Either way, the rule is the same: no one retypes a number that a record already holds.
- Fix the source first. If visits are logged late or quotes are never updated, an automated report shows the wrong numbers faster.
- Check one rep a week. Compare one rep's report with the records and look for a mismatch before the report goes to the owner.
- Leave a note box. Every number needs a place for the rep to say why. A drop in visits has a reason that the record cannot hold.
Mistakes that make reports useless
- No one reads it. If a report gets no reply or action within a week, reps stop writing it well. Reply to at least one item in each.
- Asking for the same thing twice. If the CRM has it, don't put it in the report.
- Using it as a stick. A report that mainly exposes who made fewer visits teaches reps to pad the numbers. Use it to find help to give.
- Free text for numbers. "Visited a lot of accounts" can't be added up. Use fields.
- One template for everyone. A new rep, a key account manager and a route driver need different reports. Remove fields that don't apply.
- Never changing it. Review the template each quarter. Cut any field that no one has used in a decision.
Put it into use this week
- Copy the weekly template into a shared document or spreadsheet, one tab per rep.
- Decide where each number in section 1 will come from, and have it filled in before the rep opens the page. A manager can do this by hand for the first month.
- Set the deadline for Monday 9 am and book the one-to-ones after it.
- After four weeks, ask reps which field they skip, and cut it.
The numbers in section 1 are the field sales KPIs worth tracking. If you want the visits and notes captured where the selling happens, start a free 30-day trial of Sales Perch, and the weekly report becomes a review of records. The field sales CRM page lists what each customer record keeps.
