Exhibit_F.3_-_Cleared_Check_Data_File_Format.pdf

Exhibit F.3 is a technical specification document for Volusia County, Florida's banking services procurement (RFP #25-P-131TF), detailing the data file format requirements for cleared check processing. The document specifies a fixed-width text file format that banks must use to transmit cleared check data downloaded from their systems for upload into the County's financial system. Each data record contains ten fields with predetermined sizes: a 10-character account number, 3 blank spaces, a 10-character check number, a 12-character check amount in non-decimal format, and an 8-character check date. The footer record contains a record type indicator, account number, 22 blank spaces, a 12-character summary amount field with left-padded zeros, and a 10-character record count field also left-padded with zeros. An example file structure is provided showing multiple check records followed by a total record, demonstrating the practical application of this format for processing County and Constitutional Officer accounts.

This technical specification is a supporting exhibit within a comprehensive five-year banking services agreement (with potential five-year renewal options) for Volusia County and its Constitutional Officers, including the Property Appraiser, Supervisor of Elections, and Tax Collector. The cleared check data file format represents one component of the County's requirement for modern technological integration with banking services, supporting the processing of approximately $139,880,000 in annual deposits and enabling efficient reconciliation of the extensive transaction volumes across multiple specialized accounts including Pooled Cash, Accounts Payable, Payroll, and Utility Payment accounts.