How a job runs.
The work is ordinary forensic practice, done exhaustively. Andy builds the register, resolves the tariff, recomputes every determinant, and writes up each disagreement with the basis it was tested against. What it does not do is decide anything.
-
Register construction
Every statement is parsed into rows — service period, days billed, meter and multiplier, usage and demand determinants, and each charge component separated out. Nothing later in the job reads the PDF again; the register is the working record.
-
Issuer and tariff resolution
The issuer is identified and the tariff, riders, and surcharges in force for each service period are resolved from the tariff cache. Periods that straddle a rate change are split, not averaged.
-
Recomputation
Each determinant is rebuilt from the tariff: service classification, billed demand and any ratchet, power factor, meter multipliers, rider and surcharge application, proration across the service period, tax treatment, and late charge accrual.
-
Findings
Where the rebuild disagrees with the statement, the disagreement is written up with its tariff basis, the affected periods, the arithmetic, and the exposure. Recurring errors are carried across every statement they touch rather than reported once.
-
Package
Six narrative documents and the register workbook, cross-referenced. Every figure in the documents traces back to a register row.
-
Your review
You verify the findings against the tariff actually in force, decide which to raise and which to leave, choose between informal dispute and formal complaint, and sign what goes out. That judgment is the part of the work that is not automatable, which is why the tool is gated to certified auditors.
What Andy remembers
Four stores carry across jobs: an issuer registry, a findings knowledge base, a tariff cache, and an outcomes tracker that records how demands were actually resolved. SQLite is the queryable source of truth; the workbook views are a read-only projection rebuilt from it, so there is never a second version of a fact.
Issuer-specific memory currently runs deepest for ConEd, PSE&G, BGE, Atlantic City Electric, Pepco, and Indiana Michigan Power. Statements from other issuers are audited from their tariffs the same way, without that accumulated prior.
What Andy does not do
It does not decide materiality. It does not choose between an informal dispute and a Commission complaint. It does not contact the utility, file anything, or sign anything. A confident, well-formatted, wrong demand letter damages the client, the auditor, and the profession, so the last step is deliberately a person.