Every water and wastewater rate case rests on one promise: that the revenue requirement reflects what it truly costs to run, maintain, and replace the system. When asset records, condition data, and cost history live in separate spreadsheets, that promise is hard to keep. Gaps surface late, during consultant review or public hearings, and they quietly weaken every number. A connected CMMS such as Oxmaint gives utilities one traceable record from asset to work order to cost.
Water Utility Data Gaps Wreck Every Rate Case Cycle. Connected Maintenance Data Closes Them Before Filing Day.
Water and wastewater utilities defend rate increases with asset registers, condition assessments, and maintenance cost history. Spreadsheet-based records break the chain between them. Oxmaint ties assets, inspections, work orders, and costs into one defensible dataset.
Asset registerPipes, pumps, tanks, valves
Gap
Condition dataInspections, failures, age
Gap
Cost historyLabor, parts, contractors
Gap
Rate caseRevenue requirement
Why Data Gaps Hurt Most During a Rate Case
A rate filing is a stress test of your records. Reviewers, regulators, and ratepayer advocates ask for evidence, and every unanswered question becomes leverage against the requested increase.
- Capital plans must show which assets are driving the need for investment.
- Operating expense forecasts must tie back to actual maintenance history.
- Deferred maintenance claims must be backed by documented condition, not memory.
- Prior-year variances must be explainable by asset, system, or event.
Utilities that cannot produce this evidence quickly often face delayed approvals, reduced increases, or phased adjustments that fall short of real need.
The Rate Case Cycle and Where Data Breaks Down
1
Test year and baseline
Finance pulls historical operating and maintenance costs. If work orders are not coded by asset and system, costs cannot be traced to the infrastructure that generated them.
2
Capital needs assessment
Engineering builds the replacement list. Outdated asset registers and missing install dates distort remaining useful life estimates.
3
Revenue requirement
Operating costs, debt service, and capital funding combine. Inconsistent cost categories make cost-of-service allocation harder to defend.
4
Review and hearings
Questions arrive from consultants, boards, and the public. Answers take weeks when records sit in different files owned by different departments.
5
Post-approval tracking
Promised programs must be delivered and reported. Without live work order data, proving that approved funds produced results is a manual exercise.
Common Data Gaps in Water and Wastewater Utilities
These gaps rarely look serious on their own. Together they erode confidence in the whole filing.
| Data Gap | How It Appears | Rate Case Consequence |
|---|---|---|
| Incomplete asset register | Missing install year, material, size, or location | Weak replacement forecasts and depreciation questions |
| Uncoded work orders | Costs recorded without asset or failure reference | Operating costs cannot be linked to system condition |
| Disconnected condition data | Inspection findings in reports, not in the asset record | Capital priorities look subjective |
| Paper field records | Crew notes entered days or weeks later | Labor hours and parts understated |
| Inconsistent failure codes | Main breaks, leaks, and pump trips described freely | Failure trends cannot be demonstrated |
| Multiple versions of truth | GIS, finance, and operations disagree on asset counts | Credibility questions during review |
Spreadsheet Asset Registers Versus a Connected CMMS
Before: spreadsheet registers
- Asset lists updated once a year, if at all
- Maintenance cost totals rebuilt by hand each filing
- Condition scores stored in consultant PDFs
- Staff turnover removes the logic behind the file
- No audit trail showing who changed what
After: connected CMMS records
- Asset records updated as crews complete work
- Costs roll up automatically by asset, system, and period
- Inspection results attached to the asset history
- Standard failure and cause codes across all crews
- Timestamped records that support audit and review
Start Building Rate Case Evidence Before the Next Filing
Replace scattered files with one maintenance record your finance, engineering, and operations teams can all trust.
Root Causes Behind the Gaps
Ownership split
GIS owns locations, finance owns costs, and operations owns work. No one owns the connection between them.
Reactive workload
Crews responding to breaks and overflows have little time for detailed documentation after the call.
Buried infrastructure
Pipes cannot be seen, so condition knowledge depends on repair records and periodic inspection results.
Legacy tools
Spreadsheets and standalone databases were never designed to maintain history across decades of assets.
How Oxmaint Connects Asset, Condition, and Cost Data
The goal is not more data. It is data that links together at the moment work happens.
Asset management
Build a structured register by system, facility, and asset class, with attributes that support lifecycle planning.
Inspections
Capture condition findings on mobile devices and attach them directly to the asset.
Work orders
Record corrective and preventive work with labor, parts, failure codes, and completion notes.
Inventory
Track critical spares and parts consumption so material costs connect to the work performed.
Reporting
Produce cost, backlog, and failure reports by asset, system, or period for finance and engineering review.
Preventive Maintenance and the Operating Expense Story
Rate case reviewers look for evidence that the utility manages assets, not just repairs them.
- Scheduled PM for pumps, motors, blowers, valves, and treatment equipment shows planned stewardship.
- Completion rates demonstrate that the program is real and not only a plan.
- Corrective work trends show whether PM is reducing repeat failures.
- Condition-based triggers, such as vibration or runtime thresholds, support targeted spending.
This evidence turns a request for more money into a documented case for protecting service.
Regulatory Context That Raises the Stakes
Several frameworks already push utilities toward better asset information.
GASB 34Governmental utilities report capital assets, which depends on accurate inventories and useful life data.
AWWA rate practicesIndustry rate-setting guidance expects costs to be allocated by function, supported by usable records.
America's Water Infrastructure ActCommunity water systems serving more than 3,300 people complete risk and resilience assessments and emergency response plans.
Lead service line inventoriesFederal lead and copper rules require service line inventories that must stay current and documented.
State and SRF programsFunding applications often ask for asset management plans and evidence of condition-based prioritization.
Confirm current requirements with your state primacy agency and rate consultant, since details vary by jurisdiction.
KPIs That Strengthen a Rate Case
PM completion ratePlanned work finished on schedule
Planned versus reactive ratioShare of labor spent on scheduled work
Maintenance cost per asset classSpend by pumps, mains, tanks, plants
Repeat failure rateAssets failing again after repair
Work order backlog ageHow long needed work remains open
Records completenessWork orders with asset, cause, and cost
Rate Case Data Readiness Checklist
Use this list twelve to eighteen months before your next filing.
- Every critical asset has a unique ID, location, install year, and material.
- Asset counts in GIS, finance, and the CMMS reconcile.
- Work orders require an asset, failure code, and cause code to close.
- Crews enter labor and parts from the field, not days later.
- Inspection findings are attached to the asset record.
- PM schedules exist for critical pumps, motors, and treatment equipment.
- Cost reports can be produced by system and fiscal year without manual rebuilding.
- Deferred maintenance is documented with condition and consequence of failure.
A Practical Rollout Path for Utilities
1
Start with critical assets
Load plant equipment, lift stations, and major mains first. Expand to the full network as data quality improves.
2
Standardize codes
Agree on failure, cause, and cost categories with finance so reports match budget structure.
3
Move crews to mobile
Field entry captures time, parts, and notes while details are fresh.
4
Review dashboards monthly
Treat data quality as an ongoing metric, so gaps are caught long before filing season.
Wastewater Records Carry Their Own Blind Spots
Collection systems and treatment plants generate different data problems than distribution networks. Much of the system is underground, flow-dependent, and affected by weather.
| Asset Group | What Is Often Missing | Why It Matters in a Filing |
|---|---|---|
| Gravity sewer mains | Install year, material, and inspection results | Renewal programs look arbitrary without condition evidence |
| Force mains | Break and repair history by segment | High-consequence assets need documented risk reasoning |
| Lift stations | Pump run hours, failures, and call-out frequency | Operating cost increases cannot be tied to equipment age |
| Treatment plant equipment | PM completion and repair cost per asset | Reviewers question whether equipment is managed or just repaired |
| Manholes and structures | Inspection dates and defect records | Inflow and infiltration programs lack baseline data |
| Overflow and blockage events | Cause, location, and response time | Cleaning program costs are hard to justify without event history |
A single system that records these events by asset gives the rate study a factual base for each program request.
Condition Assessment Data Needs a Permanent Home
Utilities invest in CCTV inspection, pipe sampling, valve exercising, and facility condition reviews. The findings often end up in a consultant report that no one opens again until the next study.
1
Collect the finding
Inspectors record defects, grades, and photos against a specific asset ID, not a general area.
2
Attach it to the asset
The result becomes part of the asset history, next to repairs and failures, so patterns are visible.
3
Trigger the response
Severe findings open corrective work orders, while moderate ones feed the capital candidate list.
4
Reassess on a schedule
Recurring inspection tasks keep condition data current, instead of aging for years between studies.
When condition scores sit beside cost and failure records, prioritization becomes explainable to a board or review panel.
From Maintenance History to a Believable Capital Forecast
Capital plans carry the largest dollar figures in most rate cases, and they draw the sharpest questions. Age alone is a weak argument for replacement, since many assets outlive their assumed lives.
Failure frequency
Repeat repairs on one segment or machine show where maintenance spending is not solving the problem.
Cost of keeping it running
Cumulative labor, parts, and contractor cost helps compare continued repair against replacement.
Consequence of failure
Asset criticality notes, such as service area, regulatory exposure, and access difficulty, rank which problems matter most.
Prioritized project list
Engineering and finance work from the same history, so projects connect to evidence rather than preference.
This does not replace a full asset management plan. It supplies the operational data that such a plan depends on.
Questions Reviewers Ask and the Records That Answer Them
Why did maintenance costs rise?Work order cost by asset class and year, separated into planned and reactive work.
Why replace this asset now?Failure history, inspection findings, and repair cost trend for that specific asset.
Is the utility maintaining what it owns?PM schedules with completion rates and backlog age by system.
Where did last increase go?Completed work by program, with cost and location linked to the approved plan.
How accurate are your inventories?Reconciled asset counts and records showing when data was last verified.
Mistakes Utilities Make When Trying to Fix Data
- Trying to load every asset at once and stalling before crews see any benefit.
- Importing old spreadsheets without cleaning duplicates and missing fields.
- Leaving cost coding to finance alone, with no input from field supervisors.
- Treating the CMMS as a records project instead of a daily work tool.
- Setting up dashboards before crews consistently close work orders with complete data.
Successful programs begin with the assets that carry the highest consequence and the most scrutiny, then widen as habits form. Crews who see work orders making their day easier will keep entering complete information.
Leadership attention matters as well. When finance and operations review the same monthly report, gaps are noticed and fixed quickly, long before outside reviewers find them.
Who Owns Which Data Before the Filing
Clear ownership keeps records from drifting apart between filings. Each team contributes a specific piece, and the CMMS connects them.
| Team | Owns | Feeds the Rate Case With |
|---|---|---|
| Field operations | Work orders, inspections, failure notes | Maintenance cost and failure history by asset |
| Engineering | Asset attributes, condition scores, project lists | Capital need and renewal priorities |
| Finance | Cost codes, budgets, depreciation schedules | Revenue requirement and cost allocation |
| GIS | Asset locations and network connectivity | Verified inventories and location accuracy |
| Leadership | Policy, targets, and board communication | The narrative that links evidence to rates |
Review this ownership list each quarter, so that gaps are assigned a person rather than left to chance.
Make Data Quality a Year-Round Habit
Utilities that treat records as a filing-season project repeat the same scramble every cycle. Those that review completeness monthly find problems while they are still cheap to fix.
- Review work orders missing asset or cost data every month.
- Reconcile asset counts between systems each quarter.
- Update condition scores as inspections are completed.
- Share a short data quality summary with finance and leadership.
Frequently Asked Questions
Why do rate cases expose data gaps?
Reviewers request evidence behind every cost and capital claim. Disconnected records make that evidence slow to assemble and easier to challenge.
Can a CMMS support capital planning?
It supplies the condition, failure, and cost history that planners need. Learn more by booking a demo.
Does this apply to wastewater too?
Yes. Lift stations, collection mains, and treatment equipment all generate maintenance records that feed wastewater rate studies.
How long before records become useful?
Reports improve as work orders accumulate. Starting early gives you a full cycle of history. You can sign up here.
Does a CMMS replace GIS or financial systems?
No. It complements them by holding maintenance activity and cost at the asset level, where the other systems lack detail.
Go Into Your Next Rate Case With Records You Can Defend
See how Oxmaint links assets, inspections, work orders, and costs into one dataset for your utility.
