Sales rep commission report in QuickBooks Desktop
QuickBooks Desktop has no commission report. It has Sales by Rep, which is sales by the initials on each invoice. Commission is the spreadsheet you build from that every month. Intuit’s article on commission is for QuickBooks Online.
What we do about it
We take your data out of QuickBooks as reports, put it in a database, and connect it to your Claude or ChatGPT. QuickBooks stays as it is.
The first step is small on purpose. We model one year of your sales data and get on a live call where you ask and your own numbers answer. You give us the three questions you most want answered, and we get you those answers or figure out how we can deliver them. You keep the database, connected to your Claude or ChatGPT.
The first step is $950, credited in full toward your setup if you go ahead. If you don’t, we delete the project and your data doesn’t stay with us. If it earns its place, we keep it current every week and send the reports you pick.
Nothing we build can write to your books.
What Desktop gives you
Sales by Rep Summary is total sales per rep for a date range, counting invoices where the Rep field was filled in. Sales by Rep Detail is the invoices behind it. Credit memos show up only if someone set the Rep field on the credit memo too.
The rate, the rule, when it changed, and who was on the roster when: none of that is in QuickBooks. It is in your head or in the spreadsheet.
Put the spreadsheet next to the invoices
The roster is a small table. The monthly commission sheet is another. Load both into the same database as the sales lines and every month’s commission ties to that rep’s invoices less credit memos, to the cent, or it does not and you find the invoice booked under the wrong initials.
Then the question the spreadsheet could never answer is one sentence, because the cost sheet is in there too. Two questions in a row, from a fictional company.
Who earned the most commission in the last twelve months, and what did that cost me?
| Rep | Commission paid | Invoiced sales | Rate |
|---|---|---|---|
| Teresa Ruiz | $92,753 | $3,710,127 | 3% |
| Marcus Jarvi | $86,886 | $2,896,207 | 3% |
| Sam Lindqvist | $44,704 | $2,235,185 | 2% |
$224,343 in commission over twelve months, in one sentence. The commission spreadsheet is in the same database as the invoices. Every month ties to that rep’s invoices less credit memos, to the cent. Invoices with a blank Rep field paid nobody, which real files do too.
How that was computed
select r.full_name as rep,
round(sum(c.commission)) as commission_paid,
round(sum(c.sales)) as invoiced_sales,
round(100.0 * sum(c.commission) / sum(c.sales)) as rate_pct
from commission_runs c
join reps r on r.initials = c.rep
where c.month between '2025-08' and '2026-07'
group by r.full_name
order by commission_paid descWhat margin did each sales rep actually bring in over the last twelve months?
| Rep | Sales | Gross profit | Margin |
|---|---|---|---|
| Teresa Ruiz | $3,810,110 | $783,809 | 21% |
| Sam Lindqvist | $2,265,910 | $505,935 | 22% |
| Marcus Jarvi | $2,940,085 | $465,331 | 16% |
Marcus Jarvi sells the second most and brings in the thinnest margin, 16%. The big builders in that book carry a 13% discount. QuickBooks Desktop does not print margin by rep; it needs the cost sheet next to the sales lines.
How that was computed
select r.full_name as rep,
round(sum(s.amount)) as sales,
round(sum(s.amount) - sum(s.cost)) as gross_profit,
round(100.0 * (sum(s.amount) - sum(s.cost)) / sum(s.amount)) as gp_pct
from v_sales_lines s
join reps r on r.initials = s.rep
where s.date > '2025-07-27' and s.rep in ('MJ', 'TR', 'SL')
group by r.full_name
order by gross_profit descNorthgale Building Products is a fictional company. Every name, figure and supplier on this page is made up, built to behave like a real three-and-a-half-year QuickBooks Desktop file so we can show real screens without showing anyone’s real numbers. Data as of the 2026-07-27 refresh; the last invoice in the file is dated 2026-07-24.
Short answers
- Can QuickBooks Desktop calculate commission?No. It reports sales by rep. The rate and the rule are yours to apply.
- What about commission on gross profit instead of sales?That needs item costs next to the sales lines. A database built from the sales detail and a cost sheet has both.
- Does the commission spreadsheet need to be tidy?It needs the roster and the monthly figures. We build the roster with you at the start.