How to manage and calculate sales commission
Sales commission management needs three things in one place: the deals each rep closed, the rule that turns those deals into commission, and a view that can be filtered per person. In Jestor, a ready made commercial template covers all three alongside the CRM and client onboarding.
Why commission ends up in a spreadsheet
Commission sits between sales and finance. Sales owns the deals, finance owns the payment, and the calculation belongs to neither, so it lands in a spreadsheet maintained by whoever complains least.
That spreadsheet is rebuilt monthly, disputed occasionally, and impossible to audit.
What a structured approach fixes:
- Commission recalculated by hand every month
- Reps unable to check their own numbers before payday
- Disputes with no record to settle them
- No visibility into why deals were lost
- Proposal volume per rep invisible until month end
What the commercial dashboard should track
| Indicator | What it answers | Use |
|---|---|---|
| Total sold | Closed revenue in the period | Progress against target |
| Total lost | Value of lost deals | Size of the missed opportunity |
| Total in process | Value still in play | Pipeline health |
| Commission per rep | What each person earned | Payroll and motivation |
| Proposals versus commission | Effort against result | Coaching conversations |
| Loss reasons | Why deals did not close | Product and pricing feedback |
Step by step to run it
- Install the commercial template, which includes CRM, sales panel and onboarding.
- Register your reps so deals and commission can be attributed.
- Publish the public form where leads register themselves and enter the pipeline.
- Work the opportunities through the stages until won or lost.
- Record the loss reason on every lost deal, since that data is the point.
- Filter the dashboard by rep to see each person's individual picture.
Why filtering by rep changes the conversation
A team level dashboard tells you how the month is going. Filtering to one person turns it into a coaching tool: this is your proposal volume, this is your win rate, this is your commission, and here is why your deals were lost.
- Everything filters together: indicators and charts follow the selected rep
- Loss reasons captured: patterns become visible across the team
- Onboarding included: the relationship continues after the sale
- Public form for leads: capture happens without manual entry
Frequently Asked Questions
Can each rep see their own numbers?
The dashboard can be filtered by salesperson, and permissions control who sees what. See jestor.com.
Are loss reasons tracked?
Yes. A dedicated chart shows the reasons proposals were lost.
How do leads enter the pipeline?
Through a public form where they register themselves, with no manual typing.
Video Tutorial: Step by Step
With Jestor, you can automate workflows, connect teams, and build internal systems your way, all without code and powered by AI. Discover Jestor at jestor.com and see how to take your company's operations to a new level of efficiency and control.