From a QuickBooks sales-by-rep export to commission statements
QuickBooks records who sold what. It does not work out what each rep is owed: Intuit's own help article on tracking commissions says QuickBooks Online has no feature that calculates sales commissions, and suggests multiplying a sales report by the rate yourself. This guide shows that step done once, carefully, from the report to a statement each rep can check.
Commission Desk does not connect to QuickBooks. It reads a CSV file that you export and upload. Nothing here needs access to your books.
1. Run a sales report that names the rep on every line
- QuickBooks Desktop has a Sales Rep list and, under Reports, Sales, the reports Sales by Rep Summary and Sales by Rep Detail. The detail report is the one to use: it lists each sale under its rep.
- QuickBooks Online has no rep field of its own. Intuit's suggestion is to turn on classes or locations, set up each salesperson as a class or a location, and run the Sales by Class or Sales by Location report. Choose a view that lists every transaction, not only totals.
- Set the dates to the month you are paying.
Menu names and columns differ between versions and between companies that have customised their reports. Check the report on your own screen before relying on the names above.
2. Export it
Both products export a report to Excel. Open the file in a spreadsheet program; you will save it as CSV at the end.
An exported report is laid out for reading, not for calculating. The sample below has the usual shape: a title, a block for each rep, total rows, dates written month first and amounts with commas. It is an illustration with invented names; your file will differ in detail.
Northwind Supply (sample data) Sales by Rep Detail October 2026 ,Type,Date,Num,Name,Amount Dana Lee ,Invoice,10/03/2026,INV-1001,Alder & Co,"12,000.00" ,Invoice,10/17/2026,INV-1002,Birch Ltd,"10,000.00" ,Invoice,10/30/2026,INV-1003,Cedar Inc,"5,000.00" Total Dana Lee,,,,,"27,000.00" Sam Ortiz ,Invoice,10/06/2026,INV-1004,Dogwood LLC,"4,250.00" ,Invoice,10/21/2026,INV-1005,Elm Partners,"8,900.50" Total Sam Ortiz,,,,,"13,150.50"
Download the full sample export (CSV)
3. Reshape it into four columns
A commission calculation needs one row per sale and four facts on it.
| Column | Taken from | What to do |
|---|---|---|
| deal | Num, the invoice number | Keep as it is. Each number must appear once |
| rep | The heading above each block | Add a column and fill the rep's name down beside every sale of that block |
| date | Date | Format the column as year-month-day: 2026-10-03 |
| amount | Amount | Keep. A file saved by a spreadsheet puts amounts with commas in quotes, which is correct |
- Delete the title rows, the block headings once the names are filled down, every Total row, and the columns you do not need.
- Name the first row deal, rep, date, amount.
- Decide what to do with credit memos and refunds before they reach the file. Commission Desk refuses amounts that are not above zero; it does not net a refund against a sale.
- Save as CSV.
The result for the sample:
deal,rep,date,amount INV-1001,Dana Lee,2026-10-03,12000.00 INV-1002,Dana Lee,2026-10-17,10000.00 INV-1003,Dana Lee,2026-10-30,5000.00 INV-1004,Sam Ortiz,2026-10-06,4250.00 INV-1005,Sam Ortiz,2026-10-21,8900.50
Download the sample deals (CSV)
4. Turn the file into statements
With the four columns, the arithmetic is the rate times each sale, rounded to the cent, totalled per rep. A threshold adds one step: only the part of the month's sales above it earns the higher rate, so the sale that crosses the threshold is split.
Dana Lee, October 2026. Rate 5%; 8% on the part of the month's sales above $20,000.00.
| Deal | Closed | Amount | At the rate | At the higher rate | Commission |
|---|---|---|---|---|---|
| INV-1001 | 2026-10-03 | $12,000.00 | $12,000.00 at 5% | $600.00 | |
| INV-1002 | 2026-10-17 | $10,000.00 | $8,000.00 at 5% | $2,000.00 at 8% | $560.00 |
| INV-1003 | 2026-10-30 | $5,000.00 | $5,000.00 at 8% | $400.00 | |
| Total | $27,000.00 | $1,560.00 |
You can do this in the spreadsheet you already have open. Or paste the four columns into the sample page on this site, which shows every rep's statement at once, without an account and without storing anything.
See the statements for the sample team
What Commission Desk does with the file, and what it does not
- It applies one rate per rep, with one optional higher rate above a monthly threshold, to every deal in the file.
- It refuses a file with a doubtful row (an unknown rep, a date in another format, a duplicate invoice number, an amount cut in two by a comma) and names each row, so nothing is paid on a guess.
- It gives each rep an itemised statement behind a private link and an access code.
- It does not connect to QuickBooks, read the exported report in its original layout, or write anything back to your books. The reshaping in step 3 is yours to do each month.
- It does not handle commission on gross profit, on payments received, splits between reps, clawbacks, draws, bonuses or quotas over several months.
- It does not pay anyone. You pay commissions the way you do today.
If your plan needs any of those, a spreadsheet or a larger tool is the better choice.
Before the first payday
- Sales reports are usually based on invoices, not on money received. If you pay commission only on paid invoices, filter the report or the file first.
- Check whether the report's amounts include tax or shipping, and whether your plan pays on them.
- An invoice with several lines can appear once per line. Total it to one row per invoice, or the import will refuse the repeated number.
QuickBooks is a trademark of Intuit Inc. Commission Desk is not affiliated with or endorsed by Intuit.
Sales commission calculatorTry it with sample dataSee pricingCreate a free account