Checking Commission Rules Against Live Placement Data
Commission is one of the most sensitive numbers in a recruitment business. It affects consultant behaviour, retention and cash planning, yet it is often calculated using data that is days or weeks out of date. When commission rules are not checked against live placement data, small errors quickly turn into disputes, restated payments and difficult conversations between finance and sales.
For finance managers and sales directors, the underlying problem is rarely the commission scheme itself. It is the gap between the rules on paper and what is actually happening across the ATS, CRM, timesheet, payroll and billing systems.
Why this matters for recruitment businesses
Commission schemes in recruitment are rarely simple. They usually combine permanent fees, contractor margin, thresholds, clawbacks, split deals and team overrides. Each of these elements depends on data held in different systems, and each has its own timing.
When the numbers are wrong, the impact is not just financial. Consultants lose trust in the figures, sales directors spend time defending calculations rather than driving performance, and finance teams end up rebuilding statements in spreadsheets. Checking commission rules against live placement data is what keeps the scheme credible and the pay run defensible.
What causes the problem?
The root cause is almost always fragmented data. Placements are created in the ATS or CRM. Contractor hours flow through timesheet and payroll systems. Client invoices sit in the billing system. Cash is tracked in the accounting system. Commission rules then sit on top of all of this, usually maintained in a spreadsheet or a separate calculation tool.
Common issues include:
- Placement records updated in the ATS but not reflected in the commission workings until month-end
- Rate changes agreed with the client but not applied to open assignments
- Timesheets approved but not yet invoiced, creating a mismatch between margin earned and margin paid on
- Split deals recorded inconsistently between consultants
- Clawbacks for early leavers not triggered because the leaver date is only updated in payroll
Each of these issues is minor on its own. Combined, they make it very hard to trust any single commission number without manual checking.
The impact on finance and back-office teams
Finance teams often carry the burden of reconciling commission at month-end. They pull placement lists from the ATS, margin data from billing, contractor costs from payroll and then try to match everything against the scheme rules. When any of these sources disagree, the investigation falls to finance.
The knock-on effects are familiar. Month-end runs later than it should. Credit control has less time to focus on aged debt because the team is answering commission queries. Payroll is put under pressure to accept last-minute adjustments. Sales directors receive commission reports that they cannot easily explain to their teams.
Over time, this erodes confidence in recruitment finance reporting more broadly. If commission cannot be trusted, other numbers are questioned too.
How a trusted data foundation helps
The first step is not a new commission tool. It is a trusted data foundation that brings together placements, rates, timesheets, invoices, payments and leaver dates into a single, reconciled view. Once that foundation exists, commission rules can be applied consistently and checked against what is actually happening in the business.
With a single source of truth, finance and sales can agree on the underlying numbers before the scheme is even applied. Disputes then shift from “is this data right?” to “is this rule right?”, which is a far more productive conversation.
This is where a recruitment data platform earns its place. Instead of exports and spreadsheets, the finance team works from a live, reconciled dataset that reflects the current state of placements and margin.
Where automation and AI-assisted insight can add value
Once the data foundation is in place, automation can take on the repetitive checks that currently rely on human diligence. Rules can be applied consistently, exceptions can be flagged early, and commission previews can be produced on demand rather than only at month-end.
AI-assisted insight can add a further layer by highlighting patterns that would otherwise be missed. For example, it can point out consultants whose commission has moved significantly month on month, or placements where the billed rate does not match the rate held in the ATS. It does not replace the judgement of the finance manager or sales director, but it narrows the field of things worth investigating.
Used carefully, this shifts the team from monthly reactive reporting to more frequent operational control.
Practical examples
The value becomes clearer with a few realistic scenarios.
Rate mismatches on open contracts
A client agrees a new charge rate mid-assignment. The change is captured in the CRM but the billing system continues to invoice at the old rate for two weeks. Margin on the placement is understated, and so is the consultant’s commission. Checking commission rules against live placement data catches this before the pay run, not after.
Timesheets approved but not invoiced
At month-end, several timesheets are approved but the corresponding invoices have not been raised. If commission is paid on invoiced margin, the consultant is underpaid. If it is paid on approved margin, finance needs to know which is which. A reconciled view of recruitment timesheet reconciliation and billing data makes the treatment clear and consistent.
Clawbacks for early leavers
A permanent placement leaves within the guarantee period. The leaver date is updated in payroll but not in the ATS. Without a joined-up view, the clawback rule is not triggered until someone notices manually. Automated checks against live placement data can flag the event as soon as it appears in any source system.
Split deals and team overrides
Splits are often the source of the most heated commission disputes. When the split percentages, consultant records and placement values are held consistently across systems, the calculation becomes mechanical rather than contested.
How 4thSight helps
4thSight is built for exactly this kind of problem. It combines data from ATS, CRM, timesheet, payroll, billing and accounting systems into a trusted data foundation, then automates the recurring checks that finance and back-office teams would otherwise do by hand.
For commission specifically, this means placement data, rates, margin and leaver information can be checked against the rules of the scheme on a continuous basis. Exceptions are surfaced early, AI-assisted commentary helps explain movements, and finance and sales directors work from the same numbers. 4thSight supports finance and back-office users directly, so changes to checks and reports do not depend entirely on developers.
The result is fewer surprises at month-end, faster sign-off on commission, and more time for finance to focus on margin, cash and credit control.
Conclusion
Commission errors are rarely caused by bad intent. They are caused by fragmented systems, manual reconciliation and rules that are checked too late in the cycle. Bringing placement, timesheet, billing and payroll data together, then checking commission rules against that live data, removes most of the friction.
If commission calculations are a recurring source of pressure in your recruitment finance team, it may be worth exploring how a data and automation platform like 4thSight could support a more controlled, transparent approach.