Industry Use Cases

How to Reconcile Water Production and Billed Consumption

Production increased while billed consumption barely moved. A water balance starts with dates and volumes, especially when read cycles span month-end.

What to pull

Use Excel production, imports, exports and consumption logs, or export plant or bulk-meter totals and utility billing consumption. Include authorized unbilled use where documented.

How to check it

Align the service periods and units. Account for imports, exports and any documented adjustments under your reporting boundary. Show estimated reads and timing gaps separately.

Which periods have the biggest unexplained volume differences? Show inputs, billed use, documented adjustments and source rows.

What to do with the result

If the gap starts at month-end, check delayed reads and the timing of bulk-meter entries before assigning it to a district or a cause.

Use your utility’s approved water balance method and validated records for formal reporting.

Try Jolene.pro · Follow Jolene.pro on LinkedIn

Leave a comment