Case Study 2.28.2017

Enhancing Treasury Reporting/Analytics Capabilities

Trexin helped a large health insurer enhance its Treasury reporting / analytics capabilities and streamline the operational process used to create production reports.

Business Driver

Our Client, the Treasury Cash Management and Control team of one of the largest health insurers in the country, is responsible for daily management of operating bank account balances, funding of disbursement accounts, and timely communication of excess or deficit balances to Investment Operations. Cash management is an important area of focus for Treasury as they are responsible for the safekeeping and control of the firm’s cash and investments, thus relying heavily on the primary internal control of existing bank and cash reconcilements. Uncertainty regarding implementation of the newly enacted Affordable Care Act presented risks, so Trexin was asked to streamline operational processes and create new production reports to enhance our Client’s Treasury reporting and analytics capabilities to accurately measure and assess capital and liquidity.

Approach

Trexin deployed a team with expertise in both insurance and investment management and used Trexin’s capability assessment, strategy, and roadmap (ASR) methodology to:

  • Quickly gathered information to develop a common baseline of understanding of current processes and capabilities.
  • Reviewed bank data feeds and systems involved including: Treasury Workstation capabilities, Cash Application Hub, and PeopleSoft Financials system.
  • Documented the Treasury Reconciliation Report and indicated which Bank account/BAI code pairs are booked by Treasury Workstation.
  • Analyzed and documented Treasury Workstation general ledger postings to cash accounts and identified other areas posting to those accounts.
  • Evaluated business and technical requirements for future-state improvements.
  • Assessed the possibility and feasibility to match off daily banking activity (data feeds) with the corresponding general ledger cash entries.
  • Proposed recommendations to the steering committee covering use of Treasury Workstation,  cash posting work flow, and new PeopleSoft functionality.

Results

By providing detailed documentation of reporting and improved accuracy of cash management reconciliation processes, Trexin helped our Client’s Treasury department better track and control over $100 billion in annual operating cash flow and $30+ billion of annual investment & financing cash flow,  which positively impacted investment performance.

Tagged in: Data & Analytics, Financial Services, Healthcare
Social Media Accounts