Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesSales & CRMPerformance & TerritorySales Commission Tracker

SpreadsheetPerformance & TerritoryFree

Sales Commission Tracker

Tiered commission with an accelerator above quota, a margin kicker, payouts to date and what each rep is owed.

Shown with sample data

Colour

Sales Commission Tracker

Tiered commission with an accelerator above quota, a margin kicker, payouts to date and what each rep is owed.

Commission owed
$5,483
Total earned
$10,083
Team attainment
84%
Cost of sales
7.3%
Commission as a share of bookings
Attainment by rep
  • Dana115.7%
  • Mia86.5%
  • Leo41.8%
Commission earned by rep
  • Dana$5,62656%
  • Mia$3,20332%
  • Leo$1,25412%

How to use it

  1. 1Set the tier rates, margin threshold and kicker on the Plan sheet.
  2. 2Enter each rep's quota for the period and what has been paid so far on the Reps sheet.
  3. 3Log every closed-won deal with rep, customer, value and gross margin.
  4. 4Pay each rep the Owed amount and record it in Paid to date.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Pay commission the way modern sales plans work. Log closed deals with their margin; each rep's bookings roll up against quota, and commission is calculated in tiers: a base rate up to 50% of quota, a standard rate to 100% and an accelerator on everything above quota, plus a kicker on high-margin deals. Paid to date and amount owed keep payouts accurate and every number is traceable to the plan.

Who it’s for

  • Sales managers running monthly or quarterly payouts
  • Founders designing a first commission plan
  • Reps checking their own earnings

What’s included

  • Deals sheet: Every closed-won deal this period.
  • Reps sheet: Bookings against quota and commission earned, paid and owed.
  • Plan sheet: Commission plan rules.

How to use it

  1. 1Set the tier rates, margin threshold and kicker on the Plan sheet.
  2. 2Enter each rep's quota for the period and what has been paid so far on the Reps sheet.
  3. 3Log every closed-won deal with rep, customer, value and gross margin.
  4. 4Pay each rep the Owed amount and record it in Paid to date.

Tips

  • Keep the plan simple enough that reps can calculate it themselves.
  • Accelerators above quota reward over-performance without raising base cost.
  • Pay on cash received if customers often pay late.

Questions

How do the tiers work?

Bookings up to 50% of quota earn the first rate, the next 50% earn the standard rate and anything above quota earns the accelerator.

What is the margin kicker?

An extra percentage of deal value on deals at or above the margin threshold, to reward profitable deals.

Related searchessales commissioncommission calculatorcommission trackeracceleratorquotasales compensation

Details

Format
Spreadsheet
Category
Performance & Territory
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetPerformance & TerritoryFree

Sales Commission Tracker

Tiered commission with an accelerator above quota, a margin kicker, payouts to date and what each rep is owed.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Performance & Territory
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More performance & territory templates

View all
Sales Rep Scorecard2 sheets

Team revenue

$547,000

Team attainment

88%

Team win rate

33%

Revenue by rep
$172k
$96k
$92k
$78k
$58k
MayaLenaDevElenaRavi
SpreadsheetPerformance & Territory

Sales Rep Scorecard

Compare reps on activity, pipeline, win rate and quota attainment on one page.

10 min setupPreview
Sales Territory Plan2 sheets

Company target

$3,200,000

Sum of territory targets

$3,201,000

Overall penetration

25%

Territory target
$784k
$729k
$700k
$508k
$480k
SouthStrategicNorthWestEast
SpreadsheetPerformance & Territory

Sales Territory Plan

Balance territories by accounts, potential and workload, and set a revenue target for each.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ