📊 Sales Rep Quota Calculator
Set data-driven sales quotas for your team
💡 Quick Tips
- Use your last 12 months of sales data for historical close rate and deal size
- Set attainment rate between 70-90% for realistic, motivating quotas
- Adjust for seasonal fluctuations by using period-specific revenue targets
How to Use This Tool
Start by entering your total revenue target for the selected period (monthly, quarterly, or annual) and select your local currency. Input the number of active sales representatives on your team, then add your average deal size based on historical sales data.
Next, enter your team’s historical close rate (the percentage of leads that convert to closed deals) and the average number of leads each rep receives per period. Finally, set your desired quota attainment rate: this is the percentage of reps you expect to meet or exceed their quota, typically between 70% and 90% for realistic targets.
Click Calculate Quota to generate a detailed breakdown, or Reset to clear all fields. Use the Copy Results button to save the output to your clipboard for team sharing or record-keeping.
Formula and Logic
This calculator uses standard sales operations benchmarks to generate quotas aligned with your business goals. The core logic follows these steps:
- Total Required Closed Deals = Total Revenue Target ÷ Average Deal Size
- Total Leads Needed = Total Required Closed Deals ÷ (Historical Close Rate ÷ 100)
- Per Rep Revenue Quota = (Total Revenue Target ÷ Number of Reps) ÷ (Desired Attainment Rate ÷ 100)
- Per Rep Leads Needed = Total Leads Needed ÷ Number of Reps
- Current Lead Potential Revenue = (Leads Per Rep × Number of Reps) × (Close Rate ÷ 100) × Average Deal Size
The revenue gap calculation subtracts your current lead potential from your total target to show if you need to increase lead volume, improve close rates, or adjust deal sizes to hit goals.
Practical Notes
For e-commerce and trade businesses, adjust average deal size to account for bulk order discounts or wholesale pricing tiers. B2B sales teams should factor in longer sales cycles for quarterly or annual quotas, while B2C e-commerce sellers may focus on monthly periods for faster iteration.
Use market benchmarks to validate your inputs: average close rates for B2B sales range from 15% to 25%, while B2C e-commerce conversion rates typically fall between 2% and 5%. If your desired attainment rate is above 90%, quotas may be too easy and fail to drive growth; below 60% may demotivate reps.
Factor in seasonal fluctuations for retail or trade businesses: use period-specific revenue targets (e.g., higher Q4 targets for holiday sales) rather than annual averages to avoid unrealistic quotas during slow periods.
Why This Tool Is Useful
Setting arbitrary sales quotas often leads to misaligned team goals, demotivated reps, or missed revenue targets. This tool replaces guesswork with data-driven benchmarks tailored to your team’s historical performance and business context.
Small business owners and sales managers can use the detailed breakdown to identify gaps in lead volume or close rates, then adjust marketing spend or sales training accordingly. The currency and period selectors make it adaptable for global trade teams, e-commerce sellers, and local businesses alike.
By factoring in attainment rates, you can set quotas that are challenging but achievable, reducing turnover and improving overall team performance.
Frequently Asked Questions
What is a good quota attainment rate for sales teams?
Most high-performing sales teams target a 70% to 85% attainment rate. This means 70-85% of reps meet or exceed their quota, balancing ambition with realism. Rates above 90% suggest quotas are too low, while rates below 60% may indicate unachievable targets that hurt morale.
How do I calculate average deal size for my business?
Average deal size is your total revenue from closed deals over a period divided by the number of deals closed in that same period. For trade businesses with bulk orders, separate deal size calculations for wholesale and retail customers may be necessary to set accurate quotas.
Should I include inbound or outbound leads in the leads per rep field?
Include all qualified leads assigned to reps, regardless of source. Ensure your close rate matches the lead type: if you use separate close rates for inbound and outbound leads, calculate a weighted average close rate before entering it into the tool.
Additional Guidance
Review and update your quota inputs quarterly to reflect changes in team performance, market conditions, or pricing strategy. If your revenue gap is consistently positive, consider increasing marketing spend to boost lead volume, or investing in sales training to improve close rates.
For businesses with tiered commission structures, use the individual rep revenue quota to calculate commission payouts aligned with your compensation plan. Avoid setting quotas based on top performer results alone: use team averages to ensure quotas are fair for all reps.
Global trade teams should update the currency selector when calculating quotas for regional sales teams to avoid conversion errors. E-commerce sellers can use the tool to set daily or weekly quotas by dividing monthly targets by the number of selling days in the period.