Sales compensation & quotas
Commission plans that pay the right amount, on time, with an audit trail reps can read.
| Rep | Quota | Credited | Attain. | Commission | Net payout |
|---|---|---|---|---|---|
| Jordan Avery | $300,000 | $372,175 | 124.1% | $19,218 | $19,218 |
| Priya Natarajan | $300,000 | $400,575 | 133.5% | $22,058 | $23,308 |
| Marcus Bell | $400,000 | $587,475 | 146.9% | $34,748 | $34,748 |
| Elena Kowalski | $280,000 | $359,800 | 128.4% | $19,160 | $19,960 |
| Tyler Grant | $280,000 | $143,850 | 51.4% | $3,031 | $2,781 |
Quarterly commission runs, statements per rep, quota and territory models built from history and pipeline, and the reconciliation that makes finance and sales agree on the number.
What you get
Every engagement is scoped in writing before work starts. These are the usual deliverables; take the ones you need.
Commission calculation workbookExcel or Google Sheets
Tiered rates, accelerators, SPIFs, clawbacks and splits, one row per credited deal, every formula traceable to plan language.
IncludedPer-rep statementsPDF or sheet tab per rep
A one-page statement each rep can check against their own deal list, generated from the workbook each period.
IncludedQuota and territory modelModel plus a short memo
Quotas set from prior-year actuals, pipeline and territory potential, with growth asks visible before they reach the field.
IncludedReconciliation and controlsChecklist plus control tabs
Credited revenue tied to CRM and ERP, payout totals tied to the GL, exceptions logged with who approved what.
IncludedWhy this is a known quantity
The founder's in-house record on this exact work, before Known Quantity existed.
How it goes
- Step 1 of 3
Scope it in writing
A few emails to pin down the problem, the data and what "done" looks like. You get a written scope and a price before anything starts.
The full process - Step 2 of 3
Build on your real data
Days, not months, for most projects. We say which parts were automated and which were checked by hand.
How we use automation - Step 3 of 3
Hand it over, documented
Files, logic and a walkthrough. Nothing depends on us to keep running.
What that looks like
Questions people ask
Do you design comp plans or just calculate them?
Both, within limits. We model plan options, show what each would have paid on last year's data, and build the calculation once a plan is chosen. Plan policy stays with your leadership.
Which systems have you worked with?
Salesforce, NetSuite, Dynamics CRM and Business Central, with Excel, Power BI and Databricks on top. No commission tool is required; the workbook is the system of record until you want one.
How do you handle disputes?
Every credited deal carries its source ID, so a dispute is a lookup, not an argument. Adjustments are logged on their own tab with the approver and the reason.
What does this cost?
A first commission run on a clean plan is typically a fixed-price project; ongoing quarterly runs are hourly or a flat retainer. You get a written scope and price before any work starts.
Related work
Reporting & dashboards
Reports that refresh on schedule and land in the right inbox, so nobody rebuilds the Monday file by hand.
Read moreCRM & ERP data quality
Clean, trusted records in Salesforce, Dynamics, NetSuite and Business Central, and the checks that keep them that way.
Read moreForecasts & financial models
Revenue forecasts, budgets, pricing and cash-flow models in clean, traceable spreadsheets.
Read moreReady to scope sales compensation work?
Send a few lines about the problem and the tools involved. You will have questions or a quote within one business day.