> ## Content Index
> Fetch the complete content index at: https://blog.jestor.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# How to manage and calculate sales commission
- URL: https://blog.jestor.com/sales-commission-management/
- Published: 2026-09-16T18:49:59.000Z
- Updated: 2026-09-16T18:49:59.000Z
- Author: Bruno Bannach

**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

1. **Install the commercial template**, which includes CRM, sales panel and onboarding.
2. **Register your reps** so deals and commission can be attributed.
3. **Publish the public form** where leads register themselves and enter the pipeline.
4. **Work the opportunities** through the stages until won or lost.
5. **Record the loss reason** on every lost deal, since that data is the point.
6. **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](https://www.jestor.com/?ref=blog.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](https://www.jestor.com/?ref=blog.jestor.com) and see how to take your company's operations to a new level of efficiency and control.