Treasury Management Solution

The vendor is required to provide that employs desktop treasury software for electronic processing of investment transactions
- solution must represent an integrated treasury management system which may include third-party solutions: however, all components must be integrated with the core line of business functionality proposed.
- Provide agency that provides accurate amortized investment entries and can be verified by department
- Any discrepancies exist in the posting of a financial transaction; the agency will provide the ability to adjust accruals prior to the entries posting to the general ledger system
- Agency interface directly with the city’s general ledger software
- Agency to track compliance of an investment policy by allowing user to enter limits, ether my dollar amount or percentage, or issuers, dealer/brokers or investment type;
- Provide compliant report capabilities that include but are not limited to earnings and yields summary/effective interest-actual life, portfolio value at market;
- Agency to track and report the history of rate and market price changes for an individual investment
- Agency perform partial sales analysis that captures accrued interest, book value, gains or losses on an investment, and beginning and ending par and book value;
- Agency all treasury staff to search by query and have all relevant investment data populate immediately.
- Additionally, the system must accept manual input;
- Import trade information, including market pricing imports, from multiple file formats
- The department updates investment information during the life of the security, based on details provided by the proposer’s investment data.
- The original cost of the security shall not be updated once it has posted to the general ledger;
the treasury to enter trades into the department based on the trade date and include a future or same day settlement date as well as attachment options for each investment;
- The treasurer to add dates in an information field for cash forecasting;
- The treasurer to assign unique identifiers to manual securities in the
- The department inputs collateral in numerous formats
- Historical data from the current investment management software can be uploaded into the tms for the preservation of this data
- A customized department reporting tool that allows treasury staff to create custom reports by user;
- The department balances interest payments via a pre-approval process and can manually adjust interest accruals;
- Provide a department that enters periods of time, including, but not limited to, the maturity date, for determining cash position;
- Provide a department that calculates for industry standards, such as yield, weighted average maturity, weighted average life, and duration;
- Provide a department that imports assets from the treasurer’s current system;
- Provide a department that properly tracks the multiple positions of a security owned by to group the securities together as a single asset.
- Provide a department that accurately captures historical data and current data;
- Need to meet cloud security measures (if applicable) as dictated by our information services department;
- Provide a department that codes securities by custodian; and
- Must meet best practices for security and access controls based on user roles and meet all applicable legal and audit requirements.
- A cloud-based platform, the vendor will house all data in the us, confirm that no data is transferred outside the us, allow city staff access via azure active directory integration, provide equivalent reports, and submit to annual penetration testing performed by an assigned vendor and provide relevant results to city.
- Contract Period/Term: 4 years