Spreadsheet or Commission Desk
A spreadsheet is the usual way small teams work out commissions, and for some teams it remains the right one.
| Spreadsheet | Commission Desk | |
|---|---|---|
| Cost | Usually none beyond what you have | A free plan and a paid Team plan; see the pricing page |
| Plan rules | Anything you can write as a formula | One rate per rep, one optional higher rate above a monthly threshold |
| Duplicate deals | Found only if you look | Refused: a reference exists once |
| Doubtful rows | Calculated as typed | The import is refused and each row is named |
| What the rep receives | Whatever you copy out | An itemised read-only page, frozen when issued |
| A rate that changes | Easy to apply to the wrong months | Dated: a deal is paid at the rate in force on its closing date |
| History of changes | None unless you keep versions | A change log of every edit, import and link |
| Splits, clawbacks, quotas, bonuses | Possible | Not supported |
| Connections to a CRM or payroll | Possible with effort | None: it reads a CSV file |
Stay with the spreadsheet if
- Your plan has splits, clawbacks, draws, bonuses or quotas over several months.
- One person is paid commission and nobody questions the figures.
- You need the calculation inside another workbook.
Consider Commission Desk if
- Your plan is one rate per rep, perhaps with one higher rate above a threshold.
- The monthly run takes longer than it should, or a mistake has cost trust.
- You want each rep to check their own deals without seeing anyone else's.
You can test it against your spreadsheet first, in two ways. The sample page takes up to 10 reps and 200 deals without an account and stores nothing: paste a month and compare every rep's statement with your sheet. A free account holds 3 reps and 150 deals, and adds the private link and the change log.
Compare a month on the sample page
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
- How to calculate commission from a CSV export
- A commission statement example
- Running commissions in a small sales team: a practical guide
- For bookkeepers: commission statements for your clients