WaterSight - Customer Billing

Product(s): WaterSight
Version(s): 10.00.
Area: Documentation


Administration page to upload customer meter billings. This information can be uploaded trough an excel or CSV file, which template is available for download in the Digital Twin Setup page, under Download Templates (Monthly Billing file). The template file that must be completed is composed by the following columns:

  • ID:  ID of the customer meter. Required field. Must be unique for each meter and must match the ID provided in the  Meters Characteristics page. This ID should also match the Billing ID field in the uploaded WaterGEMS hydraulic model, in case customer meter elements exist. 
  • Billing month: month which the billing is referred to. Required field. 
  • Value: value of the monthly billing volume. Required field. 
  • Units: billing volume units. Options available are: m3, hft3, hgal (U.S), kgal (U.S). Required field. 

There should be only one billing record per customer per month. If billing data exists with more than one record per customer per month, each customer data should be integrated to monthly values.

Figure below shows the template excel file that must be completed and then imported into WaterSight. 

Figure 1 - Customer Billing template file

The user can import several files - in which each file represents a billing month - or just one file with all historical billing information. Customer billings should be uploaded once every month, to make sure that water balance data is kept up to date.

Customer billings should come from the commercial system, to assure that the most up to date information is imported into WaterSight. 

Billing Table

The information provided here is just a summary of all billing records inserted by the user. Through this table the user can easily understand which billing months were uploaded, and the number of customers and billing records uploaded in each month. The number of customers and monthly billing records uploaded for each month should match, unless there were customers uploaded that are not served anymore by the water utility (and therefore have no revenue). In this last case, best practice would be to also exclude those customers from the Customer Billing file.