Replacing administrative hassle with an automation that pays for itself.

The challenge

_{two systems, zero communication}

‍

Baker Tilly uses Officient for HR management and leave requests, and AdminConsult for time tracking, project management, and payroll processing. Both are essential, but were running in complete isolation from each other.

‍

Whenever someone took a day off or called in sick, it got logged in Officient. But someone still had to manually enter that same information into AdminConsult to keep time tracking and payroll accurate. Which meant:

‍

• Duplicate work: Every single leave day manually entered into two systems.
• Error risk: Leave that exists in Officient but not in AdminConsult, or employees accidentally logging hours on their day off.
• Payroll risk: Mistakes that only surface after the facts, when they're hardest to fix.

‍

On top of that: AdminConsult runs on-premise, not in the cloud. That makes integration a lot more technically involved. But we love a challenge.

‍

The solution

_{a synchronization that saves hours}

‍

We built an automatic synchronization tool that acts as a bridge between Officient's cloud environment and AdminConsult's local server. No heavy, expensive server running 24/7. Instead, a serverless solution that only runs when needed. Cost-efficient and scalable.

‍

‍

Here's how it works:

• Nightly sync. Every night, the system automatically checks the previous day's leave and sick days in Officient.‍
• Smart filtering. Only employees on the payroll are included. No freelancers, no partners. Clean data, no noise.‍
• Happy flow. Nothing booked in AdminConsult for that day yet? The tool automatically writes off 7.6 hours of leave or sick time. Done.‍
• Conflict detection. Has the employee already logged hours for that day? The tool doesn't overwrite anything. Instead it sends smart notifications with a ready-made resolution. Proactive, not reactive.

And the on-premise challenge? Solved with some smart network engineering for a secure connection. This gives us a secure connection to Baker Tilly's local server without opening dangerous ports in the firewall. Safe, compliant with their IT standards, and zero compromises.