FM_UB_ATT_12_Reports_v2.xlsx
XLSX spreadsheet 14 KB Posted
- Solicitation number
- RFP 26-106
- Issued by
- Lee County, Fort Lauderdale City, Florida
About this file
This is an attachment to a Request for Proposals for professional implementation services related to a new Utility Billing System for the City of Fort Myers, Florida. The document specifies reporting requirements for the utility billing system across 44 distinct functional reports organized by report type, ranging from Prior Accounts with Outstanding Balances to Account and Meter Conditions Reports. Reports are categorized as either Standard Reports (SR) or Custom Reports (CR), with vendors required to indicate in their proposals whether each report will be in scope, included in the price, and the estimated consultant and client work effort in hours required for implementation. Key reporting categories include meter reading and consumption analysis, customer account management, billing and payment processing, collections management, audit trails and compliance reporting, revenue analysis, and waste collection operations.
The attachment serves as a vendor response section where proposers must evaluate each of the 44 specified reports and indicate their feasibility within the proposed solution. Vendors are required to provide work effort estimates for custom reports and specify whether reports will be included in their proposed pricing. This standardized reporting matrix enables the City to assess vendor capabilities systematically and compare proposals on a consistent basis across all functional requirements for the Oracle Utilities Billing system implementation.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Professional_Implementation_Services_for_Oracle_Utilities_Billing_(Addendum_#4_Revision).pdf | ||
| Professional_Implementation_Services_for_Oracle_Utilities_Billing_(Addendum_#1_Revision).pdf | ||
| Fort_Myers_UB_RFP_09_18_26.pdf | ||
| FM_UB_ATT_9_Conversions_v1.xlsx | XLSX spreadsheet | |
| FM_UB_ATT_6_Project_Expectations.pdf | ||
| FM_UB_ATT_10_Cost.xlsx | XLSX spreadsheet | |
| FM_UB_ATT_11_Interface_List.xlsx | XLSX spreadsheet | |
| FM_UB_ATT_7_Functional_Requirements_v2.xlsx | XLSX spreadsheet | |
| FM_UB_ATT_8_Project_Staffing.xlsx | XLSX spreadsheet | |
| FM_UB_ATT_1_Signature_Page.pdf | ||
| FM_UB_ATT_3_Prof_Svcs_Background.pdf | ||
| INSURANCE_REQUIREMENTS_CHART.pdf | ||
| FM_UB_ATT_5_Technology_Deployment.pdf | ||
| FM_UB_ATT_2_Proposer_Statement.pdf | ||
| FM_UB_ATT_4_Prof_Svcs_Reference_v1.pdf |
Show all 15
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
Reports
| Utility Billing - City of Fort Myers, FL | |||||
| Attachment 12 (Reports) | |||||
| Column D: Available Responses | |||||
| SR | Standard Reports | ||||
| CR | Custom Reports | ||||
| Note: Please specify the estimated number of hours needed for all custom reports in column E and F. | |||||
| Vendor Response Section | |||||
| Function | Functional Requirement # | Description of Report | Type of Report | ||
| SR, CR | Consultant Work Effort (in hours) | Client Work Effort (in hours) | In Scope? (Y/N) | Included in Price (Y/N) | Comments |
| UB | 11 | Prior Accounts with Outstanding Balances Report — inquiry and reporting on prior accounts with outstanding balances. | |||
| UB | 75 | Meter Reading Edit and Reread Exception Report — review accounts with an edit report and identify readings outside parameters for rereading. | |||
| UB | 86 | Meter Readings and Consumption Report — readings and consumption by cycle, meter type, or consumption. | |||
| UB | 160 | Customers Billed Report. | |||
| UB | 161 | Unread Accounts Report. | |||
| UB | 162 | Unpaid Accounts Report. | |||
| UB | 163 | Billing by Type Report. | |||
| UB | 164 | Read and Unread Accounts Report. | |||
| UB | 165 | Unbillled Accounts Listing. | |||
| UB | 166 | Leftover Reads Report. | |||
| UB | 167 | Service On/Service Off Report. | |||
| UB | 168 | Next-Time Billing Report. | |||
| UB | 169 | Backflow Report. | |||
| UB | 170 | Cut Cable/Endpoint Tamper Report. | |||
| UB | 171 | Missed/Skipped Reads Report. | |||
| UB | 172 | Leak Report. | |||
| UB | 173 | Closed, Doubtful, Write-Off, and Bankruptcy Accounts with Zero Consumption Report. | |||
| UB | 174 | Doubtful Accounts with Zero Consumption Report. | |||
| UB | 175 | High-Consumption Active Accounts Report — active accounts exceeding a City-defined usage threshold within a defined timeframe.e.g. >500 gallons | |||
| UB | 176 | Active Accounts with Zero Consumption Report. | |||
| UB | 177 | Low-Consumption Active Residential Accounts Report — usage below a City-defined threshold within a defined timeframe. | |||
| UB | 178 | High-Consumption Active Residential Accounts Report — usage above a City-defined threshold within a defined timeframe. | |||
| UB | 179 | High-Consumption Active Commercial Accounts Report — usage above a City-defined threshold within a defined timeframe. | |||
| UB | 180 | Meters with Zero Consumption Report — meters over a City-defined size with no recorded consumption. | |||
| UB | 181 | Test Circle Code Exception Report — meter size, endpoint prior to exporting the billing cycle to prevent errors in importing the readings if a change out has occurred | |||
| UB | 182 | Hydrant Meter Report — meter reads and register photographs. | |||
| UB | 183 | Past-Due Accounts Dashboard — monitor past-due accounts and other relevant billing data, or interface with the ERP dashboard. | |||
| UB | 187 | Expired Surety Bond or Letter of Credit Report/Flag. | |||
| UB | 193 | Outstanding Payments and Late Charges Statement — paper and/or electronic. | |||
| UB | 194 | Dunning Statements — including 30-, 60-, and 90-day statements. | |||
| UB | 195 | Outstanding Charges, Penalties, and Interest Statement. | |||
| UB | 196 | Consumption History Statement. | |||
| UB | 203 | Aged Balances Report — aged balances by service, account type, and age. | |||
| UB | 216 | Cashier Balancing Reports. | |||
| UB | 217 | Payment Reports — payments by amount and payment method. | |||
| UB | 245 | Personal Information Change Audit Trail Report — searchable reporting of personal changes made | |||
| UB | 252 | Upcoming Backflow Testing Requirements Report — third-party report including address, meter and endpoint numbers, meter location and size, customer account number, and related details. | |||
| UB | 256 | Cross Connection Control Annual Report for the Florida Department of Environmental Protection. | |||
| UB | 271 | Account Change Audit Log/Report — changes to accounts by user account. | |||
| UB | 272 | Transaction Change Audit Log/Report — changes to individual transactions by user account. | |||
| UB | 280 | User Access and Permission Audit Log/Report — permission changes, user logons, and user logoffs. | |||
| UB | 294 | Monthly Revenue Report — total revenue, revenue by account type, and revenue by service type. | |||
| UB | 297 | Consumption by Account Type Report. | |||
| UB | 298 | Disconnected Services and Accounts Report — services/accounts disconnected for a specified reason, such as non-payment. | |||
| UB | 299 | Geo based Report — City-defined reporting using geographic data such as polygon shapefiles. | |||
| UB | 301 | Key Performance Indicator Dashboard — City-defined KPI categories. | |||
| SW | 318 | Waste Collection Route Sheets — including special routes. | |||
| SW | 334 | Waste Tonnage Report — tonnage and material class by truck number, date, weight-ticket number, and account type. | |||
| SW/UB | 339 | Cutoff Listing. | |||
| SW/UB | 340 | Account and Meter Conditions Report — user-selected conditions such as high usage and zero reads. |
File details come from the government source that posted it. Updated .