Affiliate Payout Reconciliation
Reconcile affiliate commissions with tiered bonuses and clawback deductions. Enter values for instant results with step-by-step formulas.
Worked Examples
Example 1: Standard Month
Problem:$50k Sales, 10% Base, 5% Returns
Solution:Earned: $5,000. Clawback: $250. Net: $4,750.
Result:$4,750 Payout
Example 2: High Performance
Problem:$100k Sales, 10% Base + 5% Bonus > $50k
Solution:Base: $10k. Bonus: ($50k * 5%) = $2.5k. Total: $12.5k.
Result:$12,500 Payout
Frequently Asked Questions
What if the clawback exceeds the payout?
This creates a 'Negative Balance'. Most programs carry this forward to deduct from future earnings. You generally don't ask the affiliate to write you a check.