How to Create a Quarterly Sales Report in Google Sheets

Building a quarterly sales report doesn't have to be a complicated task that takes up half your Monday. With Google Sheets, you can create a clear, dynamic, and shareable report that gives you a solid overview of your team's performance. This article will walk you through, step-by-step, how to collect your data, calculate key metrics, and visualize your results to create a quarterly sales report that actually helps you make better decisions.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

First Things First: Gather and Organize Your Sales Data

Before you can build a report, you need clean, well-structured data. The quality of your report is entirely dependent on the quality of your raw data. Your goal is to have a single sheet that acts as your database, with each row representing a single sale or transaction and each column representing a specific piece of information about that sale.

Create a new Google Sheet and dedicate the first tab to your raw data. Name it something like "Sales Data Q1 2024". Your columns should include, at a minimum:

• Transaction Date: The day the sale was made. Make sure this is a consistent date format (e.g., MM/DD/YYYY).
• Sales Rep: The name of the person who closed the deal.
• Customer Name/ID: Who bought the product.
• Product/Service Sold: The specific item or service purchased.
• Product Category: A broader category for analysis (e.g., Software, Hardware, Services).
• Units Sold: The quantity of the product sold.
• Sale Amount: The total revenue from the transaction.

Pro-Tip: Keep this data tab pure. Do not add summaries, calculations, or charts here. This sheet is solely for your raw, unedited data. This separation makes it much easier to manage, update, and use formulas on your data without breaking anything.

Set Up Your Reporting Dashboard

Now, create a new tab in your Google Sheet and name it "Q1 Sales Report". This will be your dashboard. It’s where you’ll pull data from your "Sales Data" tab to create summaries, calculate key metrics, and display charts. This separation between raw data and your report is a best practice that keeps everything organized and prevents accidental edits to your source data.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Essential Metrics for Your Quarterly Report

A good sales report doesn’t just show lump sums, it answers specific business questions. Here are the key metrics we’ll build, all based on the data in your "Sales Data" tab.

• Total Quarterly Revenue: The most fundamental metric. How much did you sell in total?
• Average Deal Size: What is the average value of a single transaction?
• Sales Performance by Rep: Who are your top performers?
• Sales Performance by Product/Category: What are your best-selling items?
• Monthly Sales Trend: How did performance fluctuate within the quarter?

Building the Report: Essential Google Sheets Formulas

Let's start placing our calculations into the "Q1 Sales Report" tab. We will use two powerful functions: SUMIFS and QUERY. We'll assume your raw data lives in a tab named 'Sales Data Q1 2024'.

1. Calculate Total Quarterly Revenue

The SUMIFS function is perfect for adding up numbers based on multiple criteria - in this case, all sales that fall within our quarter (e.g., January 1st to March 31st).

In a cell on your report tab, type "Total Revenue." In the cell next to it, enter this formula:

=SUMIFS('Sales Data Q1 2024'!G:G, 'Sales Data Q1 2024'!A:A, ">=2024-01-01", 'Sales Data Q1 2024'!A:A, "<=2024-03-31")

Formula Breakdown:

• 'Sales Data Q1 2024'!G:G: This is the range we want to sum (the "Sale Amount" column).
• 'Sales Data Q1 2024'!A:A, ">=2024-01-01": This is our first condition. It looks at the "Transaction Date" column (A:A) and only includes dates on or after January 1, 2024.
• 'Sales Data Q1 2024'!A:A, "<=2024-03-31": This is our second condition, including only dates on or before March 31, 2024.

2. Calculate Average Deal Size

Similar to SUMIFS, we can use AVERAGEIFS to find the average sale amount for the quarter.

Next to a cell labeled "Average Deal Size," enter:

=AVERAGEIFS('Sales Data Q1 2024'!G:G, 'Sales Data Q1 2024'!A:A, ">=2024-01-01", 'Sales Data Q1 2024'!A:A, "<=2024-03-31")

This formula works the same way as our revenue calculation but computes the average instead of the sum.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

3. Rank Sales Rep Performance with QUERY

The QUERY function is one of the most powerful tools in Google Sheets. It lets you use SQL-like commands to search and aggregate your data. We'll use it to create a leaderboard of your sales reps.

Find a spot on your report for a sales rep table. In the top-left cell of where you want this table to appear, enter:

=QUERY('Sales Data Q1 2024'!A:G, "SELECT B, SUM(G) WHERE A >= date '2024-01-01' AND A <= date '2024-03-31' GROUP BY B ORDER BY SUM(G) DESC LABEL B 'Sales Rep', SUM(G) 'Total Revenue'")

Formula Breakdown:

• 'Sales Data Q1 2024'!A:G: The entire data range we're querying.
• "SELECT B, SUM(G) ...": This is our command, written in plain language.
• SELECT B, SUM(G): Select the Sales Rep column (B) and the sum of the Sale Amount column (G).
• WHERE A ...: The date filter, similar to our SUMIFS. We're telling it to only look at rows within Q1.
• GROUP BY B: This groups all sales by the sales rep's name.
• ORDER BY SUM(G) DESC: This sorts the results in descending order by total revenue, putting your top performers at the top.
• LABEL B 'Sales Rep', ...: This gives our output columns clean, reader-friendly headers.

This single formula will generate a complete, formatted table of your reps and their sales totals for the quarter, sorted from highest to lowest.

4. Identify Top-Selling Products or Categories

We can use an almost identical QUERY formula to find our best-selling product categories. Just change the columns you are selecting and grouping by.

=QUERY('Sales Data Q1 2024'!A:G, "SELECT D, SUM(G) WHERE A >= date '2024-01-01' AND A <= date '2024-03-31' GROUP BY D ORDER BY SUM(G) DESC LABEL D 'Product Category', SUM(G) 'Total Revenue'")

Here, we just changed SELECT B to SELECT D and GROUP BY B to GROUP BY D to analyze by "Product Category" instead of "Sales Rep".

Visualize Your Data with Charts

Numbers are great, but charts make insights easier to spot and understand. Now that you have your summary tables, let's create some visuals.

Sales by Rep Bar Chart

A bar chart is perfect for comparing performances.

1. Highlight the two columns of data generated by your Sales Rep QUERY formula (Sales Rep name and their Total Revenue).
2. Go to Insert > Chart in the Google Sheets menu.
3. In the Chart editor on the right, select "Bar chart" or "Column chart."
4. Customize the titles and colors under the "Customize" tab to match your report's branding.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Revenue by Product Category Pie Chart

A pie chart is a good way to show the composition of your total sales.

1. Highlight the data from your Product Category QUERY formula.
2. Go to Insert > Chart.
3. Select "Pie chart" from the Chart type dropdown.
4. Google Sheets will automatically calculate the percentages for you. You can customize labels to show values, percentages, or both.

Monthly Trend Line Chart

To see how your sales progressed through the quarter, you'll need a simple summary table showing total sales for January, February, and March. You can create this with three separate SUMIFS formulas, one for each month.

Once you have this small table, select it, go to Insert > Chart, and choose a "Line chart". This will give you an immediate visual of your sales trajectory throughout the quarter.

Best Practices for a Great Report

You’ve done the heavy lifting. Here’s how to put the finishing touches on your report.

• Keep It Simple: Don't cram too much information onto one screen. Prioritize the most important metrics at the top.
• Use Clear Titles: Label every chart and table clearly (e.g., "Q1 Revenue by Sales Rep" instead of just "Chart 1").
• Add Context: Below your main KPI dashboards, include a small section for "Key Takeaways" or "Observations." Write a few bullet points about what the data is showing. For instance, "Sarah was the top rep, driven by high-value deals in the software category."
• Share and Collaborate: Use Google Sheets' built-in sharing features to give stakeholders view-only or comment access. This allows your team to see the report in real-time without risking accidental edits.

Final Thoughts

Creating a quarterly sales report in Google Sheets is a powerful, no-cost way to get on top of your performance data. By organizing your information, mastering a few key formulas like SUMIFS and QUERY, and visualizing your findings, you can turn a simple spreadsheet into an engine for actionable insights that helps your whole team succeed.

While Google Sheets is an amazing tool, the process of downloading CSVs, cleaning data, and triple-checking formulas every quarter can still eat up valuable time. We built Graphed to remove this manual work. By directly connecting to your data sources like Salesforce, HubSpot, or Stripe, Graphed lets you build real-time, automatically updating sales dashboards just by asking questions in plain English. Instead of building formulas, you can simply ask, "Show me a comparison of sales rep performance this quarter" and get an interactive dashboard in seconds.