Attachment_B_-_LockBox_Data_FY24.xlsx

The document is an Excel spreadsheet titled "Attachment_B_-_LockBox_Data_FY24.xlsx" from the City of Clearwater, Florida, detailing monthly lockbox payment processing data for Fiscal Year 2024. The spreadsheet provides a comprehensive breakdown of utility bill payment items and amounts processed from October 2023 through September 2024, tracking 94,356 total items annually with a total processed amount of $50,617,010.06. The monthly average is 7,863 items processed, representing approximately 12.70% of items and 25.82% of payment amounts through the lockbox service.

The data correlates with the related state and local contract opportunity for Utility Billing and Lockbox Services, which seeks a vendor to manage utility billing processes including printing, processing, mailing, and daily collection of mailed utility bill payments. The lockbox data demonstrates consistent monthly processing volumes, with slight variations between months, ranging from 6,788 items in June to 8,593 items in January. The monthly processed amounts fluctuate between $3,763,541.46 in September and $4,633,841.84 in January, indicating a stable and predictable payment processing environment for the City of Clearwater's utility billing system.