Landed the biggest deal of my career — a regional grocery chain with 127 locations across Tennessee, Alabama, and Mississippi. Utilities include TVA distributors, Alabama Power, and Entergy Mississippi. I'm excited but also terrified. The sheer volume of accounts is overwhelming. Each location has 2-4 meters. That's potentially 400+ utility accounts to audit. How do you even organize something like this?
Retail chain with 127 locations — lessons learned
Congratulations — that's a career-making engagement. The key is to systematize everything from day one. Build a master spreadsheet with every location, every meter number, every account number, every utility, every rate class. Then prioritize by spend. The top 20% of locations by utility spend will contain 80% of the errors. Start there. I did a drugstore chain with 84 locations on PSE&G and JCP&L across New Jersey and the first 15 stores I audited produced $180,000 in findings. The remaining 69 stores had much smaller errors.
This is where utility bill auditing becomes a real business rather than a solo practice. A 127-location engagement requires project management discipline. My advice: break it into phases. Phase 1, collect all bills and build your database. Phase 2, audit the top 30 locations by spend. Phase 3, roll out findings to similar locations — if Store #14 in Nashville was on the wrong rate, check every Nashville store on the same utility. The errors tend to cluster by utility territory because the same billing department makes the same mistakes across accounts.
I did a hotel chain with 45 properties last year. One thing that saved me massive time — I asked the client for their consolidated utility payment data from their AP system. Most large companies track utility payments centrally even if the bills go to individual locations. That gave me 36 months of payment history for every location in one spreadsheet instead of requesting 45 separate billing histories from 12 different utilities.
The AP data idea is brilliant. I'm going to ask for that immediately. And the phased approach makes total sense. Starting with top 30 by spend this week.