Checking Commission Rules Against Live Placement Data

Commission is one of the most sensitive numbers in a recruitment business. It drives consultant behaviour, affects retention and consumes a surprising amount of finance time every month. Yet in many agencies, commission is still calculated by exporting placement data into spreadsheets and applying scheme rules by hand.

The problem is not the maths. The problem is checking whether the rules have been applied correctly against placement data that is constantly changing. When timesheets, invoices, credit notes and contract extensions are updated daily, a commission calculation produced once a month is almost always out of date by the time it lands with the sales director.

Why this matters for recruitment businesses

Commission schemes in recruitment are rarely simple. Different desks have different thresholds, different splits, different treatments for permanent and contract revenue, and different rules for clawbacks when a placement falls through or an invoice is credited.

When finance teams cannot check those rules against live placement data, three things tend to happen. Consultants raise queries that take days to resolve. Sales directors lose confidence in the numbers. And finance ends up rerunning calculations multiple times before sign-off.

For a growing agency, this is not just an admin issue. It directly affects trust between finance and the front office, and it slows down the monthly close.

What causes the problem?

The root cause is almost always fragmented systems. Placement data sits in the ATS or CRM. Timesheet and contractor data sits in a separate timesheet system. Billing and credit notes sit in the accounting platform. Pay rates, bill rates and margin information may be split across two or three of these.

Commission rules, meanwhile, often live in a spreadsheet or a scheme document that is interpreted manually each month. There is no single place where a finance manager can ask a simple question such as: which placements qualified for commission this month, at what rate, and based on which invoices?

When the underlying data is spread across systems that do not talk to each other, even a well-designed commission scheme becomes difficult to validate.

The impact on finance and back-office teams

The impact shows up in predictable ways. Finance spends the first week of every month rebuilding commission workings from exports. Errors are usually spotted by consultants rather than by controls, which is the wrong way round.

Credit control teams may not know that a disputed invoice has already been included in a commission payment. Payroll may process commission before a clawback has been recorded. And when a consultant leaves, working out final commission becomes a manual investigation across several systems.

This is also where margin leakage hides. If commission is being paid on revenue that was later credited, or on placements that never invoiced correctly, the business is paying out against income it has not actually earned.

How a trusted data foundation helps

The first step is not automation. It is having a reliable, joined-up view of the data that commission depends on. That means bringing placement records, timesheet approvals, invoices, credit notes, pay rates and bill rates into one place where they can be reconciled.

Once that foundation exists, commission rules can be checked against actual transactions rather than against a snapshot. A finance manager can see, for any consultant, which placements are contributing to commission, which invoices have been raised, which have been paid and which have been credited.

This is the kind of trusted data foundation that 4thSight is designed to create for recruitment businesses. By combining ATS, CRM, timesheet, payroll, billing and accounting data, it gives finance a single reference point for commission and margin reporting.

Where automation and AI-assisted insight can add value

With the data in one place, automation can take on the repetitive checks. Recurring rules such as threshold calculations, split percentages, clawback triggers and qualifying revenue can be applied consistently rather than rebuilt each month.

AI-assisted insight can then help finance focus on exceptions. Instead of reviewing every line, the team can be pointed to placements where the calculated commission looks unusual, where the bill rate does not match the agreed terms, or where an invoice has been credited after commission was accrued.

This does not replace the finance team’s judgement. It removes the manual work of finding the items that need judgement in the first place.

Practical examples

Commission paid on credited invoices

A contractor invoice is raised in March and included in commission. In April, the invoice is credited due to a timesheet dispute. Without a live check, the commission is paid out before the credit is reflected. A connected data view flags the credit against the original placement and prompts a clawback.

Rate mismatches between systems

A placement is agreed at one bill rate in the CRM, but the timesheet system is set up with a slightly different rate. Commission calculated from the CRM looks correct, but the invoiced revenue is lower. Checking commission rules against the actual invoiced amount, not the CRM value, prevents overpayment.

Missing purchase order references

An invoice cannot be paid because the PO reference is missing. The placement still appears in the commission run because the invoice was raised. A joined-up view shows that the invoice is unpaid and disputed, allowing finance to hold the commission until the issue is resolved.

Split desks and shared placements

Where two consultants share a placement, the split needs to be applied consistently across permanent fees, contract margin and any extensions. Automating the split against live placement data avoids the spreadsheet errors that cause most internal disputes.

How 4thSight helps

4thSight brings together data from the systems that recruitment finance teams already use, so commission rules can be applied to live placement data rather than to monthly exports. The platform supports recurring checks, exception reporting and AI-assisted commentary that helps finance explain the numbers to sales leadership.

For finance managers, this means less time rebuilding workings and more time reviewing the items that genuinely need attention. For sales directors, it means commission statements they can trust, with a clear audit trail back to placements, invoices and timesheets.

It also supports a shift from monthly reactive reporting to more frequent operational control, which is increasingly important as agencies grow across multiple desks and locations.

Conclusion

Checking commission rules against live placement data is not a luxury. It is the difference between commission statements that are trusted and ones that are argued over every month. The blockers are almost always fragmented systems and manual reconciliation, not the complexity of the schemes themselves.

If commission calculations are taking too long, generating too many queries, or quietly costing the business through overpayments, it is worth looking at the underlying data first. A conversation with 4thSight is a practical place to start.