Expense categories

How to track water bill and tanker charges month by month

A routine to track water bill and tanker charges: tally every load, log the bill, compare seasons and catch price changes, with a worked month in rupees.

Editorial illustration for How to track water bill and tanker charges month by month

Tracking water costs is easiest when you split them in two: the regular municipal or society bill, logged when it arrives, and tanker loads, tallied as they are delivered. At month end add the two. The tanker tally is the part that matters, since it is irregular, often paid in cash, and the first thing to be forgotten.

What should I record?

  • For the bill: billing period, amount, due date, date paid and how
  • For each tanker: date, number of loads, size if it varies, price per load, who supplied it and how you paid
  • For drinking water: cans or refills, with the count
  • Anything that changed: a new supplier, a price rise or a failed supply

How often does it arrive?

The bill is monthly or every two months. Tankers can come several times a week or not for a month, depending on the supply, the season and how much storage you have. Because of that, set a fixed time to update the tanker tally, such as every Sunday, instead of trying to log each delivery on the spot, when you might forget. A small tally on a note in your phone, one line per delivery, is enough to start.

A hypothetical month

Say your bill is ₹760 every two months, which is ₹380 a month, and tankers cost ₹600 a load in April. These numbers are illustrations.

Date in AprilItemLoadsAmount
3rdTanker1₹600
12thTanker1₹600
21stTanker1₹600
29thTanker1₹600
Monthly share of billMunicipal-₹380

Four loads at ₹600 make ₹2,400, and adding ₹380 gives an April water cost of ₹2,780. If the price rises to ₹650 in May and you need six loads, the tanker amount is 6 × 650 = ₹3,900. In that case, May reaches ₹4,280, and the entire increase of ₹1,500 comes from tankers.

How do I spot a change?

Look at three numbers rather than one: number of loads, price per load and total. A higher total with the same number of loads means the price moved. A higher total with the same price means more loads, which often points to a supply problem or a leaking tank or sump. A fall in the municipal bill with a rise in tanker loads may mean the supply is shifting to tankers, which is useful to know before the next summer.

What does a sensible review look like?

  1. Weekly: update the tanker tally
  2. Monthly: add tankers and bill, and compare with last month
  3. Quarterly: check the cost per load and the number of loads against the same quarter last year
  4. Yearly: total the year's water cost and see which months were highest

A spreadsheet works well for this. If dates are in A2:A100, loads in B2:B100 and amounts in C2:C100, the formula =SUMIFS($C$2:$C$100, $A$2:$A$100, ">="&$F$1, $A$2:$A$100, "<="&$G$1) totals the tanker spend between the dates in F1 and G1, and =SUMIFS($B$2:$B$100, $A$2:$A$100, ">="&$F$1, $A$2:$A$100, "<="&$G$1) counts the loads.

Where an app can help

A sheet works while the entries are few. SpendixAI is handy when you want the bill, the tankers and the rest of your spending in one place: bank statement lines for the bill come by import, and a month's cash tanker deliveries can be added together in one go. Pro adds budgets, so you can give Water a monthly limit and see how a tanker-heavy month compares.

Next step

  • Create the two water sub-categories
  • Start the tally this week
  • Note the supplier and price per load
  • Compare each month with the same month last year
  • Check the tank and pipes if the load count creeps up
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports