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
| File | Type | Posted |
|---|---|---|
| Attachment_G_-_Recent_Invoices.pdf | ||
| Billing_Samples_and_Envelopes_without_black-out.pdf | ||
| Attachment_E_-_Catalis_November_Statement.pdf | ||
| Attachment_D_-_InfoSend_December_Statement.pdf | ||
| Utility_Billing_and_Lockbox_Services.pdf | ||
| Attachment_B_-_LockBox_Data_FY24.xlsx | XLSX spreadsheet | |
| Attachment_C_-_Billing_Samples_and_Envelopes.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 Bills | Unmailed Bills (Pulls) | ||||||||||||||
| Month | Regular Bills | Direct Debit | Final Debits | Total Regular Bill File | Past Due | Reminder Finals | Total Mailed Bills | Bill Date | City Bills | Final Credits | Total Unmailed Bills | Bill Date | Total Printed Bills | Paperless Bills | |
| October-23 | 48,284 | 12,650 | 59 | 60,993 | 7,850 | 146 | 68,989 | Oct-23 | 532 | 239 | 771 | Oct-23 | 69,760 | 29,854 | 32.88% |
| November-23 | 48,854 | 12,700 | 62 | 61,616 | 7,886 | 106 | 69,608 | Nov-23 | 569 | 245 | 814 | Nov-23 | 70,422 | 29,231 | 32.20% |
| December-23 | 52,034 | 13,371 | 56 | 65,461 | 8,063 | 115 | 73,639 | Dec-23 | 571 | 209 | 780 | Dec-23 | 74,419 | 30,942 | 32.12% |
| January-24 | 51,741 | 13,073 | 52 | 64,866 | 8,852 | 114 | 73,832 | Jan-24 | 572 | 212 | 784 | Jan-24 | 74,616 | 30,475 | 31.98% |
| February-24 | 48,089 | 12,509 | 58 | 60,656 | 6,920 | 113 | 67,689 | Feb-24 | 682 | 217 | 899 | Feb-24 | 68,588 | 30,501 | 33.48% |
| March-24 | 48,879 | 13,044 | 70 | 61,993 | 7,490 | 116 | 69,599 | Mar-24 | 573 | 286 | 859 | Mar-24 | 70,458 | 30,584 | 33.06% |
| April-24 | 50,658 | 13,327 | 344 | 64,329 | 7,480 | 140 | 71,949 | Apr-24 | 574 | 2136 | 2710 | Apr-24 | 74,659 | 32,117 | 33.42% |
| May-24 | 51,420 | 13,273 | 83 | 64,776 | 8,286 | 224 | 73,286 | May-24 | 566 | 227 | 793 | May-24 | 74,079 | 31,855 | 32.99% |
| June-24 | 51,388 | 13,017 | 68 | 64,473 | 5,987 | 138 | 70,598 | Jun-24 | 567 | 229 | 796 | Jun-24 | 71,394 | 31,538 | 32.87% |
| July-24 | 50,640 | 13,032 | 62 | 63,734 | 7,989 | 160 | 71,883 | Jul-24 | 1000 | 215 | 1215 | Jul-24 | 73,098 | 32,143 | 33.55% |
| August-24 | 50,932 | 13,026 | 50 | 64,008 | 8,112 | 209 | 72,329 | Aug-24 | 572 | 194 | 766 | Aug-24 | 73,095 | 32,158 | 33.46% |
| September-24 | 50,735 | 13,062 | 65 | 63,862 | 8,374 | 148 | 72,384 | Sep-24 | 565 | 179 | 744 | Sep-24 | 73,128 | 30,289 | 32.19% |
| Totals | 603,654 | 156,084 | 1,029 | 760,767 | 93,289 | 1,729 | 855,785 | Totals | 7,343 | 4,588 | 11,931 | Total | 867,716 | 371,687 |
| Average per Month | 50,305 | 13,007 | 86 | 63,397 | 7,774 | 144 | 71,315 | Average | 612 | 382 | 994 |
| % of paperless billed | 32.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 .