How to Find Water Accounts With Meter Reads but No Bill
The meter-reading run finished on time. Several active accounts may still be missing from the billing batch. Start by checking which accounts had an accepted read but no corresponding bill.
What to pull
Use Excel meter reads, account roster and billing lines, or export them from your meter data and utility billing systems. Keep premise, account, meter, read date, cycle and status.
How to check it
Match active accounts to the premise and billing cycle. Account for meter replacements, moved customers, billing holds and later bills. Keep estimates separate from actual reads.
Which active accounts have accepted reads and no bill for the cycle? Show holds, later bills and source rows.
What to do with the result
Send billing the unexplained accounts with the read and cycle references. Check for account changes before reprocessing.
Verify account status and the billing system’s current records before taking action.