Payroll to finance
Exact HR to 4PS Construct integration: payroll costs from Exact Online payroll as a journal in 4PS, with cost centre and project as dimensions
With an integration between Exact HR (Exact Online payroll) and 4PS Construct, the payroll costs of every finalised payroll run automatically arrive as journal lines in that employer's 4PS company, with cost centre and project as dimensions. KoppelHet builds the lines from the paid pay components in Exact, and finance posts the journal in 4PS.
What the integration does
Organisations that process payroll in Exact Online payroll and keep projects and finance in 4PS Construct post the payroll costs into 4PS by hand after every run. Costs per project or cost centre are only complete once someone has retyped the Exact reports.
- Payroll finalises the payroll run in Exact.
- KoppelHet fetches the finalised lines and totals them per pay component, cost centre and cost unit.
- KoppelHet checks that every cost centre and every project exists as a dimension value in 4PS.
- The lines go into a fixed payroll journal of the 4PS company, with the run number from Exact as external document number.
- Finance reviews and posts the journal in 4PS.
What to watch for with Exact HR and 4PS Construct
- Exact Online has no payroll journal in its payroll API, but does return every paid line with cost centre and cost unit. KoppelHet converts those into journal lines for 4PS. A table maintained by finance decides which 4PS account each pay component goes to.
- 4PS Construct runs on Business Central. A journal line there has one amount field, positive for debit and negative for credit, while Exact returns allowances and deductions as separate types. KoppelHet sets the sign per type, so a deduction does not land on the project as extra cost.
- Dimension values can only be read in the Business Central API. The integration therefore cannot create an Exact cost centre or cost unit without a dimension value in 4PS itself. KoppelHet then stops the payroll run and reports which code finance needs to add in 4PS.
- In 4PS the administration revolves around projects, and finance wants to see payroll costs there per project. Exact returns a cost unit per line; KoppelHet puts it as project dimension on the journal line in 4PS, so payroll costs appear in project accounting without manual allocation.
- KoppelHet puts the run number from Exact on every line as external document number. Before a payroll run is submitted, KoppelHet checks whether that number is already in the journal, so a repeated round does not put a second set of payroll costs into 4PS.
- Exact also has the status deleted for paid lines. If a payroll run disappears in Exact after the lines are already in 4PS, KoppelHet tells finance which journal belongs to it. Finance makes the reversal in 4PS itself.
- Every Exact division is an employer, and in Business Central every company has its own route in the API. KoppelHet links each division to one 4PS company, so the payroll costs of one operating company do not end up in another's books.
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
Who posts the journal in 4PS?
Finance. The integration stages the lines in a fixed payroll journal; posting stays a step in 4PS.
Can the integration create new projects in 4PS?
No. Dimension values can only be read through the API. A missing project becomes an alert for finance.
Does this also work with Exact Globe?
No. This page assumes Exact Online payroll.
Technical details for IT
For those who want to know how it works under the hood: APIs, fields and sources used.
- Exact Online through the REST API with OAuth 2.0, read only: /api/v1/beta/{division}/payroll/PayrollTransactionsByPayrollYear (Status 6 finalised, 7 deleted; Frequency 11 to 15 pro forma; CostCenterCode, CostUnitCode, CalculatedAmount, PayrollRunCode) and /api/v1/beta/{division}/payroll/PayrollComponents (Type 1 allowance, 2 deduction, 3 subtotal).
- 4PS Construct through the Business Central API v2.0 per company: journals and journalLines (accountType, accountNumber, postingDate, documentNumber, externalDocumentNumber, amount, description) with dimensionSetLines per line; dimensionValues GET only. 4PS publishes no API documentation of its own.
Which fields are transferred
The key fields. The full mapping is agreed per customer.
| Field in Exact HR | Field in 4PS Construct | Notes |
|---|---|---|
PayrollComponentCode | accountNumber | Table from pay component to 4PS account |
CostCenterCode | Dimensie kostenplaats (dimensionSetLines) | |
CostUnitCode | Dimensie project | Configuration choice of finance |
CalculatedAmount | amount | One field; positive is debit, negative is credit |
PayrollRunCode | externalDocumentNumber | |
Division | Company in 4PS | Fixed mapping per division |
PayrollYear en Period | postingDate |
Related
Exact HR → Active Directory
Exact HR to Active Directory integration: accounts from payroll in Exact Online
Exact HR → AllSolutions
Exact HR to AllSolutions integration: payroll costs from Exact Online payroll as a journal posting in AllSolutions
ASExact HR → Arbodienst (SIVI)
Exact to occupational health service via SIVI: sick and recovery notifications from Exact Online payroll to the health service
Exact HR → Microsoft Entra ID
Exact HR to Entra ID integration: Microsoft accounts from payroll in Exact Online