The answer
Mostly. Pulling closed deals and payments, applying commission rules and producing statements are well suited to software. In our model about 75% of commission work is automatable. Matching payments to the right rep is harder than it looks, and disputes stay human, because commission is pay and people need someone accountable.
The tasks, and how much of each is automatable today
Six tasks make up commission tracking. Producing statements and sending figures to payroll are about 90 to 95% automatable. Pulling deals and applying rules are 85 to 90% automatable once the plan is written down. Matching payments to reps is about 75% automatable. Handling disputes stays mostly with the manager.
| Task | Min / week | Automatable |
|---|---|---|
| Pull closed deals and payments receivedAPIs from the CRM and payment processor provide both lists on a schedule. | 90 | |
| Match each payment to the rep or reps who earned itEasy when the payment email matches the CRM contact. Payments from a spouse or business card need a person to match. | 120 | |
| Apply the rules: rates, splits, tiers and clawbacksFully automatable once written as rules. Exceptions agreed verbally are the 15%. | 90 | |
| Handle disputes from repsA running statement prevents many disputes. Resolving the rest is a manager's job. | 60 | |
| Produce a statement for each repGenerated from the rules output and sent or shared automatically. | 45 | |
| Send approved totals to payrollExport in the payroll provider's format after manager sign-off. | 15 | |
| Whole process | 420 |
Hours saved per week
For a team of six closers and three setters, commission prep takes about 7 hours a week by hand. Automating the tasks above returns about 5 hours a week, roughly 240 hours a year. It also removes the month-end scramble that causes most commission errors and arguments.
Modelled on: A high-ticket coaching business with six closers and three setters, paid commission monthly on cash collected, tracked in a spreadsheet.
- About 40 closed deals a month, many on payment plans, so commission is earned per payment.
- Setters and closers split commission on the same deal, with different rates.
- Refunds within 14 days claw back commission.
- The plan rules exist but are partly in people's heads.
Tools that do the job
You need a source of truth for deals, a source of truth for cash, and somewhere the rules run. The CRM holds who sold what. Stripe or QuickBooks holds what was paid. Google Sheets or Airtable can run the rules for small teams, with n8n or Make pulling data in on a schedule.
- Stripe
- Source of truth for payments, refunds and payment-plan instalments.
- HubSpot
- Source of truth for which setter and closer worked each deal.
- Google Sheets
- Runs the rules and shows each rep a live statement for small teams.
- Airtable
- Alternative with linked records for deals, payments and reps.
- n8n
- Pulls new payments daily, matches them to deals and flags unmatched ones.
- Slack
- Sends each rep their running total and the manager any unmatched payments.
A simple workflow
The workflow runs daily, not monthly. Each new payment is matched to a deal and the reps on it. The rules engine calculates what each person earned, including splits and clawbacks for refunds. Reps see a running statement. At month end the totals go to payroll after a manager approves them.
- TriggerDaily: pull new payments and refunds from the payment processor.
- MatchMatch each payment to a CRM deal by email, then phone. Unmatched payments go to a review list.
- CalculateApply rates, setter and closer splits, and clawbacks for refunds inside the window.
- PublishUpdate each rep's running statement so they can check it during the month.
- ApproveAt month end the manager reviews exceptions and approves totals.
- PayExport approved totals to payroll and lock the month.
Keep these human
- Disputes and exceptions. Commission is pay; reps need a person to answer to.
- Approving the monthly total before it goes to payroll.
Where it goes wrong
- Unwritten rules. If splits and exceptions are agreed in DMs, the automation pays the wrong amount. Write the plan as rules before building anything.
- Payments that do not match. Different checkout emails break attribution. Keep a review list for unmatched payments instead of guessing.
- Monthly batch only. Calculating once a month hides errors until payday. Run daily so reps spot mistakes early.
What most guides miss
Most guides compare commission software. The real work is writing the plan as unambiguous rules: who gets credit when a setter books and a different closer closes, what happens with refunds and payment plans. Teams that skip this automate their arguments. A one-page rules document does more than any tool.
The evidence
- Sales reps spend 70% of their time on non-selling tasks; commission queries and reconciling their own numbers are part of it.Salesforce, State of Sales, 6th edition (2024)
- Processing data has a technical automation potential of 69%, while managing others sits at just 9%.McKinsey Global Institute, A future that works: Automation, employment, and productivity (2017)
“There is surely nothing quite so useless as doing with great efficiency what should not be done at all.”