OpenProject Sync for Exact Online¶

Book the time your team logs in OpenProject as hours in Exact Online: one draft line per person, work package and day. Work packages become WBS lines, and the approval status of the hours comes back in OpenProject as a comment.
Where it lives
OpenProject Sync is an app of the Exact Gateway portal at https://apps.mvdw-software.com/exact/openproject-sync/. Your account, organization, subscription and the connection to Exact Online live in the portal; this app syncs OpenProject with it.
Why¶
Your team plans and logs its time in OpenProject, because that is where the work is. Your administration and the project's profitability live in Exact Online. Without a link, someone exports the hours every week and re-types them in Exact, and the booked hours drift from what was actually worked: the wrong person, the wrong project, or a week nobody got around to.
OpenProject Sync links an OpenProject project to an Exact project and keeps them in step:
- every time entry in OpenProject becomes a draft hour line in Exact, one line per person, work package and day, already on the right project and hour type;
- work packages (with their parent/child structure) become WBS activities, and versions can become WBS deliverables, so the work breakdown follows the OpenProject plan;
- when someone approves or rejects the hours in Exact, a comment appears on the work package in OpenProject, so the team sees what finance decided without asking;
- people are matched automatically on their e-mail address, so time logged by Tom lands on Tom's employee record without anyone doing anything.
The team keeps working in OpenProject; administration approves the draft lines in Exact as usual.
A linked project, syncing:

How it fits together¶
flowchart TB
subgraph op ["OpenProject (cloud or self-hosted)"]
T["time entries"]
I["work packages and versions"]
C["comments on work packages"]
end
subgraph app ["OpenProject Sync"]
S["sync engine: every 15 minutes, per linked project"]
M["people: OpenProject user → Exact employee"]
end
subgraph exact ["Exact Online (via the portal's connection)"]
H["draft hour lines, one per person, work package and day"]
W["WBS activities and deliverables"]
P["the linked Exact project"]
end
T -- "read" --> S
I -- "read" --> S
S -- "create / update draft lines" --> H
S -- "create WBS lines" --> W
P -- "existing, or created from OpenProject" --> S
H -- "status: approved, rejected" --> C
M -- "match on e-mail" --> S
The organization signs in once in the portal, connects its Exact Online administration there (once per app), and adds an OpenProject API token in OpenProject Sync. From then on the sync runs on a schedule.
What this documentation covers¶
| You want to… | Read |
|---|---|
| subscribe, connect Exact Online and add an OpenProject token | Getting started |
| link an OpenProject project to an Exact project, step by step | Link a project |
| understand what is synced, when, and what happens on conflicts | How the sync works |
| fix a failing token, a failing project or hours that do not appear | Troubleshooting |