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 detailed financial document for the County of Volusia, Florida, presenting average cash vault deposit volumes for various county entities, including the County, Property Appraiser, Supervisor of Elections, Tax Collector, and Corrections Inmate accounts. The exhibit covers a proposed banking services contract period from June 1, 2024, to May 31, 2025, with calculations based on 250 banking days. The document provides comprehensive data on annual deposit amounts, number of deposits, cash and check volumes, and daily averages across multiple county departments.

The financial data reveals significant annual transaction volumes, with the County's main account processing approximately $139,880,000 in total deposits, including $116,039,000 in cash and $23,841,000 in checks. The Tax Collector's account shows $28,919,000 in total deposits, predominantly in cash ($28,884,000), while smaller constitutional officer accounts like the Property Appraiser and Supervisor of Elections have more modest transaction volumes. The exhibit supports the broader banking services RFP by providing granular detail on the county's financial transaction patterns, which will be critical for potential banking service providers in understanding the scope and complexity of the county's banking needs.

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_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.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
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 .