Water System Logbook

Free calculator · same math as the app

Water meter usage calculator

Enter meter readings with their dates to get the water used between readings and your average use per day, even with missed days, weekends and a meter reset in the middle.

For use per connection per day

Tick Reset when the meter was reset, replaced or rolled over before that reading. It starts a new baseline, as in the app.

Showing an example: a small park's source meter over nine days.

Paste readings from a spreadsheet

Average 6,171 gal/daySee results

Average use
6,171gal per day
Total use

over 8 days in 6 intervals

Per connection
154gal/day
Highest interval
8,834gal/day
ending Sep 8
Average gal per day, by interval
02,5005,0007,50010,000Sep 2Sep 3Sep 4Sep 7Sep 88,834Sep 9avg 6,171

Hover or tab to a bar for its interval.

DateReadingDaysUsagePer day
Sep 1 07:401,284,310—First reading — no usage yet—
Sep 2 07:351,290,02015,7105,730
Sep 3 07:501,295,65515,6355,577
Sep 4 07:451,301,48015,8255,845
Sep 7 08:101,319,300317,8205,906
Sep 8 07:401,327,95018,6508,834
Sep 9 07:451,333,70015,7505,730

How to calculate water usage from meter readings

A totalizing meter only ever counts up, so the water used between two readings is simply the later reading minus the earlier one. Average use per day is that amount divided by the days between the readings. From the example above:

ReadingRegisterUsed since previousDaysPer day
Thu Sep 4, 7:451,301,480———
Mon Sep 7, 8:101,319,3001,319,300 − 1,301,480 = 17,820 gal317,820 ÷ 3 = 5,940 gal

Counting the times too, that interval is 3 days and 25 minutes, so the calculator shows about 5,906 gallons per day. Reading at about the same time every day keeps each interval close to 24 hours, so daily figures compare fairly.

Keep the readings, not the differences

It's tempting to log “gallons used today” instead of the register reading. Don't. The register reading can always be checked against the meter and recalculated. A daily difference can't, and one mistake carries into every figure after it. The Water System Logbook app follows the same rule: it stores readings exactly as entered and works out usage whenever it's displayed or exported, never storing it.

When the new reading is lower

A lower reading means one of three things: a misread or transposed digit, a meter that was reset or replaced, or a register that rolled over past its highest number. This calculator, like the app, doesn't guess which. Fix the typo, or tick Reset on that reading so it becomes a new baseline. If you know the register rolled over, the rollover guide shows how to work out the water used across the rollover.

Units, multipliers and conversions

Not sure which dials to read? See how to read a water meter.

Using per-connection figures

For a park or small community, use per connection per day to compare against your own history. Use varies widely with occupancy, season and irrigation, so your baseline matters more than any national number. For a sense of scale, EPA WaterSense puts the average American family at more than 300 gallons a day at home. A sustained jump above your baseline, especially overnight when little water should be used, is the classic sign of a leak. Comparing the source meter with your master or customer meters can confirm it: see the water loss calculator.

Questions

How do I calculate water usage from two meter readings?

Subtract the earlier reading from the later one. That's the water used between them, in the meter's unit. Divide by the number of days between the readings for average use per day. Apply the register's multiplier first if it has one (×10, ×100).

What if I missed a day or skipped the weekend?

Nothing is lost. The next reading covers the whole gap, and the calculator divides by the actual days between readings, so a three-day weekend interval shows the same per-day rate as three single days would.

Why does a reading show as lower than the previous one?

Either a digit was misread or mistyped, or the meter was reset, replaced or rolled over. Correct the typo, or tick Reset for that reading. The calculator then treats it as a new baseline and measures the next interval from it.

Does it work for a pump hour meter?

Yes. Choose Hours as the unit to get run hours per day. To combine pump hours with the source meter and get gallons per minute, use the well pump GPM calculator.

Are my readings saved or sent anywhere?

No. The calculation runs in your browser and nothing is sent to a server. Readings are cleared when you close the page, so download the CSV if you want to keep them.

Sources

  1. EPA WaterSense — Statistics and facts (household water use)

Last reviewed September 28, 2026. Rules change and states add their own; confirm with your state drinking water program.