Open calculator ↗

Affiliate program net earnings after returns · Calculation guide

Estimate commission on retained sales and earnings after campaign costs.

Calculation guide

Returns are measured by order value, not order count. Commission is earned on retained eligible merchandise value, excluding tax and shipping. Enter direct campaign expenses for the same period.

net = sales*(1-returns/100)*rate/100-cost; commission = sales*(1-returns/100)*rate/100; reversal = sales*returns/100*rate/100

Inputs

Eligible referred sales

Example entry 50000 (in the selected currency).

Returned share of sales value

Example entry 12 %. Allowed range 0 to 100.

Affiliate commission rate

Example entry 8 %. Allowed range 0 to 100.

Direct campaign expenses

Example entry 520 (in the selected currency).

Worked example

InputValue
Eligible referred sales50,000
Returned share of sales value12%
Affiliate commission rate8%
Direct campaign expenses520
ResultValue
Profit · Affiliate income after costs3,000
Earned commission3,520
Commission lost to returns480

Calculation steps

Net affiliate earnings = ((((Eligible referred sales × (1 − (Returned share of sales value ÷ 100))) × Affiliate commission rate) ÷ 100) − Direct campaign expenses)

((((50,000 × (1 − (12 ÷ 100))) × 8) ÷ 100) − 520) = 3,000

Earned commission = (((Eligible referred sales × (1 − (Returned share of sales value ÷ 100))) × Affiliate commission rate) ÷ 100)

(((50,000 × (1 − (12 ÷ 100))) × 8) ÷ 100) = 3,520

Commission lost to returns = ((((Eligible referred sales × Returned share of sales value) ÷ 100) × Affiliate commission rate) ÷ 100)

((((50,000 × 12) ÷ 100) × 8) ÷ 100) = 480

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Eligible referred sales50,00055,000Profit · Affiliate income after costs3,0003,352
Returned share of sales value12%13%Profit · Affiliate income after costs3,0002,960
Affiliate commission rate8%9%Profit · Affiliate income after costs3,0003,440
Direct campaign expenses520572Profit · Affiliate income after costs3,0002,948
Affiliate program net earnings after returns →