What a Real CUBA Audit Looks Like: A $643,000 Hotel Bill Walkthrough

The most common question people ask before enrolling in a utility auditing certification is some version of: “What does the work actually look like?” Reasonable question. The marketing copy on most professional certification sites is heavy on outcomes and light on substance, and a thoughtful adult considering a career change wants to see the inside of the work before committing.

This post walks through a real audit — anonymized for the client’s privacy — that closed earlier this year. A hospitality property in the Northeast, served by Con Edison on a large commercial electric tariff, with five years of billing history and a total billed amount of approximately $643,000 across the audit period. We will walk through what the auditor actually did, what was found, and what the recovery looked like. By the end, the work itself should feel concrete rather than abstract.

The Setup

The client was a hotel operator with a single property under audit. The property had been on the same Con Edison rate (a large commercial demand-metered tariff) for the entire audit period. The billing volume was substantial: sixty-one bills covering a sixty-month period, with monthly billed amounts ranging from approximately $7,000 in low-usage months to over $14,000 during peak summer demand.

The engagement was contingency-based on the standard 50% structure. The client provided account numbers and authorization to obtain billing history directly from the utility. No money changed hands at the start.

Phase One: Data Collection

The first phase of any audit is acquiring complete, accurate billing data. For a sixty-month review on a single account, that means sixty-one PDF bills, a tariff history covering the audit period, and any available metering data.

This phase is unglamorous and important. The errors hide in the gaps — a missing month, a misread bill, a tariff version applied incorrectly. The discipline of the trained auditor is to refuse to proceed to analysis until the data set is genuinely complete and reconciled. In this engagement, that took roughly six hours of work spread across two days.

Phase Two: Tariff and Rate Verification

Once the data is in hand, the auditor verifies the rate class assignment and confirms which tariff version applied during which billing period. Con Edison, like most large utilities, files rate cases periodically. Each filing changes specific charges — supply rates, delivery rates, capacity tags, riders — that must be applied to the corresponding billing months.

On this property, the rate class was correctly assigned. That was the easy answer. The harder question — and the one that produced the largest finding — was whether the contract demand level had been correctly handled.

The Largest Finding: Contract Demand

Commercial demand-metered electric accounts have a concept called contract demand: a level of peak kilowatt usage that establishes minimum billing parameters and triggers certain capacity charges. On Con Edison’s large commercial tariff, contract demand is calculated as a rolling eighteen-month maximum of the customer’s actual demand. It is informational, not a billed minimum — but it drives several derivative calculations.

Reviewing the bills month by month, it became clear that the contract demand level the utility had been carrying for this property was reset upward during a single anomalously high month, and never recalculated as the rolling window moved past that month. The result: capacity tag charges and certain delivery components were calculated against an inflated contract demand for over twenty consecutive billing periods.

Recovery on this single finding: in the low five figures, with ongoing monthly savings going forward.

The Second Finding: Capacity Tag Variance

Con Edison participates in the New York Independent System Operator’s installed capacity (ICAP) market. Each commercial customer is assigned a capacity tag — a number that determines the customer’s share of capacity costs based on their demand during a specific peak hour the previous summer. The tag updates annually.

On this property, the capacity tag had been recalculated each year, but the recalculations did not reflect the customer’s actual peak-hour demand for several of the audited years. Cross-referencing the customer’s interval data against the published peak hours showed that the assigned tags were consistently too high.

This finding required an interaction with the utility — submission of the customer’s data, formal request for tag recalculation, and follow-through on the resulting credits. That kind of advocacy work is part of what the contingency fee compensates.

The Third through Eighth Findings

The remaining findings on this audit included a sales tax rate that did not reflect the property’s correct allocation between residential-allocated and commercial usage, several months in which the demand reading appeared to have been estimated rather than read, a rider that had been applied at the wrong rate version for three consecutive months, and a small but recurring issue with how the merchandise function charge was being calculated.

Individually, several of these findings were modest. Cumulatively, they added thousands of dollars to the recovery. This is the unglamorous truth of utility auditing: the headline finding is usually a single large item, but the total recovery is built from a stack of smaller findings that no one was ever going to catch by glancing at the bills.

The Deliverable Package

Every CUBA audit produces a four-document package:

• The audit workbook — a multi-sheet Excel file containing the full bill-by-bill analysis, year-over-year comparison, rate history, validation, and findings register. This is the working document.
• The audit report — a Word document containing the executive summary, account profile, methodology, findings narrative, and recommendations. This is the document the client reads.
• The utility action letter — the formal correspondence to the utility documenting the findings and requesting recovery. This is the document that gets the money back.
• The client cover letter — a one-page summary that frames the engagement and the next steps. This is the document the client forwards internally.

The package is the credibility of the practice. A polished, professional set of documents — branded consistently, structured the same way every time — is what turns a first audit into a second audit, and a second audit into a referral.

Total Time Invested

Across the full engagement, the auditor invested roughly twenty-eight hours: six hours of data collection, twelve hours of analysis, six hours of report production, and four hours of utility correspondence and follow-through. Total fee income, at the 50% contingency on the recovery: in the low five figures.

Effective hourly rate on this single engagement: well above $300. And this engagement, like most, will produce ongoing monthly savings for the client that generate fee income for the duration of the agreed recovery period.

Why This Case Study Matters

Nothing about this audit was unusual. The findings were the kinds of findings that appear, with variations, on the majority of large commercial accounts in this region. The methodology — data collection, tariff verification, line-item analysis, finding documentation, utility correspondence — is the methodology taught in the CUBA certification, applied to one specific property.

If you’ve read this far, you’ve seen the inside of the work. It is detailed. It is technical. It is repeatable. And it produces results that, for most career changers, will compare favorably to almost any alternative they are considering.

The next audit looks just like this one. So does the one after that. The skill is what makes the difference, and the skill is exactly what gets transferred during the certification.