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 - Average Cash Vault Deposits Summary

Exhibit I is a financial analysis document supporting Volusia County's RFP #25-P-131TF for comprehensive banking services, detailing average daily cash vault deposit volumes for the County and its Constitutional Officers (Property Appraiser, Supervisor of Elections, and Tax Collector) for the period June 1, 2024 through May 31, 2025. The exhibit presents critical transaction data across multiple county entities, including the County itself, Property Appraiser, Supervisor of Elections, Tax Collector, and the Corrections Inmate Fund account. The analysis encompasses 2,560 total annual deposits totaling $170,301,000, with 3,380 checks valued at $25,151,000 and cash deposits of $145,150,000, calculated across 250 banking days (52 weeks minus 10 holidays). The County represents the largest volume component with 1,065 annual deposits averaging $131,343 per deposit, followed by the Tax Collector with 1,334 deposits averaging $21,678. Performance metrics include an average daily cash vault volume of $580,600, an average of 14 daily check items, and an average of 10.24 total daily deposits.

The exhibit establishes baseline transaction volumes and deposit patterns essential for evaluating bidder capabilities to manage the County's banking infrastructure. The data demonstrates significant cash flow concentration within the Tax Collector ($28,884,000 annual cash) and County operations ($116,039,000 annual cash), requiring banks to demonstrate processing capacity for high-volume deposit operations. These metrics inform the bank selection process for managing multiple specialized accounts, ensuring float elimination, and optimizing interest earnings through appropriate sweep arrangements and vault processing capabilities within the specified Florida banking geography.

View the file

Other files

File Type Posted
Banking_Services_(Addendum_#6_Revision).pdf PDF
Banking_Services_(Addendum_#6_Revision).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_A_-_Scope_of_Services.pdf PDF
Exhibit_B.1_-_Pricing_Services_Chart_(1st_TAB_TO_COMPLETE_ONLY).xlsx XLSX spreadsheet
Exhibit_B.2_-_Net_Earnings_Chart_(4_TABS_TO_COMPLETE).xlsx XLSX spreadsheet
Exhibit_E.1_-_County_Bank_Accounts.pdf PDF
Exhibit_F.1_-_EFT_File_Format.pdf PDF
Exhibit_F.3_-_Cleared_Check_Data_File_Format.pdf PDF
Exhibit_G.1_-_E-Box_Remittance_Report.pdf PDF
Exhibit_G.3_-_ICL_File_Format.pdf PDF
Exhibit_H_-_County_Computing_Security_Procedures.pdf PDF
Exhibit_C_-_Required_Types_and_Limits_of_Insurance_Chart.pdf PDF
Exhibit_E.1_-_County_Bank_Accounts.pdf PDF
Exhibit_E.2_-_Elections_Bank_Accounts.pdf PDF
Exhibit_E.4_-_Tax_Collector_Bank_Accounts.pdf PDF
Exhibit_F.2_-_Positive_Pay_Format.pdf PDF
Exhibit_F.3_-_Cleared_Check_Data_File_Format.pdf PDF
Exhibit_G.1_-_E-Box_Remittance_Report.pdf PDF
Exhibit_Z_-_Exhibit_C_-_Insurance_Requirements_(FOR_DRAFT_CONTRACT).pdf PDF
Exhibit_A.2_-_Technical_Requirements_Matrix_(1_TAB_TO_COMPLETE).xlsx XLSX spreadsheet
Exhibit_B.2_-_Net_Earnings_Chart_(4_TABS_TO_COMPLETE).xlsx XLSX spreadsheet
Exhibit_C_-_Required_Types_and_Limits_of_Insurance_Chart.pdf PDF
Exhibit_E.1_-_County_Bank_Accounts.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_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
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 .