Milk bill format, free in PDF and Excel
One supplier, one 10-day period: every shift with litres, FAT, CLR, rate and amount, down to what you pay him.
The file
Download it, no email needed
What is on it
The columns
Eight columns, one line for each shift. There are 22 lines, enough for the 21st to the 31st.
| Column | What to write |
|---|---|
| Date | The day of the entry |
| Shift | M for morning, E for evening |
| Type | Cow or Buffalo |
| Litres | Litres taken, to 3 decimals |
| FAT | From the test, to 1 decimal |
| CLR | From the lactometer |
| Rate | ₹ a litre, from your chart |
| Amount | Litres × Rate |
Worked example
How the bill adds up
The sample figures below are made up to show the sum.
Add the Amount column for the milk total. Add any bonus, then take off product sold on credit, such as cattle feed, and any advance.
Fill the top first: your dairy's name, the supplier's name and ID, the village and the period. Keep one copy and give him the other.
Sample bill1 to 10 Oct
Milk, 240 litres₹9,360.00
Bonus+ ₹120.00
Product (khurak)− ₹800.00
Advance (uchal)− ₹1,000.00
To pay₹7,680.00
This is a purchase record
It shows what you owe a farmer. It is not a tax invoice. When a registered dairy sells exempt milk, the law asks for a bill of supply, so see the GST guide before you use it for sales.
See the 10-day bill in Doodh MasterIs this milk bill format free?
Yes. No email, no sign-up.
FreeCan I change the 10 days to 15 days?
Yes in the Excel file. Add or remove lines and the totals still work.
Yes, in ExcelDoes it work out the rate by itself?
No. You type the rate from your chart. The Excel file multiplies it out.
You type the rateCan I make this bill in Doodh Master instead?
Yes. It builds the same bill from your entries every 10 days and sends it on WhatsApp by a link, one tap per supplier.
Yes, from your entriesEnter one supplier.Print one slip.
Open the demoStep 1 of 3
Open the demo
It opens straight away. No sign-up.
Step 2 of 3
Enter one supplier
Code, litres, FAT and CLR.
Step 3 of 3
Print one slip
The demo keeps nothing. Your own account starts with the 7 free days.