Sales reports: what to include and how to present them
The sales report is the tool that connects what the sales team does with what management needs to know. But in most SMBs, reports are either a monthly 20-page PDF that nobody reads or a weekly meeting where each rep recounts what they remember. Neither format works.
A good sales report answers 3 questions in under 2 minutes: how much are we going to invoice this month, which opportunities are at risk, and what does the team need to close more.
Table of Contents
- Key takeaways
- Why most sales reports fail
- 7 metrics every sales report must include
- Frequency: daily, weekly and monthly
- Format: less text, more visual data
- Mistakes that undermine report credibility
- How Salesly generates automatic sales reports
- FAQ
Key takeaways
| Criterion | What you need to know |
|---|---|
| 3 questions in 2 minutes | A good report answers: how much will we invoice, what is at risk, and what is needed to close |
| 7 essential metrics | Pipeline, conversion rate, average cycle, activity, average deal size, forecast and stalled opportunities |
| Automation is key | 73% of sales directors say they spend over 5 hours per month compiling manual reports |
| Visual over textual | A pipeline chart is understood in 5 seconds. A 200-row table is never understood |
Why most sales reports fail
Most sales reports in SMBs have one of three problems:
Too much information without context. A list of 150 opportunities sorted by date says nothing useful. The director needs to know which ones will close this month, which have been idle for weeks and which have a deal size that warrants special attention.
Outdated data. If the report is generated on Friday with Thursday’s data, by Monday it is history. Reports must reflect the real state of the pipeline at the moment of reading, not a snapshot from 3 days ago.
Format that hinders action. A 20-page PDF with tables is a file that gets saved and never opened. An interactive dashboard where you can filter by rep, stage or date is a tool that gets used every day.
7 metrics every sales report must include
1. Pipeline value by stage
How much money sits in each funnel phase: prospecting, contact, quote sent, negotiation, close. This metric shows the overall health of the sales process. If most value is in the early stages, there is risk of missing the monthly target.
2. Stage-to-stage conversion rate
What percentage of opportunities advance from one stage to the next. If 80% of quotes sent get no response, the problem is not prospecting but the proposal. This metric points exactly to where money is lost.
3. Average sales cycle
How many days pass on average from first contact to close. If your historical cycle is 45 days and you have 30 opportunities over 60 days old, something is wrong with follow-up. The average cycle is the benchmark for detecting stalled opportunities.
4. Sales activity per representative
Number of calls, visits, emails and quotes per rep per week. This is not about micromanaging; it is about spotting patterns. A rep with many calls but few quotes may need qualification training. Another with few contacts but high conversion may be a role model.
5. Average deal size
The average value of closed deals. If the average deal size drops month over month, the team may be selling the wrong products or accepting excessive discounts. If it rises, the upselling strategy is working.
6. Monthly close forecast
The sum of opportunity values weighted by their close probability. A 10,000 EUR opportunity in negotiation stage (70% probability) contributes 7,000 EUR to the forecast. This is the metric that the C-suite reviews every week.
7. Stalled opportunities
Number of opportunities without activity in the last 7, 14 and 30 days. Every stalled opportunity is potential revenue going cold. If 20% of the pipeline has had no movement for over 2 weeks, the team needs a reactivation plan.
Frequency: daily, weekly and monthly
Not all reports serve the same purpose. Each frequency has an audience and an objective:
Daily (real-time dashboard). For the sales director and the reps themselves. No fixed format, just a panel with the updated pipeline, the day’s activities and alerts for at-risk opportunities. Consulted, not sent.
Weekly (15-minute meeting). For the full sales team. 4 points: opportunities that progressed, stalled opportunities, updated forecast and actions for the week. If it takes longer than 15 minutes, the report is not doing its job.
Monthly (management report). For the CEO or the board. Actual revenue vs. target, pipeline evolution, key metrics compared to the previous month and a list of actions for the next month. Maximum 3 pages or 5 slides.
Format: less text, more visual data
An effective sales report is read in under 2 minutes. That means:
Visual pipeline. A funnel or stacked bar chart showing value by stage. At a glance you see whether there is balance across phases or everything is stuck in prospecting.
Opportunity traffic light. Green (active, recent activity), amber (no activity for 5-7 days), red (over 7 days without movement). The director knows instantly where to intervene.
Trend vs. target. A line showing cumulative monthly revenue against the target. If on day 15 you are at 30%, the conversation is different from being at 60%.
Summary table, not full table. The report shows the 10 most relevant opportunities (highest value, highest risk, closest to close). Full detail is available in the CRM when needed.
Mistakes that undermine report credibility
Numbers that do not match actual invoicing. If the report says you closed 50,000 EUR but accounting recorded 38,000, nobody will trust the next report. The data source must be the CRM, and the CRM must be connected to the billing system.
Vanity metrics. “We made 200 calls this week” means nothing if you do not know how many generated a meeting. Every metric in the report must connect to a measurable commercial outcome.
Changing metrics every month. If in January you measure conversion rate and in February you measure number of demos, you cannot compare. Core metrics must stay constant. You can add complementary metrics, but the 7 essentials always appear.
Not including concrete actions. A report that says “the pipeline dropped 15%” without proposing “launch a reactivation campaign for stalled opportunities” is a diagnosis without treatment. Every relevant data point must come with an action.
How Salesly generates automatic sales reports
Salesly generates reports for you based on the data your team already logs in their daily work. No parallel spreadsheets, no copy-pasting.
Real-time dashboard. The panel shows the pipeline by stage, active opportunities, the monthly forecast and alerts for idle opportunities. It updates with every team action, without waiting for a “weekly close”.
Automatic weekly report. Every Monday, Salesly generates a summary with opportunities that progressed, those that stalled, the updated forecast and activity per rep. It can be emailed or reviewed in the dashboard.
Monthly management report. At month end, Salesly compiles actual revenue vs. target, pipeline evolution, comparative metrics and opportunities won and lost during the period. Exportable as PDF for board presentations.
Filters by rep, period and product. You can generate any report filtered by representative, date range or product line. Each rep can view their own metrics and each director can view the full team’s.
Billing integration. Connected to the orders and invoicing module, the report numbers match accounting. No more discrepancies between “what sales says” and “what finance says”.
If your team still compiles reports in Excel every Friday, there is a better way. Try Salesly free and let the CRM handle your reporting.
FAQ
Can I customise the report metrics?
Yes. Salesly includes the 7 essential metrics by default, but you can add your own metrics, change comparison periods and set custom alerts for each metric.
Are reports generated automatically?
Yes. The dashboard updates in real time. Weekly and monthly reports are generated automatically and can be emailed to the recipients you configure.
Can I export reports?
Yes. Reports export to PDF for presentations or CSV for additional analysis in BI tools. The PDF format includes the dashboard charts.
Can each rep see only their own metrics?
Yes. Salesly permissions let each rep view their activity, pipeline and metrics, while the director has visibility of the full team.
Can I compare periods?
Yes. Every report includes a comparison with the previous period (week, month, quarter). You can also compare custom periods to analyse campaigns or specific seasons.
Related articles
Quote automation: save 5 hours a week for your sales team
Creating quotes manually takes 20 to 40 minutes per document. With a CRM like Salesly, that drops to 2 minutes. Here is how quote automation works in practice.
Mobile CRM: manage your sales team from anywhere
Learn how a mobile CRM boosts field sales productivity. Key features, real-time data capture, and mistakes to avoid when choosing a CRM without a proper mobile app.
Sales forecasting: models, methods and tools for SMBs
Practical guide to sales forecasting for B2B SMBs. The 5 most used methods, common mistakes, tools and how to automate forecasting with a CRM.