Sales

How to Calculate Sales Commissions for Agents

A practical guide to sales commission calculation: rates, tiers, referrers, margin based plans and how to make the CRM run the numbers for you.

Luca Bosso
Luca Bosso
|10 min read
Commission report per agent calculated from closed deals in the CRM

Calculating sales commissions comes down to three written decisions: which amount the percentage applies to (revenue or margin), when the commission is earned (signature, invoice issued or invoice paid), and which rate applies to each agent or service. Once those three rules are fixed, the calculation is a multiplication your system can run on every closed deal. Without them, month end becomes a spreadsheet rebuild, and every rebuild produces an argument.

If you currently spend two days a month redoing commission numbers and answering people who dispute them, by the end of this guide you will have a commission structure written down and a way to have it calculated automatically on every deal you close.

What you need before you start

  • The list of active agents and referrers, with each person's role: who sells directly, who only introduces contacts, who leads a group.
  • The calculation base, decided: net deal value, or margin, meaning net value minus direct costs. These are two different numbers and they produce different payouts.
  • The agreed rates, per agent or per service type. If they currently live in somebody's head, this is the moment to write them down.
  • The earning trigger: signature, invoice issued, or payment received. This is the rule that stops you paying commission on invoices that are never collected.
  • Three months of history, used to check that the new structure produces numbers consistent with what you have already been paying.
DecisionOptionsPractical effect
Calculation basenet revenue / marginmargin rewards people who discount less
Earning triggersignature / invoice / paymentpayment moves the risk onto the agent
Ratesingle / per service / tieredtiers push for volume
Scopenew business only / renewals toorenewals change the total significantly

The basic calculation: a percentage of what is sold

This is the most common structure and the easiest to explain to the person receiving it: a fixed percentage of the net value of every closed deal.

Set the rate for each agent. In small service businesses, revenue based rates usually sit in the single digits, but the right number depends on your margin: a service with a 30 percent margin cannot carry the same rate as one at 70. Start from the margin and decide what share of it you are willing to hand over.

Write the formula out in full, with a worked example: a deal worth 8,000 euro net, a rate of 5 percent, a commission of 400 euro. One written example is worth three paragraphs of policy, because it is what the agent will use to check their own payout.

Test the formula on three deals you have already closed. At this point you will see whether the new structure produces amounts close to what you have been paying, or whether you are committing to figures that do not hold up. If the gap is more than 10 percent, revise the structure before you announce it, not after.

Variant: different rates per service

If you sell things with different margins, a single rate rewards whoever sells the wrong product. The fix is a table by service.

Group services by margin, not by product name. Three groups are almost always enough: high, medium and low. Ten different rates are unmanageable and nobody remembers them.

Assign a rate to each group and settle the edge case: a deal containing services from different groups. The simplest rule is to calculate line by line rather than on the total, so a mixed order does not fall entirely into the highest rate.

GroupExample serviceIndicative rate
High marginconsulting, trainingthe top of your scale
Medium marginsoftware subscription, supportmid range
Low marginhardware resale, suppliesthe bottom, or a flat amount

Variant: tiers and targets

Tiers are useful when you want to reward beating a target rather than simple activity. The rate goes up once the agent passes a sales threshold within the period.

Choose the measurement period, usually the quarter. A month is too short for long sales cycles and produces rankings driven by timing rather than performance.

Set two or three thresholds, no more, and decide whether the higher rate applies to everything sold in the period or only to the portion above the threshold. Both policies are legitimate, but the second is more prudent because it avoids a sudden jump in payout caused by a single order.

Show progress during the period, not at the end. A target that turns out to have been hit or missed on closing day has guided nobody's behaviour. When the system shows progress as it happens, the target becomes a management tool instead of a report.

Variant: referrers and external partners

Somebody who brings you a contact without running the deal is not an agent and should not sit on the same scale.

Register the referrer as a separate record, with a default percentage and contact details. In Flusia, referrers are an anagraphic record separate from users: you create the card, set the default commission and optionally link it to a partner.

Link the referrer to the deal when the deal is created, not when it closes. If the link arrives afterwards the calculation has to be redone by hand, and you lose the trail of who brought what.

Decide whether a referral pays once or also on renewals. This is the clause that causes the most disagreement a year later: putting it in writing now costs one line.

Alternative method: commission on margin

If discounting is easy and frequent, revenue based commission pushes the wrong way: the agent closes anyway at a reduced price, because their payout falls far less than your margin does. Calculating on margin aligns the interests.

Define which direct costs count: delivery hours at standard cost, purchased licences, external suppliers. They have to be costs the agent can know before signing, otherwise the rule becomes opaque.

Apply a higher rate to the lower base. Ten percent of margin can be worth as much as 4 percent of revenue, with a different effect: if the agent discounts by 15 percent, their payout falls in proportion to the actual damage.

Show the margin inside the deal, otherwise you are asking somebody to optimise a number they cannot see. That opens a permissions decision, because margin is sensitive data: who sees what is decided once and applied by role, as described in the guide to CRM roles and permissions.

How to set up automatic calculation

Written rules achieve little if the calculation stays manual: the month end spreadsheet will survive. The step that matters is having the rules applied by the system where deals are already recorded.

Open the commission settings in your CRM and create a commission plan for each structure you have defined. In Flusia, plans are configured per user, per group or per service, and external referrers have their own dedicated section.

Assign the plan to your agents and check on a test deal that the calculated amount matches the figure you worked out by hand. At this point you will see the commission appear on the deal record together with the amount and the rate applied.

Check the report for the current month. What you should see is a list per agent showing the deals that generated a payout, the total earned, and the split between what is due and what has already been paid. If that list adds up, the month end spreadsheet is no longer needed: the same picture is summarised on the commissions and targets page.

Add a sanity check: before paying, compare total commissions against revenue for the period. A ratio that moves slightly month to month is normal; one that jumps almost always means a duplicated deal or a plan assigned twice.

Common mistakes

Paying at signature instead of at payment. This is the most expensive mistake, because on an unpaid invoice you lose the revenue and have already paid the commission. If you still want to recognise something early, the prudent route is a part payment at invoicing and the balance on collection.

Changing the rules mid period. Even an improvement, if it lands halfway through a quarter, reads as arbitrary. Commission structures are updated between periods, with the new version communicated before the period starts.

Keeping the rules only in individual agreements. If every agent has their own document and nobody holds the whole picture, the calculation depends on who runs it. The structure belongs in the system that records the deals, so everybody reads the same thing.

How long it takes to set up

Defining the rules and writing them down usually takes one or two meetings. Configuring the plans in the CRM and checking them against three closed deals takes a couple of hours. The real time goes into communicating the change to the agents, which is best done with a worked example for each person.

The natural next step is connecting payouts to what happens before the close: if deals are not tracked with consistent stages, the calculation stays correct but arrives late. If you have not done it yet, start with how to set up your sales pipeline and then look at the aggregate numbers in sales reports and dashboards. If you work in an agency, where payouts are tied to projects and renewals, the fuller picture is in the guide to client management for agencies.

This guide covers how to organise the calculation, not the contractual and tax aspects of an agency relationship: for the form of the contract, social security obligations and tax treatment, talk to your accountant or an employment adviser.

Frequently asked questions

Is commission calculated on the net amount or the invoice total? On the net amount. VAT is not company revenue but a sum passing through, so including it inflates the payout with no relation to the value delivered. If it has been done differently in the past, move to the net amount with a recalculated rate, otherwise the change reads as a pay cut.

How do you handle a deal worked by two people? By splitting the commission with a percentage agreed in advance, for example 70 percent to whoever closed and 30 to whoever opened the contact. What matters is not the proportion but the timing: if the split is decided once the deal is closed, it becomes an internal negotiation every time.

Are commissions paid on renewals as well? It depends on who looks after the client after the first sale. If the agent keeps the relationship, a reduced rate on renewal is consistent; if the client moves to the support team, paying commission on renewals rewards work somebody else is doing. Write the choice into the agreement, with an explicit duration.

Do I need a dedicated system, or is a spreadsheet enough? A spreadsheet holds up while you have two agents and one rule. It becomes expensive once rates vary by service, once there are external referrers, and once somebody asks for the detail of a past month: at that point the time spent rebuilding the numbers exceeds the time saved, and the risk of error falls on a figure people check closely.

Try Flusia free for 14 days

No credit card required. Setup in less than 24 hours.

Get started

Share this article

Written by

Luca Bosso

Luca Bosso

Founder of Flusia

Related articles