Exhibit_I_-_Average_Cash_Vault_Deposits.xlsx

XLSX spreadsheet 14 KB Posted

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

About this file

Exhibit I is a financial analysis document supporting Volusia County, Florida's Request for Proposals #25-P-131TF for comprehensive banking services across the County and its Constitutional Officers, including the Property Appraiser, Supervisor of Elections, and Tax Collector. The exhibit details average cash vault deposits and transaction volumes for the period June 1, 2024 through May 31, 2025, establishing baseline operational metrics for the banking relationship. The County's primary deposit volume totals $170,301,000 annually across all entities, with the County generating $139,880,000 in deposits through 1,065 transactions averaging $131,343 per deposit. Supporting entities contribute additional deposit volumes, including the Tax Collector ($28,919,000), Property Appraiser ($805,000), Supervisor of Elections ($503,000), and Corrections Inmate Account ($194,000). The RFP was released October 10, 2025, with questions due by October 29, 2025, and proposals due November 12, 2025, at 3:01 pm. The contract term spans five years with potential renewal options for up to five additional years.

The exhibit demonstrates significant transactional complexity, with the vault processing 3,380 annual check deposits totaling $25,151,000 and $145,150,000 in annual cash deposits across 250 banking days. Daily operational metrics show the County alone averages 4.26 deposits daily ($559,520), requiring the selected bank to manage sophisticated account structures including pooled cash accounts, zero-balance accounts for accounts payable and payroll, utility payment processing, and separate Constitutional Officer accounts with appropriate fund segregation. The banking services must support approximately 2,800 biweekly direct deposit payroll transactions and 75-125 weekly ACH vendor payments, with monthly reconciliation services and centralized vault processing. The RFP establishes stringent insurance requirements including $5,000,000 Professional Liability coverage, $2,000,000 Cyber Insurance, and $10,000,000 Financial Institution Bonds, reflecting the sophisticated technology integration and regulatory compliance demands of this government banking relationship.

View the file

Other files

File Type Posted
Banking_Services_(Addendum_#6_Revision).pdf PDF
Banking_Services_(Addendum_#6_Revision).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
Exhibit_F.2_-_Positive_Pay_Format.pdf PDF
Exhibit_G.2_-_Tax_Collector_E-Box_Export.pdf PDF
Exhibit_G.5_-_Cash_Receipts_Data_File.xlsx XLSX spreadsheet
Exhibit_I_-_Average_Cash_Vault_Deposits.xlsx XLSX spreadsheet
Exhibit_J.3_-_Property_Appraiser_Average_Daily_Balances.pdf PDF
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_B.2_-_Net_Earnings_Chart_(4_TABS_TO_COMPLETE).xlsx XLSX spreadsheet
Exhibit_F.4_-_Images_of_Cleared_Checks.pdf PDF
Exhibit_G.2_-_Tax_Collector_E-Box_Export.pdf PDF
Exhibit_G.4_-_Bank_Reconciliation_Data_File.xlsx XLSX spreadsheet
Exhibit_G.5_-_Cash_Receipts_Data_File.xlsx XLSX spreadsheet
Exhibit_J.1_-_County_Average_Daily_Balances.pdf PDF
Exhibit_A.1_-_Banking_Service_Processes_(TO_BE_COMPLETED).docx DOCX document
Exhibit_F.1_-_EFT_File_Format.pdf PDF
Exhibit_G.1_-_E-Box_Remittance_Report.pdf PDF
Exhibit_G.4_-_Bank_Reconciliation_Data_File.xlsx XLSX spreadsheet
Exhibit_H_-_County_Computing_Security_Procedures.pdf PDF
Exhibit_Z_-_SAMPLE_-_DRAFT_Contract.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
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

Cash Vault Avg Daily Volume

Cash Vault Avg Daily VolumeCASHCHECKSTOTAL
Entity6/01/2024 - 5/31/2025 Annual Number of Deposits6/01/2024 - 5/31/2025 Annual Deposit Amount

(Cash + Checks)

(nearest $1,000)Average Deposit Amount
(Cash + Checks)6/01/2024 - 5/31/2025 Annual Number of Checks6/01/2024 - 5/31/2025 Annual Check Amount (nearest $1,000)6/01/2024 - 5/31/2025 Annual Cash Amount (nearest $1,000)Number of Banking Days *DOLLARS
(Annual Cash $ / Banking Days)ITEMS
(# Checks / Banking Days)DOLLARS
(Annual Check $ / Banking Days)DEPOSITS
Deposits / Banking DaysDOLLARS

Annual Deposit / Banking Days

County1065139,880,000131,343214623,841,000116,039,000250464,156995,3644.26559,520
Property Appraiser34805,00023,676103762,00043,00025017203,0480.143,220
Supervisor of Elections28503,00017,964147501,0002,000250812,0040.112,012
Tax Collector133428,919,00021,67893335,00028,884,000250115,53641405.34115,676
Corrections Inmate (County- separate account)99194,0001,9605112,000182,0002507280480.40776
Vault Totals2560170,301,00066,524338025,151,000145,150,000250580,60014100,60410.24681,204
* 52 weeks x 5 days = 260 days - 10 holidays = 250 days

&"Arial,Bold"25-P-131TF &"Arial,Bold"Exhibit I - Average Cash Vault Deposits

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