Industry Use Cases

How to Check Estimated Water Bills After an Actual Meter Read

An actual meter read arrives after three months of estimates. The account gets a large catch-up bill. Your billing team needs to see how much of that difference has already been handled.

What to pull

Use an Excel read history and adjustment register, or export reads, consumption lines and bill adjustments from meter data and billing software. Keep meter changes and multipliers.

How to check it

Bracket the estimate period with accepted actual reads. Compare total measured use across the interval with estimated volumes already billed. Keep resets and replacement meters out of the simple comparison.

Which accounts have a large unresolved difference after the next actual read? Show the read interval and billing adjustment rows.

What to do with the result

Check high-dollar accounts first. Give customer service the read history and existing adjustment before they explain a catch-up bill.

Use approved meter and billing rules when reviewing or adjusting customer balances.

Try Jolene.pro ยท Follow Jolene.pro on LinkedIn

Leave a comment