Skip to content
100% local

Sales commission calculator

Calculate sales commission per rep from seller;amount rows, with flat or tiered rates, thresholds and caps.

Input
Output

Sales commission calculator

Paste a list of sales reps and their sales totals, one per line as seller;amount — for example Alice;15000 — and this calculator works out the commission each person earns, the effective rate on that sale, and the total for the whole list. It is built for sales managers, finance teams and freelancers who need to check commission payouts without opening a spreadsheet.

Choose a flat rate applied to every sale, or switch to progressive tiers and enter bands as threshold:rate pairs — for example 0:5,10000:8,50000:12 — so higher sales earn a higher rate on the portion above each threshold, the same way a tax bracket works. Add a fixed bonus paid on top of the calculated commission, set a minimum sales threshold below which no commission or bonus applies, and cap the maximum payout per row. When a deal is split between several people, set how many ways to divide it and each row shows the per-person share next to the full commission.

Pick the currency label and how many decimal places to round money to, and switch the output between a compact table and a line-by-line list. Rows that are not in the seller;amount format are skipped and counted separately, so a stray blank line or typo never breaks the calculation, and the tool comfortably handles long lists pasted straight from a CRM export.

Everything runs locally in your browser — the sales data never leaves your device, so it is safe to use with real commission figures. Copy the result, download it as a .txt file, or send the output straight back into the input to adjust a rate and recalculate.

FAQ

What format should each line use?
Each line is seller;amount, for example Alice;15000 — a name or ID, a semicolon, then the sale amount as a plain number.
How do progressive tiers work?
Enter threshold:rate pairs separated by commas, like 0:5,10000:8,50000:12. Each portion of a sale above a threshold earns that band's rate, similar to a tax bracket.
What happens to sales below the minimum threshold?
No commission is calculated for that row, including any fixed bonus, until the sales amount meets the threshold you set.
Can I split a commission between two or more people?
Yes. Set the split count and each row shows both the full commission and the equal per-person share.
Is my sales data uploaded anywhere?
No. The calculator runs entirely in your browser, so seller names and sales figures never leave your device.