{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Bid Sheet","Scope of Work"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Bid Sheet","index":0,"n_rows":123,"n_cols":3,"rows_kept":123,"merged":[[0,0,0,2],[1,0,1,2],[119,0,119,2]]}
[" Bid Sheet"]
["ATTACHMENT C - Banking Services Bid Sheet"]
[]
[]
[null,"Current Volume","Financial Institution's Responses"]
["Financial Institutiuon Name?"]
["Total Assets?"]
["AM Best Company Insurance Rating?"]
["Founded?"]
["Banking Office Location for Bulloch County?"]
[]
["ACH Payroll Processing (Direct Deposit) charges: ","Approx. 27 "]
["  One-time set-up fee?","times/year"]
["  Monthly or annual fee?","Yearly Full Time 600 employees"]
["  File Transfer fee?","During the Summer Months"]
["  Returned Items Charge, per item?","1100 Full Time Employees"]
[]
["Online Banking Services:","10 Account(s)"]
["  Monthly Maintenance Fees, per account?","including 1"]
["  Per item charge for transfers between funds?  If so, how much per?","operating acct"]
["  Per Item debit/credit?"]
[]
["Employee Reimbursements via EFT:"]
["  One-time set-up fee?","3 files per"]
["  Monthly or annual fee?","month"]
["  File Transfer fee for upload to bank?"]
[]
["Check Reconciliation Services:","4 to 5 file(s) downloaded"]
["  File downloaded from bank to automatically reconcile cleared","from bank monthly"]
[" checks in County's Operating System.  Available?","for reconciling "]
["  Fee? If so, how much?","in our system."]
[]
["Positive Pay Services  (for check payments):","4 to 5 files up-"]
["  One-time set-up fee?","loaded to bank"]
["  Monthly or annual fee?","per month"]
[]
["Business Credit Cards (Departments, Dept Heads, Board)"]
["   One-time set up fee?","County currently"]
["   Monthly or annual fee?","has 135 credit cards"]
["   On-line access and reporting available to County? ","County may add more cards"]
["   Grace Period before interest charges?","annual spending limit"]
["   Transactions file available to export to Excel by County?",{"v":850000,"d":"$850,000"}]
[]
["Current Accounts:"]
["Master Depository Operating Account (Checking)","January 2020"]
["   Online banking available for this and all other accounts?","Avg Daily"]
["   Interest Rate for checking account?","Balance"]
["   Current Rate of Interest based on proposal?","$4.3 Million"]
["   Account maintenance fee (monthly)?"]
["   Check processing fee, per item?","Per Month:"]
["   Deposit fee, per item?","77 Deposit(s)"]
["   Stop Payment fee, per item?","4 ACH Deposit(s)"]
["   Transfer between funds fee?","6 ACH/Wires Withdrawal(s)"]
["   Electronic Debit/Credit fee, per item?","60 Credit Card Deposit(s)"]
["   Wire transfer fee?","101 Account Transfer(s)"]
["   ACH returned item fee?","0 Check(s) Cleared"]
["   NSF Fee, per item?"]
["   Overdraft fee, per item?"]
["   Cost of Deposit Bags"]
["   Please detail any other fee(s) not outlined in this section."]
[null,"2 ACH Deposit(s)"]
["Other Accounts/As of January 2020","195 ACH/Wires Withdrawl(s)"]
["General Checking Account","21 Account Transfer(s)"]
["       Monthly Maintenance Fee?","571 Check(s) Cleared"]
["       Interest Rate?","Monthly/$0.00 Avg Bal"]
["       Per Item Fee?"]
[null,"19 ACH/Wires Withdraw(s)"]
["Payroll","13 Account Transfer(s)"]
["       Monthly Maintenance Fee?","2 Cleared Check(s)"]
["       Interest Rate?","Bi-weekly"]
["       Per Item Fee?","$0.00 Avg Bal"]
[]
[]
[null,"130 Deposit(s)"]
[null,"11 ACH Deposit(s)"]
[null,"1 ACH/Wire Withdrawl(s)"]
["Parks and Recreation Concentration","21 Credit Card Deposit(s)"]
["       Monthly Maintenance Fee?","21 Account Transfer(s)"]
["       Interest Rate?","Monthly/$0.00 Avg Bal"]
["       Per Item Fee?"]
[]
[]
[]
[null,"13 Deposit(s)"]
["EMS","38 ACH Deposit(s)"]
["       Monthly Maintenance Fee?","16 Credit Card Deposit(s)"]
["       Interest Rate?","20 Account Transfer(s)"]
["       Per Item Fee?","Monthly/$0.00 Avg Bal"]
[]
[null,"$0.00 Avg Bal"]
["Probation","18 Account Transfer(s)"]
["       Monthly Maintenance Fee?","39 Check(s) Cleared"]
["       Interest Rate?","Monthly/$0.00 Avg Bal"]
["       Per Item Fee?"]
[]
["Transportation SPLOST","1 ACH Deposit(s)"]
["       Monthly Maintenance Fee?","2 Account Transfer(s)"]
["       Interest Rate?","Monthly"]
["       Per Item Fee?","$5.1 Million Avg Bal"]
[]
["SPLOST 2007","1 Account Transfer(s)"]
["       Monthly Maintenance Fee?","Monthly"]
["       Interest Rate?","$1050 Avg Bal"]
["       Per Item Fee?"]
[]
["SPLOST 2013","4 Account Transfer(s)"]
["       Monthly Maintenance Fee?","Monthly"]
["       Interest Rate?","$2.1 Million Avg Bal"]
["       Per Item Fee?"]
[]
["SPLOST 2019","1 ACH Deposit(s)"]
["       Monthly Maintenance Fee?","2 Account Transfer(s)"]
["       Interest Rate?","Monthly"]
["       Per Item Fee?","$402,897 Million Avg Bal"]
[]
["Engagement Manager for this proposal?"]
["Proposal valid through date?"]
["Email for Engagement Manager?"]
[]
["By signing below, I certify that I have fully read and understand the RFP, have full knowledge of the scope, nature, quantity and quality of the work to be performed, the detailed requirements of the services to be provided and the conditions under which the services are to be performed."]
[]
["________________________________","____________________"]
["Signature of Bank Representative","Date "]

{"sheet":"Scope of Work","index":1,"n_rows":115,"n_cols":5,"rows_kept":115,"merged":[[0,0,0,4],[1,0,1,4],[6,0,6,4],[20,0,21,1],[29,0,30,1],[42,0,42,1],[62,0,63,1],[70,0,71,1]]}
[]
["ATTACHMENT B - SCOPE OF WORK"]
[]
[]
["Name of Bank:  ________________________________________________________________________________"]
[]
["The County requires a fairly robust and sophisticated banking platform and relationship. The list below identifies many of our most significant banking needs, which are identified as either mandatory or preferred. Please review the below list and provide either : 1) insert a \"Yes\" or \"No\" in the Yes/No Response column that reflects your ability to provide the needed/requested service if \"Y\" is shown as Mandatory Column or 2) if \"Y+\" is shown in the Mandatory column provide a narrative response with any requested supplemental information that addresses your ability to provide the service. For the \"Y+\" responses, please provide a separate document with your written narrative response and indicate the line number on which you are commenting. Written Narrative is limited to thirty (30) pages this includes resumes in total."]
[]
["Y+","Y with a plus sign (+) indicates additional information is required beyond Yes or No answer, please provide the required information."]
[]
["Collateralization",{"$nulls":3},"Yes/No"]
["All funds and accounts maintained at bank must be collateralized at 110%.",null,null,"Mandatory","Response"]
[1,"Ability to collateralize balances in accordance with the Official Code of Georgia Annotated 45-8-12. Average monthly balance for General Operating Account can be assumed to be as high as $6,000,000.",null,"Y"]
[]
["Location of Bank Branches",{"$nulls":3},"Yes/No"]
["The County has a need to have branch locations within a reasonable distance to operate efficiently. ",null,null,"Mandatory","Response"]
[2,"Financial Institution provides a full service bank operation. Please give location(s). ",null,"Y+"]
[3,"Financial Institution will provide a single point of contact to serve the County. Required 3-5 years experience as dedicated customer service representative. Attach resume of individual who would be designated to work with County staff. ",null,"Y+"]
[]
["Customer Service"]
["Customer service is a significant aspect of the banking services that the County must receive as a part/function of its banking services.",{"$nulls":3},"Yes/No"]
[{"$nulls":3},"Mandatory","Response"]
[{"$f":"+A18+1","v":4},"Financial Institution has specialized governmental unit with experienced staff that will seek to understand our needs and objectives and to work to obtain the most cost efficient solutions. The bank will provide a dedicated government team that at a minimum consists of a relationship manager, treasury management representative/consultant and dedicated client support representative(s) to support the relationship on a daily basis. Provide resumes of staff along with specific experience related to government banking. Please describe your Financial Institution's customer service process and organizational structure and provide meaningful examples to illustrate. ",null,"Y+"]
[{"$f":"+A23+1","v":5},"Financial Institution must be able to provide technical support. Please describe the manner in which this support will be provided. ",null,"Y+"]
[{"$f":"+A24+1","v":6},"Financial Institution must be able to provide assistance in the form of a dedicated individual to assist the County in identifying incoming wires/ACH. Identify the individual who will serve in this capacity and provide his/her resume. Note: This can be one of the individuals listed in #4 above. ",null,"Y+"]
[7,"Provide an annually updated list of critical contacts (phone and e-mail).",null,"Y"]
[8,"Provide timely notification of lead representative change, and allow the County input before the change is implemented.",null,"Y"]
[]
["Banking Services"]
["The County utilizes a variety of general banking services that are important to the financial operations of our government.  Some of the most important are listed below. Indicate if you provide these services.",{"$nulls":3},"Yes/No"]
[{"$nulls":3},"Mandatory","Response"]
[{"$f":"+A27+1","v":9},"Financial Institution will provide full banking services, including but not limited to, the General Fund Operating Account, but all accounts listed in this RFP and any which might be added in the future.",null,"Y"]
[{"$f":"+A32+1","v":10},"Desktop deposit/check scanner capabilities from multiple locations in Statesboro.",null,"Y"]
[{"$f":"+A33+1","v":11},"Financial Institution offers electronic deposit (in addition to Desktop Deposit) - process allowing the County to capture check images and securely transmit file to Financial Institution",null,"Y"]
[{"$f":"+A34+1","v":12},"Daily notifications of ACH returned items .",null,"Y"]
[13,"The County has the ability to place debit blocks on accounts.",null,"Y"]
[14,"Send and receive domestic wire transfers and/or ACH payments.",null,"Y"]
[15,"Ability to cancel stop payments online within a specified period of time.",null,"Y"]
[16,"Financial Institution has the ability to generate monthly statements to coincide with the County's accounting cycle. Each account should be on a separate statement and available online at month-end.",null,"Y"]
[17,"Financial Institution has the ability to generate calendar month-end statements.",null,"Y"]
[]
["Online Capabilities",{"$nulls":3},"Yes/No"]
["Online capabilities are important to daily operations. Some of the most important are listed below. ",null,null,"Mandatory","Response"]
[18,"Online access to General Operating Account and all other accounts.",null,"Y"]
[{"$f":"+A44+1","v":19},"Financial Institution is able to offer 24/7/365 to a minimum of 4 County staff members.",null,"Y"]
[{"$f":"+A45+1","v":20},"Inclusive web-based system to include cleared check image access, stop pay abilities, and positive pay exceptions with electronic response options.",null,"Y"]
[21,"Daily access to returned check images.",null,"Y"]
[22,"Access to external bank platforms such as but not limited to Cash Management and Purchasing Cards via single sign on.",null,"Y"]
[23,"Ability to obtain listings of ACH and wire transfers for current day and previous day items.",null,"Y"]
[24,"Positive pay with 2 approval level process for ACH/EFT files submitted to bank.",null,"Y"]
[25,"Ability to set up templates for wire and ACH payments.",null,"Y"]
[26,"Previous Day Reporting.",null,"Y"]
[27,"Ability to download Client Analysis Statement - describe the method of delivery. ",null,"Y+"]
[28,"Financial Institution has the ability for the County to download a monthly file with transaction information for all checks cleared during the prior month for automatic reconciliation within County's operating system, which is Munis.",null,"Y"]
[29,"User specific assignable secured token access with administration by County admin user.",null,"Y"]
[]
["Returned Item Processing",{"$nulls":3},"Yes/No"]
[{"$nulls":3},"Mandatory","Response"]
[30,"Returned items must be able to be viewed electronically each day.",null,"Y"]
[{"$f":"+A59+1","v":31},"Financial Institution will automatically redeposit checks 2 times.",null,"Y"]
[]
["Positive Pay "]
["The County currently utilizes positive pay for written/issued checks. Controls over these payment techniques are important. Indicate your ability to provide the services shown below.",{"$nulls":3},"Yes/No"]
[{"$nulls":3},"Mandatory","Response"]
[32,"Check positive pay (including “payee”) capabilities via both daily/weekly file transmission (see \"Information Technology\" below), and manually input online.",null,"Y"]
[{"$f":"+A65+1","v":33},"ACH and check positive pay exceptions email notification to designated employees.",null,"Y"]
[{"$f":"+A66+1","v":34},"Direct file transmission accepted from County to bank for positive pay purposes.",null,"Y"]
[35,"Check positive pay issuance match online and ability to approve or deny exemptions online.",null,"Y"]
[]
["Information Technology and Security"]
["Electronic transactions represent a significant portion of the communication that takes place between the County and its bank. Some of the most critical functions and methods of interface are noted below. Indicate your ability to provide the service.",null,"Electronic transactions represent a significant portion of the communication that takes place between the County and its bank. Some of the most critical functions and methods of interface are noted below. Indicate your ability to provide the service.",null,"Yes/No"]
[{"$nulls":3},"Mandatory","Response"]
[{"$f":"+A68+1","v":36},"Financial Institution has the ability to provide multi-factor security to online services that includes a combination of user name, password, token and pin #. Please provide description of what is required to log into your system. ",null,"Y+"]
[{"$f":"+A73+1","v":37},"Financial Institution offers the ability to apply dual step control (i.e. log-in and a token) on all payment activity, including ACH and wire transfer payments.",null,"Y"]
[{"$f":"+A74+1","v":38},"Financial Institution offers the ability to set up $ (dollar) limits on what an individual can approve on ACH and wire transfer payments. ",null,"Y"]
[39,"Financial Institution offers the ability to set up $ (dollar) limits on debit activity on each account.",null,"Y"]
[40,"Financial institution must be able to accept and process electronically transmitted files for a variety of payments and issuance items (noted below):",null," "]
[" ","- Payroll ACH debit - typically processed bi-weekly on Wednesday with Friday payday.",null,"Y"]
[" ","- EFT payments to vendors and employees, processed through County's A/P department.",null,"Y"]
[{"$f":"+A77+1","v":41},"Financial institute must be able to accept and process electronically transmitted files for positive pay details for daily, weekly or bi-weekly check issuances (noted below):",null," "]
[" ","- Accounts Payable physically issued checks/positive pay. Accounts Payable checks are processed throughout the week.",null,"Y"]
[" ","- Payroll physically issued checks/positive pay. ",null,"Y"]
[{"$f":"+A80+1","v":42},"Ability for an individual to receive account specific event-triggered secure emails for the following: ",null," "]
[null,"- Unauthorized ACH Transactions",null,"Y"]
[null,"- Positive Pay Exceptions",null,"Y"]
[null,"- Client Analysis Statement Available",null,"Y"]
[null,"- ACH Receive Activity",null,"Y"]
[null,"- ACH Return Activity",null,"Y"]
[null,"- Cash Deposit Adjustment",null,"Y"]
[null,"- Incoming Wire",null,"Y"]
[null,"- Wire Unsuccessful, Rejected, Requires Approval, Template Requires Approval",null,"Y"]
[null,"- Outgoing Wire",null,"Y"]
[null,"- Return Items",null,"Y"]
[null,"- Stop Notices",null,"Y"]
[null,"- Account Statement Available",null,"Y"]
[{"$f":"+A83+1","v":43},"Financial Institution offers disaster recovery assistance. Please describe your process for how your institution would assist the County. ",null,"Y+"]
[{"$f":"+A96+1","v":44},"Financial Institution offers robust and secure mobile services. Please describe the services offered by mobile and how security is maintained. ",null,"Y+"]
[{"$f":"+A97+1","v":45},"Financial Institution has the ability to allow set up of users to be restricted at the individual user level which will vary according to the user's needs to access information. System Administration of this security must be able to be done electronically by the County System Administrator (s) and require DUAL approval.",null,"Y"]
[]
["Relationship Review/Training",{"$nulls":3},"Yes/No"]
[{"$nulls":3},"Mandatory","Response"]
[{"$f":"+A98+1","v":46},"Financial Institution will hold with the County an annual relationship review with the Finance Department and other departments as deemed necessary.",null,"Y"]
[{"$f":"+A102+1","v":47},"Financial Institution will hold training sessions on new products, processes or upgrades to online systems as the County is required or decides to implement them.  Please provide description of how you offer these sessions. ",null,"Y+"]
[{"$f":"+A103+1","v":48},"As part of an initial implementation financial institution has the ability to provide training for up to 10 people on electronic banking system and any related technology, applications or accounts. Please provide description of how you offer these sessions. ",null,"Y+"]
[49,"Please describe how you would assist the County in a implementation plan. Please provide a summary of what assistance (financial, training, programming, and/or other) you would be willing to provide in an implementation and the length of time you are willing to provide the assistance. Please outline the implementation schedule via Gantt Chart - outlining tasks, dates and responsible party.",null,"Y+"]
[" "]
["Additional Services/Products Offered"]
[{"$f":"+A105+1","v":50},"Please describe additional products/services offered by your financial institution that would assist the County with their banking services needs which have not been covered in the RFP. "]
[{"$f":"+A108+1","v":51},"Please describe in detail a time where your level of customer service went above and beyond a clients' expectation similar to the County. "]
[]
[]
[]
[]
["Signed by: ______________________________________  Date: ______________________"]
["Printed Name: __________________________________________"]