Calculate commission owed on affiliate sales, including tiered rates above a volume threshold.
Tiered programmes split sales at the threshold and pay the higher rate only on the excess. Refund clawback then reduces the payable amount, which is why the effective rate sits between the two headline rates. Affiliates model earnings at the top tier while finance accrues at the base rate; computing both bands and the clawback is what reconciles them.
Affiliate Commission
Commission = sales below threshold × base rate + sales above × tier rate, less refund clawback
Commission = sales below threshold × base rate + sales above × tier rate, less refund clawback Tiered programmes split sales at the threshold and pay the higher rate only on the excess. Refund clawback then reduces the payable amount, which is why the effective rate sits between the two headline rates.
Affiliates model earnings at the top tier while finance accrues at the base rate; computing both bands and the clawback is what reconciles them.
This calculator takes 5 inputs: Affiliate-driven sales, Base commission rate, Sales above which the higher rate applies, Commission rate above the threshold, Refund rate clawed back. The pre-filled defaults are a realistic starting point — replace them with figures from your own environment for a result you can act on.