Spreadsheets

Milk delivery log in Google Sheets to check the monthly bill

A milk delivery tracker in Google Sheets: daily litres, price per litre, skipped and extra days, and a monthly total to check against the vendor's bill.

Editorial illustration for Milk delivery log in Google Sheets to check the monthly bill

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.

ColumnHeadingWhat to enter
ADateGenerated by formula
BMorning litresQuantity received; leave 0 if skipped
CEvening litresOnly if you take a second delivery
DTotal litres=B2+C2
ENoteSkipped, 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.

ItemCalculationResult
Normal days received31 days - 2 skipped29 days
Litres on normal days29 x 1 litre29 litres
Extra litres2 days x 1 extra litre2 litres
Total litres29 + 231 litres
Amount due31 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

  1. Copy last month's tab and change the first date
  2. Log litres every day, including zeros
  3. On bill day, compare totals and the difference cell
  4. Pay, and note the date and mode in the sheet
SPENDIXAI JOURNAL

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

Explore your reports