How to Automate Sales Rep Commissions in QuickBooks
By Varma, Founder, CrikSales · Published
How do you automate sales rep commissions in QuickBooks? Set a commission rate for each product and customer type once, then calculate commissions only on invoices that have been paid. CrikSales does this on top of your QuickBooks data: it applies your rates, reverses commission on credit memos, and produces a report by rep, invoice and line that exports to PDF or Excel.
The short version
- Rates: one rate per product and customer type, or one flat rate per customer.
- Setup: fill in an Excel template, preview every row, and upload. Any error means nothing is saved.
- Timing: commission counts on the date an invoice was paid, not the date it was sent.
- Returns: traceable credit memos reverse commission at the original invoice's rate.
- Output: a report by rep, invoice and line, with PDF and Excel export.
Why are sales commissions hard to calculate?
Your invoices, payments and customer types already live in QuickBooks. The hard part is applying commission rules to them every month. Real rules rarely fit one flat percentage: the rate depends on the product and on who buys it, reps should be paid on cash received rather than invoices sent, and returns must reduce the payout. Working that out by hand in a spreadsheet is slow and easy to get wrong.
How do you automate commissions, step by step?
- Choose your commission model. Use one flat rate per customer, or a different rate for each product depending on the customer type, such as distributor, retailer or contractor. For example, the same chimney kit might earn one rate when sold to a distributor and another when sold to a contractor. The report switches to the right calculation for each business automatically.
- Set up rates from a spreadsheet. Download an Excel template that already lists every active product against every customer type. Fill in the rates and upload it. Customer types come straight from QuickBooks, so customers don't need to be tagged twice.
- Preview before saving. Review every row first. If any row has an error, nothing is saved, so you never end up with a half-updated rate table, and you get a clear list of the rows to fix. You can view your saved rates at any time, grouped by customer type.
- Run the Commission Report. It opens on last month, which fits a monthly commission run. Filter by customer, by one or more reps, or by paid-date range.
- Review and export. Check the totals by rep, invoice and line, then export a PDF or an Excel file for payroll or accounting.
Which invoices count toward a rep's commission?
Only paid invoices count, and they count on the date they were paid, not the date they were sent. Reps are paid on money that has actually come in. When a credit memo can be traced to its original invoice, its commission is reversed at that invoice's rate, so returns don't distort payouts.
What does the Commission Report show?
The report is grouped by rep, then by invoice, then by line item, with subtotals at each level and a grand total. You can expand or collapse everything with one click, or open just the rep or invoice level.
| Level | What you see |
|---|---|
| Rep | Each rep's total commission, so a monthly payout run is one glance |
| Invoice | The customer, PO number, transaction date and paid date |
| Line item | SKU, commission rate, quantity, unit price, line total and commission |
Export a PDF of exactly what's on screen, including which groups are expanded or collapsed, or an Excel file with subtotals included, ready for payroll or accounting.
See commission reporting on your own data
Learn more on the sales rep commissions page, start a free 2-week trial, or book a demo. New to CrikSales? Read What Is CrikSales?
Sales rep commissions FAQ
How do I automate sales rep commissions with QuickBooks?
Set a commission rate for each product and customer type once, then calculate commissions only on paid invoices. CrikSales does this on top of QuickBooks: it applies your rates, reverses commission on traceable credit memos, and produces a report by rep, invoice and line that exports to PDF or Excel.
Are commissions based on the invoice date or the paid date?
The paid date. CrikSales counts commissions by the date an invoice was paid, not the date it was sent, so reps are paid on money that has actually come in.
Can I set a different commission rate for each product and customer type?
Yes. You can set a separate rate for each product depending on who buys it, such as a distributor, retailer or contractor. Customer types come straight from QuickBooks, so customers don't need to be tagged twice. If you prefer one flat rate per customer, you can keep doing that.
What happens to commissions when a customer returns something?
When a credit memo can be traced to its original invoice, its commission is reversed at that invoice's rate, so returns don't distort payouts.
What if I enter a wrong rate in the spreadsheet?
You preview every row before anything is saved. If any row has an error, nothing is saved, and you get a clear list of the rows to fix, so the rate table is never left half-updated.
Can I export the commission report?
Yes. Download a PDF of exactly what is on screen, including which groups are expanded or collapsed, or export to Excel with subtotals included, ready for payroll or accounting.
Related articles
Related features: Sales commissions · Report library · QuickBooks integration · Pricing