Affiliate Commission Calculator

Introduction

A 20 percent commission on a settlement sheet rarely matches the bank deposit: returns claw commission back, the platform takes a service fee, invoicing adds tax, and an agency takes a cut. This page applies those four deductions in order, shows each one separately, and finishes with the creator's net receipt and effective rate.

The example has 128000 in gross sales, a 12 percent return rate and therefore 112640 in net sales. A 20 percent commission gives 22528 gross. A 10 percent platform fee removes 2252.80, tax at 6 percent of the 20275.20 remainder removes 1216.51, and a 20 percent agency cut of the 19058.69 left removes 3811.74. The creator receives 15246.95, an effective rate of 13.54 percent.

The denominator is net sales rather than gross sales, so the effective rate moves with the return rate. That makes the cost of poor after-sales visible in the same figure.

Key features

• Effective sales: Returns are deducted first and commission is based on what remains.
• Gross commission: Sales times the rate gives gross commission. An entry of 0.2 means 0.2 percent, not 20.
• Itemised deductions: Platform fee and tax are listed separately so neither is deducted twice.
• Net payout: Gross commission minus both deductions is what the creator actually receives.
• Net rate: The net commission rate divides by effective sales, not by the original order value.
• Rate ceiling: A rate above 100 is rejected. The tool will not produce a commission larger than the sale.

How to use it

1. Gross sales: Enter the sales total from the settlement sheet, before any refunds are removed.
2. Commission rate: Use a percentage: 0.2 means 0.2 percent and 20 means twenty percent. The two are a hundredfold apart.
3. Return rate: Enter the refunded share; commission is worked out on sales left after refunds.
4. Platform fee rate, Tax rate, Agency cut: Fill these from the contract. Deductions run platform fee, then tax, then the agency share, each on the remaining balance.
5. Read the payout: Press Calculate and look at the creator net receipt and the effective rate. The latter divides by net sales, not by gross sales.

Things to keep in mind

• Rate scale: Commission rate is 0-100 percent; 0.2 means 0.2%, not 20%.
• Returns: Returns reduce the amount; commission refund policy is platform-specific.
• Net commission rate: Net commission rate is over effective sales, not gross.
• Deduction order: Platform fee and tax are listed separately so they are not double-counted.
• Local figures: Amounts stay local.

Try raising the return rate with every other box unchanged. Gross commission barely moves, but the effective rate does, because its denominator shrinks with net sales. That is the point of quoting the rate against net sales: it exposes after-sales quality in the same figure the creator is paid on. The four deduction rows also let you match each line against a settlement statement.

The example uses 128000 in gross sales, a 12 percent return rate and a 20 percent commission. Walk down the four deduction rows and each one is taken from the balance left by the previous row, not from the original gross commission. If your platform refunds commission on returns by a different rule, change the return rate and compare the breakdown before agreeing a settlement.