To check a milk bill, log the litres received each day in Google Sheets, put the price per litre in one cell and multiply the month's total by it. Compare that figure with the vendor's bill. If they differ, the daily log shows which days to discuss, and a record settles the matter more politely than memory.
How should the daily log be laid out?
Use one tab for each month. Put the month's first date in H2 and the price per litre in H3, then build a simple list of dates from A2.
| Column | Heading | What to enter |
|---|---|---|
| A | Date | Generated by formula |
| B | Morning litres | Quantity received; leave 0 if skipped |
| C | Evening litres | Only if you take a second delivery |
| D | Total litres | =B2+C2 |
| E | Note | Skipped, extra, festival, new vendor |
To generate dates in A2 in Google Sheets or Excel 365: =SEQUENCE(DAY(EOMONTH(H2,0)), 1, H2, 1). This fills exactly as many rows as the month has days. In older Excel, type the first date and drag down.
What formulas total the month?
- Litres in the month: =SUM($D$2:$D$32)
- Amount due: =SUM($D$2:$D$32)*$H$3
- Days skipped: =COUNTIF($D$2:$D$32, 0)
- Extra days: =COUNTIF($D$2:$D$32, ">"&H4), where H4 holds your usual daily litres
- Vendor's bill in H6 and difference in H7: =H6-(SUM($D$2:$D$32)*$H$3)
COUNTIF with 0 counts only cells where you typed zero, not blanks, so type 0 on skipped days and the count is correct.
What does a worked month look like?
Say you take 1 litre daily at ₹60 a litre in a 31-day month. You skip 2 days, and on 2 days you ask for an extra litre for guests, so those days read 2.
| Item | Calculation | Result |
|---|---|---|
| Normal days received | 31 days - 2 skipped | 29 days |
| Litres on normal days | 29 x 1 litre | 29 litres |
| Extra litres | 2 days x 1 extra litre | 2 litres |
| Total litres | 29 + 2 | 31 litres |
| Amount due | 31 x ₹60 | ₹1,860 |
Now suppose the vendor's bill says ₹1,980. Divide by the price: 1,980 / 60 = 33 litres, two more than your log. You can ask: which two days? Often the vendor counted the skipped days. The log gives you dates to point to instead of a feeling.
How do I handle price changes mid-month?
If the vendor raises the rate on the 15th, add a second price cell and use two SUM ranges: =SUM($D$2:$D$15)*$H$3 + SUM($D$16:$D$32)*$H$5. Ask the vendor for the new rate on a message so you have it written, and note the date in column E.
What do I do with disputes and advance payments?
- Share a screenshot of the log when you question a bill; keep the tone calm and ask which days differ.
- If you pay in advance, add a cell for amount paid and subtract the amount due to see the balance carried forward.
- When you travel, tell the vendor the dates and write 0 for those days so the log and the bill agree.
Where does an expense tracker fit?
The monthly milk payment is one transaction in your statement, and a sheet cannot match it for you. If you want the payment sitting in your usual categories, SpendixAI can import the statement and let you add a milk category, while the log stays as your proof of the quantity.
What if the vendor changes the delivery pattern?
Some vendors deliver on alternate days or in two pouches of different sizes. Record the actual litres each day rather than the plan, and add a note when the pack size changes, because the bill is often based on packs and your log is based on litres. A column for pouch count lets you reconcile both ways when the two do not match.
Monthly routine
- Copy last month's tab and change the first date
- Log litres every day, including zeros
- On bill day, compare totals and the difference cell
- Pay, and note the date and mode in the sheet
Useful ideas start with a clearer picture of your own spending.
Explore your reports


