Industry
Transportation
Region: United States of America
Summary
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
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