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

This is an Exhibit document detailing cleared check image specifications and filing standards for Volusia County, Florida's banking services procurement (RFP #25-P-131TF). The document provides technical specifications for a Comma Separated Value (CSV) format index file that catalogues cleared check images, establishing the data structure and file naming conventions required for check processing and archival. The index file contains five fixed-width fields: Account Number (13 characters), Check Number (10 characters), Check Amount in cents without decimal points (16 characters), Record Item Number (5 characters), and a CIMS Key date string (35 characters) used to construct image filenames. Corresponding cleared check image files are named using a 20-character TIFF format derived from the CIMS Key data, with filename structure incorporating year, month, day, and bank-specific codes (characters 1-4 for year, 5-8 for month/day zero-padded, and 9-13 and 14-18 for bank-specific codes). The document provides sample data rows and corresponding image filenames to illustrate the required format and naming conventions for the selected banking partner's clearing and reconciliation processes.

This exhibit establishes the technical infrastructure requirements for managing cleared check documentation within Volusia County's banking operations, ensuring standardized data formatting and image file organization across the banking relationship. The specifications demonstrate the County's emphasis on systematic reconciliation and record-keeping capabilities as outlined in the broader RFP requirements for monthly reconciliation services and comprehensive account management for County operations and Constitutional Officer accounts.

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 .