Exhibit_F.3_-_Cleared_Check_Data_File_Format.pdf

PDF 117 KB Posted

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

About this file

This is a technical specification document for Volusia County, Florida's banking services procurement (RFP #25-P-131TF), detailing the cleared check data file format requirements that successful banking vendors must support. The document specifies a fixed-width text file format downloaded from the bank website for uploading into the County's financial system to clear checks, with distinct data records and footer records containing check information and summary totals. The data record layout includes ten fields: account number (10 characters), three blank spaces, check number (10 characters), check amount in non-decimal format (12 characters), and check date (8 characters). The footer record contains a record type identifier, account number, twenty-two blank spaces, summary amount left-padded with zeros (12 characters), and record count left-padded with zeros (10 characters). The specification includes a source file example demonstrating the proper formatting for six sample check records with a total summary line, illustrating how the County's existing banking infrastructure processes and reconciles check clearing data across County and Constitutional Officer accounts.

This technical specification is one component of the comprehensive banking services procurement and establishes mandatory data exchange standards that bidding financial institutions must implement to support the County's monthly reconciliation services and check clearing operations. The format applies to both County and Constitutional Officer banking relationships, ensuring standardized data handling across multiple government entities served under the five-year contract with potential five-year renewal options. Compliance with this specific file format is essential for vendors to integrate with Volusia County's existing financial systems and support the processing of the County's substantial transaction volumes, including approximately $139,880,000 in annual deposits.

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

Text version

25-P-131TF Exhibit F.3 - Cleared Check Data File Format

Cleared Check Data File

Text file in fixed-width format containing data to be associated with cleared checks. This file is downloaded from the bank website and is used to upload in the financial system to clear checks. Each field is a set size for all records except the “end-file” (last) record which includes the total number of checks in the file. This file format is used for the County and Constitutional Officer’s.

Data Record Field Layout

Field Name Data Type Field Size Description ACCOUNT_NUM Char 10 The account number the check is drawn on.

FILL1 Char 3 Three blank spaces

CHECK_NUM Char 10 The number of the check

CHECK_AMT Number 12 The amount of the check in non-decimal format (i.e., 12345 in raw data is interpreted as 123.45)

CHECK_DATE Date 8 Date the check was written

Footer (End File) Record Field Layout

Field Name Data Type Field Size Description RECORD TYPE Char 1 Hardcoded “T” for Total

ACCOUNT_NUM Char 10 The account number the check is drawn on.

FILL1 Char 22 Twenty-two blank spaces

SUMMARY AMOUNT Char 12 Implied decimal Left-padded with zeroes

RECORD COUNT Char 10 Count of data lines Left-padded with zeros

Source file example:

4943371302 000010528900000002898520250822 4943371302 000010529000000003050020250814 4943371302 000010529100000049494220250807 4943371302 000010529200000043037720250807 4943371302 000010529300000010800020250811 4943371302 000010529400000000364120250812 T4943371302 0000010964450000000006

Cleared Check Data File

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