Home » Utility Asset Management Software: How Work Orders, Inventory and Plant Records Work Together

CentralViews

Utility Asset Management Software: How Work Orders, Inventory and Plant Records Work Together

Utility field worker updating a work order in utility asset management software on a tablet

A water main breaks on Tuesday night. By Wednesday afternoon the crew has replaced a section of pipe and two valves, and service is restored. The repair took a day. The paperwork may take months. The work order sits on a clipboard until someone has time to key it in. The materials pulled from the warehouse are written on a separate slip. Labor hours land on time sheets. The map gets updated whenever the engineering technician catches up. Eventually someone in finance has to decide whether the new pipe and valves are a capital addition or a repair expense, often with incomplete information.

Multiply by every work order, every pole replacement and every new subdivision, and the result is a utility whose maps, warehouse counts and plant records drift further apart. Asset management software exists to close those gaps. This guide explains what it covers, why it matters so much for municipal utilities and cooperatives, and what to look for when you evaluate it.

What Utility Asset Management Software Covers

In a utility setting, asset management is less about a single application and more about how several records stay connected. A practical system ties together four things:

  • The asset register. A record of what the utility owns: lines, pipe, poles, transformers, meters, valves, hydrants, vehicles and equipment, along with installation dates, cost and condition.
  • Work orders. The record of every job that installs, replaces, repairs or retires an asset, including the labor, materials and equipment it used.
  • The materials on hand in the warehouse or yard, what has been issued to jobs and what needs to be reordered.
  • Financial and plant records. The general ledger (GL), capitalized plant balances and depreciation schedules that appear in the utility’s financial statements.

Many utilities also connect these records to their geographic information system (GIS), the map of where each asset physically sits. When the four records and the map share the same data, a single job updates all of them. When they do not, staff spend their time reconciling.

This is different from the large enterprise asset management (EAM) platforms built for investor-owned utilities, refineries or manufacturing plants. Those systems can be powerful, but they are often more complex and expensive than a municipal utility or cooperative needs. For most small and midsize utilities, the goal is straightforward: make sure what happens in the field shows up accurately on the map, in the warehouse and in the books.

Why Asset Management Matters So Much for Utilities

The value of electric, water or gas infrastructure is almost entirely buried, overhead or spread across miles of service territory. Much of that infrastructure is aging and being replaced at a steady pace and every replacement is a transaction that must be recorded correctly. If the old asset is not retired from the plant records, the utility carries equipment on its books that no longer exists. If the new asset is not added, depreciation is understated and future replacement planning starts with the wrong numbers.

For municipal utilities, accurate asset records carry extra weight. City councils and utility boards use them to plan capital budgets and set rates. Auditors test them every year. Residents and local media can request them. A municipal utility that provides electric, water, wastewater or gas services often manages several networks with shared personnel and warehouse facilities; each job must be charged to the right system.

For electric cooperatives, asset records support the same capital planning and audit requirements, and they feed the reporting that boards and lenders rely on. The specific requirements differ, but the underlying need is the same: records that match what is actually in the field.

The Work Order

Nearly every change to assets involves a with a work order. That makes the work order a crucial part of the asset management process and it’s not uncommon for work orders to still be done on paper.

A well-conceived and managed work order follows the job from start to finish:

  • The job is opened from a service request, an inspection finding, an outage, a new service application or a planned capital project.
  • Planning and staking. For construction jobs, engineering staff design the work and identify the materials needed.
  • The job is assigned to a crew with the information they need, including location and any related map data.
  • Items issued from inventory are charged directly to the job, so the warehouse count and the job cost stay in step.
  • Labor and equipment. Crew hours and equipment time are recorded against the job, ideally from the same time entry used for payroll.
  • Field updates. Crews update status and record what was actually installed or removed, which may differ from the original plan.
  • The job is reviewed, costs are finalized and work is classified as capital, maintenance or retirement.
  • Asset updates. Plant records and the map are updated to reflect the change.

When each of these steps happen as part of an integrated platform, the closeout step becomes routine instead of a monthly scramble.

A useful test: pick a job your crews closed last month and trace it. Can you see its labor, materials and final cost in one place? Does the map reflect what was done? Has the plant record been updated? If answering takes more than a few minutes, the process has holes in it.

Inventory: Having the Right Materials Without Tying Up Cash

Warehouses hold a large share of a utility’s working capital: wire, pipe, fittings, meters, transformers, poles and storm stock. Too little inventory delays jobs and outage restoration. Too much ties up money that could be used elsewhere and increases the risk of obsolete or missing stock.

Good asset management ensures inventory reflects work order history and planning for future projects, and materials are issued to specific jobs. Several practical benefits result:

  • Accurate job costing, because materials are charged at the time they are used
  • Reliable stock levels, because issues, returns and receipts are recorded in one place
  • Reorder points that trigger purchasing before critical items run short
  • Easier physical counts, because the system already knows what should be on the shelf
  • Better storm preparation, because the utility can see what it has on hand before severe weather arrives

For a municipal utility that shares a warehouse across electric, water and gas operations, inventory tied to work orders also makes it clear which service bore the cost, which matters when each service is accounted for as a separate fund.

Plant Records and Depreciation: Keeping the Books in Line With the Field

The financial side of asset management is where small inaccuracies add up. When a work order closes, someone has to determine how its costs should be recorded. New construction and replacements are typically capitalized, routine repairs are expensed and removed equipment is retired from the plant records. The exact rules depend on the utility’s accounting policies, so finance staff and auditors should define them clearly.

Software helps by applying those rules consistently and by keeping the link between the job and the asset. Useful capabilities include:

  • Capital, maintenance and retirement classifications set at the job level
  • Automatic updates to plant asset records when a capital job closes
  • Depreciation schedules for both individual assets and groups of similar assets
  • Posting to the GL without re-keying job totals
  • An audit trail that shows who approved each step

The payoff comes at year-end. Instead of reconstructing a year of capital activity from spreadsheets, finance staff can review closed jobs, confirm their classifications and produce plant schedules that tie back to the source records. That shortens the audit and gives leadership more confidence in the numbers used for capital planning and rate decisions.

Connecting the Field and the Map

Asset records are only as good as the information coming back from the field. When crews record what they installed on paper, details get lost between the job site and the office. When they can update records from a tablet or phone, the information arrives faster and with fewer errors.

Mapping plays a central role. A utility’s GIS shows where each asset is, while the asset register shows what it is, what it cost and how old it is. Keeping the two aligned is one of the most common challenges utilities describe, especially after storms or large construction projects. Our article on Mobile GIS for Utility Field Workers: How UtiliGo Changes How Your Crews Operate shows how mobile mapping helps crews record changes in the field, and our guide to GIS Software for Electric Cooperatives: How Mapping Technology Improves Operations covers the broader role of mapping in utility operations.

Staking is another point where field, map and work order data meet. When staking jobs are designed in the mapping system and tied to work management, the materials and assets in the design carry forward to the work order instead of being entered again.

One Job, Start to Finish: The Water Main Break Revisited

Consider the Tuesday night water main break again, this time in a utility where work orders, inventory, plant records and the map are connected.

The on-call supervisor opens a work order from the trouble call and assigns it to the crew, who can see the location and the affected section of main on a tablet. When the crew picks up pipe, couplings and two valves from the yard, those items are issued to the job, so the warehouse balance drops and the job cost rises at the same moment. Crew hours are entered against the job through the time entry application used for payroll.

At the site, the crew records what was replaced, the new materials used and attaches photos. Back in the office, the engineering technician reviews the field notes and updates the map. When the supervisor closes the job, finance reviews the totals and classifies the work. The new pipe and valves are added to the plant records, the retired section is removed and depreciation begins on the new assets.

Nothing in that sequence is unusual. The difference is that each step uses information entered once, at the point where the work happened. When the utility board asks how much was spent on main replacements this year, or the auditor asks for support behind a plant addition, the answer is already in the system.

Common Gaps When Systems Are Disconnected

Utilities that manage assets across separate systems tend to see the same problems:

  • Map backlogs. Field changes wait weeks or months to reach the map, so crews and engineers work from outdated information.
  • Inventory shrinkage. Materials leave the warehouse without being charged to a job, and counts never quite match.
  • Unclear job costs. Labor, materials and equipment for the same job live in different systems, making true costs hard to see.
  • Plant records that drift. Retirements are missed, additions are delayed and depreciation schedules no longer reflect what is in the ground.
  • Year-end crunch. Capital activity has to be reconstructed by hand during the busiest time of the year for finance staff.
  • Weak documentation after storms. Damage, repairs and costs are difficult to assemble.

None of these problems is unusual. Each one, though, costs staff time and weakens the information leadership uses to plan.

What to Look For in a System

If your utility is evaluating its options, these questions help separate a good fit from a feature list:

  1. Does it connect work orders, inventory and plant records in one system? Separate modules that require exports and imports bring back the same gaps you are trying to close.
  2. Does it support every service you provide? Municipal utilities often need electric, water, wastewater, gas and sometimes fiber in one place.
  3. Can field crews update jobs from a mobile device? Status, materials and notes should not wait for someone to return to the office.
  4. How does it work with your mapping system? Ask how changes in the field and in staking reach the map and the asset register.
  5. Does it handle capital and maintenance classification clearly? The rules should be configurable to match your accounting policies.
  6. What reporting comes standard? Look for job cost, inventory valuation, plant additions and retirements, and depreciation reports that finance and auditors can use without custom work.
  7. Is it sized for a utility like yours? A platform built for very large organizations may require more staff and configuration than a small or midsize utility can support.

Getting Started

Improving asset management does not have to begin with a full system replacement. A few practical steps can make a difference right away and will make any future software project go more smoothly:

  • Review your current process. Follow a typical job from request to closeout and note every handoff, form and spreadsheet.
  • Define closeout rules. Agree with finance on when a job is complete and how its costs are classified.
  • Clean up key data. Start with one asset class, such as transformers or meters, and confirm that the map, the warehouse and the plant records agree.
  • Set a few measures. Track the number of open jobs past their completion date, the map backlog and the time it takes to close the books on capital work.

These steps reveal where the largest gaps are and give your utility a clear baseline for deciding what to change.

Where CentralView Fits

CentralView1 is an enterprise resource planning (ERP) platform built by Central Service Association (CSA) for municipal utilities and electric cooperatives. Its CentralView Financials, Asset Management and HR tools include work orders that track the costs of each job from creation through closing, including updates to plant assets, with status updates available from a tablet in the field. Asset management features record and track inventory and assets in one place, including stock bought and used for jobs, stock counts, reorder points and depreciation schedules for individual and mass assets. On the Engineering and Operations side, UtiliTrak mapping, UtiliGo mobile mapping and UtiliStake staking help keep field and map data aligned.

See How CentralView Tracks Every Job

1 CentralView is Central Service Association (CSA) Trademark.

The information presented in this article is intended for general educational purposes. Utility software environments vary significantly. We recommend consulting with a qualified technology advisor to evaluate solutions appropriate to your organization’s specific operational requirements.