ERP systems are the source of truth for most professional services firms — but they're rarely designed to talk to the rest of your tech stack.

I built a daily sync between Deltek Maconomy and a project management platform for a client that was spending real time manually reconciling project data across systems. New projects created in Maconomy weren't showing up elsewhere until someone checked, which meant delays and mismatches.

The solution: a scheduled Make.com scenario that hits the Maconomy API each morning, pulls the day's project updates, checks for duplicates against what's already been synced, and pushes clean records to the target platform. At the end of each run, it emails a log — what synced, what was skipped as a duplicate, what errored.

The deduplication step was the most important part. Without it, re-runs after a hiccup would flood the destination with duplicate records. We keyed on project IDs and a hash of the core fields so the sync was safe to run multiple times without side effects.

The email log wasn't glamorous but it earned its place immediately. The operations team could see exactly what moved each day without logging into anything — and on the one day the API returned an unexpected structure, the log made it obvious within minutes.

Daily syncs seem simple. Making them safe to run reliably every day is the actual work.