What it is
A billing extract, as it comes out of a utility’s system, put onto one shape: one row per account per billing period, carrying the class code, the meter size, the days in the period and the consumption. Class codes are mapped onto one vocabulary, so a commercial account in one export and a commercial account in another count as the same thing.
The part that costs a study its first two weeks is not the arithmetic. It is finding out which periods are complete, which class codes mean what, which meters were changed mid-period, and which readings cannot be true. That work happens once here and is written down.
What you hand us
The billing extract. It does not need to be clean or in any particular format: one file per year, one file per cycle, a report somebody exports by hand, or a database dump. If the utility can only produce it as a PDF, say so early, because that changes what the work is.
We do not connect to a billing system. This is a file you send and a file you get back.
What you get back
The panel, and a reason column.
Every period that could not be relied on stays in the panel and is flagged, with the reason on the row: the period was partial, the class code mapped to nothing, the consumption is not physically possible for that meter, or the meter was changed part-way through. A hole with no note beside it cannot be checked by the person who has to defend the study built on it.
What gets excluded from the study is your decision, not ours. The panel gives you the flag and the reason; which flags you exclude, and what you say about it in the study, is yours.
What it is built from
The utility’s own records, and nothing else. None of it is built from public filings, no figure in it comes from a regulator’s file, and we publish none of it anywhere.
What it does not do
It does not correct a reading. Where a consumption figure cannot be true, it is flagged as implausible and left as filed. Replacing it with an estimate would put a number in the panel that no meter produced.
It does not tell you what a class ought to be. Where a class code is not in the utility’s own documentation, it is flagged as unmapped and left for somebody who can ask.
It does not reconstruct a period that was never billed. A gap in the billing record is reported as a gap.
The panel covers the consumption side only, put in order so a cost-of-service allocation can start. It is neither a water balance nor an audit.