Commission Desk

Guides

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

ColumnWhat it holdsExample
dealA reference that is unique for each dealINV-1001
repWho gets the commissionDana Lee
dateThe date that decides the month2026-10-03
amountThe amount commission is paid on1250.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.

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