Set your influencer affiliate commission rate below the money left after discounts, expected returns, variable costs and the contribution you need to retain. Calculate that limit for several order profiles before choosing a percentage, fixed bounty or tier. A competitor's rate cannot tell you whether your orders can afford it.
Modash's affiliate-program guide discusses the tension between creator earnings, discounts and product margins. Use that as a question to investigate. Your answer needs your own costs and an explicit definition of a commissionable sale.
Define the amount that earns commission
For this calculator, commissionable revenue means merchandise revenue after discounts and refunds. It excludes customer-paid shipping, taxes and duties. This is a proposed program definition. Confirm that your tracking system can apply it before putting it in an offer.
Commerce report labels need care. Shopify defines net sales by subtracting discounts and sales reversals from gross sales. Its total-sales figure adds other components, including taxes and shipping. A sales report also does not prove that payment settled.
Start with paid, eligible orders. Separate canceled orders, refunds and disputed payments before calculating approved commissions. Define attribution separately; use the guide to sharing credit between links and discount codes when two signals can identify the same order.
A calculator for three order profiles
All numbers below are hypothetical, in USD. They describe expected economics per initially placed order, averaged over many comparable orders. They are neither commission benchmarks nor forecasts for a particular brand.
The model assumes each order is either kept in full or fully refunded. Returned goods recover their full inventory cost. Return handling has a separate cost. Partial refunds, damaged returns and chargebacks require additional assumptions.
| Hypothetical input | A: small basket | B: bundle | C: costly item |
|---|---|---|---|
| Merchandise before discount | $40.00 | $100.00 | $200.00 |
| Customer discount | $10.00 | $10.00 | $20.00 |
| Revenue if kept, P | $30.00 | $90.00 | $180.00 |
| Full-refund probability, r | 5% | 10% | 25% |
| Product cost if kept, C | $10.00 | $32.00 | $110.00 |
| Other cost on every order, S | $6.00 | $9.00 | $14.00 |
| Extra cost per return, H | $4.00 | $8.00 | $12.00 |
| Required retained contribution, T | $5.00 | $18.00 | $25.00 |
S includes outbound fulfillment, shipping subsidy, customer-payment fees and an allocation for program costs such as samples or creator fees. These costs remain even when an order returns. H covers return freight and inspection. Add inventory write-downs to H when returned goods lose value.
T is the dollar contribution you want left for overhead and profit. It is a business target, not accounting profit. If program costs are uncertain, reserve more here or in S. Do not count them twice.
Use the following formulas with rates entered as decimals:
Expected net merchandise revenue N = P × (1 − r)
Expected non-commission cost V = C × (1 − r) + S + r × H
Budget for commission and its fees B = N − V − T
Maximum percentage rate = B ÷ [N × (1 + f)]
Maximum bounty per kept order = B ÷ [(1 − r) × (1 + f)]Here, f is a fee charged as a fraction of commission. The examples assume a hypothetical 3% fee and no fixed payout fee. Replace both assumptions with your provider's terms. For comparison, Shopify Collabs documents a 2.9% processing fee on automatic commission payments.
If B is zero or negative, these assumptions leave no room for a positive commission. If every order returns, neither rate formula has a usable denominator.
What the calculator produces
Dollar outputs round to the nearest cent. Maximum rates and bounty ceilings round down to two decimals so rounding does not increase the limit. Keep full precision while calculating.
| Hypothetical output | A | B | C |
|---|---|---|---|
| Expected net revenue, N | $28.50 | $81.00 | $135.00 |
| Non-commission costs, V | $15.70 | $38.60 | $99.50 |
| Commission-and-fee budget, B | $7.80 | $24.40 | $10.50 |
| Maximum percentage | 26.57% | 29.24% | 7.55% |
| Maximum bounty per kept order | $7.97 | $26.32 | $13.59 |
For profile C, expected revenue is $180 × 0.75, or $135. Expected costs are $110 × 0.75 + $14 + $12 × 0.25, or $99.50. Reserving $25 leaves $10.50 for commission and its processing fee.
The largest basket has the lowest percentage ceiling. Its product cost and returns consume more of the revenue available for commission.
These ceilings contain no allowance beyond the stated inputs. Choose an offer below the relevant ceiling, then rerun it with a deeper discount, higher return rate and less favorable product mix.
Compare a percentage with a fixed bounty
The next table uses the same hypothetical assumptions. Both options pay only on kept orders. It shows expected contribution remaining after commission and its 3% fee, per initially placed order.
| Hypothetical offer | A | B | C |
|---|---|---|---|
| Required contribution | $5.00 | $18.00 | $25.00 |
| 10% of net merchandise revenue | $9.86 | $34.06 | $21.60 |
| $10 per kept order | $3.02 | $33.13 | $27.78 |
A 10% commission misses profile C's target. A $10 bounty misses profile A's target. Neither offer meets every target across these baskets.
A percentage suits varying basket values when margins support the rate. A fixed bounty fits a defined qualifying purchase, but needs a minimum eligible basket or restricted product set when small orders cannot support it. If a bounty rewards new customers only, rerun the model using those customers' orders and define how you identify them.
For a single percentage across these three profiles, start below C's ceiling. Product-specific rates are another option if the tracking system supports them. Avoid relying on the current average product mix to protect a rate that fails on eligible low-margin orders.
A creator may still decline an affordable offer. If the expected payout cannot support the requested work, reconsider deliverables or evaluate a creator fee plus commission. Put that fee into S before comparing the options again.
Price the highest tier before announcing it
A tier can raise commission after a creator reaches a defined amount of approved revenue. Specify whether the higher rate applies only to revenue above the threshold or to all revenue in the period.
This hypothetical monthly schedule uses marginal tiers:
| Approved net revenue band | Rate | Commission on $6,000 total |
|---|---|---|
| First $5,000 | 6% | $300.00 |
| Next $1,000 | 7% | $70.00 |
| Total | 6.17% effective, rounded | $370.00 |
Applying 7% retroactively to all $6,000 would cost $420 before fees. That is a different promise.
Both marginal rates sit below the three modeled ceilings. That comparison holds only while the cost and returns assumptions hold. Set the period, qualifying revenue, refund treatment and reset rule before launch. For the operational design, see commission tiers that account for returns.
Check that the offer can be administered
Ask your tracking provider to demonstrate the proposed calculation on a discounted order, a full refund and a partial refund. A spreadsheet does not establish software support for a bounty, product exclusions or marginal tiers.
Shopify Collabs, for example, tracks commissions through its affiliate links and discount codes. Its documentation says commissions on canceled and fully refunded orders cancel during the holding period. The default is 30 days, adjustable from 1 to 90 days. That rule does not establish what happens to every partial refund or late return. Write and verify those cases separately.
Include disclosure instructions with the offer. For endorsements affecting U.S. consumers, FTC guidance calls for disclosure of financial relationships where people can notice it with the endorsement. An affiliate commission creates a financial relationship even without an upfront fee. Other jurisdictions may have their own requirements.
Before sending terms, replace the three hypothetical profiles with your smallest common basket, your main bundle and your lowest-margin eligible order. Calculate each ceiling, test the proposed maximum payout, and approve only the terms your costs and tracking system can support.
