RevOps playbook · QuotaPath + Salesforce

How to automate sales commissions with QuotaPath and Salesforce

Short answer: Commission automation works when the CRM already records what was sold and what kind of deal it was. Connect QuotaPath to Salesforce, give each role a plan mapped to an opportunity record type (New Business, Expansion, Renewal), calculate on recurring first-year ACV from opportunity products, build in clawbacks and accelerators, route every payout through a rep → manager → finance approval, and report earnings back in Salesforce so everyone sees the same number.

By Joe LaGrutta, Founder, JayOhUpdated 11 min read + 10-step walkthroughTools: QuotaPath · Salesforce Sales Cloud

Click through it: a closed deal to a paid commission

Follow one fictional deal from Closed Won to payroll: earnings appear on the opportunity, move through approvals, and show up in the finance report, the leadership dashboard and the rep's own view. Along the way you'll see the plan rules by record type and the guardrails that keep payouts correct.

QuotaPath commission automation walkthrough10 steps · use Next or ← →

Illustrative recreation of QuotaPath and Salesforce screens built by JayOh for training. It is not the vendor's actual software. Companies, people and figures are fictional.

What the walkthrough covers

  1. A deal closes and commission calculates itself
  2. Every payout is approved before payroll
  3. Who earns what on the deal, and why
  4. One rule set per record type
  5. Guardrails: clawback, paid-on, no double pay, data lock
  6. Managers get roll-up credit for their team
  7. Finance sees every dollar traced to a deal
  8. Leadership sees comp cost next to bookings
  9. Each rep sees their own number and next deal
  10. The build checklist with a done-when test per item

What commission automation actually means

Commission automation means the CRM deal is the single input, the comp plan is code instead of a spreadsheet formula, and every payout has an audit trail from deal to payroll.

QuotaPath is the calculation and approval layer. Salesforce stays the source of truth for what was sold. The work is mostly in the connection between them: which fields the plan reads, and whether those fields are trustworthy.

Comp plan
The rules for one role: what triggers a payout, what basis it is calculated on, the rate, and any accelerators or guardrails.
Plan path
One rule inside a plan, such as New Business Commission or Uplift Bonus. A plan can have several paths.
Commission basis
The Salesforce field the rate is applied to. For SaaS this is usually first-year ACV from recurring opportunity products.
Accelerator
A higher rate that applies once a rep passes quota, such as 1.5× on bookings above 100% attainment.
Clawback
Recovering commission already paid when a customer churns or cancels within a set window, often the first 12 months.
Paid-on event
The moment a commission becomes payable: Closed Won, a countersigned contract, or first invoice paid.
Roll-up quota
A manager's quota and credit built from the bookings of the team below them, often with an override rate.
Data lock
Freezing a closed, paid period so later CRM edits can't change numbers that were already paid.

Why it matters: the cost of spreadsheet comp

  • Finance spends days every month exporting deals and rebuilding the same formulas.
  • Reps shadow-account their own commissions because they don't trust the number.
  • Disputes happen in email, with no audit trail and no single answer.
  • Renewals and expansions get paid like new logos, or not at all, because the CRM can't tell them apart.
  • Clawbacks are forgotten because nobody tracks churn against the original deal.
  • Leadership can't see comp cost as a percentage of bookings until the quarter closes.
The principle: if a rep asks "why is my check this amount?", the answer should be one click from the deal.

The playbook, step by step

Build in this order. The commission layer sits on top of the opportunity model, so the CRM work comes first.

  1. Write the commission rules before configuring anything

    For each role, document the trigger, basis, rate, accelerators, clawback window, paid-on event and how splits work. Get leadership and Finance to sign it. Configuration is the easy part; agreement is the hard part.

    Done when: a signed plan document exists for every role.
  2. Prepare the Salesforce fields the plan reads

    Make sure every deal has an opportunity record type, opportunity products with first-year ACV, a Sourced By field for SDR credit, Prior and Renewed ARR plus a Renewal Outcome on renewals, and Opportunity Splits where credit is shared.

    Done when: these fields are live and populated on all open and current-year deals.
  3. Connect QuotaPath and configure plans and paths

    Connect QuotaPath to Salesforce and build one plan per role with a path per motion: New Business for AEs, Expansion for AMs (with an add-on kicker if you want one), Renewal plus uplift for CSMs, and qualified-opportunity and sourced-win payments for SDRs.

    Done when: quarter-to-date earnings match a manual recalculation to the dollar.
  4. Add guardrails to the plan

    Encode the clawback schedule, no double pay on declined quote lines (they pay only if their own Expansion deal closes), roll-up quotas and overrides for managers, and data locks after Finance close.

    Done when: each guardrail has a test case that produces the expected result.
  5. Set up the approval chain and payroll export

    Route each earning through rep confirmation, manager approval and Finance approval before payroll. Set the export format and cadence with payroll, and lock each period once it is paid.

    Done when: one full pay cycle runs end to end with no spreadsheet.
  6. Report earnings back in Salesforce

    Build an earnings-with-opportunity report for Finance with subtotals per deal and pipeline excluded from totals, a comp dashboard for leadership (cost vs bookings, by motion, attainment, approval queue), and a rep view with forecasted, current and approved earnings.

    Done when: Finance, leadership and every rep look at the same numbers.
  7. Backfill and retire the spreadsheet

    Load current-year deals so attainment and accelerators are correct from day one, reconcile against what was already paid, then archive the old commission spreadsheet as read-only.

    Done when: the spreadsheet is archived and nobody has asked for it in a full cycle.

What good looks like

Use these thresholds to grade your current commission process. They are JayOh working targets, not QuotaPath defaults.

Commission process health: weak, acceptable and strong
MeasureWeakAcceptableStrong
Finance time per commission cycleMultiple daysOne dayUnder two hours, review only
System calc matches manual recalcNot testedWithin a few percentTo the dollar
Disputes per pay periodSeveral, in emailOccasionalRare, resolved in the tool
Deals with Sourced By populatedUnder 50%50–90%100%, required at creation
Clawbacks applied when dueRarelyManuallyAutomatically
Rep visibility into earningsAfter payrollMonthly statementLive, per deal

Common mistakes

  • Configuring before agreeingIf the rules aren't signed, every edge case becomes a rebuild. Write and sign the plan first.
  • Paying on Amount instead of ACVAmount includes one-time fees. Use first-year ACV from recurring products.
  • One plan for every motionNew logos, expansions and renewals have different economics. Map each to its own path.
  • No paid-on eventPaying at Closed Won with no signed contract invites reversals. Define when money is actually owed.
  • Unlocked periodsA CRM edit months later shouldn't change a number already paid. Lock periods after Finance close.
  • Hiding the math from repsReps who can't see the basis and rate keep their own spreadsheets. Show every number on the deal.

Frequently asked questions

How does QuotaPath connect to Salesforce?

QuotaPath connects to Salesforce and reads opportunity data such as stage, owner, amount fields, record type and custom fields to calculate earnings. Earnings and attainment can then be reported back alongside Salesforce data. The quality of the result depends entirely on the quality of the opportunity fields it reads.

Should commission be paid on Amount, ACV or ARR?

For subscription businesses, first-year ACV from recurring opportunity products is the most common basis for new business. It excludes one-time fees like implementation. Expansion is usually paid on incremental ARR, and renewals on renewed ARR plus a bonus on any uplift.

How should a commission clawback work?

Define a window, often the first 12 months, and a schedule. A common pattern is 100% clawback if the customer churns in months 1 to 6 and 50% in months 7 to 12. Apply it against the original deal so it shows as a negative line for the rep who was paid.

When should commission be paid: Closed Won, signed contract or first invoice?

It depends on cash risk. Closed Won plus a countersigned contract is common for annual prepaid deals. Paying on first invoice collected is safer when payment terms are long or collections are uncertain. Whatever you choose, write it in the plan as the paid-on event.

How do accelerators work in a SaaS comp plan?

An accelerator raises the rate once a rep passes quota, for example 1.5× the base rate on bookings above 100% of quarterly quota. Show the accelerator in the rep's view so they can see what their next deal is worth.

How should SDRs be paid?

A common structure pays a flat amount per qualified opportunity they source and a larger flat amount when a sourced deal closes. It requires a Sourced By field on the opportunity so credit is data, not a claim.

Should customer success managers earn commission on renewals?

Many SaaS companies pay CSMs a small rate on renewed ARR plus a larger rate on uplift, with nothing paid on churned renewals. That only works if renewals are their own record type with a Renewal Outcome field.

Can you automate commissions without clean CRM data?

Not reliably. The commission tool calculates from opportunity fields, so missing record types, typed amounts or untracked renewals produce wrong payouts automatically. Fix the opportunity model first, then automate commissions.

Want commissions calculated from your CRM, not a spreadsheet?

JayOh documents the plan with your leadership and finance team, preps the Salesforce fields, configures QuotaPath and runs the first pay cycle end to end with you.

Talk to JayOh

Related playbooks

Joe LaGrutta · Founder, JayOh

Joe has run JayOh since 2016, building revenue systems for B2B SaaS and PE-backed companies with embedded growth pods: a consultant who owns the outcome plus developers on sprint-based delivery. JayOh is a HubSpot Platinum Partner and works across Salesforce, HubSpot and the tools around them. Connect on LinkedIn.

QuotaPath, Salesforce and related marks are trademarks of their respective owners. JayOh is not affiliated with or endorsed by them unless stated. Walkthrough screens are illustrative recreations for education only. Rates, thresholds and benchmarks are JayOh working guidance, not vendor defaults; set your own with your leadership and finance teams.