Example Data Table
| Scenario |
Total Leads |
Qualified Leads |
Closed Deals |
Average Deal Value |
Base Rate |
Expected Use |
| New sourcing partner |
150 |
55 |
12 |
$700 |
5% |
Test basic payout terms. |
| Agency campaign |
500 |
210 |
48 |
$950 |
7% |
Check tiered performance. |
| High-ticket referral |
80 |
34 |
10 |
$2,500 |
4% |
Estimate premium deal payouts. |
Formula Used
Gross sourced revenue = Closed deals × Average deal value
Base commission = Gross sourced revenue × Base commission rate
Tier commission = Tier one extra commission + Tier two extra commission
Qualified lead bonus = Qualified leads × Bonus per qualified lead
Closed deal fee total = Closed deals × Flat fee per closed deal
Commission before deductions = Base commission + Tier commission + Qualified lead bonus + Closed deal fee total
Lead sourcing cost = Total sourced leads × Lead cost per sourced lead
Total deductions = Lead sourcing cost + Chargeback deduction + Holdback deduction
Net commission payout = Commission before deductions − Total deductions
Lead conversion rate = Closed deals ÷ Total sourced leads × 100
Lead quality rate = Qualified leads ÷ Total sourced leads × 100
How to Use This Calculator
Enter the number of sourced leads, qualified leads, and closed deals. Add the average deal value and base commission rate. Then enter bonuses, flat fees, tier thresholds, lead cost, chargeback reserve, and holdback percentage.
Press the calculate button to view the payout estimate. The result appears above the form and below the header. Use the CSV button for spreadsheet records. Use the PDF button for a simple payout report.
Understanding Lead Sourcing Commission
A lead sourcing commission plan rewards the person who finds useful prospects. It also protects the business from paying too much on weak leads. This calculator combines lead volume, quality, deal value, tier rates, sourcing fees, costs, chargebacks, and holdbacks.
Lead sourcing is different from a simple sales commission. A source may only introduce the lead. A closer may complete the deal later. Because of that, the payout often depends on several checkpoints. These checkpoints may include qualified lead approval, closed deals, revenue collected, and clawback rules.
Why Inputs Matter
Use the total sourced leads field to track every lead delivered. Use qualified leads for prospects that meet your acceptance rules. Closed deals should include only deals that are approved for payout. Average deal value should reflect expected revenue per closed sale. If real deal values vary, use a blended average for quick planning.
The base rate calculates the core commission from closed revenue. Tier thresholds then add extra commission when revenue passes a target. This helps reward better sourcing performance without changing the base rate. The qualified lead bonus rewards early pipeline value. The flat sourcing fee rewards each closed deal separately.
Reading The Results
Costs matter in lead sourcing. A campaign may look profitable before advertising, tools, data, or list-building costs are deducted. Lead cost per record helps estimate that spend. Chargeback percentage handles expected refunds, canceled deals, or unpaid invoices. Holdback percentage reserves money for later review.
The net commission is the most useful result. It shows estimated payout after bonuses and deductions. The effective rate compares net commission with generated revenue. Conversion rate shows how many sourced leads became closed deals. Quality rate shows how many sourced leads passed qualification.
Better Payout Planning
For best results, update inputs each month. Compare different rates before launching a partner agreement. Save CSV or PDF outputs for records. Review formulas with your finance team if contracts have special terms. The calculator is a planning aid, not a legal agreement. Always match the final payout with signed commission terms, accounting rules, and payment schedules.
Advanced users can model several sourcing partners. This keeps approvals fair. It also reveals when better lead quality deserves a higher tier.
FAQs
What is lead sourcing commission?
It is a payout for finding or referring leads. The amount can depend on qualified leads, closed deals, revenue, bonuses, tiers, and deductions.
Can I calculate commission for a referral partner?
Yes. Enter referred leads as sourced leads. Use qualified leads and closed deals to match your referral agreement. Add flat fees or bonuses when needed.
What is a qualified lead bonus?
It is a fixed reward for each accepted lead. It is useful when a source creates value before a deal closes.
How does tier commission work?
Tier commission adds extra payout after revenue crosses set thresholds. Higher tiers can reward stronger sourcing performance without changing the base rate.
Why include lead cost?
Lead cost shows the expense of finding each lead. It helps compare gross commission with realistic net payout after sourcing spend.
What is a chargeback reserve?
It is a deduction for possible refunds, cancellations, unpaid invoices, or reversed deals. Use the rate that matches your payout policy.
What does effective net commission rate mean?
It compares net commission with gross sourced revenue. It shows the real payout percentage after bonuses, costs, chargebacks, and holdbacks.
Can I export the result?
Yes. Use the CSV button for spreadsheet work. Use the PDF button for a simple downloadable commission report.