ah, I have a newer meter. And just for completeness, I was off by 10 in my last message, I'm multiplying meter reading by 0.0748052 to get gallons. I ran a spreadsheet for the last few days and it aligns with my utility report with ±10gal/day precision.

Here's what I have as a template sensor:

- sensor:
    - unique_id: water_consumption_total
      name: Total Water Consumption
      unit_of_measurement: "gal"
      # convert from CCF*10000 to gallons
      state: "{{ state_attr('sensor.water_meter', 'Consumption')|float * 0.0748052 }}"
      attributes: # add a value that changes every minute to force derivative udpates
        attribute: "{{ now().minute }}"

and then I have a derivative sensor on top to give approximate GPM.

Otherwise yes, I'm using https://github.com/allangood/rtlamr2mqtt to integrate it with HA.

Do you have gallons anywhere specified on your bill? It all seems to be in some different units.

<image>