Exhibit_J.1_-_County_Average_Daily_Balances.pdf

726 KB Posted

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

About this file

Written by GovTribe AI ·

Exhibit J.1 is a financial document detailing the County Average Daily Balances for Volusia County, Florida's banking accounts over a 12-month period from June 2024 to May 2025. The exhibit provides monthly average ledger balances across five account categories: the County Pooled Cash Account, E-payables Account, Correction Inmate Account, Utility Deposit Account, and HDPP Local Participation Inmate Imprest Account. The Pooled Cash Account maintained the highest average daily balance at $7,827,833.21 monthly, followed by the HDPP Local Participation Inmate Imprest Account at $16,339,102.95 monthly, while the Correction Inmate Account averaged $96,431.99 and the Utility Deposit Account averaged $545,494.37 monthly. The E-payables Account averaged $404,129.96 monthly. These balances represent the financial activity and cash management requirements that a prospective banking services provider must accommodate under RFP #25-P-131TF.

This exhibit serves as a critical reference document for bidders responding to the County's banking services RFP, demonstrating the scale and complexity of account management across multiple fund types and operational divisions. The data illustrates that the County maintains substantial daily balances totaling approximately $93.9 million in the Pooled Cash Account alone over the 12-month period, with additional significant balances in specialized accounts requiring segregation and specialized management protocols. This financial snapshot enables prospective banking partners to assess their capacity to provide sweep arrangements, interest optimization, and efficient float management while maintaining compliance with the County's segregation of funds requirements and reporting obligations across multiple Constitutional Officers and operational entities.

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_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
Exhibit_F.4_-_Images_of_Cleared_Checks.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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

EXHIBIT J.1 COUNTY

Average Daily Balances - County

Pooled Cash Account E-payables Account Last 12 Months – June 2024 to May 2025 Last 12 Months – June 2024 to May 2025

Month Average Ledger Balance Month Average Ledger

Balance Jun-24 8,067,779.16 Jun-24 356,122.64 Jul-24 7,602,971.19 Jul-24 342,836.97 Aug-24 7,877,797.41 Aug-24 337,001.99 Sep-24 8,012,503.94 Sep-24 370,682.71 Oct-24 7,925,042.96 Oct-24 325,882.46 Nov-24 8,153,981.56 Nov-24 346,866.05 Dec-24 7,466,727.20 Dec-24 459,854.65 Jan-25 7,943,136.94 Jan-25 381,706.24 Feb-25 7,940,152.00 Feb-25 582,649.41 Mar-25 7,166,826.71 Mar-25 559,464.60 Apr-25 7,703,511.16 Apr-25 401,532.61 May-25 8,073,568.30 May-25 384,959.13 Total 93,933,998.53 Total 4,849,559.46 Monthly Average 7,827,833.21 Monthly Average 404,129.96

Correction Inmate Account Utility Deposit Account Last 12 Months – June 2024 to May 2025 Last 12 Months – June 2024 to May 2025

Month Average Ledger Balance Month Average Ledger

Balance Jun-24 97,097.18 Jun-24 552,534.50 Jul-24 114,025.91 Jul-24 551,881.08 Aug-24 110,762.48 Aug-24 549,856.56 Sep-24 118,005.78 Sep-24 551,188.50 Oct-24 110,096.32 Oct-24 550,914.62 Nov-24 92,755.87 Nov-24 549,020.50 Dec-24 87,482.72 Dec-24 546,350.91 Jan-25 114,516.44 Jan-25 542,772.85 Feb-25 88,162.26 Feb-25 538,912.96 Mar-25 93,560.81 Mar-25 538,308.82 Apr-25 63,937.34 Apr-25 539,308.00 May-25 66,780.72 May-25 534,883.17 Total 1,157,183.83 Total 6,545,932.47 Monthly Average 96,431.99 Monthly Average 545,494.37

25-P-131TF

EXHIBIT E-1.1 COUNTY

HDPP Local Participation Inmate Imprest Account Last 12 Months – June 2024 to May 2025 Last 12 Months – June 2024 to May 2025

Month Average Ledger Balance Month Average Ledger

Balance Jun-24 1,418,384.63 Jun-24 46,668.87 Jul-24 816,654.18 Jul-24 45,960.73 Aug-24 817,257.43 Aug-24 47,358.72 Sep-24 817,815.79 Sep-24 47,196.69 Oct-24 23,780,340.36 Oct-24 47,169.71 Nov-24 47,825,506.13 Nov-24 46,228.80 Dec-24 48,151,946.15 Dec-24 45,642.95 Jan-25 48,177,772.97 Jan-25 45,464.03 Feb-25 13,217,224.07 Feb-25 47,064.01 Mar-25 3,680,610.03 Mar-25 45,924.02 Apr-25 3,682,037.48 Apr-25 46,759.25 May-25 3,683,686.19 May-25 45,777.88 Total 196,069,235.41 Total 557,215.66 Monthly Average 16,339,102.95 Monthly Average 46,434.64

Sheet1

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