Commissions for sales agents are a key tool for motivating your sales force, but managing them can get complicated. This is especially true when customers pay their invoices partially or in installments. How do you pay the agent in these cases? If the company pays commissions only once payment has been collected, the agent may have to wait until an invoice is paid in full. On the other hand, paying the entire commission up front exposes the company to the risk of unpaid invoices.
Fortunately, with Odoo 18 Community and the OCA (Odoo Community Association) commission modules, you can automate the calculation and settlement of commissions flexibly. In this article, we'll look at how the OCA commission modules handle this scenario, in particular with the feature for commissions based on partial invoice payments.
Sales commissions in Odoo Community
Standard Odoo offers limited commission features, but the OCA community provides a package of advanced modules for sales commission management. These modules let you define commission plans and sales agents, automatically calculate commissions on quotes, orders and invoices, and manage periodic settlement for each agent.
Key features of the OCA commission management modules:
- Defining commission plans: You can create different commission types, with a fixed percentage or with tiers that vary by amount. You can also choose the calculation base: the gross amount of the line (subtotal) or the net margin (profit, i.e., sale price minus cost).
- Internal or external agents: A contact (partner) can be flagged as an Agent. In the contact's profile, you assign the applicable commission type and the settlement frequency (monthly, every two months, quarterly, etc.). The base module handles “external” agents (e.g., referrers or resellers), but additional extensions also let you manage in-house agents who are employees, linked to HR.
- Automatic assignment on orders: You can set one or more default agents on each customer. When you create a new sales order or invoice, Odoo automatically assigns the agents (and their commissions) to the lines based on the customer's configuration. Users can still manually change or add agents on each individual line through a dedicated interface (an icon next to the commission field).
- On-the-fly commission calculation: When the order is confirmed or the invoice is validated, the system calculates the commission amount due to each agent based on the associated plan. For example, with a 5% commission on the gross amount, a €1,000 line will generate a €50 commission for the agent. This information is recorded in dedicated commission lines linked to the document.
- Commissions on issued or paid invoices: A crucial point is deciding when the commission becomes payable. The OCA modules let you choose between:
- Invoice Based — the commission accrues when the invoice is issued (confirmed). The agent is immediately entitled to the commission, regardless of whether payment has been collected.
- Payment Based — the commission accrues only once payment is received. If the invoice is unpaid or reversed (credit note), the commission is canceled, ensuring a net commission balance of zero.
- Periodic commission settlement: Accrued commissions are grouped and settled according to the period chosen for the agent (monthly, quarterly, etc.). With the “Settle Commissions” function, you can generate a settlement containing all the commissions owed to each agent over a given period. This settlement is essentially an internal summary document in which each line corresponds to a commission on an invoice/order. You can then confirm the settlement and, for external agents, even automatically create a vendor bill made out to the agent to pay the commissions due. This way, agent compensation is booked in just a few clicks and stays consistent across your accounting records.
Example of a commission plan configuration in Odoo 18, with calculation options based on gross amount/margin and on issued/paid invoices
Commissions on partial invoice payments
Let's now tackle the special case of partial payments when commissions are paid on collection (Payment Based). Without proper support, this scenario creates uncertainty: either the agent has to wait until the last euro is collected to receive anything, or the company has to manually handle commission advances on every intermediate payment.
The add-on module “Sales Commissions Based on Paid Amount” extends Odoo 18 to solve this neatly. Once you install this module (and set “Invoice Status: Payment Based” and “Payment amount type: Paid amount” on the commission plan), the behavior changes as follows: the commission is split proportionally across every recorded payment. In practice, the agent is paid in tranches, in line with what the company has collected from the customer.
Let's look at a concrete example:
Suppose an invoice of €10,000 with payment agreed in two installments of €5,000 each. The agent is entitled to a 10% commission (€1,000 in total). With the traditional, standard “Payment Based” option, the agent would receive the €1,000 only after the last installment is collected. With “Paid amount”, on the other hand, as soon as the customer pays the first €5,000 installment, the system calculates that 50% of the invoice has been collected and therefore generates a partial commission of €500 (i.e., 10% of €5,000) for the agent. The agent can thus be partly paid right away. When the second installment (the remaining €5,000) is collected, the system generates the second partial commission of €500, reaching the total of €1,000 due.
How is this mechanism implemented? The module introduces the concepts of expected partial commission and actually settled commission:
- For every invoice paid in installments, or otherwise not yet fully paid, Odoo automatically creates “forecast” commission lines for each payment due date. These show how much is expected to be paid to the agent for each tranche. In our example, you would see two forecast lines of €500 each, linked to the two €5,000 installments.
- As you record a partial payment in accounting (reconciling part of the invoice), the system generates a matching actual partial commission line. This represents the amount accrued on the basis of that payment. If the amount paid exactly matches one installment, the actual line will be the same as the forecast one. If instead the customer pays amounts that differ from the planned installments (e.g., pays only half of an installment), the module adjusts the calculations accordingly. The actual commission amount is always calculated with the proportional formula amount collected * commission percentage, ensuring consistency with the total to be accrued.
- Odoo keeps the forecast lines linked to the actual ones and updates their status as commissions are settled. A handy overview is available directly from the invoice or from the agent's commission list: one click opens a window showing, for each invoice line, the commissions expected for each due date alongside the commissions already accrued and settled.
Settlement and control: Partial commissions flow into the normal periodic settlement process. The Settle Commissions procedure also picks up these “piecemeal” commissions that have not yet been settled and includes them in the agent's settlement for the current period. For example, at the end of the month, the agent in the example above will see in their settlement a €500 line for the first installment collected. The following month, once the balance has been paid, a further €500 line will be settled. This way, every agent receives what they are owed promptly with every payment collected, without waiting any longer and without the company paying in advance on receivables not yet collected.
Note that the system also handles the trickier details automatically:
- Rounding: if a total commission has to be split across many micro-payments (think of a payment broken up into many tranches), small rounding differences can occur. The module takes care of this by adjusting the last tranche so that the sum of the partial commissions exactly equals the total commission due.
- Reversals and cancellations: if a payment is later canceled or an invoice refunded, the related partial commission lines are automatically reversed or marked as not due. This avoids leaving “ghost” commissions tied to payments that were never actually finalized.
In short, commissions on partial payments ensure fairness and financial alignment: the agent earns in proportion to what the company collects, eliminating both excessive delays and the risks of paying in advance. Everything happens in a transparent, fully tracked way in the system: the finance team can check at any time the status of an agent's commissions, how much has already been settled and how much is still pending, awaiting future payments.
QTNOVA's contribution
The solution described here is made possible by the OCA community's open-source modules, the result of work by many contributors. In particular, the paid-amount commission module started as an initial development by Nextev and other OCA members for Odoo 14, and has evolved over time. QTNOVA actively contributed to this project by carrying out the migration and upgrade of the module to Odoo 18, with further improvements and fixes to integrate it fully into the updated ecosystem. We thank the original authors for the solid foundation they provided, and we are proud to have worked with the community to make such a useful tool available to businesses.
In conclusion, thanks to Odoo 18 Community and the OCA modules, even complex scenarios such as managing commissions on partial payments become automated and under control. IT managers and CEOs get real-time visibility into agent performance and commission costs, while agents benefit from a fair system that pays them on time. If your company is facing similar challenges in managing commissions, QTNOVA can help you implement and customize these solutions, bringing you technical expertise and in-depth knowledge of Odoo and the community modules. Contact us to find out how to optimize your commission process and make your sales operations more efficient.
Want to know more? Leave us your email below and we'll get back to you as soon as possible.