Table of Contents

Subscribe

Sales Tracker in Google Sheets: Rep Targets and a Live Leaderboard

Sales tracker in Google Sheets showing five reps' October attainment against target with ahead, close and behind labels

It's Friday 16 October, and the team sales sheet has Daniel on top with $64,000 in won deals. But $38,000 of that closed in September. Count only October against each rep's own target and the picture changes: Aisha leads at 70%, and Tom, third on the board, is at 21% with over half the month gone.

A sales tracker in Google Sheets fixes this with one shared deal log, one tab of monthly targets and a scoreboard that counts only the deals closed this month. It divides each rep's wins by their target, compares the result with how much of the month has passed, and ranks the team automatically.

Below: the tabs and formulas, a worked example with five reps, a fair leaderboard, and the mistakes that make sales numbers drift.

Why a Sales Tracker in Google Sheets Beats One Spreadsheet per Rep

When every rep keeps their own sheet, each ends up with its own columns, stage names and idea of what "closed" means. The team total becomes a Friday copy-and-paste job that nobody quite trusts.

A shared tracker puts every deal and every call, meeting and email into the same structure, so one set of formulas can read all of it. Identical tabs per rep that feed one summary work too. Either way, this is a people view: who is ahead, who is behind and why. A pipeline view shows how many deals sit at each stage; for that, see this guide to building a sales pipeline dashboard.

The Four Numbers Behind a Sales Performance Tracker

Whatever layout you choose, a sales performance tracker runs on four numbers. Here they are for Maya, a rep with a $40,000 monthly target, on 16 October:

  1. Target is the revenue a rep is expected to close this month: $40,000.
  2. Attainment = closed-won revenue this month ÷ target. Maya has closed $24,000, so she is at 24,000 ÷ 40,000 = 60%.
  3. Pace = working days gone ÷ working days in the month. October 2026 has 22 working days and 12 have passed, so pace is 12 ÷ 22 = 55%. By now Maya needed $40,000 × 12 ÷ 22 = $21,818, so she is $2,182 ahead.
  4. Win rate = deals won ÷ deals closed. Maya won 3 and lost 2 this month: 3 ÷ 5 = 60%.

Diagram: $24,000 won divided by a $40,000 target equals 60% attainment, and 12 of 22 working days equals a 55% pace, so the rep is ahead

Attainment says how far a rep has got; pace says how far they should be by now.

Pace is the number many trackers leave out. 40% attainment on the 25th is a problem; on the 8th it is ahead of schedule. Compare sales target vs achievement only at month end and you get a verdict. Compare it with pace weekly and you can still act.

Win rate has a cousin: conversion rate divides wins by every deal worked, including open ones. Compare reps on the same one.

How to Build a Sales Tracker in Google Sheets

You need four tabs and about a dozen formulas. Every formula below was tested on the worked example in the next section, so you can paste them as they are.

Diagram of a Google Sheets sales tracker: Reps, Deals and Activities tabs feeding one Scoreboard tab and its leaderboard

Three input tabs feed one scoreboard.

Step 1: List your reps and their monthly targets

Create a tab called Reps with two columns: Rep and Monthly target. A rep covering a bigger territory should carry a bigger number, and the scoreboard will measure everyone against their own.

Step 2: Log every deal in one tab, with a close date

Create a tab called Deals with Date added, Rep, Customer, Value, Stage and Close date in columns A to F. Fill in Close date only when a deal is won or lost; that date decides which month gets the credit.

Give Stage a dropdown so it is always spelled the same way: select the column, open Data > Data validation > Add rule, set the criteria to Dropdown and enter Lead, Qualified, Proposal, Negotiation, Closed Won, Closed Lost and On Hold. For Rep, choose Dropdown (from a range) and enter Reps!A2:A. Keep contact details in a client tracker and only the customer name here.

Step 3: Log calls, meetings and emails

Create a tab called Activities with Date, Rep, Type and Customer in columns A to D, and give Type a dropdown of Call, Meeting and Email. This is your sales activity tracker: one row per activity, logged the same day.

Step 4: Build the scoreboard

Create a tab called Scoreboard. Put the first day of the month in B1 and =TODAY() in B2. In B3, work out the pace:

=NETWORKDAYS(B1,MIN(B2,EOMONTH(B1,0)))/NETWORKDAYS(B1,EOMONTH(B1,0))

Format B3 as a percentage. NETWORKDAYS counts Monday to Friday, and MIN stops pace passing 100% after the month ends. To skip public holidays, add a range of holiday dates as a third argument to both NETWORKDAYS calls. Put headers in row 5 and rep names in A6:A10, then add these formulas in row 6 and fill them down:

  1. Target (B6): =VLOOKUP($A6,Reps!$A:$B,2,FALSE)
  2. Won $ (C6): =SUMIFS(Deals!$D:$D,Deals!$B:$B,$A6,Deals!$E:$E,"Closed Won",Deals!$F:$F,">="&$B$1,Deals!$F:$F,"<="&EOMONTH($B$1,0))
  3. Attainment (D6): =IF(B6=0,0,C6/B6)
  4. Ahead or behind pace, in dollars (E6): =C6-B6*$B$3
  5. Deals won (F6): =COUNTIFS(Deals!$B:$B,$A6,Deals!$E:$E,"Closed Won",Deals!$F:$F,">="&$B$1,Deals!$F:$F,"<="&EOMONTH($B$1,0)), and the same in G6 with "Closed Lost".
  6. Win rate (H6): =IF(F6+G6=0,"",F6/(F6+G6))
  7. Activities (I6:K6): type Call, Meeting and Email as headers in I5:K5, then fill right =COUNTIFS(Activities!$B:$B,$A6,Activities!$C:$C,I$5,Activities!$A:$A,">="&$B$1,Activities!$A:$A,"<="&EOMONTH($B$1,0)). The header doubles as the criterion.

Format D and H as percentages. Every count runs from the first to the last day of the month in B1, so changing B1 to November shows November.

Step 5: Rank the team and color the scoreboard

In L6, rank each rep by revenue and fill it down: =RANK(C6,$C$6:$C$10)+COUNTIF($C$6:C6,C6)-1. The COUNTIF part breaks ties. To rank by attainment instead, point both parts at column D: =RANK(D6,$D$6:$D$10)+COUNTIF($D$6:D6,D6)-1.

Then build the leaderboard:

  1. In row 14, type the headers Rank, Rep and Won $.
  2. Put the numbers 1 to 5 in A15:A19.
  3. In B15, pull in the rep who holds that rank: =INDEX($A$6:$A$10,MATCH($A15,$L$6:$L$10,0))
  4. In C15, use the same formula with $C$6:$C$10 in place of $A$6:$A$10 to bring across their revenue.
  5. Fill B15:C15 down to row 19.

For progress bars, type Progress in M5 and fill this SPARKLINE function down from M6: =SPARKLINE(D6,{"charttype","bar";"max",1;"color1","#4ea14e"}). A full bar is 100% of target.

Then select A6:L10, open Format > Conditional formatting, choose Custom formula is, and add three rules:

  • Green, at or ahead of pace: =$D6>=$B$3
  • Amber, up to 10 points behind: =AND($D6<$B$3,$D6>=$B$3-0.1)
  • Red, more than 10 points behind: =$D6<$B$3-0.1

Google Sheets sales scoreboard with target, won revenue, attainment, gap to pace and win rate for five reps, colored green, amber and red

The finished scoreboard with the three pace colors applied.

That grid is now a working sales target tracker. A rep slipping behind turns amber mid-month, while there is still time to act.

Step 6 (optional): Add a monthly history

List the first day of each month from A23 down. In B23, total that month's wins with =SUMIFS(Deals!$D:$D,Deals!$E:$E,"Closed Won",Deals!$F:$F,">="&A23,Deals!$F:$F,"<="&EOMONTH(A23,0)). Count them in C23 with COUNTIFS and the same conditions, and get the average deal in D23 with =IF(C23=0,0,B23/C23).

This small monthly sales report shows whether revenue grew from bigger deals or just more of them. In the example, October's $94,500 so far already beats September's $84,000. But it comes from 11 deals averaging $8,591, against 7 averaging $12,000.

Worked Example: Five Reps, Halfway Through October

Here is a five-person team on Friday 16 October 2026, 12 working days into a 22-day month. Targets differ because territories do.

Rep Monthly target Won in October Deals won / lost Calls, meetings, emails
Maya $40,000 $24,000 3 / 2 30, 10, 25
Daniel $50,000 $26,000 2 / 2 26, 8, 30
Aisha $30,000 $21,000 3 / 1 18, 9, 14
Tom $40,000 $8,500 1 / 4 52, 6, 41
Lucia $30,000 $15,000 2 / 1 20, 11, 16

Two sales leaderboards: all-time revenue puts Daniel first with $64,000, while October against target shows Aisha at 70% and Tom at 21%

The same team, before and after the board counts only October.

The scoreboard shows three things the old board hid:

  • Daniel's lead was mostly September. Without last month's $38,000 he has $26,000: 52% of a $50,000 target and $1,273 behind pace. He still leads on revenue, but is third against target.
  • Aisha is furthest ahead. $21,000 against $30,000 is 70%, which puts her $4,636 ahead of pace.
  • Tom needs help now, not on the 31st. He made the most calls, 52, but booked only 6 meetings and won 1 of 5 closed deals. At 21% he is $13,318 behind pace. The fix is turning calls into meetings, not more calls.

Together the team has $94,500 of $190,000: 50% against a 55% pace. A team total on its own would have looked roughly on track.

Sales Leaderboard Template: What to Rank and What to Show

The number you rank by shapes what people chase. Revenue is the simplest and hardest to argue with. Deals won rewards volume. Attainment is fairer when targets differ widely. Whatever you rank by, read win rate and activity beside it, or you can't tell the busy rep from the effective one.

Scatter chart of activities against win rate for five reps: Tom has the most activities, 99, and the lowest win rate, 20%

Busy and effective are not the same thing.

How the board is shown matters too. A 2025 Journal of Marketing study of more than 27,000 salespeople at over 170 firms compared three formats. Rankings with names raised quota attainment and lowered turnover. Anonymous rankings raised attainment, but more people left. Named rankings that also showed each quota cut turnover without a significant lift in attainment.

That is why the Step 5 leaderboard shows only names and revenue, while targets stay on the scoreboard. If the whole team sees the sheet, move the leaderboard to its own tab and point the formulas at the Scoreboard tab, for example Scoreboard!$A$6:$A$10. The practical reading: use names, rank on one plain number, and review each rep's attainment with them one to one.

Five Mistakes That Make Sales Numbers Drift

A sales tracker rarely breaks in one go. It drifts, one shortcut at a time, and the most common cause is a stage typed by hand:

Three won deals typed as Closed Won, Won and Closed-Won: SUMIFS counts only $9,500 of $24,000

One stage typed three ways, and $14,500 of Maya's $24,000 disappears.

  1. Typing stages instead of picking them. "Won" and "Closed-Won" look fine to a person but not to SUMIFS, which ignores capitals but not spelling. A dropdown removes the problem.
  2. Counting last month's wins in this month's number. A SUMIFS without a date condition adds up every win ever logged. That was Daniel's $64,000.
  3. Judging effort by activity alone. Tom logged 99 activities in 12 working days, the most on the team, and has the lowest attainment. Read activity next to win rate.
  4. Checking the target only at month end. By the 31st a shortfall is history. Compare attainment with pace every Friday.
  5. Letting each rep build their own layout. Different columns and stage names can't be added up. Give everyone the same structure, whether one shared log or identical tabs.

When a Spreadsheet Stops Being Enough

A spreadsheet suits a sales tracker while the team is small and the process simple. Everyone can open it, there is no per-seat fee, and you can change a formula the day your process changes. Simplicity has value: in a 2024 Gartner survey of 1,026 B2B sellers, half said they were overwhelmed by the amount of technology they need.

It starts to strain when:

  • calls and emails need to log themselves from your phone system or inbox;
  • reps need a mobile app to update deals between meetings;
  • commissions, territories or approvals depend on the numbers;
  • several managers need their own views and permissions.

Checklist: when a spreadsheet sales tracker is enough and when a CRM is worth it (auto-logging, mobile, commissions)

A quick test for when to move beyond a spreadsheet.

If two or more of those sound familiar, a CRM is worth the cost. If not, a sheet the whole team opens every day will usually beat a system they avoid.

If You'd Rather Not Build It Yourself

Everything above works, and the sheet is yours to keep adjusting. If you would rather start from a finished version, the Sales Pipeline Tracker from Acesheets is the same idea built out in full, for Google Sheets or Excel.

Each rep gets a tab with a monthly target and this month's target-reached figure, shown as a progress bar in Google Sheets. Rows record the date, activity type, customer, product, deal value and one of eight deal stages; won deals turn green and lost ones are struck through. The five activity types live in a Settings list, so rename them there before you start logging.

The dashboard ranks reps by revenue with their deals won, filters by month or salesperson, and charts activities, revenue, monthly sales and deals, and each rep's won, lost and other deals. Its win-rate chart divides wins by all deals logged, the conversion rate described above.

Sales Pipeline Tracker dashboard in Google Sheets with a revenue leaderboard, activity counts and win rate, revenue and deal charts

The Sales Pipeline Tracker dashboard in Google Sheets.

Frequently Asked Questions

How do you calculate sales target achievement percentage?

Divide the revenue a rep has closed in the period by their target, then format it as a percentage. $90,000 closed against a $120,000 quarterly target is 75%. Wrap the division in IF so a blank target returns 0, and count only deals closed inside the period.

What is a good win rate in sales?

There is no single benchmark: win rate depends on deal size, industry and how early deals enter the tracker. Teams that log every cold lead see lower rates than teams that log only qualified opportunities. Compare against your own history and watch each rep's monthly trend.

How do I make a leaderboard in Google Sheets that updates automatically?

Rank each rep with RANK, add a COUNTIF tie-breaker so no two reps share a place, then pull names into order with INDEX and MATCH. Every step is a formula, so the board reorders itself when a deal is marked Closed Won. SORT works in Google Sheets too, but INDEX and MATCH also work in Excel.

What is quota attainment?

Quota attainment is the share of a sales quota a rep has closed: closed revenue divided by quota, the same calculation as target achievement. Teams often say "quota" when the number is tied to pay and "target" when it is a goal. The formulas here work for either.

Can I build a sales tracker in Google Sheets for free?

Yes. Google Sheets is free with a Google account, and every formula in this guide uses built-in functions. The limits are practical: activities are logged by hand, and anyone with edit access can change any row unless you protect ranges. For a small team, that is usually enough.