How to Create a Quarterly Sales Report

A compelling quarterly sales report does more than just present numbers - it tells the story of your last three months and sets the stage for the next. Creating one that’s both detailed and easy to understand is essential for tracking progress, identifying trends, and making smarter decisions. This guide will walk you through building a high-impact sales report from start to finish.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Exactly is a Quarterly Sales Report?

A quarterly sales report is a document that summarizes your sales team's performance, activities, and results over a three-month period. Think of it as a regular health check for your sales operations. It’s not just a backward-looking summary, it's a strategic tool used to analyze what worked, what didn't, and why, so you can guide your team effectively in the quarter to come.

Why is it so important?

• Performance Measurement: It’s the clearest way to see if you’re hitting your revenue targets and sales goals.
• Trend Identification: Spotting patterns - like a specific product selling well in one region or a dropoff in leads from a certain channel - helps you adapt quickly.
• Team Accountability: It provides clear, data-backed insights into both team and individual performance, helping managers coach effectively.
• Strategic Planning: The insights from one quarter directly inform the strategy, goals, and forecasts for the next.

Step 1: Gather the Right Sales Data

Before you build your report, you need to collect the right information. Drowning your stakeholders in dozens of metrics is counterproductive. Instead, focus on the data points that truly reflect the health and performance of your sales engine. Most of this information should live in your CRM (like Salesforce or HubSpot), but you might need to pull from other sources, too.

Sales Performance Metrics

These are the headline numbers that tell you the overall outcome of the quarter.

• Total Revenue: The total amount of money generated from sales. You might break this down into new business, upsells, and renewals.
• Number of Deals Won: The total count of closed-won opportunities.
• Average Deal Size: Calculated by dividing total revenue by the number of deals won. An increasing average deal size is a great sign of health.
• Sales Volume by Product/Service: Which of your offerings are bringing in the most revenue? This helps identify your star performers.
• New Customers vs. Returning Customers: A key metric for understanding customer lifetime value and the effectiveness of your acquisition and retention efforts.

Sales Funnel and Pipeline Metrics

These metrics dig into the process, showing you how efficiently your team turns leads into paying customers.

• Leads Generated: The total number of new potential customers that entered your pipeline. It’s useful to segment this by source (e.g., website, marketing campaign, cold outreach).
• Conversion Rates by Stage: Track the percentage of leads that move from one stage of the sales pipeline to the next (e.g., Lead-to-Opportunity, Opportunity-to-Closed-Won). Low conversion rates at a specific stage can signal a bottleneck.
• Sales Cycle Length: The average time it takes to close a deal from the initial contact. A shorter cycle means your team is working more efficiently.
• Pipeline Velocity: A metric that measures how quickly deals are moving through your pipeline and generating revenue.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Team and Individual Performance Metrics

Finally, you need to measure the people driving the results. This helps you recognize top performers and identify reps who may need extra coaching.

• Quota Attainment: What percentage of the sales quota did each rep and the team as a whole achieve?
• Deals Closed per Rep: A straightforward measure of who is closing the most business.
• Activity Metrics: The number of calls made, emails sent, and meetings booked per sales rep. While not an indicator of success on their own, these metrics show effort and can be correlated with results.

Step 2: Structure Your Sales Report

With your data in hand, it’s time to organize it into a coherent narrative. A wall of numbers won't engage anyone. The best reports are structured logically, guiding the reader from the high-level summary to the detailed action plan.

1. Executive Summary

Start with a short, high-level overview. Always assume your audience is busy. The executive summary should provide the most important takeaways in just a few sentences. What were the biggest wins? Did you hit the overall revenue target? What was the single most important trend from the quarter? If someone only read this section, they should still understand the quarter's outcome.

2. Performance vs. Goals

This is where you directly compare your results against the targets you set at the beginning of the quarter. Use simple visualizations to make the comparison immediate and clear.

• A bar chart showing Actual Revenue vs. Target Revenue.
• A gauge chart or bullet chart displaying Team Quota Attainment %.
• Side-by-side comparisons of key metrics from this quarter versus the previous quarter (QoQ) and the same quarter last year (YoY) to show growth and trends.

Be direct. Clearly state whether you met, exceeded, or missed your goals.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

3. The Quarter's Story: Wins, Challenges, and Insights

Now, add context. The data tells you what happened, but this section explains why it happened. Split this into two parts:

Wins and Highlights

Celebrate what went right! This boosts morale and reinforces successful strategies. Examples could include:

• Spotlighting top-performing sales reps and their key deals.
• Detailing how a new marketing campaign led to a surge in high-quality leads.
• Showcasing a specific product that significantly outsold expectations.

Challenges and Opportunities

Be honest and analytical about what didn't work. This isn't about placing blame, it's about learning and improving.

• Analyze major deals that were lost. What were the common reasons? (e.g., pricing, competition, product features).
• Identify any regions or sales reps that underperformed against their goals.
• Discuss any bottlenecks in the sales funnel, such as where deals are stalling out.

4. Sales Funnel and Pipeline Analysis

Dedicate a section to the health of your pipeline. Analyze and visualize metrics like:

• The total number of new opportunities created this quarter.
• The close rate (deals won / total deals).
• The average sales cycle duration and how it compares to previous quarters.

A healthy pipeline is the best predictor of future success, so this section is critical for forecasting.

5. Forecast and Action Plan for the Next Quarter

This is arguably the most important part of the report because it turns analysis into action. Based on everything you've presented, what happens next?

• Sales Forecast: Based on the current pipeline and historical data, project the revenue for the upcoming quarter.
• Key Priorities: List 2-3 top priorities for the sales team. For example: "Increase average deal size by 10%" or "Shorten the sales cycle for mid-market deals."
• Actionable Steps: For each priority, outline the specific actions you'll take.

Step 3: Choose the Right Tools for the Job

How you build the report depends on your tools and technical comfort. There isn't a single "best" way, but some methods are far more efficient than others.

Customer Relationship Management (CRM) Systems

Tools like Salesforce and HubSpot have built-in reporting dashboards. These are fantastic for pulling predefined reports on individual metrics like deals closed or pipeline stages. However, they can become limiting when you need to combine data from different objects or create a highly custom view.

Spreadsheets (Excel or Google Sheets)

The time-honored tradition. Most companies rely on exporting CSVs from their CRM and other sales tools, then wrangling the data into pivot tables and charts in a spreadsheet. This method provides total flexibility but comes with major downsides:

• It's incredibly manual and time-consuming. The process of downloading, cleaning, and formatting data can take hours every week, let alone every quarter.
• It's prone to human error. A single copy-paste error or broken formula can throw off your entire report.
• The data is instantly stale. The moment you export a CSV, it's a static snapshot. It doesn't update in real-time.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Business Intelligence Tools

Platforms like Tableau or Power BI are extremely powerful. They can connect to multiple data sources, build complex data models, and create fully interactive dashboards. The major hurdle is the steep learning curve. Becoming proficient in these tools often requires weeks or even months of training, making them overkill for many sales teams who just need straightforward, timely reports.

Best Practices for Reporting That Clicks

Once you’ve put your report together, follow these final tips to ensure it lands with impact.

• Keep it Visual: Use charts, graphs, and tables to tell your story. A line chart is perfect for showing trends over time, a bar chart works well for comparisons (like rep performance), and a pie chart can show commission breakdowns.
• Provide Context: Raw numbers are meaningless without context. Always compare results to goals, past periods (like the previous quarter or last year), or industry benchmarks.
• Know Your Audience: A report for the CEO should be high-level and strategic. A report for sales managers needs to be more granular, with details on individual rep and team performance. Tailor the content accordingly.

Final Thoughts

Ultimately, a killer quarterly sales report is more than a recap, it's a strategic roadmap. By gathering the right data, structuring it into a clear narrative, and outlining actionable steps, you transform a chore into one of your most powerful tools for driving growth and improving performance quarter after quarter.

We know that compiling these reports manually can be a major drain on time - exporting CSVs, fighting with spreadsheet formulas, and pasting screenshots into a slide deck. At Graphed , we built a tool to fix that. Our AI data analyst connects directly to your data sources like Salesforce, HubSpot, and Google Analytics so you can build real-time, interactive dashboards by simply describing what you want in plain English. This turns hours of reporting busywork into a 30-second conversation, freeing you up to focus on analyzing insights and coaching your team.