Just landed a client with 180+ locations across 12 states. Mix of retail, warehouses, and small offices. Different utilities, rate schedules, everything. How do you guys tackle these monster audits without drowning in spreadsheets? Looking for workflow suggestions that actually scale.
How do you handle massive multi-site portfolio audits efficiently?
Alice has the right approach. I also create utility-specific templates since you'll see the same billing errors repeated across multiple sites with the same carrier. Found ComEd was misapplying the small commercial rate at 23 locations - once you spot the pattern, the rest goes much faster.
For data management, I swear by pivot tables in Excel or better yet, Power BI if you have access. Upload all the usage and billing data, then you can spot outliers and anomalies across the entire portfolio. Sites that are way off the norm usually have the biggest opportunities.
Solid advice from everyone. One thing I'd add - negotiate with utilities for bulk data exports when possible. Some will provide CSV files for all locations at once rather than making you download 180 separate accounts. Saves enormous time upfront. Also consider bringing in temporary help for the data entry phase.
All great suggestions. Leon, how did the client provide the initial data? If they're organized with account numbers, billing contacts etc. that's half the battle. I've seen portfolio audits die because the client couldn't even tell you which locations they had active service at.
Leon, I feel your pain. For portfolios that size, I categorize sites first - similar usage patterns, same utility territory, comparable square footage. Then I audit a representative sample from each category (maybe 15-20%) and use those findings to prioritize which other sites get full audits vs. targeted reviews.
Randy's bulk data tip is golden. I'd also suggest setting up a shared drive with standardized folder structures for each site. Makes it easier if you need to bring in other auditors mid-project. Document your methodology as you go - with that many sites, you'll forget your own logic by month 3.