A look at cut-off fee trends

The 2019 Utility Fee Survey was the fourth Utility Fee Survey, the third of which has alternated years with the Utility Staffing Survey. This means I’ve collected enough data to begin analyzing trends.

Cut-off fee trends

Below is a graph of the average and median cut-off or reconnect fees (or whatever you call your fee) over the four years of the Utility Fee Survey – 2012, 2015, 2017, and 2019:

The median fee (the value with an equal number of smaller and larger values) has steadily increased from $35.00 in 2012 to $46.50 last year. Interestingly, the average (or mean) value dropped from 2012 to 2015 but increased gradually in 2017 and 2019.

Breakdown by dollar range

To further analyze the data, I plotted the number of fees in $10.00 increments up to $100.00 and then the number over $100.00. This is displayed in the graph below (clicking on the graph will open a larger image in a new window):

This graph helps to understand the anomaly of 2012 where the mean was substantially higher than the median (34.08% higher as compared the next highest year, 2019, at 13.54%). 2012 had the largest number of fees in the $20.01 to $30.00 range coupled with the smallest number of fees at every other interval except for $80.01 to $90.00. The two fees over $100.00 that year were two of the three highest fees from any year.

What does this mean for your utility?

Cut-off or reconnect fees, as with any fee, should accurately recoup the cost of providing the service associated with the fee – in this case preparing the cut-off list, disconnecting, and reconnecting the accounts on the cut-off list.

Clearly, cut-off fees for the average utility have increased over time. If your cut-off fee has remained static for several years, it’s time to reevaluate your fee.

To assist you with doing that, I’ll be unveiling a new online tool, much like the Days of Exposure calculator, to calculate your optimum cut-off fee in the next Utility Information Pipeline.

Is your cut-off fee adequate?

If you’re wondering if your cut-off fee is sufficient, please give me a call at 919-673-4050, or email me at gsanders@edmundsgovtech.com to see how a business review could help you find out.

Click here to subscribe to my free, bi-weekly email newsletter...

© 2020 Gary Sanders

Happy New Year 2020!

This is the annual end-of-the-year issue, where I usually take a moment to look back on the year past and to the year ahead. This year that seems even more relevant as we say goodbye to the decade of the teens (I said goodbye to my teens a long time ago!) and look ahead to the 20’s!

Tenth year!

2020 will mark the tenth year of publishing the Utility Information Pipeline. What began as just an idea in the fall of 2010 led to the first issue on January 4, 2011. That inaugural newsletter, announcing what I was planning to do and inviting readers to subscribe, was emailed to a couple hundred Logics customers. From that group, 76 people responded and became charter subscribers. Of those original 76, 37 are still subscribers today – 214 issues later!

Looking ahead

The 2019 Utility Fee Survey was the fourth Utility Fee Survey, so I’ve collected enough data to begin analyzing trends. Look for a couple issues in early 2020 to examine these trends, including one that analyzes cut-off and reconnect fees. Along with that issue, I’ll be unveiling a new online tool, much like the Days of Exposure calculator, to calculate your optimum cut-off fee.

2020 Utility Staffing Survey

2020 will be an even year, so that means it will be time for the biennial Utility Staffing Survey again. Look for the 2020 Utility Staffing Survey invitation in the spring with the results to be published a few weeks after that.

Blog moving to EdmundsGovTech.com

With Logics’ acquisition by Edmunds GovTech earlier this year, my blog will be moving from the Logics website to EdmundsGovTech.com early in 2020. When that happens, this will be one of the first places it will be announced.

Speaking engagements

Also, with the Edmunds acquisition, management is very much interested in having me speak to more groups. If you are part of a trade association and would like to have me speak at your annual conference or training session, please give me a call at 919-673-4050, or email me at gsanders@edmundsgovtech.com.

New years’ resolutions and goals

Happy New Year 2020! If one of your goals for the new year is to improve your utility business office operation, please give me a call at 919-673-4050, or email me at gsanders@edmundsgovtech.com to see how a business review could help you.

Click here to subscribe to my free, bi-weekly email newsletter...

© 2019 Gary Sanders

Is your utility losing credibility…?

Over the course of the next few Utility Information Pipeline issues, I’ll be analyzing and reviewing some of the trends I observed from the 2019 Utility Fee Survey. If you need a refresher, here are links to the three results issues for the 2019 Utility Fee Survey:

But before we start analyzing the data, let’s take a look at something else that stood out to me.

Generic email addresses

One of the things that surprised me about the survey responses is the number of utilities still using generic email addresses. By this, I mean an email address without a domain name specific to the utility. For example, xyzutility@gmail.com rather than jdoe@xyzutility.com.

Over the seven-year history of the Utility Fee Survey, the percentage of generic email addresses has dropped slightly, with the exception of a small uptick in 2017:

A bigger surprise

Even more surprising to me were the attendees from a recent utility conference where I presented my Improving Revenue Collections for Utilities presentation. A whopping 68.75% of the utility staff (this excludes board members and non-utility employees) attending the presentation had generic email addresses!

Branded email means credibility

A Verisign survey, dating back to September 2015, “found that 65 percent of consumers believe a company-branded email is more credible than a business using a free email account.” Even though your utility may not be a for-profit business, the need for credibility is no different!

If this was the case in 2015, I have to believe it’s even more important now – over four years later!

How to solve this

There’s an easy, low-cost way to solve this. First, secure a domain name for your utility. If you already have a website, you’ve got this step covered.

Next, signup for Google’s G Suite which provides branded email, shared calendars, and cloud storage for as low as $6 per user per month. You get the same easy-to-use email interface you may already be using for your personal email with a branded email address identifying your utility.

If you’re considering doing this, please contact me and I can provide you with a promotion code good for 20% off the first year of either the G Suite Basic plan or G Suite Business plan.

Questions about how to do this?

If you have questions about getting started with branded email addresses for your utility, please give me a call at 919-673-4050, or email me at gsanders@edmundsgovtech.com and I’ll be glad to assist you.

Click here to subscribe to my free, bi-weekly email newsletter...

© 2019 Gary Sanders

A new way to draw your own maps

Five years ago I wrote about using Google Fusion Tables to create your own maps. Unfortunately, Fusion Tables will be “turned down” (isn’t that a pleasant euphemism for something that’s going to simply stop working?) on December 3 of this year.

But there’s another option

Fortunately, there is still a relatively easy way to create a map of locations for those of us who aren’t skilled Geographic Information System (GIS) users.

Google offers My Maps, which works much like Fusion Tables by letting you import a list of addresses and populating pins on a Google Map for each address. Follow along to see how easy it is to create a map…

Let’s create a map

Start by creating a CSV (comma-separated values) file or an Excel spreadsheet (it must be an .XLSX file) with the data to be imported and mapped.

In a real-world scenario, you might want to map meter reading routes or all the accounts on the cut-off list. For this example, I didn’t want to compromise a customer’s actual data, so I chose data that is readily available on the internet. I bank with Bank of America and know they have a list of banking locations on their website. I harvested the location data from the bank’s website, and using some of the data manipulation tools I wrote about recently, I converted the data into a pipe-delimited text file:

I then opened this file in Excel and added column headings, which are required by My Maps:

Your file can have the full address in one column (as this file does), or it can have separate columns for Address, City, State, and ZIP Code.

In order to show an address error for illustration purposes, I changed the address for Lynnwood Collection to a PO Box.

Now we’re ready to import the file and create your map. Start by going to Google My Maps – https://www.google.com/mymaps.


Click on Import.

Drag your Excel spreadsheet or CSV file to the window or click on “Select a file from your device” to import your file with addresses to be mapped:

Click the column (or columns) containing the address. This is what My Maps will use to locate the placemarks on the map:

Choose a column to identify the title of the markers on the map. In a real-world scenario, this might be the service address or name of the account. For my illustration, this is the bank branch name.

Now, click Finish and My Maps will create your map.

Once the file is imported and the map created, if you have any bad addresses (for example, PO Boxes) that can’t be mapped, this message will be displayed:

Click on “Open data table” to correct the addresses. A grid similar to this will be displayed:

The addresses with errors will be listed at the top of the data table. You can correct the error right in the data table, without having to fix your original input file and begin the process all over again.

By default, My Maps will draw the map with all the markers having the same color:

However, you might want to see different color pins on the map for different addresses. For example, different colors based on the services provided, or to distinguish between manual and radio read meters on a meter reading route. In my example, I want to be able to visually see the difference between full-service banks and ATM-only locations.

To do this, click on the Uniform style hyperlink:

From the window that pops up, change Uniform style to the field in your data you want to use to determine the color of the marker. In my sample data, this is the Type field:

Google will randomly assign the colors of the map pins, based on the criteria you specified. If you want to change the colors, click on one of them, then click on the paint bucket icon at the bottom of the window and select your desired color.

I chose purple for full-service banking centers, blue for ATM-only locations, and green for Bank of America Advanced Center, whatever that is!

Congratulations, you’ve created your map!

Now, if you want to share your map with others, you can do so by clicking the share button for your map:

Then select the method you want to use to share the map:

Questions about creating your map?

If you have questions about creating your map, please give me a call at 919-673-4050, or email me at gsanders@edmundsgovtech.com and I’ll be glad to try to assist you.

Click here to subscribe to my free, bi-weekly email newsletter...

© 2019 Gary Sanders

Listservs and other resources

I’ve written in the past about resources I use to stay abreast of trends in the industry and to share my knowledge. I apologize in advance to those readers who aren’t based in North Carolina, because this issue is somewhat North Carolina-centric. North Carolina is where I live and has historically been where most of Logics’ customers are, so it’s the state I’m most familiar with. However, please don’t stop reading if you aren’t from North Carolina, because I’ve got a favor to ask of you later on.

Listservs I follow

If you’re not familiar with a listserv, once you’ve subscribed, you can ask a question of everyone on the listserv by sending an email to the listserv email address. Likewise, questions asked by others end up in your inbox and you can reply so everyone in the listserv sees your response.

Below is a list of the listservs I follow, in order of the most utility billing-related content:

  • NC Water listserv – topics dealing with water utilities, often related to utility billing and customer service.
  • NC Finance Connect – topics related to local government finance, occasionally includes utility billing and customer service.
  • NC City and County Manager’s listserv – topics of interest to city and county managers, rarely includes utility billing and customer service.
  • Virginia GFOA listserv – listserv for government finance professionals in Virginia, but with infrequent utility billing and customer service questions.

Why join a listserv?

I follow these listservs for two reasons. First, to lend my expertise when a question is asked for which I can provide an answer. Secondly, listserv questions are often a good source of ideas for newsletter topics. If someone has a question prompting them to ask how other utilities deal with that issue, it is often something I can elaborate on in a newsletter.

Rates dashboards

Another great resource is rates dashboards from the Environmental Finance Center at the UNC School of Government. The EFC has a series of rates dashboards for 18 states and Canada. To see if they have one for your state, you can check here, or below is a hyperlinked list of states, current as of the date of this newsletter:

You can use these rates dashboards to compare your utility’s rates to other utilities in your area, much like the Utility Fee Survey allows you to compare fees with other utilities.

“The book”

Speaking of resources and the UNC School of Government, Kara Millonzi, an attorney and professor at the School of Government, has written a book entitled Guide to Billing and Collecting Public Enterprise Utility Fees for Water, Wastewater, and Solid Waste Services. Written for utilities in North Carolina, this book answers many questions about what utilities legally can and cannot due. It cites the appropriate General Statute and case law, where applicable, to answer legal questions regarding billing and collecting for utilities in North Carolina.

If you work in utility billing in North Carolina and you don’t recognize this book cover,

do yourself a favor and click on it and order it now!

What resources do you use?

Are there similar resources you use when you need to find the answers to your utility billing questions? I would love to know what resources you use, especially if you are located outside of North Carolina. If there are listservs in your state, please feel free so share them by dropping me an email at gsanders@edmundsgovtech.com. Or, better yet, share them as a comment below so other readers can learn what resources you rely on.

Click here to subscribe to my free, bi-weekly email newsletter...

© 2019 Gary Sanders

2019 Utility Fee Survey Results – Part III

Over the course of the past few months, I’ve been conducting the 2019 Utility Fee Survey. This is an update to the original Utility Fee Survey in 2012 and subsequent fee surveys in 2015 and 2017. The survey was designed to research what fees utilities charge, how much they charge for each fee, and to see what trends, if any, are occurring with fees.

This is the third, and final, of three consecutive Utility Information Pipelines reporting the results of the 2019 Utility Fee Survey. 135 utilities, representing 22 states, ranging in size from 89 to 539,000 active accounts participated in the survey.

The Utility Fee Survey has become a biennial survey, alternating years with the Utility Staffing Survey.

As was the case in each of the previous surveys, the results include too much information for a single issue. If you’re interested, here are the results from the 2012, 2015, and 2017 Utility Fee Surveys:

The first results issue summarized the demographics of the survey respondents as well as water and sewer tap and impact fees. The last issue dealt with delinquent fees and policies. Today’s issue is the third and final survey results issue and recaps all remaining fees.

Returned check fees

All 135 participating utilities charge a returned check fee ranging from $10.00 to $50.00, as this graph illustrates (clicking on any of the graphs will open a larger image in a new window):

Interestingly, only 83 (or 61.5%) of the responding utilities charge the maximum fee allowed by their state. 24 utilities (representing 17.8%) charge less than the maximum allowed and 28 (or 20.7%) charge more than the maximum allowed.

If you’re interested in seeing how your fee compares to the maximum allowed for your state, here is a table with all 50 states.

Application fees

In one of the earliest Utility Information Pipeline issues, I wrote about application for service best practices. One of my recommendations was to charge a non-refundable application fee, in addition to any security deposit, to all new accounts. This year, 68 of the 135 utilities (representing 50.4%) responding to the survey charge such an application or administrative fee. This is up from 47.9% in 2017, but down from 51.9% in 2015 and 52.3% in 2012. These application fees range from $5.00 to $250.00 as shown below:

Transfer fees

This year, for the second time, the Utility Fee Survey asked how much utilities charge as a transfer fee for transferring service from one account to another. 62 of the 135 utilities (representing 45.9%) charge a transfer fee ranging from $5.00 to $100.00. This is up from 44.1% in 2017. Transfer fees charged by the responding utilities are shown in this graph:

Meter reread fees

28 of the 135 utilities (or 23.0%) charge a meter reread fee if the customer requests their meter be reread. This is down slightly from 23.7% in 2017 and 23.6% in 2015. In many cases, this fee is waived if it turns out the customer was correct and the utility misread the meter. Of the utilities that charge a meter reread fee, the fee ranges from $5.00 to $50.00, as this graph shows:

Meter tampering fees

101 of the 135 utilities (or 73.3%) charge a meter tampering fee. This is down from 77.1% in 2017 and 73.6% in 2015 but up from 60.2% in 2012. Seven utilities charge the actual cost of repairs or cost plus an administrative fee. One additional utility recovers their costs through the judicial system. Six utilities have an escalating fee that increases with each meter tampering offense. The remaining 87 utilities charge a flat fee ranging from $25.00 to $1000.00 as shown below:

Of the six utilities that charge an escalating fee, here are the charges for the first, second, and third offenses:

Convenience fees

One of my earliest issues explained why I believe utilities should accept credit cards. Of the 135 utilities responding to the survey, 122 of them (or 90.4%) accept credit cards. This is an increase from 89.0% in 2017, 81.1% in 2015, and 62.5% in 2012. Clearly, credit card acceptance has become standard practice for most utilities. Of the 122 that do accept credit cards, 85 (or 69.7%) of these charge a convenience fee on at least one method of credit card payments as shown below:

This is the second year the survey asked if the convenience fee is charged by the utility or by a third party. Of the 85 utilities that charge a convenience fee, 69 (or 81.2%) are charged by a third party as shown below. This is up from 69.4% in 2017.

The convenience fees charged by these utilities are too diverse in how they are assessed to be graphed, so they are presented here in a table.

Other fees

In addition to the fees that have been described in the three results issues, the survey asked what other fees utilities charge. Below I’ve listed a few of the more creative fees that were reported:

Meter test or calibration fee

At least 15 utilities charge a fee if the customer requests that their meter be tested or calibrated. The survey didn’t specifically ask about meter test fees however, most only charge the fee if the test results validate that the meter is registering correctly.

Return trip fee

When turning a meter on, most utilities will not leave the water on if the meter indicates water is running inside the house and no one is home. This requires the utility to make a return trip when the customer is home to turn the meter on again. Several utilities charge a return trip fee to cover the time and expenses involved in returning to the customer’s home.

Field collection fee

Most utilities have adopted the best practice of not collecting money in the field on cut-off day. At least one utility still allows customers to pay the field technician to avoid being cut off and they charge an additional $25.00 to provide that service.

A special offer

I still have a few slots left for the special offer I’m offering to the first five Utility Information Pipeline subscribers who respond. If you are one of the first five to respond, I will conduct a personalized fee consultation for one-third off the regular price. That’s $1,000 rather than the usual $1,500 price for this service!

I will review your utility’s current fee schedule and conduct an in-depth phone assessment to learn more about your fees. You will receive a presentation quality document illustrating how your fees compare with other utilities. Also included will be my recommendations for revising any existing fees and suggestions of new fees you should consider charging.

If you are interested in this special offer, please contact me by calling 919-673-4050 or e-mailing me at gsanders@edmundsgovtech.com. Remember, the special discount offer is only available to the first five people who respond!

Click here to subscribe to my free, bi-weekly email newsletter...

© 2019 Gary Sanders