If you are not ready to move to an app, the next best thing is a record sheet that is actually designed for milk — dated, with morning and evening separated, and with somewhere to put payments. Most people rule columns in a general-purpose notebook and end up missing one of those three, which is what makes month-end painful.
Below are three formats you can copy onto paper, into a spreadsheet, or print: a monthly customer sheet, a daily round sheet, and a simple bill layout. They are free to use and there is nothing to download or sign up for.
Format 1: Monthly customer record sheet
One sheet per customer per month. This is the format that makes billing straightforward, because the month totals itself at the bottom.
Header: Customer name · Phone · Month and year · Rate per litre · Previous balance
| Date | Morning (L) | Evening (L) | Day total (L) | Notes |
|---|---|---|---|---|
| 1 | 1.0 | 0.5 | 1.5 | |
| 2 | 1.0 | 0.5 | 1.5 | |
| 3 | 1.0 | — | 1.0 | no evening |
| … | ||||
| 31 |
Footer block:
- Total litres for the month
- Charges (total litres × rate)
- Previous balance
- Payments received this month, with dates
- Credits or adjustments, with reason
- Closing amount due
Those six lines are the whole reason this format works. A sheet that stops at “total litres” leaves the hard part undone.
Format 2: Daily round sheet
One sheet per day, listing every customer in route order. Useful if you want to carry a single page rather than flip between customer sheets, and essential if somebody else ever covers your round.
Header: Date · Shift (morning / evening) · Delivered by
| # | Customer | Usual (L) | Delivered (L) | Cash received | Notes |
|---|---|---|---|---|---|
| 1 | 1.0 | ||||
| 2 | 0.5 | ||||
| 3 | 2.0 |
Two details that matter: list customers in the order you actually visit them, not alphabetically, and pre-fill the “usual” column so you only write where the day differs. That turns the sheet into an exception log, which is far faster to fill in at a gate.
The weakness of this format is that it is organised by day rather than by customer, so billing means gathering thirty sheets. Most people who use it also keep monthly customer sheets and copy across — which is exactly the duplication a delivery app removes.
Format 3: Customer bill
What you hand over or send at the end of the period. Everything on this list is here because leaving it off causes a question.
- Your business name and a contact number
- Customer name
- Billing period (from and to dates)
- Itemised deliveries, or at minimum a dated summary by week
- Total litres
- Rate applied
- Charges for the period
- Previous balance
- Payments received, with dates
- Credits or adjustments, with reason
- Closing amount due
- How to pay — account details, UPI ID or QR code
- Date the bill was issued
Putting the payment method on the bill itself is the single highest-return item on that list. Every step you remove between “I should pay this” and “paid” gets you paid sooner.
Setting these up in a spreadsheet
If you have a computer, a spreadsheet version of Format 1 is worth twenty minutes of setup. Three formulas do almost everything:
- Day total: morning + evening
- Month total litres: sum of the day-total column
- Closing amount: (month total × rate) + previous balance − payments − credits
Make one sheet, get it right, then duplicate it per customer per month. The honest limitation is that a spreadsheet is awkward to fill in at a gate on a phone, so most people end up writing on paper during the round and typing it up later — which means entering everything twice and recalling quantities from memory, the two things most likely to introduce errors.
Five rules that apply to any format
- Date every line. Undated quantities cannot be checked against anything.
- Keep morning and evening apart. Combined figures make shift disputes unresolvable.
- Keep deliveries and payments in the same place. Two books guarantee the balance is wrong in both.
- Carry the balance forward at the top of every month, or old dues quietly vanish.
- Write at the gate, not at night. Recalled entries are guesses.
When a sheet stops being enough
Paper formats work well up to roughly fifteen or twenty customers on a single rate. Past that, three things start to hurt: the month-end arithmetic takes hours and carries errors, you cannot see total outstanding without adding up every sheet, and different rates have to live in your memory.
That is the point at which the sheets are costing more than they save. Paper round book vs a digital ledger sets out that trade-off honestly, including where paper genuinely still wins.
Where to go next
For the arithmetic, see how to calculate a milk bill correctly, or try the free milk bill calculator. For records that scale, keeping a customer ledger that holds up and the complete guide to milk delivery apps.
If you would rather the sheet filled itself in, Milk Diary produces all three of these formats automatically from the entries you tap in during the round. It is free on Google Play and works offline.