Sales quota calculator

Quota is usually set by dividing the company number by the number of reps and adding a cushion. That ignores the fact that territories are not equal, so the same quota is easy in one patch and impossible in another. This calculator blends the top-down target with bottom-up territory potential and checks the result against OTE, so every quota is defensible to the rep who has to carry it.

Category:: Territory & Quota
Formats:: PDF + CSV + web view
Sections:: 5
Updated:: September 24, 2026

What you get

A top-down section that converts the company target into total assigned quota with explicit over-assignment
A territory allocation table that blends flat and potential-weighted quota
Sanity checks: quota as a percent of potential and quota-to-OTE ratio per rep
A worked example where the allocations sum exactly to the assigned total
A quota review checklist for the week before quotas are published

Who it's for

RevOps and sales ops teams setting next year's quotas
VPs of Sales who need to defend quota allocation to reps
Finance partners reconciling total quota to the company target

What's inside

1
Top-down quota allocation
4 columns, 5 worked example rows
2
Bottom-up territory allocation
6 columns, 5 worked example rows
3
Sanity checks
6 columns, 4 worked example rows
4
Reading the example
Guidance notes
5
Quota review before publishing
8-point checklist

Preview of section 1

Top-down quota allocation

Example inputs. Replace with your plan.

Line	Input	Value ($)	Formula
Company new bookings target (this team)		4,000,000	From the board plan
Over-assignment	10%	400,000	4,000,000 x 10%

The preview shows part of section 1. The full template has all 5 sections (4 not previewed here), with blank rows ready to fill in. Download the full template

How to use it

1
Set over-assignment explicitly
Assigned quota should exceed the company target so that the plan survives misses. Write the over-assignment percentage down and get finance to agree to it. Hidden cushions at every layer compound into quotas nobody can hit.
2
Allocate on a blend, not pure potential
Pure potential weighting punishes the rep with the best patch. Pure flat quota ignores the patch entirely. A 50/50 blend is a reasonable starting point; move the weighting toward potential as your potential estimates get more trustworthy.
3
Check quota against potential
Quota as a percent of territory potential tells you how much share the rep has to win. If one rep needs to capture far more of their potential than their peers, the quota is off or the potential estimate is.
4
Check quota against OTE
Divide quota by OTE for each rep. Use your own historical ratio where a healthy share of reps hit plan; treat any rule of thumb as a placeholder. Outliers here usually mean the comp plan and the quota were set by different people.
5
Publish quota with the math
Send each rep their territory potential, the allocation method, and the resulting quota. Reps argue far less about a number when they can see how it was built.

Frequently asked questions

How do you calculate sales quota?

Start from the team's bookings target, add an explicit over-assignment percentage, then allocate across reps using a blend of flat split and territory potential. Check each result as a percent of territory potential and as a multiple of OTE before publishing.

What is quota over-assignment?

The amount by which total assigned quota exceeds the company target, so the target is still met when some reps miss. It should be one explicit number agreed with finance, not a cushion added at every management layer.

What is a good quota-to-OTE ratio?

It depends on segment, deal size, and sales cycle. The most reliable reference is your own ratio from a year when a healthy share of reps hit plan. Any published rule of thumb should be treated as a starting placeholder.

Should every rep in a role have the same quota?

Only if territories have equal potential, which is rare. Equal quotas on unequal territories reward the rep with the best patch and push good reps in weak patches out of the company.