The Pros and Cons of EDI Utility Data Feeds

Urjanet Inc  |  March 17, 2015   |  Energy & Sustainability  


A few weeks ago, we published an in-depth look at the difference between processing utility bills with OCR software and acquiring utility bill data through Urjanet. We received some feedback from readers saying that in addition to using OCR software for a subset of utility providers, their organizations were also engaged in electronic data interchange (EDI), receiving EDI utility data feeds.

EDI, in very loose terms, is an electronic communication method built on standards for exchanging data between two entities. In the context of utility billing, EDI provides a process solely for invoicing and payment. EDI implies a series of sent and received messages, and due to its electronic nature, human intervention is minimal.

EDI utility bill feeds produce a number of benefits over using paper bills, manual data entry, or OCR software. They significantly reduce the time-intensive process of dealing with paper bills, the human error that arises from manual data entry, and the inaccuracy and cumbersome auditing of OCR. However, deploying EDI comes with its own set of drawbacks and restrictions that have led some users to question whether it’s really the best fit for their needs.

Lack of Standardization

The standard used for utility billing, EDI 810, has allowed utility providers to implement it rather loosely. What this means is that the format in which you receive the bills varies from provider to provider, oftentimes requiring additional resources to manipulate the data, in order to get all of the bills in the same format. This lack of standardization can create challenges when a multi-facility organization has many different utility providers, as it can be costly and time-intensive to execute this additional step of re-formatting.

Setup Costs

The requirements needed to properly set up and implement EDI utility feeds involve a lot of time and money, not to mention technical know-how and a deep understanding of business processes. Users must first establish a method to translate or interpret the received files before accepting them. The next step is to validate the sender (or “trading partner”), the file structure, and the individual field information. Finally, users can convert the file into the right format for the organization’s backend systems. Many providers also require quite a few forms and agreements to fill out and sign prior to implementation, adding even more steps to complete before the process gets up and running smoothly.

Difficulty Accessing Data

Because EDI 810 is the standard used for invoicing, it’s typically not a great method of accessing bill data for any purpose other than to pay the bill. Additionally, data points that are available from an actual utility bill – like total consumption or peak demand charges – get left out of EDI utility feeds because they aren’t absolutely necessary in the bill payment process. Managers in other departments like sustainability or energy management would find use for those data points, but with EDI, they have to find and pay for another way to get the data they need.

No Bill Image

Not only do EDI utility invoice feeds leave out several data points; they also leave out the original bill image. In the event that a particular statement needs to be referenced for accuracy, viewed, emailed, or printed, having the bill image is tremendously helpful. Furthermore, as we mentioned, sometimes data points get left off the EDI feed that could be useful for analysis. Having a bill image provides every single data point on the bill so that nothing gets left behind.

No Historical Data

Another major drawback for EDI is that some utility vendors do not provide any past information regarding a particular account. Benchmarking and forecasting becomes virtually impossible without historical data, and to do so requires starting from scratch to gather enough data to report on. Some utility providers may provide this information through EDI, but will generally only do so upon special request.


Time to Reconsider EDI Utility Feeds?

If the lack of standardization, setup costs and investment, difficulty accessing utility data, and lack of bill images and historical data are issues for your company, Urjanet can remedy these concerns. Our automated platform collects, aggregates, and normalizes utility data directly from more than 5,000 providers around the world. The data that you get with Urjanet:

  • Is standardized across providers and formats
  • Requires minimal setup effort on your end

  • Can be delivered and integrated into your accounting systems, as well as your sustainability, energy management, energy procurement, and business intelligence programs simultaneously

  • Includes all data points available on the bill, as well as the original bill image

  • Can be traced as far back in time with historical data as the utility will provide


Do these problems sound familiar to you? Are you ready to take advantage of new technology to overcome them? Contact us today to learn how we can help you get started.

Related Resources:

If you like what you’re reading, why not subscribe?

About Urjanet Inc

Urjanet, the global leader in utility data aggregation, simplifies how organizations access and use utility data, enabling them to focus on their business. Our technology collects, processes, and delivers data from over 6,500 electric, natural gas, water, waste, telecom, and cable utilities worldwide.

Tags   Data & Technology   |   Energy   |   Sustainability   |   Urjanet   |   Utility Bill Management   |   Utility Bills   |   Utility Data   |