To see what water really costs your household, put the municipal bill, borewell running cost and tanker payments under one Water category with three sub-categories, and total them each month. Many homes only count the bill and miss the larger tanker spend, so the combined line is often a surprise.
What are the three lines?
- Municipal or society supply: the water bill, or the water component of your maintenance if it is billed there
- Borewell: the electricity used by the pump, plus repair and servicing of the motor and pipes
- Tanker: the payment per trip, with the capacity in litres if you know it
If you also buy drinking water cans or run a purifier, keep those as a fourth line called Drinking water, since the purpose and the price pattern differ.
How do you set it up?
Create a Water category, and under it the sub-categories Municipal, Borewell and Tanker. In a sheet, use one row per payment with date, source, amount and a note. In SpendixAI, custom categories and sub-categories let you do this, and a report grouped by category then shows the total for Water as well as each source.
How do you estimate the borewell electricity cost?
If the borewell pump has its own meter, use that bill. If not, estimate from the motor's rating plate. Power in kilowatts times hours run times days gives units. Say, as an illustration, a 0.75 kW motor runs 1.5 hours a day for 30 days. That is 0.75 times 1.5, or 1.125 units a day, and 33.75 units a month. At a made-up ₹6 per unit, that is about ₹203. Mark the figure as an estimate, since the motor's actual load, the water level and the run time vary.
What does a month look like?
| Source | Details (made up) | Cost (₹) |
|---|---|---|
| Municipal supply | Monthly bill | 250 |
| Borewell | Estimated electricity, 33.75 units at ₹6 | 203 |
| Tanker | 3 trips at ₹600 | 1,800 |
| Total water cost | Sum of the three lines | 2,253 |
250 plus 203 plus 1,800 is ₹2,253. With only the municipal bill counted, the cost would look like ₹250, which understates the real figure by about nine times.
Can you compare the price per litre?
If you know the tanker capacity, yes. A 6,000-litre tanker at ₹600 is ₹0.10 per litre. For municipal water, divide the bill by the litres supplied only if you have a meter reading or the bill states volume. If not, leave it as a monthly cost. Do not guess a volume; the comparison is only useful when the figures are real.
What else should the water line include?
- Motor or pump repairs and rewinding
- Pipe and tank cleaning
- Water testing, filters and softeners
- Society water charges, if listed separately on the maintenance bill
- Any one-off cost such as drilling or deepening a borewell, kept separate with its date
How do you use the total?
Look at the monthly total across the year. Summer months often have more tanker trips, and a rainy month may have fewer. If the tanker line rises, check the municipal supply schedule and the water level, and consider asking the society whether storage or a bigger tank would help. The figure also helps you see the cost of living in a flat or area with irregular supply.
Monthly routine
- Enter each tanker payment on the day, with the trip count in the note
- Add the municipal bill when it is paid
- Estimate borewell electricity once a month, or use its meter bill
- Check the Water total against the previous month and the same month last year
Useful ideas start with a clearer picture of your own spending.
Explore your reports

