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.