You may want to look into our WaterSight product that does a water balance in line with AWWA/IWA guidelines..
https://www.bentley.com/en/products/product-line/hydraulics-and-hydrology-software/openflows-watersight
If you're interested, we could have…