The Problem
Emmenegger, a Swiss HR and payroll services provider, manages employee data across two enterprise directory systems — ZGRD and SSO. Every quarter, their billing team manually cross-referenced employee counts from both systems, reconciled discrepancies, and generated invoices for each associated company based on headcount brackets and service tier rules. With dozens of client companies and frequent employee data changes, the process consumed significant staff time and introduced billing errors.
What We Built
A GoFlow automation that handles the full quarterly billing cycle end-to-end. The workflow runs on schedule and coordinates data across ZGRD and SSO without any human intervention.
Bidirectional Record Reconciliation
The workflow detects whether each record originates from SSO or ZGRD, pulls address lists from both systems, and checks whether the addresses are already cross-linked. Existing links are updated in place. Missing links are created and registered in the target system. A "Fresh and Retry" path handles records that fail on the first pass, and a manual retry trigger covers edge cases that need human review.
Rule-Based Invoice Generation
Once employee counts are reconciled, the workflow evaluates a business rules engine based on service type and headcount band to determine the correct invoice amount for each associated company. This removes the ambiguity that previously led to manual overrides and re-invoicing.
Error Handling
Every step includes structured error handling with retry logic. Records that cannot be processed are surfaced for manual review rather than silently dropped — giving the finance team a clear view of any exceptions each cycle.
Stack
- GoFlow — workflow orchestration
- ZGRD — employee directory and HR data system
- SSO — identity and headcount data source
- Rule engine for invoice calculation logic
Result
Emmenegger's quarterly billing cycle is now fully automated. Finance staff no longer spend days cross-referencing records — the workflow handles reconciliation, address linking, and invoice generation within a single scheduled run, with built-in recovery for edge cases.