Attachment_A_-_Bill_Count_FY24.xlsx

XLSX spreadsheet 23 KB Posted

Attached to
Utility Billing and Lockbox Services State and local contract opportunity
Solicitation number
13-25
Issued by
Pinellas County, Clewiston City, Florida

About this file

The file is an Excel spreadsheet detailing monthly utility bill counts for the City of Clearwater's Utility Customer Service Department for fiscal year 2024, spanning October 2023 to September 2024. The document provides a comprehensive breakdown of mailed and unmailed bills, including regular bills, direct debit bills, and final debits. The data shows an average of 50,305 regular mailed bills, 13,007 direct debit bills, and 86 final debit bills per month, with a total of 867,716 bills processed during the fiscal year. The spreadsheet indicates a current paperless billing rate of 32.85%, representing an 8% increase from the previous year.

The billing data reveals consistent monthly processing volumes, with slight variations across different months. Key metrics include an average of 71,315 total bills processed monthly, with 7,774 past due reminders and 144 final bill notices. The document highlights the utility's efforts to increase digital billing, with paperless bills growing to nearly one-third of total billings. This data supports the related state and local contract opportunity for utility billing and lockbox services in Clearwater, Florida, demonstrating the operational scale and complexity of the city's utility billing process and potential vendor requirements for managing these services.

View the file

Other files for this state and local contract opportunity

Other files attached to Utility Billing and Lockbox Services, newest first.
File Type Posted
Attachment_G_-_Recent_Invoices.pdf PDF
Billing_Samples_and_Envelopes_without_black-out.pdf PDF
Attachment_E_-_Catalis_November_Statement.pdf PDF
Attachment_D_-_InfoSend_December_Statement.pdf PDF
Utility_Billing_and_Lockbox_Services.pdf PDF
Attachment_B_-_LockBox_Data_FY24.xlsx XLSX spreadsheet
Attachment_C_-_Billing_Samples_and_Envelopes.pdf PDF

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Sheet1

Bill Count October 2023 to September 2024
Mailed BillsUnmailed Bills (Pulls)
MonthRegular BillsDirect DebitFinal DebitsTotal Regular Bill FilePast DueReminder FinalsTotal Mailed BillsBill DateCity BillsFinal CreditsTotal Unmailed BillsBill DateTotal Printed BillsPaperless Bills
October-2348,28412,6505960,9937,85014668,989Oct-23532239771Oct-2369,76029,85432.88%
November-2348,85412,7006261,6167,88610669,608Nov-23569245814Nov-2370,42229,23132.20%
December-2352,03413,3715665,4618,06311573,639Dec-23571209780Dec-2374,41930,94232.12%
January-2451,74113,0735264,8668,85211473,832Jan-24572212784Jan-2474,61630,47531.98%
February-2448,08912,5095860,6566,92011367,689Feb-24682217899Feb-2468,58830,50133.48%
March-2448,87913,0447061,9937,49011669,599Mar-24573286859Mar-2470,45830,58433.06%
April-2450,65813,32734464,3297,48014071,949Apr-2457421362710Apr-2474,65932,11733.42%
May-2451,42013,2738364,7768,28622473,286May-24566227793May-2474,07931,85532.99%
June-2451,38813,0176864,4735,98713870,598Jun-24567229796Jun-2471,39431,53832.87%
July-2450,64013,0326263,7347,98916071,883Jul-2410002151215Jul-2473,09832,14333.55%
August-2450,93213,0265064,0088,11220972,329Aug-24572194766Aug-2473,09532,15833.46%
September-2450,73513,0626563,8628,37414872,384Sep-24565179744Sep-2473,12830,28932.19%
Totals603,654156,0841,029760,76793,2891,729855,785Totals7,3434,58811,931Total867,716371,687
Average per Month50,30513,0078663,3977,77414471,315Average612382994
% of paperless billed32.85%
Mailed Bills
Regular Bills: Average 50,305 per month. Mailed with return envelope and Sunshine Lines
Direct Debit Bills: Average 13,007 per month. Mailed with Sunshine Lines
Final Debits: Average 86 per month. Mailed with return envelope
Unmailed Bills (returned to UCS for further processing)
Final Credits: Average 382
Misc Pulls: Are deducted from regular bills

Current Percentage of Paperless - 32.85% with increase of 8% in last year

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