Rensselaer County RFP Banking Treasury ePayment Services with Appendices

RENSSELAER COUNTY BUREAU OF CENTRAL SERVICES STEVEN F. McLAUGHLIN JAMES R. GORDON COUNTY EXECUTIVE DIRECTOR RFP-22-14 NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 12/06/2021 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 Page: 1 Request for Proposal for Banking, Treasury, and ePayment Services for Rensselaer County, NY Due: Phase 1: January 14, 2022 Phase 2: February 15 & 16, 2022 Proposers shall submit Phase 1 responses through the rfpPrep web portal. Late Proposals will NOT be accepted or considered. The County reserves the right to reject, in whole or in part, any or all proposals received, and further reserve the right to negotiate the final contract terms, including cost. The mandatory pre-bid web conference will be held on Tuesday, December 21st at 2:00 P.M. EST. we ra https://rfpprep.us/ RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 2

Table of Contents Introduction 3 Overview 3 About the County 3 Objectives 3 General Process 3 RFP Contact 4 Scope of Services Overview 4 Banking Services 4 Treasury Services 4 ePayment Services 5 Scope of Services Detailed 5 Historic & Current Cash Balances 5 Current Account Structure 5 Deposits & Investments 6 Accounting Software 6 The Future of Treasury Services and ePayments 6 Phase 1 - Qualification and Pricing Round: 7 Cost Proposal 7 Option 2 Cost Proposal 8 Phase 1 Weighting 8 Total possible points is 100, weighted as follows: 8 Phase 1 Required Documents 8 Phase 2 - Presentation Phase 9 Phase 2 Weighting 10 Total possible points are 100, weighted as follows: 10 Selection Criteria 10 Phase 3 - Preliminary Finalist Phase: 11 Schedule of Events 11 Appendix A 12 Appendix B 16 Appendix C 24 Appendix D 27 Appendix E 35 RFP-22-14 12/06/2021 Page: 3 Introduction Overview Rensselaer County (the County) is issuing a Banking, Treasury, and ePayment Services Request for Proposal (RFP). The County wishes to receive bids for banking, treasury, and ePayment services in order to ensure it is receiving the best pricing and servicing, most current technology, utilizing any available interest earning opportunities to minimize the tax burden on its constituents, introduce new technologies, reduce costs, and streamline account structures where possible. About the County Please use the following links to learn more about Rensselaer County. 1. About Rensselaer County 2. Audited Financial Statements - Most recent and historic 3. Budgets - Most recent and historic 4. The Countys Investment Policy can be found in Appendix B Objectives The County wishes to enter into a long-term, well-rounded banking relationship that will be sustainable and attractive to all parties involved. In doing so, the County seeks to accomplish the following objectives: Maintain a long-term customer-centric banking relationship; Have access to a user-friendly, intuitive banking services online portal; Gain operational efficiencies through the use of treasury services/technology; Reduce check volume (both those received for payments and those issued for disbursements); Maximize potential rebates through a virtual card/p-card program; Maximize the value of every dollar; and, Ensure competitive pricing. General Process This enhanced RFP process will take place through three distinct phases: (1) Phase One - qualification and pricing, (2) Phase Two - relationship and in-person or virtual interviews, and (3) Phase Three - final legal contract review and selection. Phase 1 responses should be submitted through the banking rfpPrep web portal at www.rfpPrep.us. Proposers will need to sign-up for and have their access to the rfpPrep web portal approved by three+one. Phase 1 responses are due on or before January 14, 2022 at 4:00 P.M. Late Proposals will NOT be accepted or considered. The County reserves the right to reject, in whole or in part, any or all proposals received, and further reserve the right to negotiate the final contract terms, including cost. Three finalists will be selected to move on to Phase 2. Phase 2 will require an in-person or virtual presentation. The Finalist(s) from Phase 2 will be selected to move forward to Phase 3 where final contract negotiations with the preliminary finalist will occur. Each phase is described in further detail starting on page 7. All parties interested in providing these services to the County should contact the designated RFP contact person by the date in the Schedule of Events on page 11. Log-on access to the required online portal will be granted after the pre-proposal web conference. NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 https://www.rensco.com/ https://www.rensco.com/departments/bureau-of-finance/financial-statements/ https://www.rensco.com/departments/rensselaer-county-tobacco-asset-securitization-corporation/reports-and-financial-statements/ https://www.rensco.com/executives-office/county-budget/ https://www.rfpprep.us/ RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 4 The County reserves the right to amend, withdraw, or re-issue this RFP in whole or in part, at any time and for any reason. Submission of a proposal confers no rights upon the proposer, nor does it obligate the County in any manner. The County reserves the right not to award an Agreement and to solicit offers at a later date. The County reserves the right to reject technicalities and to reject any or all proposals in the best interest of the County. The County expressly reserves the right, in its sole discretion, to accept or reject any or all proposals, with or without cause, modify, alter, waive or reject any technicalities or provisions, or to accept the proposal which, in its sole judgment, is determined to be the best evaluated offer resulting from negotiations. After review of proposals and conducting interviews, if any, County staff may be authorized by the County to commence negotiation for a contract with the proposer recommended for the award. The County CFO will be the signer on any agreement entered into as a result of the RFP. If a satisfactory contract cannot be negotiated with the proposer deemed most qualified within a reasonable period of time, as determined solely by the County, negotiations with the proposer will be suspended, and negotiations shall be undertaken with the proposer ranked second most qualified. Should a satisfactory contract not be negotiated with either of the proposers, additional proposers may be selected in order of qualifications, as established by proposal review and/or interview, and negotiations entered into as outlined above. The proposer agrees to negotiate in good faith with the County to enter into a formal agreement with the County, with such agreement substantially incorporating the terms and conditions of the RFP. RFP Contact Alex DeRosa will be the official contact throughout this RFP process. The secondary contact will be Leah Riley. All questions must be submitted to one of the contact persons within the time frame permitted in the Schedule of Events. Phase 2 presentations will be scheduled through the contact person(s). Proposers are responsible to schedule a presentation time slot during the days outlined in the Schedule of Events and by the due date listed. For selected Proposers, presentations/demonstrations will be coordinated through Alex DeRosa and Leah Riley. You may reach the contact persons via email at: ald@threeplusone.us and ler@threeplusone.us. Scope of Services Overview Banking Services Proposals for banking services are being sought for the Countys accounts listed in Appendix D to meet (at a minimum) the service capabilities shown in the description column in Appendix C. The County is looking for Proposers who offer, at a minimum, what is currently being utilized. Treasury Services The County is looking for an enhanced treasury services relationship where the successful Proposer will offer the capabilities to provide streamlined documentation online, provide online tools for efficiencies, use banking portals to enhance cash flow management, and access a set of tools online that can link to the Countys current financial software. mailto:ald@threeplusone.us mailto:ler@threeplusone.us RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 5 ePayment Services The County wishes to change the way the finance office makes payments. The County knows there are opportunities to create efficiencies and generate revenue through ePayment and p- card/virtual card programs. While banks will be asked to respond to Phase 1 of this RFP based on the Countys current treasury services, the County is also requesting additional information and proposals on any card and ePayment programs or platforms that responding banks have to offer. There will be a dropbox on the rfpPrep portal for proposers to share specific details (program offerings, pricing, rebate opportunities, technology) on their ePayment and virtual card programs during Phase I of the RFP. During Phase II, proposers will be asked to weave these programs into their presentation. Scope of Services Detailed The County currently has one main operating bank relationship. The County typically uses between three to five additional banks for short-term and long-term investments (ICS, MMKs, CDARs, CDs, etc). See graph in Appendix A for the breakdown of deposits at these different banks. The County intends to establish a relationship with a Broker Dealer with one of its financial providers in order to gain access to the full list of allowable investments that can be found in their Investment Policy -- this is not an RFP for those services. Appendix C provides a list of all Treasury Services used over a recent 12-month period - this is also provided through the online rfpPrep web portal. Service description and total volume are provided for a 12-month period. At a minimum, a new contract will mirror all current services. However, the County is open and supportive of alternatives that can help it gain operational efficiencies where legal and practicable. Transaction volumes (in Appendix D) are provided as a guide to volume usage, but it is fully anticipated that usage will change through implementation of more efficient banking services. No attempt is made to project how volume usage will change. Historic & Current Cash Balances Appendix A highlights the Countys historical cash balances between all current operating and investment accounts. It is not to be assumed that the County will continue to hold the current deposit levels across each institution. Pricing should be based upon transaction volume and not upon historic balances. The County is willing to pay fees if greater value is available for those funds that would have been used to offset fees. Pricing points will be determined on the ECR and the overall cost based on historic transaction volume and proposed unit cost. Additional services not currently used by the County will be able to be added to the submission through the online response portal, but these services will not be included in the overall price comparison and may be used subjectively to impact the Service Capability (see Phase 1 Score Weighting on page 8). Current Account Structure Appendix D discusses the Countys current account structure, including a high-level summary of activity associated with each account. The purpose of this depiction is to allow the proposers the opportunity to highlight, through a presentation in Phase 2 (explained in further detail below), advantageous opportunities of differentiation through the current and desired account structure and to propose other services that can provide value to the County. At a minimum, the County will continue with all accounts as listed. However, any potential consolidations through ZBA structures RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 6 will be considered, and are encouraged, as well as other recommendations made in Phase 2 if sufficient value is demonstrated through financial and operational efficiency. Deposits & Investments The purpose of this RFP is not for outside investment firms, but proposers are encouraged to share unique opportunities within their institution to earn additional interest on all monies. However, any services that have an investment purpose (e.g. money market deposit/savings accounts), must comply with all state laws governing the investment and collateralization of public funds. The Countys Investment Policy can be found in Appendix B. All those responding will be required in the Phase 1 process to acknowledge they have read, and will comply with, the Countys Investment Policy. Accounting Software The Countys accounting software is New World ERP by Tyler Technologies. The County is currently implementing new features including Miscellaneous Billing, Tyler Payments, and Tyler Cashiering. Proposers need to confirm capability to integrate services, send & receive securely to and from the accounting software without manual intervention (Straight-Through Processing (STP)), and otherwise facilitate information exchange efficiently and effectively with the accounting software. This can be done via SFTP (Secure File Transfer Protocol), online file transfer or other available methods. Proposers are encouraged to expand on methods the County can use within its online facilities to auto-process tasks the County may currently do manually in an effort to save taxpayer resources. This may include workflow solutions for payment creation and approval processes in addition to visibility of balance and transaction reporting. The Future of Treasury Services and ePayments Overall, the Countys transaction volume is very traditional and antiquated in electronic payments. More municipal entities are moving payments to electronic methods and reducing check volume. Managing the changing payment landscape increases in importance as costs for paper disbursements continue to increase, the population demographics change, and the financial technology advances. Check Disbursements: Checks continue to be a very inefficient way of conducting financial transactions. The main reasons most entities continue to cut and/or choose paper disbursements are related to remittance data that accompanies the check. Financial solutions exist today that provide the remittance data needed as well as the cost savings associated with electronic payments. Recognizing the cultural shift needed for electronic payments, the County may adopt an Electronic Payment Policy stating the plan to phase in electronic payments over a specified period of time (between three and five years). The adoption of such a policy will provide both the County and its vendors with the timeframe needed to make any process adjustments. Moving to electronic payments also strengthens the banking relationship. Banks have developed and gained efficiencies that also make this an attractive service to RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 7 provide. However, the County is aware that banks are no longer the only providers of electronic payment services. Non-financial providers have entered this arena and provide competitive p-card/ghost card/ACH payment services as well. This provides the opportunity for generating revenue through this program rather than increased costs. Phase 1 - Qualification and Pricing Round: Phase 1 responses are subject to three criteria: 1. Overall service capability of the institution as determined by responses to the Yes/No and short-answer online response form provided. a. Appendix E lists all the Yes/No and short-answer questions that must be answered through the online portal. Access to this portal will be granted after the mandatory pre-bid conference. The questions are provided in Appendix E for convenience at this time to allow all institutions the ability to review with internal teams. 2. Two pricing options are available with only one being selected by each respondent: a. Option 1 provides a line item pricing structure based on AFP codes and services being used by the County at their current banking provider. The Countys true volumes are used throughout. This has been done in order to facilitate comparisons between proposals. Option 1 includes proposing an ECR which will be used to calculate the compensating balance to offset all or a portion of fees. b. Option 2 is a flat fee compensating balance proposal. The proposers will be asked to list the compensating balance requirement needed in order for the County to not pay any fees. In addition, the proposers will be asked to list the current interest rate that liquid dollars kept at the bank over and above the compensating balance amount can earn. If the proposer selects this option, the proposed balance will be compared with the compensating balance responses of Option 1. 3. Reputation as provided by references. Three references of current municipal clients must be submitted. It is preferred that one client be new (within the last 12 months) and one long-term (more than 3 years). It is also preferred that at least one reference has experience utilizing the responding banks ePayment program. The County reserves the right to contact any government with which the Proposer provides similar services to if the service provider is known through various associations. Cost Proposal An online response template and an offline download/upload excel template will be provided on the rfpPrep portal. The Option 1 Pricing section of the rfpPrep portal and the pre-bid virtual meeting will review the details of how to use these two Option 1 pricing templates. Basic transaction volume is provided in Appendix D for the period October 2020 - September 2021. When submitting pricing proposals, proposers will be required to include associated AFP codes in order to support comparisons between proposals. As banking services pricing differs from bank to bank, room is provided within the template to add substitute pricing, and additional appropriate line items where applicable or appropriate to list new services/fees. See Option 1 features explanation below. RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 8 Proposers will need to build, through the online pricing portal or provided excel file, the fee structure fully needed to support the services currently being used. The host of fees associated with current full service municipal banking should be included. Proposers that move on to phase 2 will be scored on fee justification which will require them to justify any fees added in phase 2 and explain as to why they were not present in phase 1. Proposers that move on to phase 3 and contract negotiations will be explicitly required to explain and defend any fees charged to the County that were not present in phase 1. Option 1 Features Explanation Proposers will have the opportunity to add new fees that are not listed within the provided service descriptions but will be charged by the bank. Proposers will have the opportunity to include substitute fees in place of any of the listed fees/service descriptions. Proposers will have the opportunity to completely waive fees that the bank does not charge. Any fees that are completely waived will need a description to confirm that the bank does not charge for this service or a closely related service. Proposers are asked to include additional fees and services that may be presented as a result of new recommendations/ideas during phase 2 or phase 3 in the Proposed Services Pricing section. These fees will not be factored into the total calculated cost to the County for phase 1 comparison purposes, but they will be used in phase 2 presentations for proposers new servicing ideas. The purpose of this section is to represent additional services not currently being used by the County that a respondent offers and may propose in phase 2 or phase 3. Option 2 Cost Proposal Proposers that choose Option 2 for pricing will have the opportunity to submit alternative flat fee and/or compensating balance pricing in place of the line item fee responses. The County will evaluate each pricing scenario independently in order to compare their options across different proposers. If the proposer chooses Option 2, they will also need to provide the scenarios under which the required compensating balance will be adjusted as market rates change. Proposers will need to indicate whether a floor and/or ceiling will be set on the size of the compensating balance. Finally, selecting Option 2 is an overt commitment that all services the County may need from the proposer will be included in the value of the balances submitted. Over the life of the contract, future adjustments to balances may only be made based on changes in the rate environment and not changes in banking services. Phase 1 Weighting Total possible points is 100, weighted as follows: Service Capability: 45 points Pricing of Existing Services: 25 points References: 30 points Phase 1 Required Documents All Phase 1 proposers will be required to download, fill out, and submit the Certification of Compliance via the rfpprep.us portal. Phase 1 proposers will also be required to acknowledge that they have read the Insurance Requirements Form (available on the rfpPrep portal) and https://www.rfpprep.us/ RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 9 will satisfy those requirements if they win the RFP. The required Certification of Compliance and the Insurance Requirements Form can be found on pages 12-14. In addition to the Certification of Compliance document that the County is requiring to be submitted, the proposers will have the opportunity to upload their own necessary disclosures and required paperwork onto the rfpprep.us portal. Phase 2 - Presentation Phase The top scoring banking institutions in Phase 1 will be eligible for Phase 2 presentations, if determined by the County as appropriate. Phase 2 will begin with additional information, if any, being provided to proposers. Subsequently, proposers will have sufficient time to submit questions and prepare a presentation/demonstration. It is expected that each prospective banking institution will use their professional knowledge, experience, and data herein to provide a proactive and creative presentation that meets the objectives outlined. Simply responding with a presentation to duplicate the services as the County currently stands may not result in a winning proposal. Creativity is encouraged; meeting the needs of the County while defining a well-rounded relationship within the changing landscape of public banking is paramount. If a responding institution wants to propose services it deems to be superior or more appropriate than those requested, the responding institution should make the case, provide appropriate pricing, and an example of how it would provide a net benefit. All responding institutions should not submit the typical lengthy proposal. Submitted documents, including presentation slides, are limited to a maximum of 20 total pages. We encourage this round of presentations, taking place on February 15 & 16, 2022, to be creative. It is preferred that institutions prepare an overall presentation addressing the needs as outlined. All Phase 2 Proposers shall provide with their presentation a sample of proposed agreements for review by the County. Proposers in Phase 2 will be given a maximum of a 60-minute time slot to make their presentation. Areas required are as follows: Why you?: What makes your bank the best partner for the County? Possible discussion points include the following, but ultimately you may decide how to fill each topic area. o Number of public banking clients Dedication to this market space Research & development Clear differentiators from competitors Innovative solutions that correspond to the objectives outlined Proposed account structure and treasury services: (subject to the limitations outlined/provided) Your recommendations must include, but are not limited to: Why are you recommending the proposed account structure? https://www.rfpprep.us/ RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 10 How is the bank incorporating innovation? Local branch availability or how to manage the relationship if you do not have local branches. What is the benefit/value of your proposed account structure/treasury services? Fee justification of cost proposal provided in Phase 1 and adapted to your Phase 2 proposal. Why these fees? If not explicit, what value does the fee provide to the County? Be prepared to answer specific questions regarding fees. Discuss potential caps or limits your institution may be willing to give on fee increases at the end of the initial contract. How the bank has managed and plans to manage the transition experience. Customer Service model: o Accountability and Contact Frequency Account review Service method Demonstration of all online/web-based resources being offered (or provide a video overview of each before interview) Banking portal Payments Portal All others Introduction to key personnel. The County requires one relationship manager be available for the duration of the contract as the point of contact regarding any and all services provided by the proposer. Open Q&A Phase 2 Weighting Total possible points are 100, weighted as follows: Presentation with Proposed Account Structure and Treasury Services: 40 points Customer service model proposal: 40 points Fee justification: 20 points Selection Criteria The successful Proposer will be selected based on the best overall value. Price will be a factor in this decision, but will not be the sole, nor necessarily the most important factor. Experience, customer service, corrective action processes, efficient account structure, treasury services, fraud protection, technology, and maximizing the value of every dollar will all be factors considered. RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 11 Phase 3 - Preliminary Finalist Phase: Phase 3 preliminary finalists will be selected based on the overall cumulative score of Phase 1, Phase 2, and the Countys legal review of the Proposers submitted Agreements. Phase 3 preliminary finalists will be notified and will be subject to final legal and Agreement negotiations as the County sees fit. Schedule of Events The following schedule details key dates and times related to this RFP. The County reserves the right to revise this schedule as needed to ensure process integrity. Date Time Description December N/A RFP issued. December 17 4:00 P.M. Email RFP Contact Person to express interest in responding. December 21 2:00 P.M. Mandatory Pre-bid web conference call. January 7 4:00 P.M. Phase 1 question deadline for proposers. Answers provided continually through 4:00 P.M on January 7. * January 14 4:00 P.M. Phase 1 responses submitted through the online portal. January 26 4:00 P.M. Phase 2 finalists will be notified. January 28 N/A Additional information, if any, provided to Phase 2 Proposers. January 28 4:00 P.M. Phase 2 Proposers must have interviews scheduled or will be disqualified. * February 4 4:00 P.M. *Proposers submit questions, if any, for Phase 2. Answers provided continually through the end of day February 4. * February 15 & 16 TBD Virtual or onsite presentations/interviews conducted. February 25 TBD Preliminary finalist notified. February N/A Final negotiations, if applicable, and agreement completion. March TBD All Proposers notified of results. March N/A Transition begins, if necessary, and completed within 270 days. *All questions submitted will be answered with questions/responses provided to all Proposers. Answers may be issued after this date if more time is needed by the County to verify the answers. ** Phase 2 interviews can be scheduled starting on January 26. The mandatory pre-proposal web conference will be held on Tuesday, December 21 at 2:00 P.M. EST. The pre-proposal web conference will be held at: meet.google.com/xje-isfb-fge The pre-proposal web conference web address is subject to change. https://meet.google.com/xje-isfb-fge RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 12 County of Rensselaer - Insurance Requirements INDEPENDENT CONTRACTORS REQUIRED COVERAGE: The amounts of insurance coverage to be provided shall not be less than the limits shown herein. Duplicate copies of Insurance Certificates shall be furnished along with insurance company statements that contractor has paid insurance premiums. All insurance carriers must have a best rating of an A or better. A Workmen's Compensation Section A - Employee Benefits Statutory Section B - Employers Liability Statutory Now York State Disability Benefits Statutory Commercial Gener | Liability including products/completed operations: $1,000,000 General Aggregate $1,000,000 Products-Completed Operations Aggregate $1,000,000 Personal Injury and Advertising Liablity $1,000,000 Each Occurrence $ 500,000 Fire Damage (any one fire) $ 10,000 Medical Expense (any one person) The Commercial Comprehensive General Liability policy shall include coverage for acts of all Contractors, sub- contractors and sub-contractors for all Iabilty assumed under this contract and where applicable, coverage for Use of explosives, collapse of buildings and damage to underground properties (X, C & U Coverage), and coverage required by any Law or Municipal Ordinance or Regulations. D. Comprehensive Automobile Liability, including contractual hired car and non-owned vehiclo coverage: $1,000,000 Combined Single Limit - Bodily Injury and Property Damage E. Owner's and Contractors Protective Policy: The Contractor shall take out and maintain during the life of this Contract such contingent property damage and public liablity insurance polices, in described amounts as will protect the County of Rensselaer, its officers and agents as follows: 1) Gostiicate Holder County of Rensselaer Attn: Rensselaer County Attorney Nad Pattison Rensselaer County Government Center 1600 Seventh Avenue Troy, New York 12180, 11) Limit of Liabity $1,000,000 Each Occurrence / General Aggregate The original Owners Protective Policy shall be furnished to the County of Rensselaer. RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 13 County of Rensselaer Insurance Requirements F, Umbrolta Liability Limit of Liabitty rninimum timits) $2,000,000 each occurrence / $2,000,000 aggregate * (where applicable) excess of Commercial General Liability, Commercial Automobile and Workers Compensation Employers Liability coverages. G. Other Requirements The Insurance Certificate shall contain the following: A 8) ) >) A description ofthe work and contract authorization number. Reference to any special endorsements restricting standard policy coverage. Asstatement that the insurance company will provide 60 days written notice to the County of Rensselaer prior to any modifications or cancellations of any such policy by registered mail or retum receipt. County of Rensselaer and/or any of their employees, officers or agents are named as additional insured with respects to the referenced contract. {All required insurance must be in effect and continued so during the life of the Contract, at the Contractor's, expense, and is subject to the approval of Counsel as to adequacy, form and correctness. No approval to begin work shall be given to the Contractor until submission and approval of proper insurance certficates and original Owner's and Contractors Protective Palcy. For additional questions regarding insurance requirements please contact the Rensselaer County Attorney's Office at (518) 270-2950. With regard to Aggregate RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 14 LOCAL LAW #2, 1982 CERTIFICATION of COMPLIANCE Local Law No.2 forthe Year 1992, adopted by the County of Rensselaer and effective as of September 1, 1992, provided for certain changes to th County's Code of Ethics, adopted orginally in 1989. One of the changes provided for by the 1992 logislation affects those persons and enites wino wish to do business with the County of Rensselaer and Hudson Valley Community Caloge. In substance, the Cade of Ethics, as amended, provides as follows: No elocted public official or family member here, nor any partnership [or] unincorporated association in which he or she fe'a member or employee or in which he of she has a proprietary Interest, nor any business or professional corporation of which he o she isan afer, director or legally or beneficially owns or controls more than five percent of the outstanding stock, shal have business dealings wih Rensselaer County or ary of is boards, agencies, commissions, autores, disvcis and Hudson Valley Community Colege. For purposes of this subdivision, business dealings shall include contacts with Rensselaer Counly, ts boards, agencies, commissions, authorves, disits and Hudson Valley Communty College, gained through competiive bidding" For the purposes of the above section, the term family member means "..a spouse, child, step-06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 15 Appendix A Note: The accounts out for bid are shown in blue at the top of this graph. This is the Countys main operating relationship. Balances by Bank Balances by Bank 200M 150M 100M Balance SOM 7/1/2021 8/1/2021 9/1/2021 10/1/2021 om 10/1/2020 11/1/2020 12/1/2020 1/1/2021 2/1/2021 3/1/2021 4/1/2021 5/1/2021 6/1/2021 Date Balances - All Accounts Maximum - 203,027,379 Average - 164,245,487 10/1/2020 11/1/2020 12/1/2020 1/1/2021 2/1/2021 3/1/2021 4/1/2021 S/1/2021_6/1/20217/1/2021-8/1/2021 9/1/2021 10/1/2021 Date RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 16 Appendix B Rensselaer County Investment Policy I. SCOPE This investment policy applies to all monies and other financial resources available for investment on its own behalf or on behalf of any other entity or individual. II. OBJECTIVES The primary objectives of the local government's investment activities are, in priority order, to conform with all applicable federal, state and other legal requirements to adequately safeguard principal to provide sufficient liquidity to meet all operating requirements, and to obtain a reasonable rate of return within the parameters of prudent risk management III. DELEGATION OF AUTHORlTY The governing board's responsibility for administration of the investment program is delegated to the Chief Fiscal Officer who shall establish written procedures for the operation of the investment program that is consistent with the established investment guidelines. Such procedures shall include an adequate internal control structure which will provide a satisfactory level of accountability based upon a data base of records incorporating description and amounts of investments, transaction dates, and other relevant information while regulating the activities of subordinate employees. IV. PRUDENCE All participants in the investment process shall seek to act responsibly as custodians of the public trust and shall avoid any transaction that might impair public confidence in the County of Rensselaer to govern effectively. Investments shall be made with judgment and care, under circumstances then prevailing, which persons of prudence, discretion and intelligence exercise in the RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 17 management of their own affairs, not for speculation, but for investment, while considering the safety of the principal and the probable income to be derived. All participants involved in the investment process shall refrain from personal business activity that could conflict with proper execution of the investment program, or which could impair their ability to make impartial investment decisions. V. DIVERSIFICATION It is the policy of the County of Rensselaer to diversify its deposits and investments by financial institution, by investment instrument and by maturity scheduling. VI. INTERNAL CONTROLS It is the policy of the County of Rensselaer for all monies collected by any officer or employee of the government to transfer those funds to the Chief Fiscal Officer immediately, unless impractical by virtue of amount, stewardship requirements or other procedure established for the efficient disposition of the funds. The official having custody of the funds is responsible for establishing and maintaining an internal control structure which provide; reasonable, but not absolute, assurance that deposits and investments are safeguarded against loss from unauthorized use or disposition; that transactions are executed in accordance with management's authorization and recorded properly; and are managed in compliance with applicable laws and regulations. This internal control structure shall include, but in no way be limited to, the reconciliation of all bank statements received for each account with the internal records - maintained by the department having custody of the account. Such reconciliation will be performed and documented by the employee assigned to this duty by the department head. The review of any such reconciliation will be independently conducted and documented by an employee within the department other than that employee who performs the initial reconciliation. Any questions or discrepancies which arise during such independent review shall be clearly documented along with the resolution of the matter. Should no resolution be attainable, the head of the department shall be notified immediately and conduct further investigation into the matter. VII. DESIGNATION OF DEPOSITORIES The banks and trust companies authorized for the deposit of monies up to the following maximum amounts of $55,000,000 each are: RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 18 Depository Name TD Bank JP Morgan Chase Citizens Bank NBT Bank Bank of America Key Bank, NA M&T Pioneer Commercial Bank Saratoga National Capital Bank VIII. COLLATERALIZING OF DEPOSITS In accordance with the provisions of General Municipal Law, Section 10, all deposits of the County of Rensselaer, investments in certificates of deposit and special time deposits, in excess of the amount insured under the provisions of the Federal Deposit Insurance Act shall be secured as allowed by law: 1. By a pledge of "eligible securities", with an aggregate "market value", as provided by General Municipal Law, Section 10, equal to the aggregate amount of deposits from the categories designated in Appendix A to the policy. 2. By an eligible "irrevocable letter of credit" issued by a qualified bank other than the bank with the deposits in favor of the government for a term not to exceed 90 days with an aggregate value equal to 140% of the aggregate amount of deposits and the agreed upon interest, if any. A qualified bank is one whose commercial paper and other unsecured short-term debt obligations are rated in one of the three highest rating categories by at least one nationally recognized statistical rating organization or by a bank that is in compliance with applicable federal minimum risk- based capital requirements. 3. By an eligible surety bond payable to the government for an amount at least equal to 100% of the aggregate amount of deposits and the agreed upon interest, if any, executed by an insurance company authorized to do business in New York State, whose claims - paying ability is rated in the RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 19 highest rating category by at least two nationally recognized statistical rating organizations. It will be the responsibility of all County officers having custody of funds to assure that the funds are sufficiently secured and collateralized. Additionally, the security on the funds must be exclusive of FDIC insurance unless a written waiver stating that the FDIC insurance is not being applied to general purpose County funds, is received from the Chief Fiscal Officer. IX. SAFEKEEPING AND COLLATERALIZATION Eligible securities used for collateralizing deposits shall be held by the Depository or a third party bank or trust company subject to security and custodial agreements. Rensselaer County prefers that collateral be held by a Third party and will give preference to such collateral arrangements when analyzing banking proposals. The security agreement shall provide that eligible securities are being pledged to secure local government deposits together with agreed upon interest, if any, and any costs or expenses arising out of the collection of such deposits upon default. It shall also provide the conditions under which the securities may be sold, presented for payment, substituted or released and the events which will enable the County to exercise its rights against the pledged securities. In the event that the securities are not registered or inscribed in the name of the County, such securities shall be delivered in a form suitable for transfer or with an assignment in blank to the County of Rensselaer or its custodial bank The custodial agreement shall provide that securities held by the bank or trust company, or agent of and custodian for, the County will be kept separate and apart from the general assets of the custodial bank or trust company and will not, in any circumstances, be commingled with or become part of the backing for any other deposit or other liabilities. The agreement should also describe that the custodian shall confirm the receipt, substitution or release of the securities. The agreement shall provide for the frequency or revaluation of eligible securities and for the substitution of securities when a change in the rating of a security may cause ineligibility. Such agreement shall include all provisions necessary to provide the local government a perfected interest in the securities. Eligible securities for collateralization shall be those listed in Appendix A, hereto, and discounted as to their market value in accordance which the standards set forth in General Municipal Law (Section 10) RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 20 x. PERMITTED INVESTMENTS As authorized by General Municipal Law, Section 11, the County of Rensselaer authorizes the Chief Fiscal Officer to invest monies not required for immediate expenditure for terms not to exceed its projected cash flow needs in the following types of investments: Special time deposit accounts; Certificates of deposit; Obligations of the United States of America; Obligations guaranteed by agencies of the United States of America where the payment of principal and interest are guaranteed by the United States of America; Obligations of the State of New York; Obligations issued pursuant to LFL Section 24.00 or 25.00 (with approval of the State Comptroller) by any municipality, school district or district corporation other than the County of Rensselaer; Obligations of this local government, but only with any monies in a reserve fund established pursuant to GML, Section 6-c, 6-d, 6- e, 6-g, 6-h, 6-j, 6-k, 6-1, 6-m, or 6-n. Officials other than the Chief Fiscal Officer will be limited to investments in time deposit accounts and certificates of deposit. All investment obligations shall be payable or redeemable at the option of the County of Rensselaer within such times as the proceeds will be needed to meet expenditures for purposes for which the monies were provided and, in the case of obligations purchased with the proceeds of bonds or notes, shall be payable or redeemable at the option of the County of Rensselaer within two years of the date of purchase. XI. AUTHORIZED FINANCIAL INSTITUTIONS AND DEALERS The Chief Fiscal Officer shall maintain a list of financial institutions and dealers approved for investment purposes and establish appropriate limits to the amount of investments which can be made with each financial institution or dealer. All financial institutions with which the local government conducts business must be credit worthy. RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 21 Banks shall provide their most recent Consolidated Report of Condition (Call Report) at the request of the Chief Fiscal Officer. Security dealers not affiliated with a bank shall be required to be classified as reporting dealers affiliated with the New York Federal Reserve Bank, as primary dealers. The Chief Fiscal Officer is responsible for evaluating the financial position and maintaining a listing of proposed depositories, trading partners and custodians. Such listing shall be evaluated at least annually. XII. PURCHASE OF INVESTMENTS The Chief Fiscal Officer is authorized to contract for the purchase of investments: 1. Directly, including through a repurchase agreement, from an authorized trading partner. 2. By participation in a cooperative investment program with another authorized governmental entity pursuant to Article 5G of the General Municipal Law where such program meets all the requirements set forth in the Office of the State Comptroller Opinion No. 88-46, and the specific program has been authorized by the governing board. 3. By utilizing an ongoing investment program with an authorized trading partner pursuant to a contract authorized by the governing board. All purchased obligations, unless registered or inscribed in the name of the local government, shall be purchased through, delivered to and held in the custody of a bank or trust company. Such obligations shall be purchased, sold or presented for redemption or payment by such bank or trust company only in accordance with prior written authorization from the Chief Fiscal Officer or his designated agent. All such transactions shall be confirmed in writing to the County of Rensselaer by the bank or trust company. Any obligation held in the custody of a bank or trust company shall be held pursuant to a written custodial agreement as described in General Municipal Law, Section 10. The custodial agreement shall provide that securities held by the bank or trust company, as agent of and custodian for, the local government, will be kept separate and apart from the general assets of the custodial bank or trust company and will not, in any circumstances, be commingled with or become part of the banking for any other deposit or other liabilities. The agreement shall describe how the custodian shall confirm the receipt and release of the securities. Such agreement shall include all RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 22 provisions necessary to provide the local government a perfected interest in the securities. XIII. REPURCHASE AGREEMENTS Repurchase agreements authorized are subject to the following restrictions: All repurchase agreements entered into must be subject to a Master Repurchase Agreement. Trading partners are limited to banks or trust companies authorized to do business in New York State and primary reporting dealers. Obligations shall be limited to obligations of the United States of America and obligations guaranteed by agencies of the United States of America. No substitution of securities will be allowed. The custodian shall be a party other than the trading partner. APPENDIX A Schedule of Eligible Securities Yes (i) Obligations issued, or fully insured or guaranteed as to the payment of principal and interest, by the United States of America, an agency thereof or a United States government sponsored corporation. No (ii) Obligations issued or fully guaranteed by the International Bank for Reconstruction and Development, the Inter-American Development Bank, the Asian Development Bank, and the African Development Bank. No (iii) Obligations partially insured or guaranteed by any agency of the United States of America, at a proportion of the Market Value of the obligation that represents the amount of the insurance or guaranty. Yes (iv) Obligations issued or fully insured or guaranteed by the State of New York, obligations issued by a municipal corporation, school district or district corporation of such State or obligations of any public benefit corporation which under a specific State statute may be accepted as security for deposit of public monies. No (v) Obligations issued by states (other than the State of New York) of the United States rated In one of the three highest rating categories by at least one nationally recognized statistical rating organization RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 23 No (vi) Obligations of Puerto Rico rated in one of the three highest rating categories by at least one nationally recognized statistical rating organization No (vii) Obligations of counties, cities and other governmental entities of a state other than the State of New York having the power to levy taxes that are backed by the full faith and credit of such governmental entity and rated in one of the three highest rating categories by at least one nationally recognized statistical rating organization. No (viii) Obligations of domestic corporations rated in one of the two highest rating categories by at least one nationally recognized statistical rating organization. No (ix) Any mortgage related securities, as defined in the Securities Exchange Act of 1934, as amended, which may be purchased by banks under the limitation established by bank regulatory agencies. No (x) Commercial paper and bankers' acceptances issued by a bank, other than the Bank, rated in the highest short term category by at least one nationally recognized statistical rating organization and having maturities of not longer than 60 days from the date they are pledged. No (xi) Zero coupon obligations of the United States government marketed as "Treasury strips" RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 24 Appendix C Bank Category Description Total Volume account reconciliation arp full ppay input per item 17,955 account reconciliation payee positive pay issue match 17,108 account reconciliation arp void cancel items 795 account reconciliation arp full ppay maint ppr supp 30 account reconciliation payee positive pay maint 24 account reconciliation arp ppay maint no recon 12 account reconciliation arp recon output file 12 account reconciliation arp full ppay maint paper rpt 6 account reconciliation arp positive pay return other 1 balance related services deposit bank assessment 188,437 commercial deps cash vault curr coin dep 100 bkg ctr 4,231 commercial deps cash vault curr coin dep 100 qbd nd 169 controlled disbursements controlled disb cks paid trun 8,947 controlled disbursements cont disb funding credits 251 controlled disbursements controlled disb maintenance 12 depository services image deposited items rdso 12,638 depository services general disb cks paid trunc 7,570 depository services checks deposited bkg center 3,870 depository services credits posted electronic 2,446 depository services check deposit icl or rdso 2,345 depository services general disb cks paid image 1,320 depository services debits posted electronic 502 depository services banking center deposit 431 depository services cashpro account transfer 351 depository services deposit account stmts over1 219 depository services account maintenance 197 depository services stop pay automated>12 months 91 depository services returns email images 52 depository services returns erin 52 depository services returns dup advice 35 depository services returns reclear 28 depository services stop pay automated=12 months 27 RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 25 depository services rdi discretionary data fields 24 depository services returns chargeback 24 depository services returns additional advice 12 depository services returns duplicate advice 12 depository services returns reclear services 12 depository services deposit correction non cash 10 depository services interest bearing account maint 10 depository services qbd night drop deposit 7 depository services deposit correction rds 3 depository services atm deposits 2 depository services cks dep un encoded items 2 depository services ledger overdraft per day 1 edi services global advice ar elec per pmt 243 edi services global advice ar elec maint 12 general ach services ach off us credits 42,676 general ach services ach credit received item 2,099 general ach services ach on us credits 1,896 general ach services ach optional rpts electronic 380 general ach services ach debit received item 371 general ach services ach blocks auth instructions 324 general ach services ach blocks auth maintenance 168 general ach services ach reports electronic 142 general ach services ach input file 103 general ach services ach originated addenda 94 general ach services ach lv off us items 69 general ach services ach lv on us items 47 general ach services ach notif of change noc 33 general ach services ach standard rpts electronic 29 general ach services ach return item 20 general ach services ach lv monthly maintenance 12 general ach services ach monthly maintenance 12 general ach services ach delete reversal 6 image image archive 7 years 17,385 image cashpro online image retrieval 350 image cashpro image subscription 36 information services cashpro online pdr item 46,546 information services cashpro online cdr item 7,321 information services cashpro online pdr account 132 RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 26 information services cashpro arp reports 21 information services cashpro online cdr account 12 information services cashpro reporting subscription 12 information services cashpro online subscription 9 information services cpo arp online reports 7 information services cpo online subscription 3 information services cashpro security access 2 miscellaneous nonrelationship cust ck cashed 244 miscellaneous photocopy manual 15 remote deposit services remote deposit item storage 600,292 remote deposit services remote deposit ck image proc 12,638 remote deposit services remote deposit account maint 12 wire transfer cashpro gp cust mnt tmplt strg 870 wire transfer elec wire out domestic 314 wire transfer cashpro gp accts entitled 120 wire transfer book credit 44 wire transfer elec wire out book db 19 wire transfer incoming domestic wire 14 wire transfer ph or stnd order temp store 12 wire transfer wire monthly subscription 12 RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 27 Appendix D DA Fed Forfeiture Average Balance: $15,830.16 Minimum Balance: $11,518.11 Maximum Balance: $18,928.11 Standard Deviation of Balances: $2,592.91 Interest Bearing: Yes Transaction Breakdown: Count: Raw Total ($): Average Amount ($): NegativeCheck 1 -$7,410.00 -$7,410.00 DA State Forfeiture Average Balance: $28,720.13 Minimum Balance: $5,328.94 Maximum Balance: $63,742.75 Standard Deviation of Balances: $13,414.85 Total Interest($) Earned: $38.72 Interest Bearing: Yes Transaction Breakdown: Count: Raw Total ($): Average Amount ($): PositiveElectronic - NonACH/Wires 8 $51,234.19 $6,404.27 Negative Check 24 -$58,836.67 -$2,451.53 Controlled Disbursement Average Balance: $0.00 Minimum Balance: $0.00 Maximum Balance: $0.00 Standard Deviation of Balances: $0.00 Interest Bearing: No RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 28 Transaction Breakdown: Count: Raw Total ($): Average Amount ($): Positive Return 1 $100.00 $100.00 Positive Transfer 23 $7,315,622.21 $318,070.53 Positive Electronic- Non ACH/Wires 230 $117,585,481. 48 $511,241.22 Negative ACH 1 -$453.57 -$453.57 Negative Check 2 -$400.00 -$200.00 NegativeAdjustment 1 -$100.00 -$100.00 NegativeElectronic - NonACH/Wires 251 - $124,900,250. 12 -$497,610.56 Asset Forfeiture Average Balance: $15,520.77 Minimum Balance: $0.00 Maximum Balance: $72,776.91 Standard Deviation of Balances: $25,659.88 Interest Bearing: No KeywordName: Count: Raw Total ($): Average Amount ($): Positive ACH 1 $1,034.47 $1,034.47 Positive Return 2 $52.85 $26.43 Positive Wire 1 $1,575.00 $1,575.00 NegativeBankingRelated Fee 2 -$52.85 -$26.43 NegativeTransfer 3 -$13,355.00 -$4,451.67 Credit Card Processing RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 29 Average Balance: $2,130.88 Minimum Balance: -$109.64 Maximum Balance: $45,995.05 Standard Deviation of Balances: $4,012.88 Interest Bearing: No KeywordName: Count: Raw Total ($): Average Amount ($): PositiveACH 231 $339,499.89 $1,469.70 PositiveTransfer 2 $40.00 $20.00 NegativeACH 13 -$1,166.59 -$89.74 NegativeTransfer 228 -$338,349.34 -$1,483.99 Mortgage Tax Average Balance: $1,301,306.34 Minimum Balance: $30.21 Maximum Balance: $3,320,975.19 Standard Deviation of Balances: $687,436.11 Interest Bearing: Yes Transaction Breakdown: Count: Raw Total ($): Average Amount ($): Positive Transfer 1 $464,517.15 $464,517.15 PositiveElectronic - NonACH/Wires 11 $4,465,565.65 $405,960.51 Negative Return 1 -$0.50 -$0.50 Negative Transfer 2 -$4,228,887.31 -$2,114,443.66 Self Insurance Average Balance: $40,601.13 Minimum Balance: $0.00 Maximum Balance: $283,936.22 RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 30 Standard Deviation of Balances: $91,258.73 Interest Bearing: Yes State Small Cities Average Balance: $4,634.69 Minimum Balance: $49.06 Maximum Balance: $212,473.38 Standard Deviation of Balances: $19,673.40 Interest Bearing: No Transaction Breakdown: Count: Raw Total ($): Average Amount ($): PositiveElectronic - NonACH/Wires 4 $127,890.79 $31,972.70 Negative Transfer 5 -$127,890.79 -$25,578.16 Money Market 2 Average Balance: $969,291.70 Minimum Balance: $9,570.12 Maximum Balance: $2,332,034.88 Standard Deviation of Balances: $904,039.57 Interest Bearing: No Transaction Breakdown: Count: Raw Total ($): Average Amount ($): Positive Wire 2 $11,526.20 $5,763.10 PositiveElectronic - NonACH/Wires 39 $118,174.02 $3,030.10 S.A.F.E Account RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 31 Average Balance: $2,400.00 Minimum Balance: $2,400.00 Maximum Balance: $2,400.00 Standard Deviation of Balances: $0.00 Interest Bearing: No DA Misdemeanor Forfeiture Average Balance: $17,068.06 Minimum Balance: $4,617.93 Maximum Balance: $78,270.53 Standard Deviation of Balances: $13,967.15 Interest Bearing: Yes Transaction Breakdown: Count: Raw Total ($): Average Amount ($): PositiveElectronic - NonACH/Wires 5 $14,805.14 $2,961.03 Negative Check 57 -$14,225.78 -$249.58 Probation Special Average Balance: $117,052.35 Minimum Balance: $90,539.58 Maximum Balance: $156,280.47 Standard Deviation of Balances: $11,580.75 Interest Bearing: No Transaction Breakdown: Count: Raw Total ($): Average Amount ($): PositiveInvestment 34 $7,297.00 $214.62 PositiveElectronic - NonACH/Wires 39 $134,237.29 $3,441.98 Negative Check 374 -$142,332.01 -$380.57 Negative Return 1 -$270.00 -$270.00 RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 32 HUD Average Balance: $7,554.77 Minimum Balance: $0.00 Maximum Balance: $112,584.27 Standard Deviation of Balances: $13,449.78 Interest Bearing: Yes Transaction Breakdown: Count: Raw Total ($): Average Amount ($): Positive Transfer 9 $55,179.49 $6,131.05 PositiveElectronic - NonACH/Wires 8 $14,737.70 $1,842.21 Negative Return 1 -$0.01 -$0.01 Negative Wire 5 -$65,156.00 -$13,031.20 General Fund Average Balance: $21,935,760.27 Minimum Balance: $840,233.77 Maximum Balance: $56,229,849.65 Standard Deviation of Balances: $10,809,665.33 Interest Bearing: Yes Transaction Breakdown: Count: Raw Total ($): Average Amount ($): Positive ACH 1513 $115,567,502. 52 $76,383.02 Positive BankingRelated Fee 13 $1,330.00 $102.31 Positive Interest 12 $5,237.94 $436.50 Positive Return 4 $18.57 $4.64 Positive Transfer 238 $4,708,482.44 $19,783.54 Positive Wire 209 $105,496,557. 84 $504,768.22 RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 33 PositiveInvestment 21 $6,478.00 $308.48 Positive Electronic- Non ACH/Wires 2709 $222,415,886. 42 $82,102.58 Negative ACH 12 -$217,190.22 -$18,099.19 Negative BankingRelated Fee 4 -$42,673.37 -$10,668.34 Negative Return 30 -$84,335.11 -$2,811.17 Negative Transfer 118 - $81,195,046.0 3 -$688,093.61 Negative Wire 331 - $237,136,966. 53 -$716,425.88 NegativeElectronic - NonACH/Wires 365 - $127,695,797. 09 -$349,851.50 Payroll Ded Average Balance: $214,761.40 Minimum Balance: -$2,397.35 Maximum Balance: $1,202,589.24 Standard Deviation of Balances: $119,436.78 Interest Bearing: Yes Transaction Breakdown: Count: Raw Total ($): Average Amount ($): Positive Transfer 53 $26,545,657.3 2 $500,861.46 Positive Electronic- Non ACH/Wires 4 $837.74 $209.44 Negative Check 874 -$3,402,885.35 -$3,893.46 Negative Wire 54 -$3,497,324.10 -$64,765.26 NegativeElectronic - NonACH/Wires 70 - $19,660,309.3 5 -$280,861.56 RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 34 Payroll Average Balance: $180,885.86 Minimum Balance: $14,952.06 Maximum Balance: $1,782,948.14 Standard Deviation of Balances: $361,779.85 Interest Bearing: Yes Transaction Breakdown: Count: Raw Total ($): Average Amount ($): Positive Return 11 $8,746.94 $795.18 Positive Transfer 53 $54,129,652.0 7 $1,021,314.19 Negative Check 10 -$9,635.63 -$963.56 Negative Return 1 -$986.23 -$986.23 NegativeAdjustment 1 -$0.03 -$0.03 NegativeElectronic - NonACH/Wires 350 - $54,140,450.7 1 -$154,687.00 Dept. of Aging Average Balance: $7,412.74 Minimum Balance: $909.00 Maximum Balance: $22,208.31 Standard Deviation of Balances: $3,682.38 Interest Bearing: Yes Transaction Breakdown: Count: Raw Total ($): Average Amount ($): PositiveElectronic - NonACH/Wires 40 $35,541.50 $888.54 Negative Check 15 -$49,562.81 -$3,304.19 Negative Return 2 -$1,204.00 -$602.00 RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 35 Appendix E Name Question ACCOUNT MAINTENANCE SERVICE Do you offer non-Interest bearing checking? ACCOUNT MAINTENANCE SERVICE Do you provide interest bearing checking? ACCOUNT MAINTENANCE SERVICE Do you provide sweep accounts/services? ACCOUNT MAINTENANCE SERVICE Do you provide analysis billing statements? ACCOUNT MAINTENANCE SERVICE Do you provide online audit confirmations? ACCOUNT MAINTENANCE SERVICE Do you provide Collateral as per State Law? ACCOUNT RECONCILIATION Do you provide partial account reconciliation? ACCOUNT RECONCILIATION Do you provide full account reconciliation? ACCOUNT RECONCILIATION Do you provide online reporting? ACCOUNT RECONCILIATION Can you provide Report/Files customized to meet the requirements for New World ERP by Tyler Technologies? ACCOUNTING SOFTWARE INTEGRATION Do you provide implementation/project management? ACCOUNTING SOFTWARE INTEGRATION Do you provide straight through processing? ACCOUNTING SOFTWARE INTEGRATION Do you have APIs that allow for more real-time integration with ERP systems? ACH SERVICES Do you provide access to remittance information reporting (Confirmations/Other)? ACH SERVICES Please describe reporting (Confirmations/Other) ACH SERVICES Do you provide EDI reporting? ACH SERVICES Do you provide role based user assignments? ACH SERVICES Please provide Banks methodology for determining debit and credit exposure limits. Propose exposure limits for the County. RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 36 ACH SERVICES Do you provide origination? ACH SERVICES Do you provide addenda record origination? ACH SERVICES Do you provide fed clearing? ACH SERVICES Do you provide fed clearing addenda? ACH SERVICES Do you provide direct transmission batch file processing? ACH SERVICES Do you provide FTP via internet batch file processing? ACH SERVICES Do you have other batch file processing? ACH SERVICES Do you provide limitations on ACH format (e.g. PPD, CTX, etc)? ACH SERVICES List any ACH which are not supported ACH SERVICES Do you provide exception processing? ACH SERVICES Do you provide batch reversals/deletes? ACH SERVICES Do you provide individual reversals/deletes? ACH SERVICES Funding Requirements (Bulk) Reversals/Deletes? ACH SERVICES Do you provide return notification - online? ACH SERVICES Do you provide return notification - E-Mail? ACH SERVICES Do you provide transaction summary reporting (Confirmations/Other)? ACH SERVICES Do you provide online reporting (Confirmations/Other)? ACH SERVICES Do you provide NOC - online Reporting (Confirmations/Other)? ACH SERVICES Do you provide NOC - Email Reporting (Confirmations/Other)? ACH SERVICES If you have other forms of batch file processing, please specify: ACH SERVICES Please describe your Authorization/Approval process: ACH SERVICES Do you provide NOC - e-mail Reporting (Confirmations/Other)? ACH SERVICES If yes, please describe reporting (Confirmations/Other): ACH SERVICES Please provide your banks methodology for determining debit and credit exposure limits. Propose exposure limits for the County. ACH SERVICES Do you provide role-based user assignments? ACH SERVICES Please provide Banks methodology for determining debit and credit exposure limits. Propose exposure limits for the County. ADDITIONAL INFORMATION Are any services outsourced to a third party? ADDITIONAL INFORMATION I have read and agree to comply with the County's Investment Policy Statement. ADDITIONAL INFORMATION Are you aware of any planned merger or acquisition for your company? RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 37 ADDITIONAL INFORMATION If yes, please explain: ADDITIONAL INFORMATION Does your firm have any offices that reside within the County? ADDITIONAL INFORMATION I understand and will abide by all state laws governing the investment of public funds. ADDITIONAL INFORMATION I have read and agree to abide by the County's General Information & Instructions as stated in the RFP document. ADDITIONAL INFORMATION Please upload your Certification of Compliance Document. ADDITIONAL INFORMATION Please upload your Insurance Requirements Form. BRANCH LOCATIONS Do you have a branch located in the County? (preferred but not required) BRANCH LOCATIONS If yes, do branch locations have a night deposit box? BRANCH LOCATIONS How far (in miles) is your nearest branch to 1600 7th Ave., Troy, NY 12180? CASH DEPOSIT If you provide other branch change orders categories, please specify: CASH DEPOSIT Do you provide cash deposit at branch within the County? CASH DEPOSIT Do you provide cash deposit in night drop? CASH DEPOSIT Do you provide cash deposit in vault? CASH DEPOSIT Do you provide cash deposit via courier? CASH DEPOSIT Do you provide branch change orders currency strap? CASH DEPOSIT Do you provide branch change orders coin roll? CASH DEPOSIT Do you provide other branch change orders category? CASH DEPOSIT Do you provide cash recycler (onsite check/cash deposit capability)? CHECK DEPOSIT Do you provide check deposit at a local branch within the County? CHECK DEPOSIT Do you provide multiple remote deposit scanners? (If yes, please provide appropriate pricing in the Other Services section of the pricing response within this portal.) CHECK DEPOSIT Can check payments made via Remote Deposit be made into multiple accounts? CHECK DEPOSIT Will the County be able to have administrative permissions to add/edit/change or otherwise manage the accounts tied to the remote deposit scanners? CHECK DEPOSIT If yes, please provide details on capabilities and limitations: CHECK DEPOSIT Can you provide Report/Files customized to meet the requirements for New World ERP by Tyler Technologies? CHECK DEPOSIT Do you provide check return e-mail notification? RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 38 CHECK DEPOSIT If you provide other check return categories, please specify: CHECK DEPOSIT Do you provide check deposit at night? CHECK DEPOSIT Do you provide check deposit in vault? CHECK DEPOSIT Do you provide check deposit via courier? CHECK DEPOSIT Do you provide remote deposit scanners? CHECK DEPOSIT Will the County be able to have administrative permissions to add/edit/change or otherwise manage the accounts tied to the remote deposit scanners? CHECK DEPOSIT Does your Remote Deposit Scanner/Service have the capability to scan other documents (e.i. Coupons) to extract information and create import files? CHECK DEPOSIT Do you provide check conversion (BOC/ARC)? CHECK DEPOSIT Do you provide image storage online? CHECK DEPOSIT Do you provide reclears? CHECK DEPOSIT Do you provide check return? CHECK DEPOSIT Do you provide check return online notification? CHECK DEPOSIT Do you provide check return email notification? CHECK DEPOSIT Do you provide check return represented check via ACH (RCK)? CHECK DEPOSIT Do you provide other check return category? CHECK DEPOSIT Are you able to process Canadian checks? CHECK DEPOSIT Are you able to process foreign checks? COMPANY BACKGROUND Please provide a URL/link of company website COMPANY BACKGROUND Please provide a link to annual 10-k and quarterly 10-Q reports (If you are not a publicly traded company, please put N/A) COMPANY BACKGROUND Please provide a link to the latest statement of Auditing Standards (SAS) No. 70 (If you are not a publicly traded company, please put N/A) COMPANY BACKGROUND Do you have any current litigation/investigation by a regulatory authority? COMPANY BACKGROUND If yes, please explain: COMPANY BACKGROUND Have you (as a Sole Proprietor), your business or anyone on the proposed team bidding on this project, ever been debarred or suspended? COMPANY BACKGROUND Please provide an estimate of your bank's total assets. CONTROLLED DISBURSEMENT Do you provide controlled disbursement (CD) account services? CONTROLLED DISBURSEMENT Where is your CD endpoint/location? RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 39 CONTROLLED DISBURSEMENT Is the location a High Dollar Group Sort endpoint? CONTROLLED DISBURSEMENT Do you provide Notification Services? CONTROLLED DISBURSEMENT Notification Start Times CONTROLLED DISBURSEMENT Notification End Times CONTROLLED DISBURSEMENT Do you have other account types? CONTROLLED DISBURSEMENT Do you provide controlled disbursement account services? CUSTOMER SERVICE Do you offer a separate department for customer service as it pertains to investments or a centralized customer service department for all cash management services? CUSTOMER SERVICE Will a dedicated customer service/relationship manager by assigned to the County? CUSTOMER SERVICE Please provide credential details of the person (text box - 250 word limit) CUSTOMER SERVICE Please upload Bios/Resumes ELOCKBOX Do you provide eLockbox (consolidating/converting consumer-initiated payments through constituent bank portal to ACH)? ELOCKBOX Can you process and convert all payments to an electronic receipt? ELOCKBOX Can you provide remittance data electronically to the accounting software, facilitating reconciliation? ELOCKBOX Can you provide Report/Files customized to meet the requirements for New World Systems? FRAUD PROTECTION Do you provide other fraud protection? FRAUD PROTECTION If yes, please specify: FRAUD PROTECTION Do you provide post no checks? FRAUD PROTECTION Do you provide ACH Blocks? FRAUD PROTECTION Do you provide ACH Filters? FRAUD PROTECTION Do you provide positive pay standard? FRAUD PROTECTION Do you provide Positive Pay Payee? FRAUD PROTECTION Do you provide Positive Pay Reverse? FRAUD PROTECTION Do you provide positive pay exception processing? INVESTMENT SERVICES Do you provide MMDA/MMSA? INVESTMENT SERVICES Please provide Indicative Rate for MMDA/MMSA for the County. INVESTMENT SERVICES Do you provide Sweep Accounts/Services? INVESTMENT SERVICES Please provide indicative Rate for Sweep Accounts/Services for the County. RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 40 INVESTMENT SERVICES Do you provide CDs? INVESTMENT SERVICES Please provide indicative rate for CD (30 Days) INVESTMENT SERVICES Please provide indicative rate for CD (60 Days) INVESTMENT SERVICES Please provide indicative rate for CD (90 Days) INVESTMENT SERVICES Please provide indicative rate for CD (180 Days) INVESTMENT SERVICES Please provide indicative rate for CD (1 Yr) INVESTMENT SERVICES Please provide indicative rate for CD (2 Yr): INVESTMENT SERVICES Do you participate in deposit placement services (e.g. ICS/CDARS)? ONLINE SERVICES Do you provide image viewing duration limits? ONLINE SERVICES If yes, please specify: ONLINE SERVICES Do you provide check search? ONLINE SERVICES Please explain other security features you provide: ONLINE SERVICES Do you provide wire initiation? ONLINE SERVICES Do you provide ACH initiation? ONLINE SERVICES Do you provide current day reporting? ONLINE SERVICES Do you provide previous day reporting? ONLINE SERVICES What are your overall retention limitations? ONLINE SERVICES Do you provide role based user assignments? ONLINE SERVICES Do you provide dual factor authentication? ONLINE SERVICES Do you provide other security features? ONLINE SERVICES Do you provide account transaction viewing? ONLINE SERVICES Do you provide account transaction search? ONLINE SERVICES Do you provide balance viewing? ONLINE SERVICES Do you provide image viewing? ONLINE SERVICES Do you provide monthly bank statements? ONLINE SERVICES Do you provide monthly analysis statements? ONLINE SERVICES Do you provide online account transaction search? ONLINE SERVICES Do you provide online image viewing duration limit? ONLINE SERVICES Do you provide monthly PDF bank statements online? ONLINE SERVICES Do you provide monthly PDF analysis statements online? ONLINE SERVICES Do you provide Prior Day BAI2 and EDI 822 file type transmission protocols? RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 41 ONLINE SERVICES Do you provide transfers online (between accounts)? ONLINE SERVICES Do you provide wire initiation online? ONLINE SERVICES Do you provide ACH initiation online? ONLINE SERVICES Do you provide current day reporting online? ONLINE SERVICES Do you provide previous day reporting online? ONLINE SERVICES What are your overall online retention limitations? ONLINE SERVICES Do you provide online role-based user assignments? ONLINE SERVICES Do you provide dual factor authentication online? ONLINE SERVICES Do you provide other online security features? ONLINE SERVICES Do you provide online account transaction viewing? OVERALL SERVICES Are you willing to cap any price increase that may occur at the end of the initial contract? OVERALL SERVICES Can you provide an SFTP (with SSH key) connection to allow a treasury management tool to pull 822 files from the banks server? OVERALL SERVICES Will you confirm that you can provide files with specific naming conventions in a SFTP (with SSH key) transmission? OVERALL SERVICES Will you guarantee pricing for the life of the contract and therefore hold submitted pricing without increases? OVERALL SERVICES Do you provide BAI2 cash management balance reporting files? OVERALL SERVICES Do you provide an 822 file? OVERALL SERVICES Can you provide an SFTP (with SSH key) connection to allow a treasury management tool to pull BAI2 files from the banks server? PAPER DISBURSEMENTS Do you provide check clearing? PAPER DISBURSEMENTS Do you provide online stop payment? PAPER DISBURSEMENTS Do you provide manual stop payment? PAPER DISBURSEMENTS Do you provide automatic renewal stop payment? PAPER DISBURSEMENTS Do you provide check cashing (non-account holders)? PAPER DISBURSEMENTS Do you provide check conversion to ACH? PROCUREMENT POLICY Do you agree to abide by the Countys standard procurement polices? RETAIL LOCKBOX Do you provide transfer initiation by Standing Instructions (ZBA each day for cleared amount)? RETAIL LOCKBOX Can you work with customized remittance docs? RETAIL LOCKBOX Do you provide customized post office box #s/vanity street addresses? RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 42 RETAIL LOCKBOX Do you provide a set time(s) that lockbox exceptions will be made available? RETAIL LOCKBOX Do you provide Report/Files customized to meet the requirements for New World ERP? RETAIL LOCKBOX Can envelopes be scanned with check/coupon image? RETAIL LOCKBOX Are you able to process payments made via credit card through the lockbox site? RETAIL LOCKBOX Do you provide retail lockbox? RETAIL LOCKBOX Where is the Lockbox location? RETAIL LOCKBOX Do you provide transfer initiation by Telephone? RETAIL LOCKBOX Do you provide transfer initiation by Wire? WHOLESALE LOCKBOX Do you provide wholesale lockbox? WHOLESALE LOCKBOX Where is your lockbox location? WHOLESALE LOCKBOX Do you provide transfer initiation by Telephone? WHOLESALE LOCKBOX Do you provide transfer initiation by Wire? WHOLESALE LOCKBOX Do you provide transfer initiation by Standing Instructions (ZBA each day for cleared amount)? WHOLESALE LOCKBOX Can you work with customized remittance docs? WHOLESALE LOCKBOX Do you provide customized post office box #s/vanity street addresses? WHOLESALE LOCKBOX Can you provide a set time(s) that lockbox exceptions will be made available? WHOLESALE LOCKBOX Can you provide Report/Files customized to meet the requirements for New World ERP? WIRE SERVICES Do you provide email notification (Confirmations/Other)? WIRE SERVICES Do you provide fax notification (Confirmations/Other)? WIRE SERVICES Do you provide other notification (Confirmations/Other)? WIRE SERVICES Do you provide telephone initiation? WIRE SERVICES Do you provide fax initiation? WIRE SERVICES Do you provide internet based initiation? WIRE SERVICES Do you provide system to system initiation? WIRE SERVICES Do you provide file import initiation? WIRE SERVICES Do you provide authorization roles? WIRE SERVICES Do you provide wire cancellation? WIRE SERVICES If yes, when is your wire cancellation deadline? WIRE SERVICES Do you provide role based user assignments? RFP-22-14 12/06/2021 Page: NED PATTISON RENSSELAER COUNTY GOVERNMENT CENTER 1600 SEVENTH AVENUE, TROY, NEW YORK 12180 43 WIRE SERVICES Do you provide wire services through the Fed System? WIRE SERVICES Do you provide CHIPS? WIRE SERVICES Do you provide template storage? WIRE SERVICES Do you provide instruction storage? WIRE SERVICES Do you provide e-mail notification (Confirmations/Other)? WIRE SERVICES If you provide other notifications (Confirmations/Other), please specify: WIRE SERVICES Do you provide dual authorization? WIRE SERVICES Please Describe Your Authorization/Approval Process: ZERO BALANCE ACCOUNTS Do you provide ZBA Sub Accounts? ZERO BALANCE ACCOUNTS Do you provide ZBA Master? ZERO BALANCE ACCOUNTS Do you provide zero balance account services?