A summer water and cooling cost log is a simple sheet with one row for every tanker, can, ice bag or cooling item you pay for, plus a monthly total. After one season you can see exactly how much more the hot months cost than the cool ones, and that difference is the amount to plan for next year.
Why do these small costs need a log?
Tanker money is paid in lumps, cans in ones and twos, ice in small notes. None of it looks big on the day, and most of it is cash. By the end of May the total can still surprise you, because it never appeared in one place. A log puts it there.
What should each row contain?
- Date of the purchase or delivery.
- Type: tanker, drinking water can, ice, cooling item or other.
- Quantity, such as one tanker, six cans or two ice bags.
- Amount paid and how it was paid.
- A short note, for example the supplier or a delivery that came late.
If your society or building arranges a shared tanker and charges you through the maintenance bill, log your share as its own type so it does not get lost inside maintenance.
A starter log you can copy
| Date | Type | Quantity | Amount | Note |
|---|---|---|---|---|
| 3 May | Tanker | 1 | ₹700 | Paid cash on delivery |
| 5 May | Cans | 10 | ₹400 | Monthly supplier, ₹40 each |
| 8 May | Ice | 2 bags | ₹60 | For the weekend |
| 12 May | Cooling item | 1 | ₹450 | Cooler pump replaced |
| 19 May | Tanker | 1 | ₹700 | Second booking of the month |
The amounts above are made up to show the layout. Your tanker, can and ice prices will be whatever you actually pay.
How do you compare a summer month with a cooler month?
Total each type separately and then add up the month. Say in May you book four tankers at ₹700, take thirty cans at ₹40, buy ten bags of ice at ₹30 and pay ₹450 for a cooler pump.
- Tankers: 4 × ₹700 = ₹2,800.
- Cans: 30 × ₹40 = ₹1,200.
- Ice: 10 × ₹30 = ₹300.
- Cooling item: ₹450.
- May total: ₹2,800 + ₹1,200 + ₹300 + ₹450 = ₹4,750.
Say that in January the same home needs one tanker at ₹700, fifteen cans at ₹40 and no ice or cooling items. That is ₹700 + ₹600 = ₹1,300. The gap is ₹4,750 − ₹1,300 = ₹3,450. That ₹3,450 is the summer water and cooling extra, and it is a more useful number to plan with than a general feeling that summer is expensive.
What should you do with the numbers at the end of the season?
Set a summer line in next year's budget equal to this year's extra, and add a small cushion for a repair or an extra tanker. If the number is much larger than you expected, ask whether anything can change: a regular can supplier on a monthly count, storing water when supply is good, or fixing a leaking tap or tank that wastes water. None of that needs new equipment, only the habit of looking.
Can SpendixAI help with this?
Partly. You can add cash expenses by hand, several at once, and set up a custom category with sub-categories such as Tanker, Cans and Cooling. The Report builder can then filter and group by month so you see the summer climb, and you can download the result as a CSV. A sheet works just as well for a log this small.
A short routine for the log
- Write every payment the same day, even small ones.
- Tick cans on delivery.
- Total the month on the last day.
- Compare with the coolest month of last year, or with January this year.
- Carry the difference into next year's plan.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

