Exhibit_E.1_-_County_Bank_Accounts.pdf

PDF 922 KB Posted

Attached to
Banking Services
Solicitation number
25-P-131TF
Issued by
Volusia County, Florida

About this file

This is a County Bank Account Matrix exhibit for Volusia County, Florida's Request for Proposals #25-P-131TF for comprehensive banking services. The exhibit details the specific account structures and features required across multiple county departments and constitutional officers. The RFP encompasses specialized accounts including a Pooled Cash Account serving as the master for zero-balance accounts, Accounts Payable Account, Payroll Account, Utility Payment Account, Airport Automated Account, ePayables Account, HDPP Local Participation Fund Account, Corrections Inmate Account, Inmate Imprest Account, Utility Deposit Account, Non-Interest Grant Account, Votran Deposit Account, and Electronic Deposit Account. Each account type is configured with distinct fraud protection levels (ACH Fraud Filter options for Stop or Review), payment authorization capabilities, wire origination, positive pay features, and varying treasury information reporting functions. The County requires integration with advanced technological systems including NACHA formatted EFT files and Image Cash Letter (ICL) deposit processes to support approximately $139,880,000 in annual deposits and process approximately 2,800 biweekly direct deposit payroll transactions and 75-125 weekly ACH vendor payments.

The matrix demonstrates the sophisticated banking infrastructure needed to manage segregated funds across multiple government entities while maintaining consolidated reporting and sweep account positioning. Key service requirements include statements and notices, transaction search capabilities, treasury information reporting with options such as ACH Customer Activity, ACH Origination, ACH Receive, ACH Return/NOC, ARP File Posting Confirmation, and various composite and position reporting functions. Specialized features such as Desktop Deposit, Image File Import for Posted Items, E-Box access, Cash Vault services, Stagecoach Sweep arrangements, and Positive Pay with Payee Validation are deployed across different account types based on operational needs. This account structure reflects the County's need for a banking partner capable of providing comprehensive government banking services with robust security protocols, fraud prevention measures, and detailed transaction and balance reporting across multiple constitutional officer accounts while maintaining appropriate fund segregation and maximizing operational efficiency.

View the file

Other files

File Type Posted
Banking_Services.pdf PDF
Exhibit_B.3_-_One-Time_Transition_Costs_and_Cost_Offsets_(4_TABS_TO_COMPLETE).xlsx XLSX spreadsheet
Exhibit_E.2_-_Elections_Bank_Accounts.pdf PDF
Exhibit_G.4_-_Bank_Reconciliation_Data_File.xlsx XLSX spreadsheet
Exhibit_Z_-_Exhibit_C_-_Insurance_Requirements_(FOR_DRAFT_CONTRACT).pdf PDF
Exhibit_A_-_Scope_of_Services.pdf PDF
Exhibit_B.1.A_-_Appendix,_Services_Descriptions.xlsx XLSX spreadsheet
Exhibit_J.2_-_Elections_Average_Daily_Balances.pdf PDF
Exhibit_J.3_-_Property_Appraiser_Average_Daily_Balances.pdf PDF
Exhibit_B.1.A_-_Appendix,_Services_Descriptions.xlsx XLSX spreadsheet
Exhibit_B.3_-_One-Time_Transition_Costs_and_Cost_Offsets_(4_TABS_TO_COMPLETE).xlsx XLSX spreadsheet
Exhibit_E.2_-_Elections_Bank_Accounts.pdf PDF
Exhibit_E.3_-_Property_Appraiser_Bank_Accounts.pdf PDF
Exhibit_F.2_-_Positive_Pay_Format.pdf PDF
Exhibit_F.3_-_Cleared_Check_Data_File_Format.pdf PDF
Exhibit_J.1_-_County_Average_Daily_Balances.pdf PDF
Exhibit_A.3_-_Technical_Requirements_Form_(TO_BE_COMPLETED).docx DOCX document
Exhibit_B.1.A_-_Appendix,_Services_Descriptions.xlsx XLSX spreadsheet
Exhibit_C_-_Required_Types_and_Limits_of_Insurance_Chart.pdf PDF
Exhibit_F.4_-_Images_of_Cleared_Checks.pdf PDF
Exhibit_J.1_-_County_Average_Daily_Balances.pdf PDF
Exhibit_J.2_-_Elections_Average_Daily_Balances.pdf PDF
Exhibit_A.1_-_Banking_Service_Processes_(TO_BE_COMPLETED).docx DOCX document
Exhibit_A.2_-_Technical_Requirements_Matrix_(1_TAB_TO_COMPLETE).xlsx XLSX spreadsheet
Exhibit_B.1_-_Pricing_Services_Chart_(1st_TAB_TO_COMPLETE_ONLY).xlsx XLSX spreadsheet
Exhibit_B.3_-_One-Time_Transition_Costs_and_Cost_Offsets_(4_TABS_TO_COMPLETE).xlsx XLSX spreadsheet
Exhibit_D_-_Human_Trafficking_Affidavit_FINAL_(TO_BE_COMPLETED).pdf PDF
Exhibit_E.3_-_Property_Appraiser_Bank_Accounts.pdf PDF
Exhibit_F.1_-_EFT_File_Format.pdf PDF
Exhibit_G.3_-_ICL_File_Format.pdf PDF
Exhibit_H_-_County_Computing_Security_Procedures.pdf PDF
Exhibit_I_-_Average_Cash_Vault_Deposits.xlsx XLSX spreadsheet
Exhibit_J.4_-_Tax_Collector_Average_Daily_Balances.pdf PDF
Exhibit_Z_-_SAMPLE_-_DRAFT_Contract.pdf PDF
Exhibit_A.3_-_Technical_Requirements_Form_(TO_BE_COMPLETED).docx DOCX document
Exhibit_A_-_Scope_of_Services.pdf PDF
Exhibit_B.1_-_Pricing_Services_Chart_(1st_TAB_TO_COMPLETE_ONLY).xlsx XLSX spreadsheet
Exhibit_D_-_Human_Trafficking_Affidavit_FINAL_(TO_BE_COMPLETED).pdf PDF
Exhibit_E.4_-_Tax_Collector_Bank_Accounts.pdf PDF
Exhibit_F.4_-_Images_of_Cleared_Checks.pdf PDF
Exhibit_G.2_-_Tax_Collector_E-Box_Export.pdf PDF
Exhibit_G.3_-_ICL_File_Format.pdf PDF
Exhibit_J.2_-_Elections_Average_Daily_Balances.pdf PDF
Exhibit_J.4_-_Tax_Collector_Average_Daily_Balances.pdf PDF
Exhibit_Z_-_Exhibit_C_-_Insurance_Requirements_(FOR_DRAFT_CONTRACT).pdf PDF
Exhibit_D_-_Human_Trafficking_Affidavit_FINAL_(TO_BE_COMPLETED).pdf PDF
Exhibit_E.3_-_Property_Appraiser_Bank_Accounts.pdf PDF
Exhibit_E.4_-_Tax_Collector_Bank_Accounts.pdf PDF
PRIME-SUB_FORM_for_Contractors_rev._01.15.2025_(lock_before_publishing).xls XLS spreadsheet
PRIME-SUB_FORM_for_Contractors_rev._01.15.2025_(lock_before_publishing).xls XLS spreadsheet
Show 40 more

50 files listed here. See the rest on GovTribe.

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

COUNTY BANK ACCOUNT MATRIX

Pooled Cash Account

• Master for Zero Balance Accounts

• Key Billing Account

• ACH Fraud Filter - Review

• Partial ARP

• Payment Authorization

• Branch Services

• Cash Vault

• Desktop Deposit

• Electronic Deposit

• Stagecoach Sweep

• Wire Origination

• Returned Item Service

• Statements & Notices

• Transaction Search

• Treasury Information Reporting o ARP Statements & Reports

(CSV/EXCEL/PDF)

o Express Balance o Intraday Composite o Previous Day Composite o Previous Day Posting Status o Sweep Account Position o Wire Transfer Detail

Accounts Payable Account Payroll Account

Utility Payment Account

• Zero Balance Account

• ACH Fraud Filter - Stop

• Payment Authorization

• Statements & Notices

• Transaction Search

• Treasury Information Reporting o ACH Receive o ACH Return/NOC o Intraday Composite o Intraday Position o Previous Day Composite o Previous Day Posting Status o Wire Transfer Detail

• Zero Balance Account

• ACH Fraud Filter - Stop

• Full ARP

• Positive Pay w/ Payee Validation

• ACH Direct Origination

• Image File Import – Posted Items

• Statements & Notices

• Transaction Search

• Treasury Information Reporting o ACH Customer Activity o ACH Origination o ACH Receive o ACH Return/NOC o ARP File Posting Confirmation o ARP Statements & Reports

(CSV/EXCEL/PDF)

o Express Balance o Previous Day Composite o Previous Day Posting Status o Wire Transfer Detail

Airport Automated Account

• Zero Balance Account

• ACH Fraud Filter - Review

• Full ARP

• Positive Pay w/ Payee Validation

• ACH Direct Origination

• ACH Payments

• Image File Import - Posted Items

• Wire Origination

• Statements & Notices

• Transaction Search

• Treasury Information Reporting o ACH Customer Activity o ACH Origination o ACH Receive o ACH Return/NOC o ARP File Posting Confirmation o ARP Statements & Reports

(CSV/EXCEL/PDF)

o Express Balance o Previous Day Composite o Previous Day Posting Status o Wire Transfer Detail

• Zero Balance Account

• ACH Fraud Filter - Stop

• E-Box

• ACH Direct Origination

• Statements & Notices

• Transaction Search

• Treasury Information Reporting o ACH Customer Activity o ACH Origination o ACH Receive o ACH Return/NOC o E-Box o Express Balance o Intraday Composite o Previous Day Composite o Previous Day Posting Status ePayables Account

• ACH Fraud Filter - Review

• Payment Authorization

• Wire Origination

• Statements & Notices

• Transaction Search

• Treasury Information Reporting o ACH Receive o ACH Return/NOC o Intraday Composite o Intraday Position o Previous Day Composite o Previous Day Posting Status o Wire Transfer Detail

25-P-131TF Exhibit E.1 - County Bank Accounts lurice Cross-Out

COUNTY BANK ACCOUNT MATRIX

HDPP Local Participation Fund Account

• ACH Fraud Filter - Review

• Full ARP

• Positive Pay Only

• Image File Import – Posted Items

• Cash Vault

• Wire Origination

• Statements & Notices

• Transaction Search

• Alerts

• Treasury Information Reporting o ARP File Posting Confirmation o ARP Statements & Reports (PDF) o Express Balance o Previous Day Composite o Previous Day Posting Status o Wire Transfer Detail

Corrections Inmate Account

• Key Billing Account - Standalone

• ACH Fraud Filter - Review

• Payment Authorization

• Wire Origination

• Statements & Notices

• Transaction Search

• Treasury Information Reporting o Intraday Composite o Intraday Position o Previous Day Composite o Previous Day Posting Status

Inmate Imprest Account

• ACH Fraud Filter - Review

• Payment Authorization

• Wire Origination

• Statements & Notices

• Transaction Search

• Treasury Information Reporting o Express Balance o Previous Day Composite o Previous Day Posting Status

Utility Deposit Account

• ACH Fraud Filter - Stop

• Payment Authorization

• Wire Origination

• Alerts

• Statements & Notices

• Transaction Search

• Treasury Information Reporting o Express Balance o Previous Day Composite o Previous Day Posting Status

Non-Interest Grant Account

• ACH Fraud Filter - Stop

• Payment Authorization

• Wire Origination

• Alerts

• Zero Balance Account

• ACH Fraud Filter - Review

• Statements & Notices

• Transaction Search

• Treasury Information Reporting o ACH Receive o Intraday Position o Intraday Composite o Express Balance o Previous Day Composite

Votran Deposit Account Electronic Deposit Account

• Zero Balance Account

• ACH Fraud Filter - Review

• Payment Authorization

• Statements & Notices

• Transaction Search

• Treasury Information Reporting o ACH Receive o ACH Return/NOC o Intraday Composite o Intraday Position o Express Balance o Previous Day Composite o Previous Day Posting Status

25-P-131TF Exhibit E.1 - County Bank Accounts

File details come from the government source that posted it. Updated .