To track milk delivery, multiply litres per day by the rate and by the number of delivery days, and compare the result with the vendor's bill. Record what you actually pay, note any skipped days or price change, and review once a quarter. Because the arithmetic is simple, any mismatch is easy to spot.
The formula for the month
Monthly milk cost equals litres per day, times the rate per litre, times the number of days delivered. Keep these three numbers in a note, and every month's bill can be checked in a few seconds.
A hypothetical month
Say you take 1.5 litres a day at ₹60 a litre, and the month has 31 days. You pause delivery for 3 days while travelling.
| Step | Working | Result |
|---|---|---|
| Days delivered | 31 - 3 | 28 |
| Daily cost | 1.5 x ₹60 | ₹90 |
| Milk cost | 28 x ₹90 | ₹2,520 |
| Extra curd, 2 packs | 2 x ₹35 | ₹70 |
| Total bill | ₹2,520 + ₹70 | ₹2,590 |
If the vendor's bill says ₹2,790, which is 31 full days, you have caught the skipped days before paying. The ₹270 difference is 3 days at ₹90.
What do you record?
- The amount paid, the date, and how you paid.
- The days delivered, or the days paused, in the note.
- The rate per litre, and the date it changes.
- Extras such as curd or paneer, on a separate line if you want to track them.
- For a prepaid wallet, the balance at month-end, to correct for top-ups.
How do you handle a price change?
When the rate moves, write down the date and the new figure. From then on, your formula uses the new rate. If the rate goes from ₹60 to ₹62 for the same 1.5 litres over 30 days, the month rises from 30 x ₹90 = ₹2,700 to 30 x ₹93 = ₹2,790. That is ₹90 more for the month, and over twelve months about ₹1,080. A single rupee per litre does not feel like much, but the tracker shows its yearly cost.
Dairy prices can change more than once in a year, so a dated note matters. When you look back, you can match a jump in the bill to the exact date the rate moved, rather than guessing whether the vendor billed extra days.
What about a prepaid wallet or a monthly coupon?
If you top up a wallet with ₹3,000 and the app deducts the daily cost, the top-up is not the month's cost. The deductions are. Compare your formula with the wallet's balance. Suppose the wallet started the month at ₹3,000 and ended at ₹480, then ₹3,000 - ₹480 = ₹2,520 was used, matching the milk cost above. If it does not match, an extra item or a missed pause is hiding somewhere.
How should the review go?
- Each month, compare the bill with your formula.
- Note any difference and its reason.
- Each quarter, average the three months. Months with 28, 30 and 31 days will differ for no reason beyond the calendar.
- Each year, total the cost and see how much of the change came from price and how much from litres.
A SpendixAI rule on the vendor's name files the monthly payment, and you can add cash payments by hand. The formula and the day count remain your own habit.
Month-end checklist
- Is the day count right, including pauses?
- Does the bill match the formula?
- Is any price change dated in the note?
- Is the payment recorded the same day?
Useful ideas start with a clearer picture of your own spending.
Explore your reports


