A good sales report answers three questions on one page: where are we against target, what changed since last time, and what are we doing about it. Everything else is decoration. The templates below are structured around those three questions at weekly, monthly, and quarterly cadences, and you can copy them directly into a doc, email, or slide.
The most common reporting failure is not missing data. It is reports stuffed with every number the CRM can export, which nobody reads and which hide the two numbers that actually needed a decision.
Here is what belongs at each cadence, the templates themselves, and how to build the monthly summary in Excel or Google Sheets without dreading it.
What Belongs in a Sales Report
Match the content to the cadence, because each cadence answers a different question.
Weekly reports are operational: activity, pipeline movement, deals advancing or stalling, and blockers needing help now. Their audience is the team and its manager, and their job is course correction while the month can still be saved.
Monthly reports are performance-oriented: results versus target, win rates, pipeline coverage for the coming months, and notable wins and losses with reasons. Audience: sales leadership and often the wider company.
Quarterly reports are strategic: trends across the quarter, forecast accuracy, what the numbers say about strategy, and what changes next quarter. Audience: executives and sometimes the board.
Every report at every cadence should lead with target versus actual, state the delta plainly, and end with actions that have owners. If a number in the report would never change a decision, cut it.
Weekly Sales Report Template
Copy this structure and fill it in. It should take fifteen minutes to complete, not an afternoon.
WEEKLY SALES REPORT - Week of [date]
1. Headline: One sentence. Example: Booked 9 meetings against a target of 10; two late-stage deals slipped to next week.
2. Numbers vs target: New meetings booked [x / target]. Opportunities created [x / target]. Deals closed and value [x, $y]. Pipeline added [$x].
3. Deal movement: Advanced: [deal, from stage, to stage]. Stalled 14+ days: [deal, stage, reason]. Lost: [deal, reason].
4. Blockers and asks: What is stuck and who is needed to unstick it. Example: Contract for [account] with their legal for 10 days; requesting exec nudge.
5. Focus for next week: Three bullets maximum.
The discipline that makes this work: the stalled-deals section uses a hard rule, such as no activity in 14 days, so deals cannot hide, and the asks section names people. A weekly report without asks is a diary.
Monthly Sales Report Template
MONTHLY SALES REPORT - [Month, Year]
1. Summary: Two or three sentences: result vs target, the main driver, the main concern. Written last, placed first.
2. Revenue: Closed [$x] vs target [$y], [z]%. Vs last month and same month last year. By segment or product if meaningful.
3. Funnel for the month: Leads or replies [x]. Meetings held [x]. Opportunities created [x, $y]. Won [x, $y]. Win rate [%]. Average deal size [$x]. Average cycle length [days].
4. Pipeline health going forward: Open pipeline for next month and quarter [$x], coverage ratio vs target [e.g., 3.1x]. Largest five open deals with stage and expected close.
5. Wins and losses that teach something: Two or three of each with the reason. Lost to [competitor] on [reason] is useful; lost, no decision repeated five times is a finding in itself.
6. Actions for next month: What changes, who owns it, and how you will know it worked.
Coverage ratio deserves a note: pipeline divided by target. Teams commonly aim for roughly 3x, but your real number depends on your win rate, so calculate it from your own history rather than adopting the folklore figure blindly.
Quarterly Sales Report Template
QUARTERLY SALES REVIEW - [Q, Year]
1. Results: Revenue vs target, by month, by segment. Quota attainment distribution across reps, not just the average, since one big deal can hide a struggling team.
2. Trends: Win rate, deal size, and cycle length across the last four quarters. Three lines that say more than most dashboards.
3. Forecast accuracy: What we forecast at quarter start vs what landed, and why the gap. This section is what makes future forecasts believable.
4. Strategy read: What the quarter said about ICP, channels, and pricing. Example: win rate inside ICP was double the rate outside it; we are tightening qualification.
5. Next quarter plan: Targets, the two or three changes being made, capacity and hiring notes, and risks.
Building a Monthly Sales Summary in Excel or Google Sheets
If your CRM reporting is weak or you just need an excel summary of sales by month, a pivot table gets you there in minutes once the data is shaped correctly.
Step 1: Get the raw data flat. One row per closed deal: close date, deal name, owner, segment, amount, stage or outcome. Export from your CRM or maintain the sheet directly. No merged cells, no subtotal rows, headers in row one. Flat data is the entire trick; almost every spreadsheet reporting struggle traces back to violating it.
Step 2: Add a month column. In a helper column, extract the month from the close date. A robust approach is a formula that produces the first day of the month, for example using DATE with YEAR and MONTH of the close date, then formatting it to display like Jan 2026. This keeps months sorting chronologically instead of alphabetically.
Step 3: Insert a pivot table. Select the data, insert a pivot table on a new sheet. Rows: your month column. Values: sum of amount, and add a second value of count of deals. You now have revenue and deal count by month. Columns: owner or segment, if you want the breakdown.
Step 4: Add the comparisons that make it a report. Next to the pivot, add your monthly target column and a variance formula, and a simple line or column chart of revenue by month. Percent change month over month is one extra formula.
Step 5: Make refresh painless. Keep raw data on one tab, the pivot and chart on another, and append new exports to the raw tab. In Google Sheets, pivots refresh automatically; in Excel, right-click the pivot and refresh. If pasting new exports monthly, convert the raw range to a proper Excel Table first so the pivot picks up new rows without re-selecting the range.
That is genuinely all a monthly summary requires. Resist the temptation to build a 12-tab workbook; the one-pivot version gets read.
Automating Reports From Your CRM
Manual reporting has a failure mode beyond wasted time: numbers assembled by hand get quietly massaged, and stale copies of the truth multiply.
The automation ladder, in order of effort. First, use your CRM native dashboards and scheduled email reports; HubSpot, Salesforce, Pipedrive, and most others can send a dashboard snapshot on a schedule, which covers the numbers section of the weekly report for free. Second, live-sync a sheet: native CRM-to-Sheets connectors or tools like Coupler or Zapier can land deal data in your spreadsheet automatically, so your pivot summary is always current. Third, BI tools like Looker Studio or Power BI on top of CRM data, worth it once multiple sources need joining.
Outbound teams should pull sequence metrics into the same picture, since meetings booked upstream predict revenue downstream. If your outreach platform has its own analytics, as tools like ClickReach do for reply and meeting data, link or export those numbers into the weekly report rather than reporting pipeline as if it appears from nowhere.
One thing automation cannot do: the narrative. Automate the numbers, then spend your saved time writing the three sentences of interpretation and the action list, because that is the part anyone senior actually reads.
A data-hygiene warning: automated reports faithfully publish garbage. If reps do not keep stages and close dates current, automation just delivers wrong numbers faster. Fix the hygiene expectation first; the simplest lever is using the report itself in the weekly meeting, so wrong data embarrasses its owner immediately.
Avoiding Vanity Metrics
A vanity metric is one that can go up while the business goes nowhere. In sales reporting the usual suspects are raw activity counts: emails sent, dials made, and total pipeline value inflated by dead deals nobody has disqualified.
Activity numbers are not useless, they are diagnostic. Low meetings with high email volume points at list quality or messaging. But they belong in the diagnosis conversation, not the headline. Reporting 4,000 emails sent as an achievement invites optimizing for 5,000.
The honest replacements: meetings held rather than booked, qualified pipeline with a real disqualification discipline rather than gross pipeline, win rate and cycle length rather than deal count alone, and revenue against target above everything. A useful test for any metric: if this number doubled and nothing else changed, would we actually be better off? If not, demote it.
FAQ
What should a weekly sales report include?
Target vs actual on the two or three numbers that matter, deal movement including stalled deals, blockers with named asks, and next week's focus. One page, fifteen minutes to write.
How do I summarize sales by month in Excel?
Flat data with one row per deal, a helper column for month, then a pivot table with month in rows and sum of amount in values. Add a target column and a chart beside it. Details in the walkthrough above.
Who should receive sales reports?
Weekly: the team and its manager. Monthly: sales leadership, often shared company-wide in summary. Quarterly: executives and the board. Widening the audience is usually good; widening the length is not.
Conclusion
A sales report exists to force a decision: we are here versus target, this is why, this is what we are doing. Use the weekly template for course correction, the monthly for performance and pipeline health, the quarterly for strategy, and a plain pivot table for the Excel summary. Automate the numbers, write the narrative yourself, and cut anything that would never change a decision. Short reports get read, and read reports are the only kind that work.
