I've done a few 40-plus location portfolios. The key is getting interval data for all accounts upfront, even the ones that look clean on the surface. Found two hidden ratchet issues that way.
Member Community
Enter your email to read this discussion
You're reading the AAUBA Member Forum — where Certified Utility Bill Auditors share case studies, tariff strategies, and industry insights.
Free to read. Enter your email to continue.
No spam. We'll send you one welcome email about CUBA certification. Unsubscribe any time.
Aggregating Pepco data across 12 DC properties
Working 12 Pepco DC commercial accounts across a property portfolio. Mix of MGT-LV and MGS rate classes. Has anyone built a tool for bulk DC tariff validation? The manual rate lookups across the DC PSC approved rates are killing me.
I've been doing exactly this for two clients the last few months — DIP Welcare and Inspire Rehab. Built an AI-powered validator that checks all six DC surcharges against the approved rate tables. $0.50 variance threshold catches the real errors without drowning in rounding noise. Happy to walk through the architecture offline.