Payroll integration
Cezanne HR to ADP iHCM integration: compensation, single payments and leavers to Dutch ADP payroll
An integration between Cezanne HR and ADP iHCM passes salary changes, single payments such as bonuses and the termination date of employees of the Dutch company in Cezanne HR to ADP iHCM. Payroll then no longer retypes that data; creating a new employee in ADP remains work for payroll.
What the integration does
Organisations that use Cezanne HR for several countries and have Dutch payroll at ADP iHCM pull a compensation report from Cezanne every month and fill ADP by hand. A bonus in Cezanne is often an annual amount with a separate payment date, and whoever copies the wrong figure pays too much or in the wrong month.
- HR records a compensation record, a bonus or a termination date in Cezanne.
- KoppelHet fetches the changed records and keeps only employments of the Dutch company.
- The base salary goes to ADP as a salary change; a single payment as a variable line in the period of the payment date.
- A termination date on the employment starts the termination in ADP.
- Deviations are in an overview for payroll.
What to watch for with Cezanne HR and ADP iHCM
- A compensation record in Cezanne can be a single payment, with its own payment date besides the term. KoppelHet sends such a record to ADP as a variable line in the period of the payment date, not the effective date, so an annual bonus lands in the month of payment.
- Cezanne keeps compensation both in the payment currency and in the organisation's base currency, plus a target amount and an achieved percentage. KoppelHet only sends the actual amount in euros to ADP; the target amount never goes along.
- Compensation proposals are in a separate, read-only table in Cezanne. KoppelHet ignores them and waits until a proposal has become an actual compensation record, so a pay rise still in the review round does not reach ADP.
- An employment in Cezanne belongs to a company with its own code, and an employee can have several employments with one primary. KoppelHet only includes employments of the Dutch company and translates that company code to the ADP pay group.
- On departure Cezanne has a termination date, a last worked date and a last paid date. KoppelHet gives ADP the termination date of the employment and puts a different last paid date on the list for payroll, because it affects the final settlement.
- Webhooks are only available at Cezanne in the People PLUS+ package. Without that package KoppelHet filters hourly through OData on the change date of the compensation records; with People PLUS+ the integration reacts directly to the webhook.
How we build and run it
- The integration runs on the KoppelHet platform, hosted in a data centre in the EU.
- Every sync and every error is visible in the functional log; on an error your administrator is notified.
- A change that cannot go through is not half-applied but queued for another attempt.
- KoppelHet is ISO 27001 certified. Data travels encrypted and stays on the platform no longer than needed.
- After go-live we manage the integration and adjust it when your process changes.
- The integration fits next to your existing integration layer. Only the fields in the design are transferred; the platform keeps no register of its own.
Implementation and price
This is not an app you switch on. We build the integration for your organisation on our platform, with building blocks we reuse on every project. So it is custom work that does not start from scratch.
A consultant prepares the intake and analyses both systems. We then record the mapping and exceptions field by field, test in the test or acceptance environment and go live at a moment you choose. Costs are a one-off amount for the setup and a monthly amount for platform, monitoring and support.
Frequently asked questions
Do we need People PLUS+?
No. With People PLUS+ changes arrive faster through webhooks; without it the integration works with an hourly check.
Does the integration create new employees in ADP?
No. Payroll creates the employee in ADP; KoppelHet then links them on employee number.
Do fixed allowances go along?
In the first version as a notification to payroll. Through ADP's API for fixed pay components can be added later as an extension.
Technical details for IT
For those who want to know how it works under the hood: APIs, fields and sources used.
- Cezanne HR through the OData data service (v7, $format=json, $filter, $select, $top, $skip) with an access token: Compensation (PersonCode, CompItem, CompItemCode, CompItemType, EffectiveFrom, EffectiveTo, PaymentCurrency, BaseCurrency, PayPeriod, SinglePayment, SinglePaymentDate, CurrentAmount, AnnualAmount, TargetAmount, LastModifiedDate), CompensationProposals (read-only) and Employments (CompanyCode, PrimaryEmployment, HireDate, TerminationDate, LastWorkedDate, LastPaidDate, TerminationReason).
- ADP iHCM through GET /hr/v2/workers, the Base Remuneration Change API (2416 and 2417), the Pay Data Input API for iHCM NL and the Worker Terminate API (worker.terminate, worker-termination.cancel). Canonicals in the Consumer Application Registry (CAR).
Which fields are transferred
The key fields. The full mapping is agreed per customer.
| Field in Cezanne HR | Field in ADP iHCM | Notes |
|---|---|---|
PersonCode | payrollfilenumber | Linked once and stored by KoppelHet |
Employments CompanyCode | payrollGroupCode | Lookup per company |
Compensation CompItemCode basissalaris, CurrentAmount, PayPeriod | Salarisbedrag 2417 en salariscode 2416 | |
Compensation EffectiveFrom | effectiveDateTime van de salariswijziging | |
Compensation SinglePayment 1, CurrentAmount, SinglePaymentDate | Variabel veld (Vxxx) met de begin- en einddatum van de periode | Lookup per CompItemCode |
Employments TerminationDate | Beëindiging in worker.terminate |
Related
Cezanne HR → Active Directory
Cezanne HR to Active Directory integration: domain accounts per employer and location
Cezanne HR → AFAS Profit
Cezanne HR to AFAS integration: the Dutch employer from Cezanne in AFAS Profit Payroll
ASCezanne HR → Arbodienst (SIVI)
Cezanne HR to the occupational health service via SIVI: sickness absence events as absence reports
Cezanne HR → DATEV
Cezanne HR to DATEV integration: the German company from Cezanne HR to the tax adviser