Exhibit_G.2_-_Tax_Collector_E-Box_Export.pdf

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