Consolidation Software for Staffing Companies: The Client Margin Test

Executive summary

• When one entity employs staff and another invoices clients, a standard trial balance roll-up can duplicate revenue and costs while leaving each ledger internally correct.
• Eliminating the cost-plus recharge fixes consolidated totals, but group profitability by client still requires matching payroll, internal charges, and external invoices.
• Timing differences, staff transfers, variable mark-ups, and different currencies create unmatched recharges that finance must explain rather than force to zero.
• Test consolidation software with one real client that spans two entities and two months. Demand a traceable client margin and a reconciliation to both ledgers.
• As employing and billing entities multiply, repeatable client mappings and documented elimination rules matter more than a generic intercompany feature checkbox.

The client looks profitable in both ledgers. The group sees a third margin.

A billing subsidiary reports a client contract at a 13% margin. The employing subsidiary records a 9% margin on the related staff recharge. The group CFO adds the ledgers and finds revenue that no outside customer ever paid. Once finance eliminates the internal charge and traces the actual staff costs to the contract, the client generates a 20% group margin.

Both subsidiary ledgers can be correct while neither shows what the contract earns for the group. For a finance lead comparing consolidation software staffing company options, this is the test that matters: can the system reconcile the legal-entity accounts and produce a reliable client-level result?

This problem appears in labour supply, outsourced staffing, and facilities management groups that separate the employer of record from the company holding the client contract. Each entity has a valid statutory P&L. The commercial margin crosses the boundary between them.

The recharge makes a profitable contract look smaller

Take a monthly contract with $500,000 of client revenue. The employing company incurs $350,000 of payroll and bills the sales company $385,000, including an illustrative 10% mark-up on payroll cost. The billing company incurs another $50,000 of direct client costs. It reports $65,000 of profit, while the employing company reports $35,000.

Adding the two ledgers before consolidation produces $885,000 of revenue: $500,000 from the customer and $385,000 from the internal recharge. It also carries the $385,000 internal expense. Removing both sides of the recharge leaves $500,000 of external revenue, $400,000 of real direct costs, and $100,000 of group contribution, or 20%. The exact gross-margin label depends on the group’s agreed cost classification.

When both sides are recorded consistently, eliminating the recharge changes neither consolidated profit nor the underlying payroll cost. It removes ghost revenue and the matching internal expense. The harder work is connecting those real costs to the client contract that produced the invoice.

One recharge balance can cover six contracts and three payroll cycles

An account-level elimination can remove the $385,000 recharge from the group P&L. It cannot, by itself, tell the CFO which clients consumed the staff, which cost centres supplied them, or whether a contract was profitable after overtime and subcontractors. A trial balance identifies accounts and entities. The client bridge requires more detailed references.

Finance needs a shared client identifier across the billing invoice, employee assignment or approved timesheet, employer payroll allocation, and internal recharge line. A site or project identifier may be necessary when one client operates multiple facilities under different rates. Where one employee works for two clients during the month, the underlying payroll must follow an approved allocation rule.

This is the difference between consolidated financial statements and management reporting that can explain contract economics. The same entity-to-segment mapping problem emerges when legal companies and operational reporting units overlap. The allocation basis should remain documented, reviewable, and consistent across periods.

Consolidation software for staffing companies must pass the client margin test

Start with an anonymised month of transactions from one employing entity and one billing entity. Include a client invoice, the related payroll expense, a cost-plus recharge, and another direct contract cost. Add a mid-month transfer between clients and a recharge posted after month-end. The group margin should still reconcile when the data becomes messy.

The resulting view should show the recharge eliminated on both sides, external revenue intact, and payroll assigned to the correct client and period. Client contribution must tie back to the consolidated group accounts, with every elimination and allocation traceable to the source. Change the approved mark-up and repeat the calculation without rebuilding the workbook.

Kudwa brings entity ledgers and relevant operational data into one financial model. It maps accounts into a common structure, applies intercompany eliminations, handles currency translation, and supports profitability analysis by client. With agreed client and site mappings, finance can review external billings alongside the underlying staff costs after internal recharges are removed from the group result. The employing and billing entities retain their own statutory transactions.

Timing differences are a reconciliation issue, not a margin adjustment

Payroll often posts before the staffing company raises the intercompany recharge. The billing entity may wait for approved timesheets before invoicing the client. At month-end, the three records can land in different periods. The controller must distinguish an unrecorded recharge, an unmatched internal payable, and valid accrued or unbilled revenue under the accounting policy.

When an employing entity in the UAE recharges a KSA billing entity, currency adds another layer. The recharge and its counter-entry may use different posting dates or translation conventions. Finance should match the underlying transaction first and then investigate the remaining currency or cut-off difference; an arbitrary clearing entry makes the next month harder.

The internal mark-up also belongs to the statutory and tax records. It can determine which entity reports profit even though consolidation removes the internal sale and purchase. The tax team should document and support the transfer-pricing policy, and confirm VAT treatment and invoicing obligations in the relevant jurisdictions. The software should apply the approved policy and preserve the audit trail, not choose the mark-up or contract revenue presentation for management.

The spreadsheet survives the first close. The sixth is harder.

A spreadsheet can support one employing company, one billing company, and a handful of stable clients. The controller can reconcile the recharge, remove it, and attach a client-margin schedule to the pack. That arrangement becomes fragile when a new licence creates another employer, contract mark-ups change, staff move between sites, or an acquisition arrives with different account codes.

The recurring work soon expands beyond the elimination journal. Every close brings fresh payroll allocations, internal invoices, external billing, exceptions, mapping changes, and explanations of client-margin movements. Finance also needs to reproduce the previous board figure from its original source records when a contract manager challenges it weeks later.

Kudwa makes that reporting process repeatable. It connects the existing accounting and operational systems, maintains consistent mappings and consolidation adjustments, and refreshes management reporting as new data arrives. Finance can analyze client profitability across entities and trace the group result back to the employing and billing ledgers, while the approved internal mark-up stays in the individual entity records.

The buying decision rests on a repeatable answer: how does a $500,000 client invoice become $100,000 of group contribution after internal charges disappear? The CFO needs the same answer next month when staff assignments, recharge timing, and contract costs change. That requires a consolidated result that remains tied to the actual client.

See the real group margin behind each client

See how Kudwa consolidates employing and billing entities, eliminates internal recharges, and supports a clearer view of client profitability. Book a demo now.

‍