Create a report that displays quarterly sales by territory

Eoin Comerford by Eoin Comerford on October 13, 2020  |  5 minute read
Try it for free

Despite all the research highlighting the importance of long-term planning, most companies run on 90-day reporting.

The quarterly sales report is a business staple. But like every KPI or sales metric you track, there are sales reports and more sales reports. The difference often comes down to the data.

Modern sales teams thrive on data. With better information, every sales rep can maximize their potential, push more deals through the sales cycle, and hit their revenue target.

However, good data doesn't just appear out of thin air. It has to be pulled from reliable sources and curated into reports that are easy to understand. There are many ways to prepare an actionable quarterly sales report, so let's start.

What makes an excellent quarterly sales report?

Every sales team is different. But there are some standard features you'll find in most sales reports. Here are some examples:

Sales revenue: Obviously. You would expect a quarterly sales report to break new revenue down by customer, sales rep, lead source, and territory (more on later).

Sales forecast: If you've got good data on what you've done, you have a better chance of forecasting what you'll do next. That allows for better planning and not just in sales.

Open opportunities: The quarter is over but assuming you're still in business, you'll want to know how much of your sales pipeline is rolling over. At the end of a quarter, there is a natural drop in intensity; measuring the new sales pipeline is critical.

Average deal size: A popular KPI with sales managers. Nudging up the average deal size is an excellent way to improve sales productivity (more revenue from the same or similar effort and cost).

Sales activity: How busy was each sales rep? How many meetings did they attend? How many calls did they make? How many new opportunities made it to a particular sales stage? A useful leading indicator for next quarter.

Why good data is vital for managing a sales team

A veteran sales rep might trust their gut when working their sales funnel. But a good sales report needs hard numbers.

According to Salesforce, high performing sales professionals are 1.5 times more likely to create forecasts using data. Lower-performing reps relied on their instincts.

Accurate sales forecasts allow a sales manager to allocate resources more efficiently. Other teams can rely on sales projections to prepare for new customers. And financial decision-makers can run a more realistic cash flow.

Analyzing data by territory

With good, clean data, your quarterly sales dashboard can provide new insights.

Breaking the numbers down by territory can quickly highlight inefficiencies and missed opportunities.

Salesperson A may miss the quota due to unfair lead distribution or processes. Salesperson B is overloaded with customers and cannot service them effectively.

Circumstances can change quickly. You need to organize and realign sales territories in real time. That way, you can get your resources in the right place and cut inefficiency out of your sales process.

Is sales territory management an integral part of your overall strategy? Analyzing your market by geographic area can be the first step toward developing a sales territory plan.

excel-banner

Using Microsoft Excel to report on quarterly sales by territory: Functional but limited

You may already have access to tools that you can use to create a sales report by territory. Microsoft Excel is the most popular.

However, the functionality of the world's favorite spreadsheet could be improved. Such reports may also take time to develop without producing clear insights immediately.

The process of creating a quarterly sales report in Excel is pretty straightforward.

First, you'll create columns for each quarter and input the totals according to the category you'd like to highlight. Territories are one category example.

If you have multiple data sources, you'll have to input each item manually, then total them up using a pivot table. You'll also need to adjust the formatting to display dollars and cents or dates. You can select graphical displays for the data when you're done, including pie charts with adjustable color settings.

Most people are familiar with Excel, but there are a few downsides to relying on it for your quarterly sales reporting:

  • The potential for human error: If you can export sales figures from another application, you have an advantage. If you still need to, you'll have to enter all the relevant data by hand, cross-referencing where necessary. There's substantial room for mistakes in either situation, especially if you misconfigure the sums or need to format your data correctly.
  • The time commitment: The entire process can add to a sizable time burden, from entering data to formatting the report. Keep in mind this doesn't even involve any analysis. It's just accounting for the bare minimum required to produce the report.
  • The bigger picture: Quarterly sales reports produced in Excel stand-alone and lack integration with other programs. You'll have to read between the lines to develop your takeaways. You must also deploy other unique tools based on what you've learned.

Territory reporting with dedicated software

If breaking down your quarterly sales data by territory matters to your business, you need dedicated software.

Proper territory optimization tools are quicker and easier to use. And they can update in real time, helping you jump on every opportunity.

Key benefits

Territory mapping solutions like eSpatial are designed with sales teams in mind. And relieve the admin burden from your sales managers.

You can also leverage integrations for seamlessly transferring and reporting data between different sources.

In addition, dedicated mapping software provides better visual insight into your sales territories. It can help you better align your resources, driving higher revenue with lower costs.

All in all, this means:

  • Improved accuracy
  • Lower sales team burden
  • Better, faster insights


Eoin Comerford Written by

Eoin Comerford

Eoin is an eSpatial mapping expert with more than 10 years of experience in the field. He specializes in using mapping to help sales and marketing professionals target revenue growth, make cost reductions and improve customer service.

Read more from Eoin Comerford