Expense categories

How to track drinking water cans month by month

How to track drinking water cans month by month: a tick calendar, cost per can, monthly bill checks and a worked example with guests and a price rise.

Editorial illustration for How to track drinking water cans month by month

To track drinking water cans, tick each delivery on a calendar, count the cans at month end and check the count against what you pay. The cost per can is the one number to watch. It tells you at once whether a bigger bill means more cans or a higher price, and it catches billing mistakes that a lump-sum payment would hide.

What should you keep?

  • A tick or a number for each delivery, on a wall calendar or a phone note.
  • The price per can, as the supplier tells you.
  • The payment date and how you paid, whether by cash each time or a monthly settlement.
  • Any deposit or equipment visit, kept separate from the running cost.

How often does it arrive?

Deliveries are regular but not identical. A household may take two cans a week for months, then four when relatives stay, then back to two. Most vendors settle monthly, and some collect at each delivery. In either case, the monthly figure is the unit to review.

What does a worked month look like?

Say last month you took 9 cans at ₹50, which is ₹450. This month there were guests for a function and you took 13 cans. The supplier also moved the price to ₹55.

MonthCansPrice per canTotal
Last month9₹50₹450
This month13₹55₹715

The total rose by ₹715 minus ₹450, which is ₹265. How much came from the extra cans, and how much from price? The extra 4 cans at the old price add 4 × ₹50 = ₹200. The price rise on the original 9 cans adds 9 × ₹5 = ₹45. The remaining ₹20 is the price rise on the 4 extra cans, which is 4 × ₹5 = ₹20. In total ₹200 + ₹45 + ₹20 = ₹265. Almost all of the jump came from guests, not from the supplier.

How do you check a monthly settlement?

If you pay once a month, compare the supplier's count with your own tick marks before paying. A mismatch of one or two cans is common, since a delivery may be forgotten or doubled. Resolve it while the month is fresh. In three months nobody remembers.

What should the monthly review be?

  1. Count the ticks on your calendar.
  2. Multiply by the price and compare with the bill.
  3. Record the payment with the number of cans in the note.
  4. Keep equipment costs on a separate line.
  5. Compare with last month and note the reason for any difference.

Where a tool fits

If you pay the supplier by UPI, SpendixAI can bring the payment in from your statement and apply a rule to the supplier's name. You then add the can count in a note or keep the supplier's message as a receipt with the transaction.

What if you share cans with neighbours or flatmates?

In a shared flat, one person often pays the supplier and the others send their share by UPI. Decide in advance whether you record the full bill or only your own part. Recording only your share is simpler: if the supplier is paid ₹600 for 12 cans by one flatmate and your share is a third, your entry is ₹200. If you record the full bill, record the shares you receive as money received, so that the net cost is clear.

Whatever you choose, write the number of cans next to it, and the arithmetic stays checkable.

Checklist

  • Calendar ticks counted.
  • Supplier's bill compared with your count.
  • Price per can recorded.
  • Deposit and equipment kept separate.
  • Guest weeks marked so spikes make sense.
SPENDIXAI JOURNAL

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

Explore your reports