The problem
In most recruitment agencies, placement margin is calculated and monitored across several disconnected systems. The CRM or ATS holds the placement record. The pay and bill system holds the contract rates. Payroll holds what the worker is actually paid. Invoicing holds what the client is actually charged. Timesheets sit somewhere in between.
When a placement is created, the agreed pay rate, charge rate, margin, holiday pay treatment, on-costs and any uplifts need to flow through every downstream system correctly. In practice, they often do not. Rates are keyed manually, contract changes are missed, AWR uplifts are forgotten, overtime rules are applied inconsistently, and one-off agreements made by consultants are never captured in the master record.
Finance teams then spend significant time each week reconciling timesheets, payroll runs and sales invoices in spreadsheets, trying to confirm whether the margin booked actually matches the margin earned.
Why it matters
Margin leakage on placements is one of the most common and least visible profit issues in recruitment. A few pounds per hour, multiplied across hundreds of contractors and thousands of timesheets, quickly becomes material. By the time the issue is spotted in a month-end review, the placement may have been running incorrectly for weeks.
The commercial impact is direct:
- Under-billed clients mean lost revenue that is rarely recovered.
- Over-paid workers create awkward conversations and write-offs.
- AWR, holiday pay and pension errors create compliance exposure.
- Inaccurate margin reporting undermines consultant commission and management decisions.
For finance leaders, the bigger issue is control. If you cannot prove that every active placement is billing and paying at the correct rate, you cannot trust your gross margin number.
The opportunity
This is a process that benefits enormously from joined-up data, no-code automation and embedded AI. The underlying logic is not complex. The challenge is that the data lives in different systems and the checks are currently manual.
A governed workflow can:
- Pull placement, payroll, timesheet and invoice data into one controlled environment.
- Recalculate the expected margin for every placement, every week.
- Flag any placement where actual margin diverges from contracted margin.
- Use AI to read contract variations, side letters and email confirmations and extract the agreed rates.
- Produce a clean exceptions list for consultants and finance to action.
The result is a continuous margin control process rather than a retrospective month-end clean-up.
Example workflow
1. Connect the source data
Connect to the CRM or pay and bill system for placement records, the payroll system for actual pay, the timesheet platform for hours worked, and the finance system for raised invoices. Where contract variations live in email or shared drives, ingest those as well.
2. Standardise and prepare the data
Normalise rates to a consistent unit (for example, hourly), align pay periods with billing periods, and resolve worker, client and placement identifiers across systems. Apply consistent treatment for VAT, holiday pay accruals and employer on-costs.
3. Apply business logic
For each active placement, calculate the expected pay, expected charge and expected margin for the period based on contracted rates and hours worked. Layer in overtime rules, AWR uplifts, bonuses and any agreed variations.
4. Run checks and controls
Compare expected values against actual payroll and actual invoiced amounts. Flag variances above a defined threshold. Check for missing timesheets, placements with no invoice, invoices with no matching placement, and rate changes that have not been reflected downstream.
5. Produce outputs
Generate a weekly margin control pack: a summary view for finance leadership, a consultant-level view showing their placements and any exceptions, and a detailed exceptions list with the supporting data for each flagged record.
6. Review exceptions
Route exceptions to the right owner. Rate or contract issues go to the consultant. Payroll or billing issues go to operations or finance. Use embedded AI to draft a plain-language explanation of each exception, so reviewers know exactly what to check.
7. Move to governed operation
Run the workflow on a defined schedule with full audit logging. Track exception ageing, resolution and recovered margin. Feed learnings back into the placement creation process so the same errors stop recurring.
What good looks like
- Every active placement is checked every pay cycle, not just at month-end.
- Expected margin is calculated from contract data, not from what was billed.
- Variances are categorised by root cause, not just flagged as differences.
- Contract variations captured outside the core systems are still picked up.
- Exceptions have clear owners, deadlines and audit trails.
- Finance can evidence the control to auditors and to the board.
- Recovered margin and prevented leakage are tracked as a KPI.
Benefits
For the business team
Consultants and operations get a clear, weekly view of any placements where pay, bill or margin looks wrong. Issues are caught while they can still be corrected with the client or worker, rather than written off later.
For leadership
Finance and commercial leaders gain a reliable gross margin number, supported by a repeatable control. Margin movements can be explained with confidence, and commission calculations are based on accurate data.
For the wider business
Clients are billed correctly, workers are paid correctly, and compliance obligations around AWR, holiday pay and pensions are met consistently. The agency protects both its profitability and its reputation.
Where to start
A good first version focuses on one population: for example, active contract placements in a single division or a single pay and bill system. Start with the largest source of margin and the highest volume of timesheets. Build the data joins, prove the margin recalculation, and run it in parallel with the existing month-end process for a few cycles.
Once the workflow is trusted, expand to additional divisions, permanent placement fee reconciliation, and contract variation capture using AI extraction.
How 4th Revolution can help
4th Revolution is a finance-led, data-led specialist in no-code automation and embedded AI. We work with recruitment and staffing businesses to design margin control workflows that are not just clever data joins, but governed, repeatable processes that finance and operations can rely on.
We focus on:
- Joining placement, payroll, timesheet and billing data cleanly.
- Building the margin recalculation logic that mirrors your commercial reality.
- Using AI to handle the messy edges, such as contract variations and rate confirmations.
- Embedding the workflow into a controlled, auditable operating rhythm.
The goal is a margin control process that runs every week, evidences itself, and gives leadership confidence in the numbers.
Example outcome
Before: a finance team spends several days each month reconciling payroll and billing in spreadsheets. Margin issues are typically found weeks after they occur, and a portion are written off because the client period has closed or the worker has already been paid.
After: every active placement is recalculated weekly. Exceptions are routed to consultants and finance within days, not weeks. Rate errors, missed uplifts and billing mismatches are corrected while they are still recoverable. The gross margin number reported to the board is supported by a documented, repeatable control.