Exhibit_F.4_-_Images_of_Cleared_Checks.pdf

PDF 123 KB Posted

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

About this file

Exhibit F.4 is a technical specification document for Volusia County, Florida's banking services RFP #25-P-131TF that details the data format and file structure for cleared check processing and archival. The document outlines a comma-separated value (CSV) index file format with fixed-width columns containing cleared check metadata, including account number, check number, check amount, record number, and a CIMS key that encodes bank cycle information, transaction date, and bank-specific codes. The cleared check image files are generated using a 20-character TIFF filename derived from the CIMS key, with specific character positions designating the year (characters 1-4), month and day (characters 5-8), and bank codes (characters 9-18). Sample data rows and corresponding TIFF filenames are provided as reference examples for implementing the cleared check imaging and retrieval system.

This technical exhibit establishes the data integration requirements for the selected banking services provider to maintain compatibility with Volusia County's existing check processing and archive systems. The specification ensures that cleared check images can be systematically indexed, retrieved, and reconciled through a standardized naming convention and metadata structure, supporting the county's monthly reconciliation services and financial record management requirements across its pooled cash accounts and multiple specialized banking functions.

View the file

Other files

File Type Posted
Banking_Services_(Addendum_#6_Revision).pdf PDF
Banking_Services.pdf PDF
Exhibit_Z_-_Exhibit_C_-_Insurance_Requirements_(FOR_DRAFT_CONTRACT).pdf PDF
Exhibit_Z_-_SAMPLE_-_DRAFT_Contract.pdf PDF
Exhibit_J.4_-_Tax_Collector_Average_Daily_Balances.pdf PDF
Exhibit_J.3_-_Property_Appraiser_Average_Daily_Balances.pdf PDF
Exhibit_J.2_-_Elections_Average_Daily_Balances.pdf PDF
Exhibit_J.1_-_County_Average_Daily_Balances.pdf PDF
Exhibit_I_-_Average_Cash_Vault_Deposits.xlsx XLSX spreadsheet
Exhibit_H_-_County_Computing_Security_Procedures.pdf PDF
Exhibit_G.5_-_Cash_Receipts_Data_File.xlsx XLSX spreadsheet
Exhibit_G.4_-_Bank_Reconciliation_Data_File.xlsx XLSX spreadsheet
Exhibit_G.3_-_ICL_File_Format.pdf PDF
Exhibit_G.2_-_Tax_Collector_E-Box_Export.pdf PDF
Exhibit_G.1_-_E-Box_Remittance_Report.pdf PDF
Exhibit_F.4_-_Images_of_Cleared_Checks.pdf PDF
Exhibit_F.3_-_Cleared_Check_Data_File_Format.pdf PDF
Exhibit_F.2_-_Positive_Pay_Format.pdf PDF
Exhibit_F.1_-_EFT_File_Format.pdf PDF
Exhibit_E.4_-_Tax_Collector_Bank_Accounts.pdf PDF
Exhibit_E.3_-_Property_Appraiser_Bank_Accounts.pdf PDF
Exhibit_E.2_-_Elections_Bank_Accounts.pdf PDF
Exhibit_E.1_-_County_Bank_Accounts.pdf PDF
Exhibit_D_-_Human_Trafficking_Affidavit_FINAL_(TO_BE_COMPLETED).pdf PDF
Exhibit_C_-_Required_Types_and_Limits_of_Insurance_Chart.pdf PDF
Exhibit_B.3_-_One-Time_Transition_Costs_and_Cost_Offsets_(4_TABS_TO_COMPLETE).xlsx XLSX spreadsheet
Exhibit_B.2_-_Net_Earnings_Chart_(4_TABS_TO_COMPLETE).xlsx XLSX spreadsheet
Exhibit_B.1.A_-_Appendix,_Services_Descriptions.xlsx XLSX spreadsheet
Exhibit_B.1_-_Pricing_Services_Chart_(1st_TAB_TO_COMPLETE_ONLY).xlsx XLSX spreadsheet
Exhibit_A.3_-_Technical_Requirements_Form_(TO_BE_COMPLETED).docx DOCX document
Exhibit_A.2_-_Technical_Requirements_Matrix_(1_TAB_TO_COMPLETE).xlsx XLSX spreadsheet
Exhibit_A.1_-_Banking_Service_Processes_(TO_BE_COMPLETED).docx DOCX document
Exhibit_A_-_Scope_of_Services.pdf PDF
PRIME-SUB_FORM_for_Contractors_rev._01.15.2025_(lock_before_publishing).xls XLS spreadsheet
Show all 34

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.4 - Images of Cleared Checks

Index of Cleared Checks Overview Text file in Comma Separated Value format containing data to be associated with images of cleared checks.

Columns are fixed width as well. Line terminators are Line Feed (New Line) characters.

Cleared Check Index File Field Name Type Field Width Note

ACCNO Text 13 Account Number COMMA Text 1 - SER_NO Text 10 Check Number COMMA Text 1 - ITM_AM Text 16 Check Amount (No decimal point) COMMA Text 1 - ITEM_NUM Text 5 Record number within the file COMMA Text 1 -

CIMS_KEY Text 35

Date String

– Period Separated

– Used to build image file name

ELRC - Code for Bank Use (not used at Volusia)

C## - Cycle Number Filename Characters 19-20

Y#### - Year Filename characters 1-4

MD#### - Month and Day Zero padded to 2 characters each Filename Characters 5-8

S##### - Code for Bank use Filename Characters 9-13

S##### - Code for Bank use Filename Characters 14-18

Sample 0009999999999,0001005223,0000000000095036,01241,ELRC.C05.Y2016.MD0701.S06528.S29437 0009898989898,0000760001,0000000000005559,02185,ELRC.C05.Y2016.MD0715.S50921.S24866

Cleared Check Image File Name Samples (matching sample data rows above) 20160701065282943705.tiff 20160715509212486605.tiff

Index of Cleared Checks
Overview
Cleared Check Index File
Sample
Cleared Check Image File Name Samples (matching sample data rows above)

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