Skip to main content

Commission billing, automated instead of in Excel

Recalculating variable pay by hand costs time and invites arguments. In projectfacts the commission rules sit on the order and settle themselves.

Enquire now

What is commission billing?

Commission billing is the process of working out performance related pay, evidencing it and bringing it to payment. It answers three questions: what the calculation is based on, how much falls due and when. This page is about the route from the agreement to the payment.

In many companies, pay in sales consists of a fixed base plus a variable share, while other models pay purely on commission. The more models run side by side, the less a spreadsheet can carry.

Transparent for both sides

Your staff can see at any time which deals count and what follows from them. That takes the ground out of month end discussions.

No duplicated work

The figures are already in the system. Copying them into a spreadsheet for the commission run simply builds a second source of error.

Several models at once

Field sales, office sales and team leaders rarely settle on the same rule. All of them can run side by side without a special solution.

Commission on revenue or on gross profit?

On revenue
A percentage of the order or invoice value
On gross profit
A percentage of the value actually added
Calculation basis
the amount invoiced
revenue less cost or purchase price
Steering effect
rewards volume
rewards margin
With resold goods
commission also on licences passed through
only on the margin between purchase and sale
With own work
commission on the full hourly revenue
revenue less the internal transfer rate
Discount risk
a discount barely dents the commission
a discount hits the commission in full

What a commission rule consists of

Whichever model you run, a rule always answers the same four questions. Settling them in writing beforehand saves settling them afterwards.

Calculation basis and rate

What is the calculation based on, revenue or gross profit, and at what percentage or fixed amount? A mix is common too, for instance a percentage on your own work plus a fixed amount per deal.

Scope of the order

Does the commission apply to all parts of the order or only to individual items? Third party services that are passed on are often excluded, or valued differently from your own work.

  • Whole order or individual items
  • Third party services valued separately

When it falls due

When does the commission fall due, on the deal, on invoicing or only once the payment arrives? And does the rule apply only to deals closed within a certain window?

  • Set the trigger: deal, invoice or payment
  • Period in which the rule applies

Recipient

Who receives it? Alongside the person who closed the deal there is often a second rule for the team leader, with a different rate and a different basis.

An example: two rules on one order

A sales employee receives four per cent commission on the gross profit of an order, for each invoice relating to that deal. The division manager receives a flat 50 euros on every invoice for the same deal.

What follows from that

Both rules sit on the same order and settle independently of one another. The gross profit is the difference between the value received and the cost incurred, for example resold working time less the internal transfer rate, or, for a licence bought in and resold, the margin between the two.

Commission on a gross profit basis therefore does not relate to the full order value, but to the value that the work actually adds.

Variable pay without spreadsheet upkeep

As soon as several models run in parallel, commission billing by hand becomes a source of errors. In projectfacts you set up the rules once and let them settle.

Enquire now
Setting up commission rules on the order | projectfacts

Setting up commission rules in projectfacts

The rules sit on the order, not in a separate list. Authorised users store several commission rules there side by side, so that even unusual arrangements can be represented without anyone keeping a spreadsheet alongside.

Since version 2026.2 you can also name groups as the recipient of a rule and store a different recipient in addition. A team leader commission is now a setting rather than a separate calculation.

  • Several rules in parallel on one order
  • Revenue or gross profit basis selectable per rule
  • Groups and alternative recipients since 2026.2
From the commission rule to the payment | projectfacts

From the rule to the payment

Because orders, invoices and time entries in projectfacts share the same data, the commission is derived from figures that are already there. There is no second version that would have to be reconciled with the first.

The calculated amounts flow into wage and salary together with bonuses and overtime, ready to be exported for payroll. Every employee has a transparent overview of their performance and the payments that follow from it.

  • Calculated from order and invoice data, no second version
  • A transparent overview for every employee
  • Handover to preparatory payroll accounting

Commission billing with projectfacts at a glance

Rules on the order

Several commission rules side by side instead of a spreadsheet

Revenue or gross profit

Calculation basis freely selectable per rule

Team leader commission

Groups and alternative recipients since version 2026.2

Controlled timing

Store the trigger and the period of validity per rule

Transparency

Everyone sees their deals and the pay that follows from them

Linked to payroll

Amounts arrive export ready in preparatory payroll accounting

Show us your commission model

In 30 minutes we will look together at whether and how your rules can be represented in projectfacts. The unusual ones included.

Enquire now

Still have questions? We have the right answer!

Give us a call, send us an e-mail or take a look at our FAQ section! We will be happy to answer your questions!

Frequently asked questions

What is commission billing?
Commission billing is the process by which performance related pay is worked out, evidenced and brought to payment. It clarifies what the calculation is based on, how much falls due and when.
What is the difference between commission on revenue and on gross profit?
On a revenue basis a percentage is applied to the amount invoiced, which rewards volume. On a gross profit basis it is the revenue less the cost incurred or the purchase price, which rewards margin. For your own work, the gross profit is the revenue less the internal transfer rate.
What is gross profit in the context of commission?
Gross profit is the difference between the value received and the cost incurred or the purchase price. That can be resold working time less the internal transfer rate, or, for a licence bought in and resold, the margin between the two.
What belongs in a commission rule?
Four things: the calculation basis and the rate, the scope of the order meaning the whole order or individual items, when it falls due meaning the deal, the invoice or the incoming payment together with the period of validity, and the recipient.
Can I store several commission rules on one order?
Yes. Authorised users store several rules side by side on the order, and these settle independently of one another. That allows a rule for the sales employee and one for the division manager to run in parallel.
How do I represent a team leader commission?
Since version 2026.2 groups can be named as the recipient of a commission rule, and a different recipient can be stored in addition. A team leader commission is therefore a setting rather than a separate calculation.
Can commission apply to only some order items?
Yes. You define per rule whether the commission applies to all parts of the order or only to individual elements of the commission agreement.
When does the commission fall due?
You define that in the rule itself. Common triggers are the deal, the invoice or the incoming payment. You can also store whether a rule applies only to deals closed within a certain window.
How do commissions reach payroll?
The calculated amounts flow into wage and salary together with bonuses and overtime and are available there, ready to be exported for the payroll run.
Can employees see their own commissions?
Yes. Every employee has a transparent overview of their performance and the payments that follow from it, without anyone having to send out a report.