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 average daily ledger balances for multiple County accounts managed by Volusia County, Florida for the 12-month period from June 2024 through May 2025. The exhibit provides monthly and annual balance data across five distinct account categories: the County Pooled Cash Account, E-payables Account, Correction Inmate Account, Utility Deposit Account, and County HDPP Local Participation Inmate Imprest Account. The County Pooled Cash Account maintained the largest average monthly balance of $7,827,833.21, with total 12-month balances of $93,933,998.53, while the Utility Deposit Account averaged $545,494.37 monthly. The Correction Inmate Account and E-payables Account averaged $96,431.99 and $404,129.96 monthly, respectively, with total balances of $1,157,183.83 and $4,849,559.46. The County HDPP Local Participation Inmate Imprest Account showed significant variance throughout the period, averaging $16,339,102.95 monthly with total balances of $196,069,235.41, reflecting substantial deposits during October 2024 through January 2025. The Inmate Imprest Account averaged only $46,434.64 monthly with total balances of $557,215.66.

This financial exhibit supports the banking services RFP #25-P-131TF by demonstrating the substantial transaction volumes and account management complexity required of the selected banking partner. The combined average daily balances across all County accounts total approximately $25,254,921.48 monthly, illustrating the significant cash management and liquidity requirements the successful bank must accommodate. These balance figures directly inform the banking partner's ability to provide sweep arrangements, maximize interest earnings, and manage the multiple specialized accounts outlined in the RFP scope of services.

View the file

Other files

File Type Posted
Banking_Services_(Addendum_#6_Revision).pdf PDF
Banking_Services_(Addendum_#6_Revision).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
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
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 .