Alteryx
343 Case Studies
A Alteryx Case Study
Compensar, a major social-welfare provider, faced a slow, error-prone payment collection and reconciliation process handled manually across multiple teams and data sources (banks, ATMs, SAP, PAYU, credit systems, etc.). The disparate file types and inconsistent records made matching transactions time consuming and difficult to audit.
Using Alteryx, Compensar implemented a two-stage automated workflow that standardizes and consolidates files (txt, csv, xls/xlsx), applies business rules and cross-reference keys, then runs reconciliation to produce consolidated accounts, reconciliation results, pending items and detailed logs; processed files are archived automatically. The automation greatly sped up reconciliation, reduced errors to almost zero, improved traceability, and made the payment collection process more efficient and auditable.