ColurianCOLURIAN
← All free tools Free tool

Sales quota calculator

Turn an annual revenue target into a quota per rep, with new reps counted at their ramp, then work back to the deals, pipeline and new opportunities each rep needs.

Free, no sign-up · Runs in your browser · Updated

Turn a revenue target into quotas and pipeline

Start from the year's target. The calculator splits it across your reps, counts new reps at their ramp, and works back to the pipeline each rep needs.

—Quota per ramped rep
—Quota per new rep
—Deals to win per ramped rep
—Pipeline per ramped rep
—New opportunities per rep, per month

In Colurian, reports and dashboards show each rep's won deals and open pipeline, with no add-on.Book a demo

In short: start from the revenue the business needs, add a buffer, and split it across your reps by how much each can realistically sell. Then work backwards: deal size tells you how many deals that is, and win rate tells you how much pipeline it takes.

How the quotas are worked out

  1. Team quota. Revenue target × (1 + over-assignment). Over-assignment is a buffer, often 10–20%, so the business still hits its number if some reps miss.
  2. Rep-equivalents. Fully ramped reps count as one each. A new rep counts at their capacity: a rep expected to sell half a normal year counts as 0.5.
  3. Quota per ramped rep. Team quota ÷ rep-equivalents. A new rep's quota is that figure × their capacity.
  4. Deals per rep. Quota ÷ average deal size, rounded up.
  5. Pipeline per rep. Quota ÷ win rate. At a 25% win rate, every $1 of quota needs $4 of pipeline.
  6. New opportunities per month. Deals needed ÷ win rate ÷ 12.

Sense-checking the result

  • Compare with last year. If the new quota is far above what your best rep closed last year, the target or the headcount needs another look.
  • Check the opportunity number. If each rep needs more new opportunities a month than marketing and prospecting have ever produced, quota attainment will suffer whatever the target says.
  • Ramp honestly. New reps rarely sell at full speed in their first months. Counting them at 100% inflates everyone else's quota later in the year when they miss.

Once quotas are set, the sales forecast calculator shows whether the pipeline in front of you is on track for them.

Frequently asked questions

What is over-assignment?

Setting the sum of all quotas above the company's revenue target, so the target is still reached if some reps fall short. A 10% over-assignment on a $1.2M target makes the team quota $1.32M.

How do I pick a win rate?

Divide the deals you won last year by all the deals that reached a real opportunity stage and then closed, won or lost. Use deals that closed, not ones still open.

Does the calculator save what I type?

No. It runs entirely in your browser. Nothing you enter is sent anywhere.