Calculating Commission from ATS, Invoice and Margin Data

Commission calculations are one of the most sensitive processes in a recruitment business. They affect consultant pay, consultant trust and finance team workload. Yet in most agencies the numbers still depend on manual work across ATS exports, invoice ledgers and margin spreadsheets.

When the data lives in several systems that do not speak to each other, finance managers end up rebuilding the same calculations every month. Sales directors then query the results, and the cycle starts again. This article looks at why commission calculations are so difficult to automate, and what a more reliable approach looks like.

Why this matters for recruitment businesses

Commission is often the second largest cost after contractor pay. It is also the number that consultants scrutinise most carefully. A late or incorrect statement damages trust quickly, and disputes consume senior finance time that should be spent on analysis.

For sales directors, commission is a management tool. If the numbers arrive two weeks after month-end, the behavioural signal is lost. Consultants cannot see how deals converted into paid margin, and leaders cannot coach around real figures. Accurate, timely commission reporting is a competitive advantage, not just a finance task.

What causes the problem?

The root cause is almost always fragmented systems. Placement data sits in the ATS or CRM. Timesheets live in a timesheet portal. Invoices and credit notes sit in the billing or accounting system. Payroll data lives somewhere else again. Commission schemes then reference all of these.

Typical complications include:

• Deals recorded in the ATS that do not match the invoiced value
• Rate changes agreed mid-contract that were never updated in one of the systems
• Credit notes raised against invoices from a previous commission period
• Split deals between consultants that are tracked only in a spreadsheet
• Threshold and accelerator rules that depend on cumulative paid margin
• Clawback rules triggered by aged debt or cancelled placements

Each rule is manageable on its own. Combined across hundreds of consultants and thousands of placements, they create a reconciliation problem that spreadsheets cannot solve reliably.

The impact on finance and back-office teams

Finance teams usually carry the operational cost. Someone spends several days each month exporting data, pasting it into a master workbook, running VLOOKUPs and chasing anomalies. Any change to the scheme means rebuilding the model.

The knock-on effects are familiar:

• Month-end extends because commission depends on finalised margin
• Credit control cannot easily flag which paid invoices support which commission
• Payroll receives commission figures late, compressing their own deadlines
• Sales directors receive summaries without the drill-down they want
• Disputes are resolved by whoever built the spreadsheet, creating key-person risk

The business ends up with a process that works, but only because one or two people hold it together.

How a trusted data foundation helps

Automating commission starts with the data, not the calculation. If ATS, timesheet, invoice, credit note and payroll data are brought into a single structured layer, the commission engine has something consistent to read from. Each placement can be linked to its invoices, each invoice to its payments, and each line to the responsible consultant or split.

This matters because commission rules are usually simple once the data is clean. The hard part is agreeing which invoice relates to which placement, which margin figure is final, and whether a credit note should reduce this period or a prior one. A trusted data foundation answers those questions in one place rather than in a different spreadsheet each month.

It also means the same source of truth drives margin reporting, debtor reporting and board packs. Consultants, finance and leadership see consistent numbers.

Where automation and AI-assisted insight can add value

Once the data is reliable, automation handles the repetitive work. Commission schemes can be configured as rules, run on a schedule and recalculated whenever underlying data changes. Finance keeps the final sign-off, but no longer rebuilds the model from scratch.

AI-assisted insight is useful in narrower, practical ways:

• Flagging placements where invoiced value differs from expected value
• Highlighting consultants whose commission has moved sharply versus the prior month and explaining why
• Summarising the drivers behind a commission run in plain language for sales directors
• Spotting invoices that should probably be excluded, such as those under query

The point is not to replace judgement. It is to surface the exceptions that a human needs to review, so finance spends time on decisions rather than data preparation.

Practical examples

Rate mismatches between ATS and invoice

A placement is recorded in the ATS at a charge rate of £550 per day. The invoice is raised at £525 because a client-agreed discount was applied in billing but never updated in the ATS. If commission is calculated from the ATS, the consultant is overpaid. If it is calculated from invoices without checking the ATS, the discrepancy is never investigated.

Credit notes crossing commission periods

An invoice from March is credited in May after a timesheet dispute. The consultant has already been paid commission on the March margin. Without a joined-up view, the clawback is missed or applied inconsistently.

Split deals and accelerators

Two consultants share a placement 60/40. One hits a quarterly accelerator; the other does not. The calculation needs placement-level splits, consultant-level cumulative margin and scheme rules applied in the correct order. This is where spreadsheets break down.

Timesheets approved but not invoiced

Margin reports that include approved but uninvoiced timesheets can overstate commission. A reliable process should distinguish billed, billable and paid margin, and apply the correct definition for each scheme.

How 4thSight helps

4thSight brings ATS, CRM, timesheet, payroll, billing and accounting data into a single platform designed for recruitment businesses. That gives finance teams a consistent base for commission, margin and debtor reporting without rebuilding the data layer each month.

From there, 4thSight automates recurring checks, such as reconciling invoiced value to placement value, identifying credit notes that affect prior commission periods, and tracking cumulative margin against scheme thresholds. AI-assisted commentary helps explain movements between periods in language sales directors can act on.

The aim is practical: fewer spreadsheets, faster commission runs, clearer audit trails and fewer disputes. Finance keeps control of the scheme logic and sign-off, while the heavy lifting of pulling data together is handled by the platform.

Conclusion

Commission calculations are difficult because the underlying data is fragmented, not because the rules are complex. Once ATS, invoice and margin data are joined up and trusted, automation becomes straightforward and AI-assisted insight becomes genuinely useful.

If your finance team is spending days each month rebuilding commission in spreadsheets, it is worth looking at how a connected data platform could change the process. 4thSight is built for exactly this kind of recruitment back-office problem, and we are happy to talk it through.