GIS Audits Electric Use Tax and Uncovers Billing Errors

Billing the right address seems like an easy endeavor, particularly when you have buildings that have been located on a property for decades. Yet minor errors in a database can make a sizeable difference in tax collection and village revenue. Take the case of Elk Grove Village, IL which imposed a municipal electric use tax back in 2011. 

Today, Elk Grove Village is in the process of verifying that tax data to make sure all the properties within its boundaries are being billed correctly. The local electric company, ComEd, gave the village a spreadsheet of the address billing records to be verified.

After mapping all of the address points in the spreadsheet data, the staff at Geographic Information Systems (GIS) discovered that the records provided by ComEd had errors in the database. Thanks to an intersect tool in GIS, staff were able to quickly identify all the addresses in the village that were not correctly billed. 

Some errors in the database are buildings that have no billing address on the property. Other billing records were combined for companies or owners that control multiple properties. These addresses must be manually reviewed to determine the appropriate billing. Without the benefit of GIS, staff would have to rely solely on billing data supplied by ComEd to manually review each address – a time-consuming and inefficient process.