Calculating Commission from ATS, Invoice and Margin Data
Commission calculations are one of the most sensitive processes in a recruitment business. Consultants scrutinise every figure, sales directors want visibility of performance in real time, and finance teams need to be confident that every payment is accurate. Yet in most agencies, commission is still calculated by pulling exports from the ATS, matching them against invoices in the accounting system, and reconciling margin in a spreadsheet.
This manual process is slow, error-prone and hard to audit. When the numbers are wrong, trust in finance suffers. When they are late, motivation drops. The good news is that most of the work can be automated once the underlying data is properly joined up.
Why this matters for recruitment businesses
Commission is not just a payroll cost. It drives consultant behaviour, shapes team performance and directly affects retention. If a top biller cannot see where they stand mid-month, or disputes a calculation at month-end, the impact goes well beyond finance.
Sales directors need confidence that commission schemes are being applied consistently. Finance managers need assurance that payments reconcile back to invoiced revenue and realised margin. Without a reliable process, both sides end up spending time on rework rather than growth.
What causes the problem?
The root cause is almost always fragmented data. A typical recruitment business runs on several disconnected systems:
- An ATS or CRM holding placement and candidate data
- A timesheet or VMS platform capturing contractor hours
- A billing or middle-office system generating invoices
- A payroll system paying contractors and PAYE workers
- An accounting system holding the ledger and cash position
Each system has its own view of a placement. The ATS might record an agreed margin, the billing system might invoice a slightly different rate, and payroll might apply a different pay rate due to a mid-contract change. When commission depends on all three, discrepancies are almost guaranteed.
Add in scheme complexity, thresholds, deal splits, clawbacks for unpaid invoices and matrix rates, and the spreadsheet quickly becomes unmanageable.
The impact on finance and back-office teams
Finance teams often spend the first working week of every month rebuilding the same commission workings. Someone exports placement data from the ATS, someone else pulls invoice data from the accounting system, and a third person cross-checks margin against pay and bill rates.
This has several knock-on effects:
- Month-end reporting is delayed because commission is a blocker
- Credit control teams cannot easily see which invoices are affecting clawback calculations
- Payroll teams get last-minute changes that increase the risk of errors
- Disputes with consultants take hours to investigate because the working is buried in a spreadsheet
Over time, this erodes confidence in the numbers and pushes finance into a reactive rather than proactive role.
How a trusted data foundation helps
The first step in automating commission is not buying a commission tool. It is building a single, trusted view of the data that commission depends on: placements, timesheets, invoices, pay rates, bill rates and margin.
When ATS, timesheet, billing, payroll and accounting data sit in one properly modelled data layer, calculations become deterministic. Every placement can be traced from candidate to invoice to cash. Every commission line can be linked back to the underlying transaction. Every adjustment can be evidenced.
This is where a recruitment data platform earns its place. Instead of finance rebuilding the join between systems each month, the join is maintained continuously and can be interrogated whenever needed.
Where automation and AI-assisted insight can add value
Once the data foundation is in place, automation can handle the repetitive parts of the process. Commission schemes can be codified once and applied consistently. Threshold calculations, splits and clawbacks can run on a schedule rather than being reworked manually.
AI-assisted insight adds another layer. Rather than replacing the finance team, it helps highlight anomalies that would otherwise be missed. Examples include a placement where the invoiced rate does not match the ATS, a contractor being paid before the corresponding invoice has been raised, or a commission line that has moved significantly compared to the previous period.
The aim is not to remove human judgement. It is to make sure the judgement is applied to the right exceptions rather than to routine reconciliation.
Practical examples
Reconciling ATS margin to invoiced margin
A consultant places a contractor at an agreed margin of £8 per hour. The timesheet is submitted and approved, but the invoice is raised at a slightly lower bill rate because a rate change was not reflected in the billing system. Without automation, this is only spotted when the consultant questions their commission. With connected data, the discrepancy is flagged before commission is calculated.
Handling clawbacks for unpaid invoices
Many schemes claw back commission if an invoice is not paid within a defined period. This requires commission workings to be tied to live debtor data. When ATS, invoice and cash data are joined, clawbacks can be calculated automatically and shown transparently to the consultant.
Managing split deals across teams
Split commissions are a common source of disputes. A clear, auditable calculation that pulls directly from the ATS record and applies agreed split percentages removes the guesswork and gives sales directors confidence that the scheme is being applied fairly.
Mid-month visibility for consultants and managers
Rather than waiting until month-end, consultants can see projected commission based on live placement, timesheet and invoice data. Sales directors get a clearer view of team performance without asking finance for another report.
How 4thSight helps
4thSight brings together data from ATS, CRM, timesheet, payroll, billing and accounting systems into a single trusted foundation designed specifically for recruitment businesses. That foundation is what makes reliable commission automation possible.
From there, 4thSight helps finance teams automate recurring checks, generate margin and commission reporting on demand, and use AI-assisted insight to surface anomalies that would otherwise be lost in spreadsheets. Finance and back-office users can work with the data directly, without depending on developers for every change.
The result is a commission process that is faster, more transparent and easier to defend when questioned.
Conclusion
Commission calculation is a symptom of a wider issue in recruitment finance: too many systems, too much manual reconciliation and not enough trusted data. Fixing the underlying data problem makes commission accurate almost as a by-product, and delivers better margin reporting, faster month-end and clearer operational control at the same time.
If commission calculations are consuming time in your finance team, it may be worth looking at how a connected data platform could take on the heavy lifting. 4thSight would be happy to talk through how other recruitment businesses have approached it.