---
title: "Housing Society Water Balance Template: Record Supply, Storage and Demand"
description: Use a daily water balance template to record municipal, borewell and tanker supply, usable tank storage, withdrawals and unexplained differences without double counting.
---

[Skip to content](https://www.towneve.com/resources/society-water-balance-template#main)

[![TownEve](https://www.towneve.com/hs-fs/hubfs/raw_assets/public/Towneve-Theme/assets/logo.png?width=164&height=70&name=logo.png)](https://www.towneve.com/)

Menu

- [Water Management](https://www.towneve.com/water-management)
  
  ⌄
  
    - [How It Works](https://www.towneve.com/resources/how-it-works)
- Solutions ⌄
  
    - [For Builders](https://www.towneve.com/resources/builder-water-monitoring)
- [Resources](https://www.towneve.com/resources)
  
  ⌄
  
    - [Case Studies](https://www.towneve.com/resources/tag/case-studies)
- [About](https://www.towneve.com/about)
- [Contact](https://www.towneve.com/contact)

[Log in](https://water.towneve.com)[Request an Assessment](https://www.towneve.com/contact/)

1. [Home](https://www.towneve.com/)
2. [Resources](https://www.towneve.com/resources)
3. Housing Society Water Balance Template: Record Supply, Storage and Demand

[Guides](https://www.towneve.com/resources/tag/guides)

# Housing Society Water Balance Template: Record Supply, Storage and Demand

TownEve Editorial Team · October 1, 2026

## QUICK ANSWER

A society water balance compares the water entering a defined system with water leaving it and the change in stored water over the same period. This recurring ledger sits within the broader [water budgeting method](https://www.towneve.com/resources/housing-society-water-budgeting). A useful template records each source separately, uses verified usable tank volumes, distinguishes measurements from estimates, and identifies any unexplained difference for investigation. Use consistent [water-data evidence classifications](https://www.towneve.com/resources/water-budget-data-quality) for measured, calculated, estimated and unknown values.

## The governing equation is:

Opening stored water + external inflow − external outflow ± documented adjustments = closing stored water.

The most important setup decision is the accounting boundary. If the budget covers an entire society, moving water from an underground tank to an overhead tank is an internal transfer—not new external supply. If the budget covers just one overhead tank, the pumped transfer is an inflow to that tank. Never mix the two boundaries in one equation.

## WHY A TEMPLATE HELPS

Committees may know how many tankers were ordered and whether the rooftop tanks are low, yet lack a reliable daily reconciliation. A ledger makes the distinction between deliveries ordered, water received, water stored and water used visible.

It can also reveal missing measurements. An unexplained difference is not automatically a leak: it may reflect inconsistent timestamps, incorrect tank configuration, unrecorded internal transfers, meter error or other uses.

## SET UP THE ACCOUNTING BOUNDARY

Choose a specific water service and set of connected tanks. Drinking, domestic and treated recycled-water services may require separate ledgers.

## Document:

\- The external supply entry points included.

\- The tanks and compartments included.

\- The external withdrawal or delivery points included.

\- Internal transfers excluded from the property-wide total.

\- The cutoff time and time zone for each accounting day.

\- Who approves the configuration.

Do not add unrelated tanks merely because they share a building. If a pump or valve makes a volume inaccessible to the service, flag that operational constraint.

## COPY-READY DAILY LEDGER

## Create one row per service and accounting day with these fields:

Date | Service / boundary | Opening usable storage (kL) | Municipal inflow (kL) | Borewell inflow (kL) | Tanker inflow (kL) | Other external inflow (kL) | Total external inflow (kL) | External outflow (kL) | Documented adjustment (kL) | Expected closing storage (kL) | Observed closing usable storage (kL) | Reconciliation difference (kL) | Data quality / source | Responsible person | Follow-up.

Use separate source-event records when the daily total is derived from several meter readings or tanker arrivals. “Unknown” is not the same as zero.

## CALCULATIONS

Total external inflow = municipal + borewell + tanker + other verified external input.

Expected closing storage = opening usable storage + total external inflow − external outflow + documented adjustment.

Reconciliation difference = observed closing usable storage − expected closing storage.

An adjustment should have a documented reason; it must not be a plug number inserted merely to make the reconciliation zero.

If external outflow is unknown, do not claim to have calculated a reconciliation difference. Instead calculate the implied net withdrawal:

Implied net withdrawal = opening usable storage + external inflow − observed closing usable storage + documented adjustment.

Label that result “implied net withdrawal,” not independently measured consumption. It may contain unmeasured uses, losses and measurement error.

## ILLUSTRATIVE ONE-DAY EXAMPLE

One domestic-water boundary begins with 100 kL of usable water. It receives 40 kL of verified municipal supply and 20 kL of verified tanker water. An independent outgoing meter records 50 kL leaving the boundary. No adjustments are recorded.

Expected closing storage = 100 + 40 + 20 − 50 = 110 kL.

Suppose independently observed closing usable storage is 108 kL.

Reconciliation difference = 108 − 110 = −2 kL.

The 2 kL discrepancy calls for investigation; it is not proof of a 2 kL physical leak. Check meter cutoffs, source quantities, sensor readings, geometry configuration and any omitted transfers first.

If the outgoing meter were absent, 100 + 60 − 108 = 52 kL would be the implied net withdrawal under the stated assumptions, not verified resident consumption.

## HOW TO RECORD INCOMING WATER

Municipal: capture the meter or authorized supply record, measurement period and any known interruption.

Borewell: capture measured abstraction where available and relevant permissions or operational constraints without assuming an entitlement.

Tanker: record supplier, arrival, destination, measured received volume where possible and the difference between ordered, invoiced and received quantities.

Other sources: identify service, measurement method and permitted use.

Do not assume the nominal capacity of a tanker equals the exact volume delivered. Do not count a tanker merely because it was booked.

## HOW TO RECORD STORAGE

For each included tank, record its stable asset ID, water service, verified geometry, configured 0% and 100% usable-water reference levels, sensor or measurement reference, and measurement timestamp.

TownEve directly senses water depth and derives tank-specific level and volume from the configured geometry rather than a generic tank-size assumption. During setup, tank-specific 0% and 100% reference levels define the usable range, allowing unusable or dead-water portions to be excluded from usable-water calculations.

This supports accurate calculations across different tank sizes and shapes when the entered geometry and underlying level measurement are correct. Sum usable litres, not percentages, and do not double count water during underground-to-overhead transfer.

A stale reading should be labeled stale, not silently carried forward as a current observation.

## MEASUREMENT QUALITY RULES

For each quantity, distinguish “measured,” “estimated,” “planned,” and “unknown.” Preserve its source, units and timestamp.

Do not treat an estimated daily demand from occupancy × litres per person as a measured outgoing volume. It can be used for a planning scenario but cannot validate an actual water balance on its own.

Use consistent units: 1 kL = 1,000 litres. Align the beginning and ending measurement times. Record missing readings rather than interpolating them without disclosure.

A reconciliation threshold should reflect the property's actual meter, sensor and operating uncertainty; do not publish a universal acceptable-loss percentage.

## WHAT THE COMMITTEE SHOULD SEE

A daily summary can show opening usable storage, verified supply by source, observed closing usable storage, independently measured or implied withdrawal, discrepancy status, and a named action owner.

A weekly or monthly report can aggregate compatible daily periods. Do not sum daily opening or closing stocks as though they were flows; use the first opening stock and last closing stock for a continuous period, and sum the intervening flows.

Highlight incomplete data and late deliveries. A visually tidy report that replaces unknown values with zero is less useful than a clearly incomplete report.

## FROM WATER BALANCE TO ACTION

When incoming supply declines, confirm the source and update the supply assumption. When usable storage falls, compare the expected withdrawal with the actual level trend. When the reconciliation differs, verify the data before inspecting the physical system.

For a conditional water-runway estimate, combine verified usable storage with a stated withdrawal scenario and the timing of expected replenishment. A booked tanker is an uncertain future input until delivery is verified.

Pump transfer problems can leave underground water available while overhead levels fall. Tank-level patterns can prompt investigation, but they do not directly establish pump electrical state.

## WHERE TOWNEVE FITS

TownEve currently provides contactless ultrasonic monitoring for suitable overhead and underground tanks, current and historical level visibility, configured email alerts and telemetry-freshness monitoring.

Its geometry- and usable-range-aware configuration strengthens the storage column of the ledger. Where operations establish a controlled boundary, storage change over time can support a derived withdrawal or consumption estimate. Source-specific inflows use their own evidence or instrumentation, and unknown simultaneous inflow and outflow cannot be independently separated from uncontrolled tank-level change alone.

Direct pump-state monitoring is in development, remote pump operation is in development and testing, tanker workflows are in development, and flow-meter integration is app-capable although flow-meter hardware has not yet been deployed. Manually controlled no-inflow and valve-isolation observations have already been tested as an analysis method. The broader water-intelligence vision can progressively strengthen source, transfer and consumption records without presenting unreleased automation as current capability.

## FAQ

What is the water balance formula?

Opening storage + external inflow − external outflow ± documented adjustments = closing storage for a defined boundary and period.

Is water pumped from an underground tank to an overhead tank new supply?

Not for a property-wide boundary that includes both tanks. It is an internal transfer.

What if the society has no outgoing flow meter?

Calculate implied net withdrawal from observed storage change and verified inflow, but do not label it measured consumption.

Should drinking and recycled water be combined?

Keep separate service balances unless there is a valid, explicitly documented accounting reason to aggregate them.

Can an unexplained difference prove a leak?

No. Verify measurement, timing, configuration and omitted transfers before investigating physical losses.

Can tank percentages be added?

No. Convert each tank to verified usable volume first and only sum volumes that belong to the relevant service and boundary.

Is a tanker invoice proof of water received?

No. Preserve ordered, invoiced and verified received quantities separately.

## Organize your water-balance workbook

1\. Instructions and definitions: boundary, service, units, measured/estimated/planned/unknown definitions.

2\. Tank inventory: asset ID, service, geometry source, usable reference, included boundary.

3\. Source events: timestamp, source type, destination, measured quantity, evidence and verification.

4\. Daily balance: the copy-ready columns above, formulas and discrepancy status.

5\. Committee summary: period, verified source totals, opening and closing usable inventory, data completeness and unresolved issues.

Formula rules: use blank/unknown propagation instead of converting missing input to zero. Keep source records distinct from stock readings. Never sum opening stocks across dates. Do not automatically interpret discrepancies as leaks. Validate nonnegative quantities, units, duplicate source events and timestamps. Adjustments require a reason. Preserve an audit trail for corrected readings.

Explore further

## Understand your water system. Plan the next step.

Browse more practical resources or discuss your property's monitoring needs.

[Request a Water Monitoring Assessment](https://www.towneve.com/contact/)[All resources →](https://www.towneve.com/resources)

TownEve · CyberGrove Solutions Private Limited  
Water monitoring for residential communities.

[About](https://www.towneve.com/about/)[Contact](https://www.towneve.com/contact/)[Privacy](https://www.towneve.com/privacy/)[support@towneve.com](mailto:support@towneve.com)

 ​

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "TownEve Editorial Team",
    "url" : "https://www.towneve.com/resources/author/towneve-editorial-team"
  },
  "dateModified" : "2026-10-05T12:47:27.445Z",
  "datePublished" : "2026-10-01T06:19:34.000Z",
  "headline" : "Housing Society Water Balance Template: Record Supply, Storage and Demand",
  "mainEntityOfPage" : {
    "@id" : "https://www.towneve.com/resources/society-water-balance-template",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://www.towneve.com/hubfs/TownEve%20logo%20(1).png"
    },
    "name" : "TownEve"
  }
}
```