Case Studies

Treasury Investment and Accounting Automation



Region: United States of America


SFA’s Center of Excellence in Treasury Management streamlined one of the largest transit authority’s treasury investment and accounting automation to manage multi-billion-dollar long-term/short-term investment portfolios with multiple treasury counterparties, custodians, investment types and accounting treatments, enabling total transparency in managing capital and operating funds.

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


  • 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


  • 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