Exhibit_G.2_-_Tax_Collector_E-Box_Export.pdf

PDF 179 KB Posted

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

About this file

This is a technical specification exhibit for an electronic payment processing system serving Volusia County, Florida's Tax Collector under RFP #25-P-131TF. The document defines the Bank Export for Tax Collector Software (TaxSys) requirements, establishing a comprehensive electronic payment processing service that enables the Tax Collector to identify and post payments to property tax accounts. The system supports taxpayer-initiated automatic payments where customers authorize their bank to pay annual tax bills directly from their accounts, with funds remitted to the Tax Collector's pooled cash account on specified due dates. The Bank shall provide an electronic file transmission system such as an E-box or equivalent that securely transmits detailed payment information including transaction details, taxpayer account information, payee information, and payment confirmation data. The structured data files must integrate directly into the tax collection system for automated posting and record updates, with daily transmission of files—including empty files when no transactions occur—to ensure consistent data flow and system synchronization.

The technical specification details the required file format and data structure for bank exports, including header records, billing data records, payment data records, and footer records with specific field definitions, data types, and field sizes. The header record contains record type (H1), Julian date, and standard date in mm/dd/yyyy format. Billing data records include record type (BD), Julian date, bill ID (combining 8-character date as yyyymmdd and 8-digit bill number), bill type indicators (ranging from current tax payments to other payment types), alternate key (Property Appraiser's ID), tax year, and amount with implied decimal. Payment data records capture record type (PD), Julian date, bill ID, payment ID from E-box, and amount. The footer record provides final counts of billing and payment data records plus the total E-box deposit amount. This streamlined process ensures timely, accurate payment posting while reducing manual processing requirements for the Tax Collector's office.

View the file

Other files

File Type Posted
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
Exhibit_F.4_-_Images_of_Cleared_Checks.pdf PDF
Exhibit_G.2_-_Tax_Collector_E-Box_Export.pdf PDF
Exhibit_G.3_-_ICL_File_Format.pdf PDF
Exhibit_J.2_-_Elections_Average_Daily_Balances.pdf PDF
Exhibit_J.4_-_Tax_Collector_Average_Daily_Balances.pdf PDF
Exhibit_Z_-_Exhibit_C_-_Insurance_Requirements_(FOR_DRAFT_CONTRACT).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_A_-_Scope_of_Services.pdf PDF
Exhibit_B.1_-_Pricing_Services_Chart_(1st_TAB_TO_COMPLETE_ONLY).xlsx XLSX spreadsheet
Exhibit_B.2_-_Net_Earnings_Chart_(4_TABS_TO_COMPLETE).xlsx XLSX spreadsheet
Exhibit_E.1_-_County_Bank_Accounts.pdf PDF
Exhibit_F.1_-_EFT_File_Format.pdf PDF
Exhibit_F.3_-_Cleared_Check_Data_File_Format.pdf PDF
Exhibit_G.1_-_E-Box_Remittance_Report.pdf PDF
Exhibit_G.3_-_ICL_File_Format.pdf PDF
Exhibit_H_-_County_Computing_Security_Procedures.pdf PDF
Exhibit_C_-_Required_Types_and_Limits_of_Insurance_Chart.pdf PDF
Exhibit_E.1_-_County_Bank_Accounts.pdf PDF
Exhibit_E.2_-_Elections_Bank_Accounts.pdf PDF
Exhibit_E.4_-_Tax_Collector_Bank_Accounts.pdf PDF
Exhibit_F.2_-_Positive_Pay_Format.pdf PDF
Exhibit_F.3_-_Cleared_Check_Data_File_Format.pdf PDF
Exhibit_G.1_-_E-Box_Remittance_Report.pdf PDF
Exhibit_Z_-_Exhibit_C_-_Insurance_Requirements_(FOR_DRAFT_CONTRACT).pdf PDF
Exhibit_A.2_-_Technical_Requirements_Matrix_(1_TAB_TO_COMPLETE).xlsx XLSX 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 G.2 - Tax Collector E-Box Export

Bank Export for Tax Collector Software - TaxSys

The Bank shall provide a comprehensive electronic payment processing service that enables the Tax Collector to efficiently identify and post payments to customers' property tax accounts. This bill pay service includes support for taxpayer-initiated automatic payments where customers authorize their bank to pay annual tax bills directly from their accounts, with funds remitted to the Tax Collector's pooled cash account on specified due dates.

The Bank shall provide an electronic file transmission system (such as Ebox or equivalent) that securely transmits detailed payment information including transaction details, taxpayer account information, payee information, and payment confirmation data.

The system will allow taxpayers to establish bill pay services using their property account information and authorize payments through their banking institution. Upon payment processing, the Bank shall transmit a structured data file to the Tax Collector that can be integrated directly into the tax collection system for automated posting and record updates.

The Bank shall transmit these electronic files daily, including empty files when no transactions have occurred, to ensure consistent data flow and system synchronization.

This streamlined process ensures timely, accurate payment posting while reducing manual processing requirements for the Tax Collector's office.

Header Record

Field Name Data Type Field Size Description RECORD TYPE Char 2 Hard coded “H1” JULIAN DATE Char 3 Three characters

DATE Char 10 mm/dd/yyyy format

Billing Data Record

RECORD TYPE Char 2 Hard coded “BD” JULIAN DATE Char 3 Three characters

BILL ID Char 16

• 8-Character Date as yyyymmdd

• 8-Digit Bill Number – Serial number

BILL TYPE Char 1

• "1" means Current Tax Payment

• "2" Tangible Tax Payment

• "3" Delinquent (not accepted in

EBox)

• "4" means Installment (partial payment)

• "5" Means Other Payment Type

25-P-131TF Exhibit G.2 - Tax Collector E-Box Export

ALTERNATE KEY Char 7 Property Appraiser’s ID for parcel or other taxable item

TAX YEAR Char 4 Four digit year of the tax bill that is being paid

AMOUNT Char Variable Implied Decimal

Payment Data Record Field Layout

RECORD TYPE Char 2 Hard coded “PD” JULIAN DATE Char 3 Three characters

BILL ID Char 16

• 8-Character Date as yyyymmdd

• 8-Digit Bill Number – Serial number PAYMENT ID Char 15 Payment Identifier from EBox

AMOUNT Char Variable • Variable Width

• Implied Decimal

Footer (End File) Record Field Layout

RECORD TYPE Char 1 Hardcoded “F1” for Total JULIAN DATE Char 3 Three characters

BD COUNT Char Variable Count of Billing Data records PD COUNT Char Variable Count of Payment Data records

FILE TOTAL Char Variable Total EBOX Deposit to Tax Collector account

Source file example:

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

Bank Export for Tax Collector Software - TaxSys

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