Abstract

{taxmate}: An R-Based Solution to Streamline Treasury Processes

{taxmate} is an internal R-based business solution developed to replace SAS workflows from January 2026. Built in close collaboration with end users, the package is designed for production use with a strong focus on usability, reliability, and auditability, without requiring technical expertise. Its implementation is expected to reduce software licensing costs by approximately $58,000 annually.

The solution is delivered as a golem-based Shiny application with a Bootstrap 5 front end. Core business logic is implemented using the R6 framework, and all data are stored in DuckDB databases. The application operates as a standard point-and-click tool, with commonly used functions accessible via action buttons. For advanced users, a SQL interface provides flexible data extraction and analysis.

Behind the user interface, the application automates previously manual processes, including file renaming, data extraction, transformation, database updates, and archival. Workflow progress is reported dynamically, data quality issues are surfaced through automatically generated diagnostic reports, and all user actions are audit-logged to ensure transparency and support compliance review.