Skip to Content

How to Write a Sales Report in 7 Steps

How to Write a Sales Report in 7 Steps

It is crucial that you create sales reports that showcase the most important information. Learn how to create an effective sales report in a few steps.

We’ve all been in meetings where the sales manager presents an overly complex and confusing sales report. By the end of the meeting, you somehow have less of an idea of how the sales team is performing than when the meeting convened.

Now that you are a sales manager, your company’s executives expect you to keep them apprised of how your team is doing. After all, the sales department is arguably the engine of the company. The information you convey in your sales report will, in large part, fuel major decisions, such as whether to discontinue certain products, ramp up hiring, pay bonuses, and more. According to Suzanne Paling, author of The Accidental Sales Manager, “The information in these reports plays a critical part in helping a manager oversee the success of the sales team and essentially the whole company.”

It is crucial that you create clear, concise sales reports that showcase the most important information your bosses need to steer your company away from potholes and on a smooth road to continued growth and success. Here’s how to do it.

Get fresh insights from 7,700 sales professionals.

Dig into our latest report to learn how sales professionals are driving productivity and efficiency.

High-Performing Sales Teams Embrace Technology to Improve Sales Based on Data

  • Sales anaytics
    • 57% currently using
    • 22% piloting/plan to use in next 12-18 months
  • Customer insights
    • 43% currently using
    • 23% piloting/ plan to use in next 12-18 months
  • Offer managment
    • 44% currently using
    • 20% piloting/ plan to use in next 12-18 months
  • Sales methodologies
    • 46% currently using
    • 23% piloting/ plan to use in next 12-18 months
  • Competitive intelligence
    • 48% currently using
    • 22% piloting/ plan to use in next 12-18 months
  • Targeted sales content
    • 41% currently using
    • 23% piloting/ plan to use in next 12-18 months
  • Predictive analytics
    • 33% currently using
    • 25% piloting/ plan to use in next 12-18 months
  • Price rules engine
    • 36% currently using
    • 19% piloting/ plan to use in next 12-18 months
High performing sales teams embrace technology to improve sales based on data: sales analytics, customer insights, offer management, sales methodologies, competitive intelligence, targeted sales content, predictive analytics, price rules engine

1. Know Your Audience

As a sales manager, you probably sit on a mountain of information that grows bigger by the hour. All of this information is relevant to you, but is it necessary for or useful to your management team? Before you begin to build your sales report, you must first consider your audience and ask yourself what information they need. This perspective will guide you as you choose what data to provide.

For example, the information that interests your vice president of marketing will be vastly different than what your chief financial officer looks for. Your VP of marketing wants to know how well your sales reps are converting the leads her team is providing. She will also want details on which marketing campaigns are leading to the highest conversion rates and have the greatest ROI. In contrast, you CFO will want all of the major sales numbers, along with your expenses. He also needs accurate sales forecasts so he can make sure everyone gets paid and the lights stay on.

Your sales report must reflect the needs of your particular audience. If it seems like a lot of work to redesign your reports for different people, the right CRM system can make that process easy. (More on this a little later.)

2. Pick the Right Info to Share

Once you identify the primary audience of your report, you next need to decide what data will give them an accurate picture of how your team is performing and help them make the decisions to keep their department or the entire company on track. Most reports, especially to upper management, should answer these key questions:

  • Are you meeting your sales goals?
  • What is your revenue versus expenses for the chosen time period?
  • How did your team’s sales compare to previous periods (ex: previous quarter, previous year)?
  • Which products and services are selling the most?
  • Which products and services are not meeting expectations?
  • What is your sales forecast for the next month/quarter/year?
  • What are key areas for opportunities? Do you need to divide a territory or ask for executive assistance to close a big account?
  • What are key challenges? Is it time to pull back from a territory or product line?

All of this information may not be necessary for every report you create, especially if you are presenting to a single department head who may only be interested in a narrow field of information. However, offering a more comprehensive picture of sales performance is often better than giving too little information.

How do Sales Reports Help Managers?

  • Sales reports enable a manager to
    • Track how much time salespeople are spending on different sales activities
    • See if they are meeting their productivity goals
    • Learn whether their efforts are translating into real sales
  • Sales reports paint a picture of the sales representatives’ day even when the manager can’t be there to observe them
  • The information in these reports plays a critical part in helping a manager oversee the success of the sales team and essentially the whole company
How do sales reports help managers? Sales reports enable a manager to: track how much time salespeople are spending on different sales activities, see if they are meeting their productivity goals, learn whether their efforts are translating into real sales.

3. Decide on a Time Period

Are you going to share all your sales numbers from the inception of your company? That would be a pretty hefty report. Instead, figure out what time period you want to focus on. Is this a weekly report, a monthly report, a quarterly report, or a year-end review? The length of time will help determine the focus of the report.

For example, a yearly report will allow you to review larger trends in your industry, customer buying habits, as well as the results of major marketing initiatives, new product roll-outs, and seasonal fluctuations. Choosing a specific time period will also allow you to perform more accurate period-to-period comparisons.

4. Choose the Right Visuals

In every mountain of data you can mine many important, actionable gems, but you can’t expect your management team to grab a pickaxe and start digging. The way you decide to convey information is just as important as the information itself. The primary function of a good sales report is to convey information in a way that is easily understandable, digestible, and actionable.

When you begin compiling numbers, ask yourself, “How can I showcase an important point in the best way possible?” A bar graph may do a better job of showing how much sales of your flagship product have increased over the last five years than simply putting the numbers into a table. Or, maybe a pie chart is the clearest way of showing how each product contributes to your overall sales numbers.

Visually crafting your data isn’t just about making your sales report look pretty. It’s about making the information engaging and easy to understand. Your management team doesn’t have time to sift for gems of info, so don’t make them.

5. Gather Your Data

You can’t build a solid sales report or act without reliable information. Regardless of the size of your company or your particular industry, you need a robust CRM system to capture, track, filter, and help you analyze all of this information before you can put it into your report. Make sure your CRM system has capabilities specifically designed to help you quickly and easily put together highly focused and compelling sales reports.

For example, use a dashboard template that automates the organization of your most important sales metrics, including a Sales Executive Dashboard. You should design and personalize your dashboard to create reports tailored for different department heads. Get an eagle-eye view of your team’s sales performance over time, or dig down into the nitty gritty.

Whether your CEO wants you to present a 10-minute year-to-date review of sales for a new investor, or your VP of marketing asks for a day-long dive into the details of the latest marketing campaign results, use your CRM to quickly and easily design the reports you need.

6. Cut Out the Fluff

When you adopt a robust CRM, you gain access to an unprecedented amount of information. It will be easy to review every aspect of your sales apparatus with a fine-toothed comb. These are powerful abilities for you, the sales manager, but your CEO probably doesn’t need to know how many calls each of your sales reps made yesterday.

It may be tempting to stuff your sales report with as much information as possible, but resist the urge to drown your bosses in the details. Your goal is to present the management team with a clear and concise report that gives them only the information they truly need to take action.

Suzanne Paling’s Recommendations for Basic Sales Reports for Managers

  • The Daily Call Report
    • Accounts are not all created equal
      • Some need to be called on more frequently than others
      • After establishing the call frequency for all of the salespeople’s accounts, the data from this report confirms whether they are adhering to the schedule
    • Number of calls made in a row
    • Specific types of calls
    • Absence of certain types of calls
    • Excessive numbers of certain types of calls
    • Average length of call time
  • The Productivity Report
    • Those managing salespeople need a reasonably accurate summary of how many and which type of calls they make
    • The data often includes the number of
      • Outbound calls
      • Conversations
      • Voice mails
      • Emails
      • Customer meetings
      • Product demonstrations
      • Proposals generated in a given day, week, or month
    • The purpose of this report is to compare actual results against the benchmarks established for each activity
    • When reviewing this report, Paling advises managers to ask:
      • At which point in the sales cycle is the rep below/above productivity quota?
      • In which areas is the rep consistently behind/ahead?
      • Where the rep is below/above the productivity quota, how does it affect the next phase of the sales cycle?
  • The Pipeline
    • The pipeline report consists of all those prospects being actively pursued by a sales representative
    • Separates them by their appropriate phase in the sales cycle
    • This information allows managers to keep track of the total number of prospects the salesperson is working with at any given point
    • Managers can tell how quickly a prospect progresses from one stage to the next or be aware when a prospect drops out altogether
    • Paling offers these as examples of typical pipeline phases:
      • Phase I—Decision-maker expresses interest in product or service
      • Phase II—Salesperson meets with decision maker
      • Phase III—Decision-maker participates in product demonstration
      • Phase IV—Proposal submitted
      • Phase V—Sale closed/sale lost
  • The Sales Forecast
    • The single most important document generated in most sales organizations
      • Holds salespeople accountable for the deals they intend to close at the end of each month
      • Determines which opportunities need executive attention
      • Helps to estimate revenue
      • Paves the way for post-sale product or service delivery
    • The accuracy of this report strongly affects the entire organization
    • The sales forecast shows only those prospects in the final stages of purchasing the product or service
    • When looking at the sales forecast, ask:
      • In which months (1, 2, or 3) is the rep typically above or below quota?
      • Does revenue usually drop in any one month in particular?
      • How many accounts drop out/get added from one month to the next?
      • Does the rep have an easier/more difficult time achieving quota in one product line vs. another?
  • The Long-Range Sales Forecast
    • Typically, the long-range forecast keeps track of prospects planning to buy anywhere from four months to two years from the time of the initial contact with the sales representative
    • Many of these long-range sales involve
      • RFPs
      • Intense competition
      • The possible replacement of the prospect’s current provider
    • Sales like these usually require executive involvement at some point
Suzanne Paling's recommendations for basic sales reports for managers: the daily call report, the productivity report, the pipeline, the sales forecast, the long-range sales forecast

7. Add Context

Numbers can never tell the full story, and data can also be manipulated or misinterpreted. Your responsibility to your management team isn’t just to hand over data; it is also to put the numbers into context. Did overall sales go down last month? That could be a scary metric to your CEO—until you explain that a major tropical storm depressed sales in your top-selling territory and that you expect those customers to buy this month. Make sure you add context in your report so that your team can correctly identify true trends.

Pro tip: Your management team doesn’t have nearly as much insight into your sales operation as you do. Consider adding one or two informative or positive case studies to your report to show your managers what is happening on the ground or to highlight great work by members of your team.

A New Kind of Sales Report

The growing complexity of the business world, along with the increasing capabilities of CRM systems, means that you can’t get by with the same sales reports your predecessors used. These days you have access to a huge amount of data, and you must find a way to boil it down into an informative and useful sales report for your busy executive team.

It may seem like a big task, but remember to consider first who the report is for. Think about the information they need to act, and put that into your report. Choose a time period and figure out how best to clearly convey the information. Your CRM system will help you quickly pull your information into a sleek report. Eliminate data that isn’t essential, and add any additional context that tells the story behind the numbers. And there you have it: A beautiful report that informs, clarifies, and impresses your higher-ups.

Share “7 Steps to Creating a Sales Report Your Bosses Will Enjoy Reading” On Your Site

Jessica Bennett

Jessica Bennett is a writer, editor, and novelist. Her clients span a number of industries, and she's written blog posts, product descriptions, articles, white papers, and press releases— all in the name of inbound marketing. She's proud to be Inbound Certified, but her VP of Morale, Avalon, doesn't quite get what all the fuss is about. But he's a rabbit, so you can't really blame him.

More by Jessica

Get timely updates and fresh ideas delivered to your inbox.