Calculator Inputs
Use direct sales, or let the page estimate sales from orders and average order value.
Example Data Table
This sample shows how different programs can change final payout and total marketing cost.
| Campaign | Gross Sales | Orders | Base Rate | Refund Rate | Tier Bonus | Final Payout | Total Cost Rate |
|---|---|---|---|---|---|---|---|
| Content Partner A | $12,000 | 160 | 8% | 4% | 1.5% | $1,120.32 | 10.12% |
| Coupon Site B | $8,500 | 210 | 6% | 8% | 0% | $511.98 | 7.23% |
| Influencer C | $15,750 | 95 | 10% | 3% | 2% | $1,930.50 | 13.60% |
| Loyalty Partner D | $6,400 | 140 | 5% | 2% | 0.5% | $346.56 | 6.15% |
Formula Used
Gross Sales = Entered Gross Sales or Orders × Average Order Value
Refunded Sales = Gross Sales × Refund Rate
Discount Cost = Gross Sales × Discount Rate
Eligible Sales = Gross Sales − Refunded Sales − Discount Cost
Base Commission = Eligible Sales × Base Commission Rate
Override Commission = Eligible Sales × Override Rate
Tier Bonus = Eligible Sales × Tier Bonus Rate, when threshold is met
Fixed Bonus Total = Orders × Fixed Bonus Per Order
Gross Commission = Base + Override + Tier Bonus + Fixed Bonus
Final Affiliate Payout = Gross Commission − Withholding
Merchant Total Cost = Final Affiliate Payout + Network Fee
Contribution After All Costs = Eligible Sales − Merchant Total Cost − Cost of Goods
How to Use This Calculator
- Enter direct gross sales, or enter orders and average order value.
- Add the base commission rate for the affiliate program.
- Include overrides, thresholds, and tier bonuses when your plan uses them.
- Enter refund, discount, network fee, and withholding percentages.
- Optionally add cost of goods for a stronger profitability view.
- Click Calculate Commission to see results above the form.
- Review payout, total cost, effective rates, and contribution margin.
- Use the CSV or PDF buttons to export the calculation summary.
Frequently Asked Questions
1) What does eligible sales mean?
Eligible sales are the sales remaining after subtracting refund losses and discount cost. This adjusted amount is used for most payout calculations.
2) When should I use orders and average order value?
Use them when gross sales are unavailable. The calculator automatically estimates gross sales by multiplying total orders by average order value.
3) What is an override rate?
An override rate is an extra percentage paid on eligible sales, often used for partner managers, sub-affiliate structures, or agency oversight arrangements.
4) How does the tier bonus work?
If eligible sales reach the threshold you entered, the calculator applies the tier bonus percentage to eligible sales. If not, tier bonus stays zero.
5) Why include withholding?
Withholding helps estimate the amount deducted before the affiliate receives payment. This is useful when tax or policy-based deductions affect payouts.
6) What does merchant total cost include?
Merchant total cost combines the final affiliate payout and the network fee. It shows the full direct marketing cost of the affiliate arrangement.
7) Why add cost of goods rate?
Cost of goods rate improves profit analysis. It shows how much contribution remains after product cost and affiliate-related costs are both considered.
8) Can I use this for recurring or SaaS commissions?
Yes. Enter recurring period revenue into gross sales, then apply the correct rates, fees, and bonuses for that billing cycle.