FM_UB_ATT_12_Reports_v2.xlsx

XLSX spreadsheet 14 KB Posted

Attached to
Professional Implementation Services for Oracle Utilities Billing
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

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
SRStandard Reports
CRCustom Reports
Note: Please specify the estimated number of hours needed for all custom reports in column E and F.
Vendor Response Section
FunctionFunctional Requirement #Description of ReportType of Report
SR, CRConsultant Work Effort (in hours)Client Work Effort (in hours)In Scope? (Y/N)Included in Price (Y/N)Comments
UB11Prior Accounts with Outstanding Balances Report — inquiry and reporting on prior accounts with outstanding balances.
UB75Meter Reading Edit and Reread Exception Report — review accounts with an edit report and identify readings outside parameters for rereading.
UB86Meter Readings and Consumption Report — readings and consumption by cycle, meter type, or consumption.
UB160Customers Billed Report.
UB161Unread Accounts Report.
UB162Unpaid Accounts Report.
UB163Billing by Type Report.
UB164Read and Unread Accounts Report.
UB165Unbillled Accounts Listing.
UB166Leftover Reads Report.
UB167Service On/Service Off Report.
UB168Next-Time Billing Report.
UB169Backflow Report.
UB170Cut Cable/Endpoint Tamper Report.
UB171Missed/Skipped Reads Report.
UB172Leak Report.
UB173Closed, Doubtful, Write-Off, and Bankruptcy Accounts with Zero Consumption Report.
UB174Doubtful Accounts with Zero Consumption Report.
UB175High-Consumption Active Accounts Report — active accounts exceeding a City-defined usage threshold within a defined timeframe.e.g. >500 gallons
UB176Active Accounts with Zero Consumption Report.
UB177Low-Consumption Active Residential Accounts Report — usage below a City-defined threshold within a defined timeframe.
UB178High-Consumption Active Residential Accounts Report — usage above a City-defined threshold within a defined timeframe.
UB179High-Consumption Active Commercial Accounts Report — usage above a City-defined threshold within a defined timeframe.
UB180Meters with Zero Consumption Report — meters over a City-defined size with no recorded consumption.
UB181Test 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
UB182Hydrant Meter Report — meter reads and register photographs.
UB183Past-Due Accounts Dashboard — monitor past-due accounts and other relevant billing data, or interface with the ERP dashboard.
UB187Expired Surety Bond or Letter of Credit Report/Flag.
UB193Outstanding Payments and Late Charges Statement — paper and/or electronic.
UB194Dunning Statements — including 30-, 60-, and 90-day statements.
UB195Outstanding Charges, Penalties, and Interest Statement.
UB196Consumption History Statement.
UB203Aged Balances Report — aged balances by service, account type, and age.
UB216Cashier Balancing Reports.
UB217Payment Reports — payments by amount and payment method.
UB245Personal Information Change Audit Trail Report — searchable reporting of personal changes made
UB252Upcoming Backflow Testing Requirements Report — third-party report including address, meter and endpoint numbers, meter location and size, customer account number, and related details.
UB256Cross Connection Control Annual Report for the Florida Department of Environmental Protection.
UB271Account Change Audit Log/Report — changes to accounts by user account.
UB272Transaction Change Audit Log/Report — changes to individual transactions by user account.
UB280User Access and Permission Audit Log/Report — permission changes, user logons, and user logoffs.
UB294Monthly Revenue Report — total revenue, revenue by account type, and revenue by service type.
UB297Consumption by Account Type Report.
UB298Disconnected Services and Accounts Report — services/accounts disconnected for a specified reason, such as non-payment.
UB299Geo based Report — City-defined reporting using geographic data such as polygon shapefiles.
UB301Key Performance Indicator Dashboard — City-defined KPI categories.
SW318Waste Collection Route Sheets — including special routes.
SW334Waste Tonnage Report — tonnage and material class by truck number, date, weight-ticket number, and account type.
SW/UB339Cutoff Listing.
SW/UB340Account 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 .