Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesSales & CRMForecast & QuotaSales Quota Attainment Tracker

SpreadsheetForecast & QuotaFree

Sales Quota Attainment Tracker

Bookings against quota for each rep, with pace for the days gone, projected finish, pipeline coverage and the gap to close.

Shown with sample data

Colour

Sales Quota Attainment Tracker

Bookings against quota for each rep, with pace for the days gone, projected finish, pipeline coverage and the gap to close.

Team attainment
45%
Projected finish
84%
At the current run rate
Gap to quota
$347,000
Pipeline coverage
1.4
Open pipeline ÷ gap; aim for 3 or more
Attainment by rep
  • Priya Nair81.3%
  • Mia Rossi48.8%
  • Dana Wu42.1%
  • Tom Becker37.5%
  • Leo Park26.7%
  • Sam Diaz25.6%
Gap to quota by rep
  • Leo Park$73,300
  • Dana Wu$69,500
  • Sam Diaz$67,000
  • Tom Becker$59,400
  • Mia Rossi$56,300
  • Priya Nair$21,500

How to use it

  1. 1Set the quarter's start and end dates and the pipeline coverage target on the Settings sheet.
  2. 2Enter each rep's quota, monthly bookings and current open pipeline.
  3. 3Review pace and projected finish weekly; reps At risk or Behind need a plan.
  4. 4Use pipeline coverage to see who needs more prospecting.

In this workbook

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

About this template

See where every rep stands against quota the way revenue leaders review it. Monthly bookings roll up to attainment; pace compares that with how much of the quarter has gone, a projected finish extends today's run rate to quarter end, and pipeline coverage shows whether each rep has enough open pipeline to close the gap. The status is worked out for you: Achieved, On pace, At risk or Behind.

Who it’s for

  • Weekly forecast calls
  • Quarterly business reviews
  • Coaching reps who are behind

What’s included

  • Quota sheet: Quarterly quota, bookings and outlook for each rep.
  • Settings sheet: Quarter dates and coverage target.

How to use it

  1. 1Set the quarter's start and end dates and the pipeline coverage target on the Settings sheet.
  2. 2Enter each rep's quota, monthly bookings and current open pipeline.
  3. 3Review pace and projected finish weekly; reps At risk or Behind need a plan.
  4. 4Use pipeline coverage to see who needs more prospecting.

Tips

  • 3x pipeline coverage of the remaining gap is a common rule of thumb.
  • A rep behind pace early in the quarter can recover; late in the quarter they need help now.
  • Update bookings the day deals close so the pace stays honest.

Questions

What does pace mean?

Attainment compared with the share of the quarter that has passed. 100% pace means the rep is exactly on track.

How is projected finish worked out?

Bookings so far divided by the share of the quarter gone. It assumes the current run rate continues.

Related searchesquota trackersales quotaquota attainmentpipeline coveragesales forecastsales leaderboard

Details

Format
Spreadsheet
Category
Forecast & Quota
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetForecast & QuotaFree

Sales Quota Attainment Tracker

Bookings against quota for each rep, with pace for the days gone, projected finish, pipeline coverage and the gap to close.

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
Forecast & Quota
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More forecast & quota templates

View all
Weighted Pipeline Forecast2 sheets

Quarter target

$250,000

Weighted forecast

$209,200

Commit

$120,000

Weighted value by deal
$67k
$36k
$36k
$26k
$22k
Harbor Logistics, fleet suiteApex Build, estimatingNorthwind Health, analyticsBrightline Retail, POS rolloutMeridian Clinics, scheduling
SpreadsheetForecast & Quota

Weighted Pipeline Forecast

Forecast the quarter from open deals: stage probability, close month and the gap to target.

10 min setupPreview
Monthly Sales Forecast3 sheets

Forecast revenue

$586,979

Gross profit

$373,235

Gross margin

64%

Forecast revenue by month
$80k
$67k
$54k
$51k
$46k
DecNovOctSepMay
SpreadsheetForecast & Quota

Monthly Sales Forecast

A 12-month forecast by product from base volume, monthly growth and seasonality, with revenue, gross profit and actuals vs forecast.

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