How to Calculate Sales Commission Automatically

To calculate sales commission automatically, the commission has to be part of the deal record rather than a separate month-end exercise. When the deal closes, the commission is already known, already attributed, and already visible to the person who earned it.

Why commission becomes a monthly argument

Commission disputes are rarely about the percentage. They are about which deals counted and who owned them.

Deals attributed to the wrong salesperson after the fact
Commission recalculated by hand in a spreadsheet each month
No visibility for reps into what they have earned so far
Lost deals recorded without a reason, so nothing improves

What the commercial dashboard should show

Total sold, total lost, and total in progress, as headline indicators
Commission per salesperson, alongside proposals made
Loss reasons, so the pattern behind lost deals becomes visible
Filter by salesperson, recalculating every indicator for that person
Open opportunities, listed underneath the indicators

How to configure it in Jestor

Capture leads through a public form in Jestor — anyone with the link can fill it in, and the entry lands on the opportunity board.
Open the card to set the deal title, the client's stated problem, and the product being proposed.
Assign the responsible salesperson as the deal moves into the proposal stage.
Record the proposed value and the expected closing date.
Use the conditional Kanban so each phase shows only the fields relevant to that phase.

Why choose Jestor for commercial management?

Jestor makes the whole dashboard filterable by salesperson, so a rep sees their own numbers and a manager sees everyone's, from the same build. Conditional phases keep forms short — nobody fills a loss-reason field on a deal that is still open.

Because the board, the indicators, and the form share the same records, commission figures move as deals move, with no monthly consolidation step.

Frequently Asked Questions

Can leads come from a public form?

Yes, through a shareable link. See jestor.com.

Can each phase show different fields?

Yes, using conditional rules on the board phases.

Can a rep see only their own numbers?

Yes, through permissions and dashboard filters.

Video Tutorial: Step by Step

Check out other practical tutorials on the Jestor YouTube channel.

Get to know Jestor

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.

How do you choose an AI tool for professional services operations teams in SMBs?

To choose an AI tool for professional services operations teams in SMBs, look for a platform that combines no-code tables for clients, engagements, and documents with AI features that answer messages, read documents, and summarize data, while keeping professionals in control of advice. In Jestor, these pieces work together,

How do you build a business continuity plan for a services firm?

To build a business continuity plan for a services firm, list critical processes and deadlines, identify risks such as system outages or key person absence, define backup options, assign roles, and test the plan. In Jestor, processes, risks, and actions are connected, so the firm keeps serving clients during disruptions.

What is the best way to run IT security awareness training for staff in a services firm?

A practical way to run IT security awareness training for staff in a services firm is to define short training modules, assign them to all staff, track completion, run simulated phishing tests, and schedule refreshers. In Jestor, staff, modules, and results are connected, so security habits become part of the

How do you route website lead forms to the right team in a services firm?

To route website lead forms to the right team in a services firm, ask for the service and company size in the form, route leads automatically to the right team, set response time targets, record follow-ups, and track conversion by source. In Jestor, forms, leads, and teams are connected,