Weekly Sales Report Template: What to Include and How to Stop Rebuilding It
Every Monday the same export, the same duplicate rows to delete and the same email to the managers. The report is not hard. Doing it by hand fifty times a year is.
A weekly sales report needs six things: what was created, what was won, what was lost, the win rate, what moved, and what is stuck. Add next week's expected closes and it fits on one page. Most of the effort is not in deciding what to include. It is in re-running the same export and cleaning it every Monday.
The layout
| Section | What it shows | Where it comes from |
|---|---|---|
| Created | New deals and their total amount this week | Create date in the window |
| Won | Count and amount of deals closed won | Close date in the window, stage won |
| Lost | Count, amount and top loss reasons | Close date in the window, stage lost |
| Win rate | Won / (won + lost), with the count beside it | The two rows above |
| Moved | Deals that changed stage, from and to | Stage-change dates |
| Stalled | Open deals with no stage change for a set number of days | Days in current stage |
Put the commit for next week at the bottom: open deals the team expects to close, with the amount and the owner.
The Monday cleanup
- Duplicates. Deduplicate on the deal ID before counting. A deal associated with two companies often appears twice in the export.
- Blank owners. Show them as a row. Dropping them makes the totals not add up.
- The window. Filter on the date in the section: created on create date, won and lost on close date. Using one date for every section is the usual error.
For the formulas behind each section, see sales pipeline analysis in a spreadsheet and win rate by rep. A ready-made workbook is the sales pipeline forecast tracker.
Sending it without running the export
Quiriz can read the deals from a connected CRM, apply one definition of win rate and stage, and send the answers as a scheduled report, so the managers get the same layout each Monday and nobody runs the export. The HubSpot connector is read-only and refreshes daily, so the Monday report reads the previous day's data.
Check first. Run the scheduled version beside your manual report for one week and compare the counts. The two should match, and if they do not, the difference is usually a duplicate or a date definition.
The Monday report without the Monday export
Try a weekly pipeline question on sample deals with no signup, then connect your CRM and schedule the report.
Try Quiriz free →