Top 10 Municipal Utility Revenue KPIs

Direct Answer

Why Municipal Utilities Measure Differently

Municipal utilities—publicly owned electric, water, gas, or wastewater systems—don’t chase venture capital or shareholder returns. Their revenue model is cost-of-service, meaning rates are set to recover operating expenses, debt service, and capital reserves, not to maximize profit.

This creates a different KPI framework compared to investor-owned utilities (IOUs) or private SaaS companies.

Key differences:

• Revenue is capped. Rate increases require public hearings and regulatory approval, often tied to inflation or specific capital needs. A municipal utility cannot “capture value” by raising prices arbitrarily.
• Cash flow is the priority. Profit is secondary to ensuring there’s enough cash to pay bonds, maintain infrastructure, and avoid rate shocks. Debt Service Coverage Ratio (DSCR) is a regulatory and bond-rating requirement, not a growth metric.
• Customer base is captive. Municipal utilities serve a defined geographic area with no competition. Churn is near zero, so customer acquisition cost is irrelevant. Instead, focus is on collection efficiency and usage patterns.
• Regulatory constraints. Many municipals must report to city councils, state public utility commissions, or boards. KPIs must align with GASB 34 (Governmental Accounting Standards Board) standards for financial reporting.

Tools like Cayenta (a utility billing and customer information system from Harris Computer) and Oracle Utilities Customer Cloud Service are purpose-built for this sector, not generic CRM/ERP. Workday and SAP are sometimes used for back-office finance, but they lack utility-specific rate modeling and regulatory compliance modules.

The Most Important KPIs to Track

Below are the top 10 revenue KPIs for municipal utilities, with definitions, formulas, and real-world benchmarks.

1. Net Revenue Margin (NRM)

Definition: The percentage of total revenue remaining after operating expenses (excluding debt service and capital expenditures). This is the utility’s “profit” available for reserves, capital projects, or rate stabilization.

• Formula: (Total Operating Revenue – Total Operating Expenses) / Total Operating Revenue × 100
• Benchmark: 5%–15% for well-run municipals. Below 5% indicates rates are too low or expenses are out of control. Above 20% may trigger regulatory pushback or customer complaints.
• Vendor example: Cayenta calculates NRM automatically in its financial reporting module.

2. Debt Service Coverage Ratio (DSCR)

Definition: Measures the utility’s ability to pay its annual debt obligations (principal + interest) from net revenue. This is a bond covenant metric—fall below 1.0 and you risk default.

• Formula: (Net Operating Revenue + Depreciation + Interest) / Annual Debt Service
• Benchmark: 1.25x–1.50x is the industry standard for investment-grade bonds (per S&P Global Ratings). Below 1.0x triggers covenant violations.
• Real example: The Los Angeles Department of Water and Power (LADWP) targets a DSCR of 1.5x for its revenue bonds.

3. Collection Rate (or Collection Efficiency)

Definition: The percentage of billed revenue actually collected within a given period (e.g., 30, 60, 90 days). High collection rates reduce bad debt and improve cash flow.

• Formula: (Total Collections / Total Billings) × 100
• Benchmark: 97%–99% for residential customers; 95%–98% for commercial/industrial. Below 95% indicates billing or customer service issues.
• Vendor example: Oracle Utilities offers a Customer to Meter (C2M) module that tracks real-time collection rates and flags delinquent accounts.

4. Days Sales Outstanding (DSO)

Definition: The average number of days it takes to collect payment after billing. Lower DSO means faster cash conversion.

• Formula: (Average Accounts Receivable / Total Billed Revenue) × Number of Days in Period
• Benchmark: 25–35 days for residential; 30–45 days for commercial. Municipals with DSO > 60 days likely have poor billing or disconnection policies.
• Tool: Workday Financial Management can track DSO across utility operations, but it’s not utility-specific.

5. Revenue per Customer (RPC)

Definition: Average monthly revenue generated per customer account. Useful for rate-setting and demand forecasting.

• Formula: Total Monthly Revenue / Total Active Customer Accounts
• Benchmark: Varies by service type. For electric: $80–$150/month (residential). For water: $40–$80/month. For gas: $50–$120/month.
• Real data: Seattle City Light reported an average residential monthly bill of $96 in 2023 (per its annual report).

6. Rate Recovery Ratio

Definition: The percentage of actual revenue collected compared to the revenue required to cover costs (as determined by the cost-of-service study). This indicates whether rates are adequate.

• Formula: (Actual Revenue / Required Revenue) × 100
• Benchmark: 100%–105%. Below 100% means rates are insufficient; above 105% suggests over-collection, which may trigger rate reductions or refunds.
• Vendor example: Cayenta has a Rate Modeling tool that calculates this ratio based on consumption data and tariff structures.

7. Customer Arrears Rate

Definition: The percentage of customers with outstanding balances > 60 days past due. High arrears signal economic distress or poor disconnection enforcement.

• Formula: (Number of Accounts with Arrears > 60 Days / Total Active Accounts) × 100
• Benchmark: 1%–3% for well-managed utilities. Above 5% is a red flag.
• Real example: The Detroit Water and Sewerage Department had an arrears rate of 8% in 2022, leading to a controversial shutoff moratorium.

8. Operating Expense Ratio (OER)

Definition: Operating expenses as a percentage of total revenue. Lower is better, but municipals have fixed costs (e.g., infrastructure maintenance) that limit flexibility.

• Formula: Total Operating Expenses / Total Operating Revenue × 100
• Benchmark: 70%–85% for most municipals. Above 90% leaves little room for debt service or reserves.
• Tool: SAP S/4HANA for utilities can track OER with granular cost-center allocations.

9. Revenue per Employee (RPE)

Definition: Total revenue divided by the number of full-time employees (FTEs). Measures operational efficiency.

• Formula: Total Annual Revenue / Total FTEs
• Benchmark: $200,000–$400,000 per FTE for electric utilities; $150,000–$250,000 for water/wastewater.
• Vendor example: Workday provides workforce analytics that can be tied to revenue data.

10. Regulatory Compliance Rate

Definition: The percentage of regulatory filings (e.g., rate cases, financial reports, environmental compliance) submitted on time and without violations. Revenue can be directly impacted by fines or delayed rate approvals.

• Formula: (Number of On-Time Compliant Filings / Total Required Filings) × 100
• Benchmark: 100% is the target. Any miss can trigger audits or penalties.
• Tool: Cayenta’s Regulatory Reporting module automates GASB 34 and FERC filings.

👉 Quick Call with Kory White, Fractional CRO · See Kory on LinkedIn · CRO Syndicate

Real Operators

• Los Angeles Department of Water and Power (LADWP): The largest municipal utility in the U.S. (serving 4 million customers). Uses Oracle Utilities for billing and SAP for finance. Targets a DSCR of 1.5x and a collection rate of 98%. In 2023, it reported a net revenue margin of 12% (per its annual financial report).
• Seattle City Light: A publicly owned electric utility. Uses Cayenta for customer information and billing. Its 2023 annual report shows a DSCR of 1.4x and an OER of 78%.
• Austin Energy: The municipal electric utility for Austin, TX. Uses Workday for HR/finance and Oracle Utilities for metering. Its 2023 budget projected a collection rate of 97% and an arrears rate of 2.5%.
• Detroit Water and Sewerage Department (DWSD): A large water utility with chronic collection issues. In 2022, it had an arrears rate of 8% and a DSO of 55 days. It uses Cayenta for billing but struggles with legacy system integration.

Failure Modes

• Rate Inertia: Municipals often delay rate increases due to political pressure, leading to NRM < 5% and DSCR < 1.0x. Example: Jackson, Mississippi’s water system collapsed partly due to decades of underfunding.
• Bad Debt Accumulation: Poor collection enforcement (e.g., moratoriums on shutoffs) inflates arrears rate above 10% and DSO above 60 days. This was a major issue for DWSD during the pandemic.
• Misaligned Rate Structures: Flat rates (not tied to consumption) can cause RPC to fall during conservation efforts, while fixed costs remain. This creates a rate recovery ratio below 100%.
• Data Silos: Using separate systems for billing (Cayenta), finance (SAP), and operations (SCADA) leads to inconsistent KPIs. For example, revenue per customer might be calculated differently in billing vs. Financial reports.
• Over-reliance on Manual Processes: Spreadsheet-based KPI tracking introduces errors and delays. A 2023 Gartner survey found that 40% of utility finance teams still use Excel for rate modeling, leading to 10%+ error rates.

Reporting Cadence

30-60-90 Day Plan for Implementing These KPIs

Days 1–30: Audit and Baseline

• Week 1: Pull 12 months of historical data from billing (Cayenta) and finance (SAP/Workday). Calculate baseline for NRM, DSCR, Collection Rate, and DSO.
• Week 2: Identify data silos. If billing and finance systems don’t talk, set up a manual reconciliation process using Power BI or Tableau (free trials available).
• Week 3: Define KPI definitions and formulas with the CFO and regulatory team. Document them in a shared Confluence or Notion page.
• Week 4: Present baseline KPIs to the city council or board. Highlight any red flags (e.g., DSCR < 1.2x, arrears > 5%).

Days 31–60: Automate and Standardize

• Week 5–6: Configure Cayenta or Oracle Utilities to calculate KPIs automatically. Set up weekly email alerts for Collection Rate and Arrears Rate.
• Week 7: Implement a rate recovery ratio model using Excel (temporary) or Cayenta’s Rate Modeling tool. Run a scenario analysis for a 5% rate increase.
• Week 8: Train billing and finance teams on the new dashboards. Use Gong or Outreach (if you have a sales team) to document training sessions—though this is more for internal ops.

Days 61–90: Optimize and Report

• Week 9–10: Review DSO and Collection Rate trends. If DSO > 40 days, implement automated payment reminders via Oracle Utilities or a third-party tool like Paymentus.
• Week 11: Present a 90-day KPI report to the board. Include a DSCR forecast for the next 12 months based on current debt service schedules.
• Week 12: Set up quarterly reporting cadence for Regulatory Compliance Rate and Revenue per Employee. Schedule a rate case review if Rate Recovery Ratio is below 95%.

FAQ

What is the most critical KPI for a municipal utility? Debt Service Coverage Ratio (DSCR) is the most critical because it’s a bond covenant. Falling below 1.0x can trigger default, higher borrowing costs, or even state intervention. Aim for 1.25x–1.50x.

How often should we review revenue KPIs? Collection Rate and Arrears Rate should be reviewed weekly. NRM and DSO monthly. DSCR and Rate Recovery Ratio quarterly or before any rate case filing.

What’s a typical collection rate for a municipal utility? 97%–99% for residential. Below 95% indicates billing issues, customer hardship, or poor disconnection enforcement. Detroit Water had 92% in 2022, leading to a $30M bad debt write-off.

Can we use Salesforce for utility KPIs? Not recommended. Salesforce is a CRM for customer-facing sales and service, not for utility-specific metrics like DSCR or rate recovery. Use Cayenta, Oracle Utilities, or SAP S/4HANA for utilities instead.

How do we benchmark our KPIs against other municipals? Use American Public Power Association (APPA) annual reports, National Association of Water Companies (NAWC) data, or S&P Global Ratings utility sector reports. Many municipals publish annual financial statements with KPIs.

What’s the biggest mistake utilities make with KPIs? Ignoring rate recovery ratio. Many utilities set rates based on historical costs without modeling future capital needs. This leads to NRM erosion and DSCR declines over time.

Sources

• American Public Power Association (APPA) - Annual Utility Financial Reports
• S&amp;P Global Ratings - U.S. Public Finance: Municipal Utilities Criteria
• Los Angeles Department of Water and Power - 2023 Annual Financial Report
• Seattle City Light - 2023 Annual Report
• Oracle Utilities Customer Cloud Service - Product Page
• Cayenta Utility Billing - Harris Computer
• Workday Financial Management for Utilities
• Gartner - Utility Finance and KPI Best Practices (2023)
• Detroit Water and Sewerage Department - Financial Reports
• National Association of Water Companies (NAWC) - Benchmarking Data