Milk bill calculator
A month's milk bill = (morning + evening litres a day) × delivery days × rate per litre, plus extra litres, plus the old balance, minus what the customer paid.
Bill
- Delivery days
- 28
- Morning milk
- 28 L · ₹1,792.00
- Evening milk
- 14 L · ₹896.00
- Extra milk
- 3 L · ₹192.00
- Total milk
- 45 L
- This month's bill
- ₹2,880.00
- Amount due
- ₹2,530.00
Bill = (morning L × morning rate + evening L × evening rate) × (days − paused days) + extra L × rate; due = bill + previous balance − payment
How do you calculate a monthly milk bill?
Add the morning and evening litres a customer takes each day and multiply by the number of days milk was delivered, which is the days in the month minus any paused days. Multiply those litres by the rate per litre and add any extra litres at the same rate; that is the month's bill. Add the previous balance and subtract the payment received to get the amount the customer owes.
- Delivery days = days in month − paused days
- Milk bill = (morning L × morning rate + evening L × evening rate) × delivery days + extra L × rate
- Amount due = milk bill + previous balance − payment received
Worked example
A customer takes 1 litre in the morning and half a litre in the evening at ₹64 a litre. In a 30-day month they paused delivery for 2 days and asked for 3 extra litres. They owed ₹150 from last month and paid ₹500 during the month. These are the numbers the calculator above starts with.
| Item | Working | Litres | Amount |
|---|---|---|---|
| Delivery days | 30 − 2 | 28 days | |
| Morning | 1 L × 28 × ₹64 | 28 | ₹1,792.00 |
| Evening | 0.5 L × 28 × ₹64 | 14 | ₹896.00 |
| Extra | 3 L × ₹64 | 3 | ₹192.00 |
- Total milk
- 45 L
- This month's bill
- ₹2,880.00
- Previous balance
- + ₹150.00
- Payment received
- − ₹500.00
- Amount due
- ₹2,530.00
Common questions
How do I enter half a litre or 250 ml?
Enter litres as a decimal: 500 ml is 0.5, 250 ml is 0.25 and 750 ml is 0.75. A customer who takes 1.5 litres a day for 30 days gets 45 litres.
What counts as a paused day?
A day with no delivery at all, for example when the family is out of town. In this calculator a paused day stops both the morning and the evening milk. If only one delivery was skipped, take those litres off the extra litres instead.
How do I charge different rates for cow and buffalo milk?
Tick 'Different rate for evening milk' and enter both rates. This works when a customer takes one kind of milk in the morning and the other in the evening. Extra litres are charged at the morning rate.
How many days should I count in the month?
Count the days in the calendar month you are billing: 31 for January, 28 or 29 for February, 30 for April, and so on. Then enter the days with no delivery as paused days.
What if the customer paid more than the bill?
The calculator shows 'Advance left' instead of 'Amount due'. Carry that advance into next month as a minus previous balance, or take it off next month's bill.
Make every customer's bill in Milk Setu
Milk Setu keeps every customer, every litre and every rupee of a dairy in one place. Mark deliveries, make monthly bills and collect dues from the phone, in Gujarati or English. Monthly bills are made from the deliveries you marked, with a UPI QR code; print them, save them as PDF or share them on WhatsApp. 30 days free with all features. No card needed and no approval needed; the trial starts as soon as the shop is registered.
Last checked