Two hours of manual entry a day gone.
At 230 working days, roughly 460 hours a year.
Promesse → Exact Online · OneDrive / FTP · mapping and error handling
The situation
The administration of end client De Boer Schilderwerken lives in Promesse, the bookkeeping in Exact Online. Someone typed every journal entry by hand from one system into the other. Duplicate work, and errors only surfaced at the review.
What I built
An integration that automatically picks up export files from OneDrive or FTP, translates Promesse codes to their Exact equivalents through a configurable mapping layer, and writes the entries away as sales, purchase or general journal postings.
What changed
Every journal entry used to be retyped by hand; that now happens automatically. When something goes wrong, the dashboard shows whether it's the source data, the settings, Exact itself or the connection — so it's immediately clear who needs to fix it.
Where the real work was
Building an integration that works when everything goes right is the easy part. This system is built on the assumption that things will go wrong.
Incomplete entries wait
Entries that arrive split across several exports only go through once they're complete.
Missing master data blocks nothing
Lines continue on their own as soon as the missing data is there.
The system protects itself
After three consecutive errors, the integration pauses itself for fifteen minutes.
Reposting without duplicate entries
Even after deletion in Exact you can safely reprocess; a double-click never produces a duplicate entry.