How to calculate commission from a CSV export
Almost every CRM and invoicing tool can export closed deals as a CSV file. That file is enough to work out commissions, if four columns are right.
The four columns
| Column | What it holds | Example |
|---|---|---|
| deal | A reference that is unique for each deal | INV-1001 |
| rep | Who gets the commission | Dana Lee |
| date | The date that decides the month | 2026-10-03 |
| amount | The amount commission is paid on | 1250.00 |
Checks before you calculate
- Duplicates. An export run twice, or a deal listed once per product line, pays a commission twice. Check that each reference appears once.
- Dates. 03/10/2026 is March in one country and October in another. Export dates as year, month, day.
- Amounts with commas. In a CSV file, 1,250.00 without quotes is two cells: 1 and 250.00. Spreadsheet programs write it in quotes; a file edited by hand may not.
- Names. 'D. Lee' and 'Dana Lee' are two people to a computer. Use one spelling per rep.
- Negative lines. Decide how refunds and credit notes are treated before they appear in a file.
If the export comes from QuickBooks, it is laid out as a report, with a block per rep and total rows, and needs reshaping first.
From a QuickBooks sales-by-rep export to commission statementsDownload a sample file with the four columns (CSV)
In a spreadsheet
Sort by rep and date, add a column with the amount multiplied by the rep's rate, round it to cents, and total per rep. With a threshold you also need a running total per rep to split the deal that crosses it.
In Commission Desk
Add the reps with their rates, then paste the file or choose it under Import deals. The import is all or nothing: if any row is doubtful, such as an unknown rep, a date in another format, a duplicate reference or an amount split by a comma, nothing is stored and each problem is listed with its line number. Importing the same file twice changes nothing.
Sales commission calculatorTry it with sample dataSee pricingCreate a free account
More guides
- From a QuickBooks sales-by-rep export to commission statements
- How sales commission is calculated
- Flat commission versus tiered commission
- A commission statement example
- Running commissions in a small sales team: a practical guide
- Spreadsheet or Commission Desk
- For bookkeepers: commission statements for your clients