Investment Reporting and Accounting Services

The Vendor is required to provide a comprehensive fixed income investment management solution that delivers portfolio reporting, advanced analytics, investment accounting, and seamless integration with the city’s general ledger system, workday.
- Functional requirements
1. Support for various fixed income instruments
•    Solution must recognize and provide real time information and calculations, such as market pricing, call dates, interest payment calculations, etc., for investment instruments.
2. Trade capture and settlement tracking.
•    Users will need the ability to enter investment purchase data, including CUSIP, trade date, settlement date, maturity date, investment issuer, par value, principal, and broker dealer information into the solution.
•    Solution should be able to populate various data fields, including maturity date, coupon, call dates, etc., based on CUSIP to assist with data entry.
3. Real-time portfolio valuation and performance analytics.
•    Solution should provide a dashboard with current portfolio totals and breakdown of portfolio by investment type.
•    Solution should provide real-time market pricing and an import function for updating pricing monthly at minimum.
•    Reporting will be used to monitor the investment portfolio daily, monthly and annually.
•    Standard reports should include:
o    Cash flow projections
o    Maturity, call and interest information
o    Par, market and book value of all investment holdings
o    Investment holdings by issuer
o    Maturity distribution and aging
o    Investment activity (purchases, maturities, and redemptions)
o    Broker dealer activity
o    Interest income, projections, yield, and accruals
o    Investment analysis (duration, yield to maturity, etc.)
- Customer service
•    Accessible, courteous, responsive and seamless customer service is of highest priority for the city. 
•    Accessible service means that citizens have easy access to the organization. 
•    Seamless customer service means that a customer gets good service no matter who is responsible. 
•    Responsible customer service means that our employees know what they are doing: that information they give is accurate; that they have a good understanding of how to get problems and decisions made; that they are trained and evaluated for the jobs they are doing. 
•    Customer service goals must be measurable and regularly evaluated. 
•    Continuous improvements in customer service must be made in order to make city services accessible, responsive and as seamless as possible.