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 ·

This document is Exhibit J.1 and Exhibit E-1.1 from a County financial report detailing average daily balances across multiple accounts for the period of June 2024 to May 2025. The exhibits include financial data for four specific accounts: Pooled Cash Account, E-payables Account, Correction Inmate Account, Utility Deposit Account, HDPP Local Participation, and Inmate Imprest Account.

The financial tables reveal significant variations in average monthly balances across different accounts. The Pooled Cash Account maintains a monthly average balance of $7,827,833.21, while the HDPP Local Participation account shows dramatic fluctuations, with balances ranging from $816,654.18 in July 2024 to $48,177,772.97 in January 2025. The Utility Deposit Account remains relatively stable, with a monthly average of $545,494.37, and the Inmate Imprest Account maintains a consistent monthly average of $46,434.64. These detailed financial records provide a comprehensive overview of the county's cash management and account balances across various operational funds.

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