Money & shopping

Tiered sales commission

Apply progressive commission rates to successive sales bands.

Tiered sales commission
Esc to restore

Your inputs

Use the example headings. UTF-8 CSV and TSV files stay on this device; maximum 25 MB.

Up to 25 MB per file, 50,000 data rows, 200 columns and 2 million data cells. Fully blank rows and columns are ignored before row, column and cell limits are checked. Individual tools may have smaller result or chart limits.

Results update as you type. Larger files run when you press Update result.

Processed on your device

Your result

LOCAL & PRIVATE

Your result will appear here.

Your inputs stay in this browser. Nothing is uploaded or saved.

A clear answer. Here’s how.

Each threshold starts a new sales band and its rate applies only to sales in that band. First threshold must be zero; thresholds must strictly increase and rates must be 0–100%. Adds base pay after commission. Excludes caps, clawbacks, tax and contract-specific conditions; up to 100 bands.

See a worked example

Worked example

A fixed demonstration, separate from the values you enter above.

Commissionable sales
15000
CSV: Threshold,Rate
Threshold,Rate
0,5
10000,10
20000,15
Base pay for the same period
1000

Example result

Example result
Band startsBand endsRateSales in bandCommission
010,0005%10,000500
10,00020,00010%5,000500
20,000No upper limit15%00

Base pay 1,000.00; total gross pay 2,000.00. Progressive bands, before tax.

Keep going.

Bill splitterUnit price calculatorMargin & markup calculatorBreak-even calculator