Case Studies

Treasury Investment and Accounting Automation

Industry

Software

Region: United States of America

Summary

SFA’s Center of Excellence in Treasury Management supported PeopleSoft/Oracle organization in quality assurance and release testing of PeopleSoft Treasury applications such as cash management, financial gateway, deal management and risk management for successful general release including Strategy, PeopleBooks and Integration development support services.

Objectives and Challenges

  • Objectives: Implement modern treasury capital and operating investment portfolio management and accounting replacing intense manual legacy system
  • Challenges: Lack of documentation with manual legacy system; Heavy reliance on manual calculations; complex accounting rules and chart-of-accounts; multiple statutory and regulatory compliance reporting requirements; constant portfolio changes with multiple partial sell/buybacks; multiple counterparties and custodians; multi-tiered workflow requirements

Results

  • Successfully implemented long-term and short-term investment portfolios with multiple investment types, day-count basis, interest and amortization schedules with partial/buybacks abilities and mark-to-market
  • Streamlined cashflow management with enterprise resource planning system with total transparency on transactions and daily cash positions
  • Automated accounting on daily investment cashflows, monthly amortizations and accruals, and complex chart-of-account substitutions
  • Several integrations with custodians, pricing and treasury counterparties with automated reconciliation, KPIs based reporting and dashboards

Benefits

  • Total automation of treasury investment and accounting with modern applications and integrations with total transparency
  • Automated system calculated interests, amortizations, and sell/buyback schedules leading to no manual calculations, no errors
  • Standards-based investment, pricing and accounting configurations leading to streamlined investment processing for better compliance
  • Complete automation in treasury investment accounting based on general ledger chart-of-accounts, substitution rules and treatments

Products and Technology

  • PeopleSoft FSCM (Treasury Deal, Risk and Cash, General Ledger, Banking)
  • PeopleTools
  • PGP
  • WebLibs
  • Batch Scripts
  • Cronjobs
  • XML Publisher
  • SQR Reports
  • Oracle OAS
  • Java
  • JavaScript