Case Study: St. LukesHealth achieves over 25% process efficiency gains through automated reconciliation with Yellowfin

Automated reconciliations deliver over 25% process efficiencies for St. LukesHealth

St. LukesHealth, a Tasmanian not‑for‑profit health insurer with over 30,000 policies, was spending the equivalent of 1.08 FTE on manual payroll remittances — comparing employer PDF remittance advices with records in its HAMBS system — a tedious, time‑consuming process that became unsustainable as membership grew. To tackle this, St. LukesHealth deployed Prometheus ETL tools alongside Yellowfin’s YellowfinBI analytics and visualisation platform to enable automated reconciliation.

Using Prometheus to ingest employer CSV data and Yellowfin to build side‑by‑side reconciliation reports with conditional formatting, alerts and broadcasts, Yellowfin’s solution automated checks, highlighted discrepancies and routed clean reports to the member services task list. The result: large payroll groups that once took an afternoon now take about half an hour, delivering estimated processing efficiency gains of 25–33%, faster root‑cause identification and higher staff satisfaction — with the proof‑of‑concept completed in two months and ongoing incremental improvements.

St. LukesHealth

Matthew Ranson

Senior Analyst