Home / Blog / Weekly Sales Report Template
How-to · 2026

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.

By · Published November 17, 2026 · 5 min read

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

SectionWhat it showsWhere it comes from
CreatedNew deals and their total amount this weekCreate date in the window
WonCount and amount of deals closed wonClose date in the window, stage won
LostCount, amount and top loss reasonsClose date in the window, stage lost
Win rateWon / (won + lost), with the count beside itThe two rows above
MovedDeals that changed stage, from and toStage-change dates
StalledOpen deals with no stage change for a set number of daysDays 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

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 →

Frequently asked questions

What should a weekly sales report include?
Pipeline created, deals won and lost, win rate, stage movement, stalled deals and the expected close for next week. Anything beyond that tends to go unread. Add detail in a linked tab rather than on the main page.
How do I remove duplicate deals from a CRM export?
Deduplicate on the deal ID, not the name. Two different deals can share a name, and one deal can appear twice when it is associated with more than one company or contact.
How do I report win rate weekly?
Won deals divided by closed deals, won plus lost, for deals that closed in the week. A weekly figure can swing on a small number of deals, so show the count beside it and keep a rolling four-week figure as well.
Can my CRM send this report on a schedule?
Many CRMs schedule an export or a standard report, but not always in the layout the managers want. If yours does not, a report built outside it from the export can be scheduled instead.