Skip to content
Sales Goal Tracker cover: a sample sheet with team goal, closed so far and team progress and a bar chart, beside the Dashboard, Reps and Wins tabs

Sales Goal Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Modern
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

This tracker helps a sales lead or small team see progress toward a quarterly goal. The Reps tab holds each person's goal and calculates what they have closed, how much remains and their progress, highlighted by a colour scale. The Wins tab logs each closed deal with its date, rep, deal name and amount. The Dashboard shows the team goal, the closed total, team progress and a bar chart comparing goal and closed for each rep.

Set goals at the start of the quarter, then log each win on the day it closes so progress stays current. Use the same rep names on the Reps and Wins tabs, or closed amounts will not count. To check whether the team is on pace, compare team progress with the share of the quarter that has passed. If progress trails the calendar, plan extra outreach for the rest of the period.

Useful for

  • Tracking quarterly targets for a small sales team
  • Showing each rep how much is left to close
  • Checking early in the quarter whether the team is on pace

What's included

  • 4 tabs: Dashboard, Reps, Wins, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Reps: a table
  • Wins: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Reps tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How is the amount remaining calculated?

The Remaining column subtracts the closed amount from the goal and shows zero once a rep has passed it. On the dashboard, Left to goal subtracts all closed wins from the team goal, so one rep's extra sales can offset another rep's gap.

Can I track goals by month instead of by quarter?

Yes. Set the goals on the Reps tab for the period you want, then keep only the Wins rows from that period. For monthly goals, save a fresh copy on day one of each month. The formulas and charts keep working because they read whatever rows are on the Wins tab.

What if a deal is cancelled after it closes?

Delete its row on the Wins tab, or set its amount to zero. The progress updates straight away. To keep a trace of the cancellation, note it in the deal name before you remove the amount.

  • #sales-tracker
  • #sales-goal-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More sales tracker templates

See all 8

Also in Sales

All sales templates
Get this template

Preparing your template…