Zip it

By Clinton Jones on November 5, 2010

A customer at the WUG was commenting on one of their challenges being around ensuring that the Zip code in their Excel workbook was correct. As many of you are aware, incorrect Zip codes can lead to a wide variety of challenges not just in the logistics arena, but also in finance (sales tax jurisdiction) and of course it can mess with your statistical analysis in a variety of other areas too, take voting for example.

Not only do Zip codes change as a result of Zip code rezoning, but new zip codes are added and whole suburbs reclassified – remember that the Zip code is the USPS way to get your mail to you in an efficient way.  Timely updates to your SAP system can of course be achieved through integration, but what do you do in MS Excel? You don’t want to keep extracting data from your SAP system simply to ensure that your Zip codes are up to date, additionally, having a list of Zip codes is ok, but doesn’t tell you whether the address that you have entered actually matches up with the correct Zip code.

Through some sleuthing here at Winshuttle, we came up with a couple of options for you to consider, some of which allow you to make real time connections to an online address verification and Zip code validation resource over the internet.

If you’ve implemented these or something similar, we would love to hear about it

About the author

Clinton Jones is a Director for Finance Solutions Management at Winshuttle where he has worked since 2009. He is internationally experienced having worked on finance technologies and business process with a particular focus on integrated business solutions in Europe, the Middle East, Africa and North America. Clinton serves as a technical consultant on technology and quality management as it relates to data and process management and governance for finance organizations globally. Prior to Winshuttle he served as a Technical Quality Manager at SAP and with Microsoft in their Global Foundation Services group.

Questions or comments about this article?

Tweet @uploadsap to continue the conversation!