Calculating Commission from ATS, Invoice and Margin Data

Commission is one of the most sensitive numbers in a recruitment business. Consultants watch it closely, sales directors rely on it to drive behaviour, and finance teams spend hours making sure it is right. Yet in most agencies, the data needed to calculate commission sits across several disconnected systems.

The ATS holds the placement. The billing system holds the invoice. The accounting system confirms cash. The margin sits somewhere between them, often rebuilt manually in a spreadsheet at month-end. When any of these sources disagree, commission becomes a debate rather than a calculation.

Why this matters for recruitment businesses

Commission is rarely a simple percentage of revenue. Most schemes depend on margin, cash collection, threshold triggers, contract type, desk splits and clawback rules. Each of these inputs lives in a different system, and each system records the placement slightly differently.

For finance managers, this creates risk on two sides. Underpay a consultant and you damage trust. Overpay and you erode margin that is hard to claw back. For sales directors, commission disputes consume time that should be spent winning business or coaching consultants.

The problem grows as the business scales. A team of ten consultants is manageable in a spreadsheet. A team of a hundred, across permanent and contract desks, is not.

What causes the problem?

The root cause is almost always fragmented data. A typical recruitment business runs several systems that were never designed to talk to each other.

• The ATS or CRM records the placement, fee and consultant ownership.
• The timesheet system captures contractor hours and approvals.
• The billing or pay and bill system raises invoices and pays contractors.
• The accounting system records revenue, cost of sale and cash receipts.
• The commission scheme itself often lives in a spreadsheet maintained by finance.

Each system has its own view of a placement. Job titles differ. Consultant codes differ. Client names are spelt three different ways. Start dates do not always match. When finance pulls exports from each platform and tries to join them, the joins break.

The result is a monthly exercise in reconciliation rather than calculation.

The impact on finance and back-office teams

The operational impact is significant. Finance teams often spend the first week of each month rebuilding the data set before any commission can be calculated. Credit control may not have flagged which invoices are disputed, so cash-based commission triggers are based on assumptions.

Payroll reporting becomes harder because contractor margin needs to be confirmed before consultant commission can be signed off. Sales directors receive commission statements late, which weakens the link between performance and reward.

Common issues include:

• Timesheets approved but not yet invoiced, distorting margin.
• Invoices raised at the wrong rate because the ATS was not updated.
• Candidate pay and client bill rates not matching the agreed terms on the placement.
• Missing purchase order references delaying payment and therefore cash-based commission.
• Clawbacks not applied because credit notes are tracked separately.

Each of these issues is small in isolation. Across a full month, they add up to material errors and a lot of finance time.

How a trusted data foundation helps

The first step in fixing commission is not buying a new commission tool. It is building a trusted data foundation that brings the ATS, timesheet, billing and accounting data together in one place, with consistent keys and definitions.

Once a placement in the ATS can be matched reliably to its invoices, its contractor costs and its cash receipts, commission becomes a calculation rather than a reconstruction. Margin is known. Cash is known. Thresholds can be applied with confidence.

This also improves recruitment margin reporting more broadly. The same data set that drives commission can drive desk profitability, contractor margin analysis and board reporting, without finance maintaining several parallel spreadsheets.

Where automation and AI-assisted insight can add value

With a clean data foundation in place, automation can take over the repetitive work. Recurring checks can run daily rather than monthly, flagging the issues that previously only surfaced at commission time.

AI-assisted insight is useful where judgement is involved. For example, it can help summarise why a consultant’s commission has moved month on month, or highlight placements where margin looks inconsistent with the rest of the desk. It does not replace finance review, but it shortens the time spent finding the questions worth asking.

Safe areas to automate include:

• Matching ATS placements to invoices and credit notes.
• Reconciling timesheet hours to invoiced hours.
• Calculating margin per placement using actual pay and bill rates.
• Applying scheme rules consistently across consultants.
• Producing draft commission statements for finance review.

Practical examples

Margin-based commission on contract desks

A contract consultant earns commission on weekly margin. The margin depends on timesheet hours, pay rate, bill rate and any agency margin adjustments. If the timesheet system and billing system disagree on hours for a single week, the commission figure is wrong. Automated reconciliation between the two, with exceptions flagged to back-office, removes the guesswork.

Cash-collected commission on permanent fees

A permanent consultant only earns commission once the client has paid. Finance needs to match each cash receipt to the original invoice and the original placement. When credit control data, accounting data and ATS data are joined, this becomes automatic. When they are not, it is a manual trace through three systems.

Threshold and clawback rules

Many schemes include thresholds, accelerators and clawbacks for cancelled placements or unpaid invoices. These rules are easy to describe and hard to apply manually. Automation handles them consistently, and produces an audit trail that stands up to consultant queries.

How 4thSight helps

4thSight is a data, AI insight and automation platform built for finance and back-office teams in recruitment businesses. It connects to the ATS, CRM, timesheet, payroll, billing and accounting systems already in use, and creates a trusted data foundation that finance can rely on.

From that foundation, 4thSight automates recurring checks, supports recruitment commission calculations, and produces margin and operational reporting without finance rebuilding the data each month. AI-assisted insight helps explain movements and highlight exceptions, so finance and sales leaders can focus on decisions rather than data preparation.

It is designed to be used by finance and back-office teams directly, not only by developers, which matters when scheme rules change or new desks are added.

Conclusion

Commission errors are rarely caused by bad intent. They are caused by fragmented data, manual joins and tight month-end deadlines. Fixing the data foundation fixes most of the problem, and automation handles the rest.

If commission calculations are taking too long, generating disputes or eroding trust between finance and sales, it is worth looking at how your ATS, invoice and margin data are joined today. A conversation with 4thSight is a practical place to start.