Calculate quota attainment: enter actual sales and quota to get percent to quota and the amount remaining or above it, with optional pacing for the period.
- All Business Calculators
- Sales Ratio Calculator
- OTE Calculator
- Target Profit Calculator
- Sales Per Labor Hour Calculator
Sales Quota Ratio Formula
The calculator runs three modes. Each uses its own formula.
Attainment mode:
Sales needed mode:
Quota from sales mode:
- Actual Sales: closed-won revenue in the period.
- Quota: the assigned sales target.
- Attainment: sales as a percentage of a positive quota; enter 85 for 85%.
- Period completed: optional elapsed share above 0% and up to 100%; blank omits pacing.
Choose one of the three solve modes and enter its visible inputs. Quota ratio = sales ÷ quota; percentage variance from quota = attainment − 100. Optional pacing uses expected sales to date = quota × period fraction and projected finish = sales ÷ period fraction. It assumes uniform sales accumulation, not a pipeline forecast. Sales-needed mode uses its calculated sales as a scenario. The calculator does not estimate funnel capacity, quota fairness, OTE or commission payments. Amounts use USD without exchange conversion.
Attainment Readings and Archived Illustrations
The first table states only the mathematical relationship to quota. Attainment alone cannot diagnose employee fit, quota fairness or compensation. The second table retains archived illustrative source assumptions; its win rates, sales cycles and quota-to-OTE ratios are not validated benchmarks or inputs to this calculator.
| Attainment | Reading |
|---|---|
| 110%+ | At least 10% above the quota amount; pay treatment depends on the plan. |
| 100% to 109% | Quota met or exceeded by up to 9% in this displayed range. |
| 80% to 99% | Between 1% and 20% below the quota amount. |
| 60% to 79% | Between 21% and 40% below the quota amount. |
| Below 60% | More than 40% below the quota amount; cause is not determined. |
| Archived illustrative role | Illustrative Win Rate | Illustrative Cycle | Illustrative Quota:OTE |
|---|---|---|---|
| SMB / Inside | 22-30% | ~1 mo | 5x-7x |
| Mid-market | 18-25% | 2-3 mo | 4x-6x |
| Enterprise | 15-20% | 4-9 mo | 3x-5x |
Worked Examples
Example 1 – Attainment. A rep closed $85,000 against a $100,000 quota. Attainment is (85,000 / 100,000) × 100 = 85%; the quota ratio is 0.85:1. The remaining quota gap is $15,000. A 110% attainment level requires $110,000 sales, or $25,000 more than the actual sales.
Example 2 – Solving for quota. Actual sales are $425,000 at 85% attainment. Quota = $425,000 ÷ (85 / 100) = $500,000. For the first example, entering 50% period completion gives expected-to-date sales of $50,000, a 170% pace index and projected finish of $170,000. This projection assumes uniform pace and does not assess whether a quota is reachable.
FAQ
What counts as “actual sales” for attainment? Use the same sales measure, crediting rules and period as the quota, such as bookings or recognized revenue as defined by your organization. The ratio does not determine which compensation rules apply.
What does optional period pacing assume? It treats sales as accumulating uniformly through the entered elapsed share. Expected-to-date sales = quota × period fraction; projected finish = sales ÷ period fraction. A positive elapsed share is required. Deal timing, ramp, pipeline and seasonality are not modeled.
Can quota be solved when sales or attainment is zero? Zero sales against a known positive quota gives 0% attainment. But zero sales and zero attainment do not identify a unique quota. Positive sales with 0% attainment, or zero sales with positive attainment, cannot determine a finite positive quota.
Can attainment exceed 100%? Yes. Above 100% means the sales amount exceeds the quota amount. Commission rates, accelerators and eligibility depend on the actual compensation plan and are not calculated here.
