Finance & Accounting
Sales commission calculator for one deal or a whole deals CSV
Type a sale amount and a rate for a quick figure. For a full month, upload your deals and get the commission per deal, a statement per sales rep and a draft payout file. Flat rates only: no tiers, splits or caps.
Quick commission check
Free, works in your browser, nothing is uploaded.
- Total commission
- 992.00
- Commission per deal
- 992.00
- Total sales
- 12,400.00
12,400.00 × 8% = 992.00 per deal, rounded to the cent.
Next step
Statements for every rep from one CSV
One row per deal with rep, deal ID, amount and rate. You get a per-deal ledger, a total per rep and a draft payout file.
or drop it here
Free: 3 jobs a day with a free account. Pro: up to 200 jobs a day, €12.99/month or €89.99/year. Compare plans
What you get · sample data
A sample run: 5 deals, 3 reps
Made-up figures to show the layout. Settings: rounding per deal, statement currency EUR.
| Rep | Commission | Currency |
|---|---|---|
| A. Novak | 1,412.00 | EUR |
| M. Keller | 1,546.50 | EUR |
| J. Ortiz | 573.00 | EUR |
Sum of the three reps: 3,531.50 EUR from 47,370.00 in sales
| Rep | Deal | Amount | Rate | Commission |
|---|---|---|---|---|
| A. Novak | D-1041 | 12,400.00 | 8 | 992.00 |
| A. Novak | D-1047 | 5,250.00 | 8 | 420.00 |
| M. Keller | D-1043 | 18,900.00 | 6.5 | 1,228.50 |
| M. Keller | D-1050 | 3,180.00 | 10 | 318.00 |
| J. Ortiz | D-1044 | 7,640.00 | 7.5 | 573.00 |
- draft-payout.csv the same per-rep amounts, laid out for hand-off to payroll
- manifest.json the rounding and currency you chose
- findings.csv notes from the run
How the CSV run works
- 1
Export your deals
One row per deal with the columns Rep, Deal, Amount and Rate. Up to 50,000 deals in one file.
- 2
Pick rounding and currency
Round once per deal or once on each statement total, and set the currency for the statements.
- 3
Check and download
Look over the preview, then download the ledger, rep statements, draft payout file and manifest.
Calculating flat-rate commission for each sales rep
What the deals file needs
Each row carries its own commission rate, and that rate is applied exactly as supplied. A rate above 1 is read as a percent, so 8 means 8%; a rate of 0.08 also means 8%. Tiers, split credit, caps and clawbacks are not worked out for you, so build them into the rate column before you upload. Every deal ID may appear only once: a duplicate stops the run before any payout file is made.
Tracing a rep total back to its deals
result.csv lists the commission for every deal, and every figure in rep-statements.csv adds up from those rows. manifest.json records the settings you used, including the rounding choice, so a colleague can see how the numbers were produced. Your source file is not changed, and results are kept for 24 hours.
Rounding, currency and the approval step
On a large file, rounding per deal and rounding on the statement total can differ at cent level, which is why the choice is recorded. The payout file is a draft calculation. It needs payroll or contract approval before anyone is paid, and that approval stays with your finance team.
Questions before you run it
Which columns does the CSV need?
One row per deal with a rep, a deal ID, an amount and a rate. The headers Rep (or Sales rep), Deal (or Deal ID), Amount (or Revenue) and Rate (or Commission rate) are recognised. A rate above 1 is read as a percent, so 8 and 0.08 both mean 8%.
Does it handle tiered rates, splits, caps or clawbacks?
No. Each deal row carries its own rate and that rate is applied exactly as supplied. Work tiers, split credit, caps and clawbacks into the rate column before uploading.
Where does rounding happen?
You choose: once per deal, or once on the statement total. On a large set the two settings differ at cent level, and the setting used is recorded in manifest.json.
What does the draft payout file contain?
Per-rep amounts in the statement currency you set, laid out for hand-off. It stays a draft calculation and needs payroll or contract approval before anyone is paid.
How do I check a single rep figure?
result.csv holds the per-deal ledger, so every total in rep-statements.csv can be traced back to the deal rows that produced it.
How many deal rows can one file hold?
Up to 50,000 deals in a single CSV upload.
Do I need an account?
Not for the quick check at the top of this page, which runs in your browser. The CSV statement run needs a free account and uses one of your 3 free jobs a day. Failed jobs are not counted.