How to Create a Quarterly Sales by Territory Report

A detailed quarterly sales by territory report can transform your sales strategy from guesswork into a data-driven plan. It shows you exactly which regions are thriving, which are lagging, and where your biggest opportunities lie. This guide will walk you through the practical steps to build a powerful and clear sales report, so you can spend less time buried in spreadsheets and more time acting on insights.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why a Quarterly Sales by Territory Report is Essential

Before jumping into the "how," let's quickly cover the "why." A well-structured sales territory report isn't just a collection of numbers, it's a strategic tool. When created and reviewed consistently, it helps your team:

• Identify Top and Bottom Performers: Instantly see which territories are crushing their goals and which need more support. This clarity helps you replicate success and intervene before minor issues become major problems.
• Allocate Resources Smarter: Should you hire another rep for the West Coast or invest in more marketing for the Northeast? This report provides the data you need to make informed decisions about budget, staffing, and marketing spend.
• Set Realistic and Motivating Quotas: Base your sales goals on actual performance and market potential, not just a gut feeling. A territory with historically lower sales but high growth might get a different quota than a mature, saturated market.
• Uncover Market Trends and Opportunities: Notice a sudden spike in sales in a specific region? Maybe a competitor is stumbling, or a new industry is booming there. These reports help you spot trends early and capitalize on them.
• Improve Team Performance and Coaching: By pairing territory data with sales rep data, you can see which reps are excelling in certain environments. This provides valuable context for coaching calls and performance reviews.

Gathering the Right Data for Your Report

The quality of your report depends entirely on the quality of your data. To get started, you'll need to pull together a clean dataset. The goal is to have one central place with a row for every individual sale (or line item) in the quarter. Aim to collect the following fields at a minimum:

• Sale/Order ID: A unique identifier for each transaction.
• Sale Date: Crucial for filtering by quarter. Make sure it's in a consistent format (e.g., MM/DD/YYYY).
• Sale Amount: The revenue generated from the sale.
• Customer Name/ID: To track sales to new vs. existing customers if needed.
• Product/Service Sold: Helps you analyze which offerings are popular in different regions.
• Sales Rep: The name of the person who closed the deal.
• Territory: This is the key field! It could be a state, country, ZIP code, or a custom-defined region (e.g., "Northeast," "West Coast Sales").

Most of this data lives in your CRM, like Salesforce or HubSpot. You can also find it in your accounting software (QuickBooks, Stripe) or e-commerce platform (Shopify). Often, the easiest way to start is by exporting a report from one of these systems into a CSV file, which you can then open in Excel or Google Sheets.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Build Your Report in a Spreadsheet (Excel or Google Sheets)

For many teams, a spreadsheet is the most accessible tool for creating a quarterly sales by territory report. The key is to use a PivotTable, which does the heavy lifting of summarizing your raw data for you.

Step 1: Clean and Prepare Your Data

Before you build anything, take a few minutes to clean your raw data export. This step saves you major headaches later.

• Check for Consistency: Scan your "Territory" column. "California," "CA," and "california" will be treated as three separate territories by a spreadsheet. Standardize them to one format (e.g., state abbreviations). The same goes for sales rep names.
• Format Your Data: Make sure dates are formatted as dates and sales amounts are formatted as currency.
• Fill in the Blanks: Ensure every row has a value for territory and sales amount. Blank cells can cause errors in your analysis.

Once your data is clean, format it as a table by selecting your entire data set and pressing Ctrl + T (or Cmd + T on Mac). This makes your data dynamic, so the PivotTable will automatically include new rows if you add more data later.

Step 2: Create Your PivotTable

A PivotTable is an interactive tool that lets you quickly summarize, group, and analyze large datasets without writing a single formula. It's perfect for this task.

• Click anywhere inside your formatted data table.
• Go to the Insert tab in the ribbon.
• Click PivotTable.
• A dialog box will pop up. Your data table should already be selected. Just confirm you want the PivotTable placed in a "New Worksheet" and click OK.

You'll now have a blank PivotTable on a new sheet, with a "PivotTable Fields" pane on the right side of your screen. This is where you'll build your report.

Step 3: Arrange the PivotTable Fields

This is where your report comes to life. Simply drag and drop the fields from the top of the pane into the four boxes below:

• Rows: Drag the Territory field here. This will create a unique row for each sales territory in your data.
• Values: Drag the Sale Amount field here. It should default to "Sum of Sale Amount," which is exactly what you want. This calculates the total revenue for each territory.
• Filters: Drag the Sale Date field here. This allows you to filter the entire report for a specific time frame, like a single quarter.

As soon as you do this, you'll have a basic sales by territory report! You can now use the "Sale Date" filter at the top of your report to select the exact quarter you want to analyze.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 4: Drill Down and Add More Detail

A great report answers follow-up questions. What if you want to see which reps are performing best within each territory?

Easy. Just drag the Sales Reps field into the Rows box, placing it directly underneath the Territory field. Your PivotTable will instantly update to show a breakdown of sales by rep, neatly nested under their respective territories.

Step 5: Visualize the Data with Charts

A table of numbers is useful, but a chart is often much easier to understand at a glance. Select your PivotTable data and go to the Insert tab to add a visualization.

• Bar Chart: The best choice for comparing total sales across different territories. It makes it immediately obvious which regions are leading and which are trailing.
• Map Chart: If your territories are geographical (states, countries), a map chart is a fantastic way to visualize performance. Excel and Google Sheets can automatically generate a heat map showing sales density across different locations.

Taking Your Report to the Next Level

While spreadsheets are great, they can become cumbersome, especially as your team grows. Manually exporting CSVs and refreshing reports every quarter is time-consuming and prone to human error.

Using Native CRM Reporting (e.g., Salesforce, HubSpot)

Your CRM likely has built-in reporting tools that can generate basic sales by territory reports. These are often great for a quick look at performance and can be configured to update automatically on a dashboard. The primary limitation is that they usually only show you data from that single platform. If you want to combine CRM data with financial data from QuickBooks or advertising data from Google Ads, you're back to exporting CSVs.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Dedicated BI Tools (Power BI, Tableau, Looker)

Business Intelligence tools are the next step up. They allow you to connect directly to multiple data sources (like Salesforce, Shopify, and Google Analytics) and build powerful, interactive, and automated dashboards. You can set them up once, and they will pull fresh data automatically.

The main challenge with these tools is their complexity. Becoming proficient in Power BI or Tableau requires a significant time investment and technical know-how. This often creates a bottleneck where only one "data person" on the team can build or update reports.

Best Practices for an Effective Report

No matter which tool you use, follow these principles to make your report as valuable as possible:

• Keep It Simple: Focus on the most important metrics. A cluttered report with too many data points is harder to read and understand. Start with total sales by territory and add more detail only when necessary.
• Include Comparisons: Context is everything. Compare performance against the previous quarter (QoQ) or the same quarter last year (YoY) to understand growth trends. Are you growing, shrinking, or staying flat?
• Tell a Story: Don't just present the numbers, add a few bullet points with your analysis. What do the numbers mean? What actions should the team take based on this data?
• Automate When Possible: The less manual work you have to do each quarter, the better. Automation reduces errors and frees you up to focus on strategy instead of report-building.

Final Thoughts

Creating a quarterly sales by territory report moves your team from guessing about performance to making strategic, evidence-based decisions. By gathering clean data, using a PivotTable to summarize it, and adding simple visualizations, you can uncover powerful insights that will drive growth and improve sales effectiveness across the board.

Of course, the manual process of pulling data and building PivotTables is exactly the kind of repetitive work that steals time away from strategic analysis. At Graphed, we help you skip that process entirely. You can connect your CRM (like Salesforce or HubSpot), your database, or even Google Sheets, and then ask questions in plain English like, "Show me a bar chart of total sales by territory for Q3 compared to Q2." We'll instantly build a live, shareable dashboard that updates automatically, giving you back hours of your week. Check out Graphed to see how you can get answers from your sales data in seconds, not hours.