How to Create a Quarterly Sales by Territory Report in Google Sheets

Tracking quarterly sales performance by territory is essential for spotting regional trends, allocating resources, and coaching your team effectively. While it sounds complex, you can build a powerful and dynamic sales report without leaving the comfort of Google Sheets. This guide will walk you through the entire process, from structuring your raw data to creating an interactive dashboard with charts and filters.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Start with Clean, Structured Sales Data

Before you can build any report, you need a solid foundation of clean data. Your sales data should be organized in a simple list format on a single sheet, preferably in a Google Sheet tab named "Raw Data." Avoid merged cells, empty rows, or extra header text. Every row should represent a single sale, and every column should represent a specific piece of information about that sale.

Your data should, at a minimum, include these columns:

• Sale Date: The date the deal was closed or the sale was made. This must be in a valid date format.
• Sales Territory: The geographic area or team responsible for the sale (e.g., North, South, West).
• Sale Amount: The revenue value of the sale. This should be a number without currency symbols.

Ideally, your dataset would have a few more useful details for deeper analysis, such as:

• Order ID: A unique identifier for each sale.
• Sales Rep: The name of the salesperson who closed the deal.
• Product/Service Category: What was sold.

Here’s an example of what your pristine data table should look like:

Pro Tip: Ensure territory names are consistent. "West" and "west" will be treated as two different territories, so pick a format and stick with it. Using Data Validation rules can help enforce consistency.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Add Helper Columns for Quarter and Year

To group our sales data by quarter, we need to first calculate the quarter for each sale date. The easiest way to do this is by adding a "helper column" to our raw data sheet. While we’re at it, let's include the year to prevent data from different years from being mistakenly grouped together.

Let's assume your 'Sale Date' is in column A. Find an empty column next to your data (let's say column F), label the header "Quarter", and enter this formula in the first data row (cell F2):

="Q" & ROUNDUP(MONTH(A2)/3,0) & " " & YEAR(A2)

Drag the fill handle (the small blue square in the corner of the cell) down to apply this formula to all your rows. Now, let's break down what this formula does:

• YEAR(A2): This simple function extracts the year from the date in cell A2 (e.g., 2024).
• MONTH(A2): Similarly, this function extracts the month number (1-12) from the date.
• MONTH(A2)/3: This divides the month number by 3. January (1) becomes 0.33, February (2) becomes 0.66, March (3) becomes 1, April (4) becomes 1.33, and so on.
• ROUNDUP(...,0): This rounds the result of the division up to the nearest whole number. This neatly groups the months into quarters: months 1-3 all round up to 1 (Q1), months 4-6 round up to 2 (Q2), etc.
• "Q" & ... & " " & ...: The ampersand (&) is used to join text together. We’re combining the letter "Q" with our calculated quarter number and the year to produce clear, readable labels like "Q1 2024" or "Q3 2024".

With this helper column, our data is now perfectly prepared for reporting.

Use a Pivot Table to Summarize Your Data

Pivot tables are the engine of reporting in Google Sheets. They take a large dataset and quickly summarize it into a compact, insightful table. We’ll use one to create the core of our quarterly sales report.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step-by-Step Guide to Creating the Pivot Table:

1. Select Your Data: Click anywhere inside your data table (including your new Quarter column). Press Ctrl + A (or Cmd + A on Mac) to select the entire range.
2. Insert Pivot Table: Navigate to the menu and click Insert > Pivot table.
3. Choose Where to Place It: In the pop-up, Google Sheets will confirm the data range. Choose the "New sheet" option for placement. This keeps your raw data separate from your final report, which is much cleaner. Click Create.
4. Configure the Report Layout: A new sheet will appear with a blank pivot table and the Pivot table editor on the right. This editor is where you define the structure of your report. Drag and drop the fields like this:

Just like that, you have a perfectly formatted quarterly sales report! It will show a clear breakdown of total sales for each territory, neatly organized by quarter. When you add new data to your "Raw Data" sheet, refresh the pivot table, and it will automatically update with the latest totals.

Visualize Your Report with Charts

Numbers in a table are great, but visuals make insights jump off the page. A chart can quickly show you which territories are leading and which might need support.

Let's create a column chart to compare performance:

1. Select the Pivot Table Data: Click and drag to highlight the territories and their quarterly sales totals in your pivot table. Be sure to include the headers.
2. Insert a Chart: Go to Insert > Chart. Google Sheets will suggest a chart type, which is often a stacked column chart in this case — a great choice!
3. Customize Your Chart: The Chart editor will appear, letting you refine the visual:

Position your new chart next to your pivot table. Now you have a mini-dashboard that gives you both a detailed numerical summary and a high-level visual comparison of performance.

Make Your Report Interactive with Slicers

A static report is helpful, but an interactive one is empowering. With slicers, you can filter your report by other categories - like sales rep - without altering the pivot table’s structure. This allows you to drill down into the data on the fly.

Here’s how to add a Sales Rep filter:

1. Click anywhere inside your pivot table to select it.
2. In the menu, go to Data > Add a slicer.
3. A slicer element will appear on your sheet. In the settings on the right, under "Column," choose "Sales Rep" (or another field you want to filter by, like Product Category).
4. Optionally, use the "Customize" tab to change the slicer's title and colors.

Now, you can use the slicer dropdown to select one or more sales reps. Both your pivot table and your chart will instantly update to show the data only for the reps you’ve selected. This is fantastic for seeing how an individual rep's sales are distributed across territories or for comparing the performance of two reps.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Final Thoughts

Transforming a long list of sales transactions into an insightful quarterly territory report is a valuable skill, and Google Sheets provides all the necessary tools. By tidying up your data, using formulas to create helper columns, and leveraging pivot tables and charts, you can build a reporting dashboard that provides real clarity into your team's performance.

While building reports in Google Sheets is powerful, the process of manually exporting data, cleaning it, and refreshing reports can still become a weekly chore. We built Graphed because we believe getting answers from your data should be much faster. You can connect sources like Salesforce, HubSpot, or a Google Sheet directly to us, and then simply ask in plain language: "build a chart showing sales by territory for each quarter this year." We automatically create the live dashboard for you, saving you valuable time to focus on strategy, not spreadsheets.