Quick answer: A milk collection register records one line per farmer per shift:
- the date and the shift (morning or evening)
- the farmer’s code and name
- litres, fat % and SNF %
- the rate per litre and the amount
Every 10 or 15 days, the lines for each farmer are added up into a payment slip, and any advance is deducted.
Download a free milk collection register in Excel below. You type the code, litres, fat and SNF. The name, rate and amount fill in, and the farmer slip and summary make themselves.
Key takeaways
- Rate by formula: fat % × fat rate + SNF % × SNF rate. Change the two rates once, and every entry recalculates.
- Collection sheet for up to 3,000 entries, with up to 60 farmers.
- Farmer payment slip for any period up to 16 days: day-wise morning and evening litres, fat, amount, average fat and rate.
- Advance / feed recovery and the net amount payable.
- Summary of litres, average fat and amount for every farmer.

Summary for all farmers

How the rate is worked out
The sample uses ₹4.60 per fat % and ₹2.40 per SNF %. Buffalo milk at 6.5 fat and 9.0 SNF comes to ₹51.50 a litre. Cow milk at 4.0 fat and 8.5 SNF comes to ₹38.80. These are example rates only. Use the rates your dairy plant or society gives you.
Average fat on the slip is weighted by litres. A 3-litre evening with 7.0 fat counts for more than a 1-litre morning with 6.0.
How to use the template
- Setup: type your centre name, the fat rate and SNF rate, and your farmers with a short code, village and animal.
- Collection: after each shift, enter the date, shift, farmer code, litres, fat and SNF.
- Farmer Bill: type a farmer code and the From and To dates. Enter any advance or feed recovery, then print the slip.
- Summary: set the same dates to see every farmer’s total for the period.
Tips for a collection centre
- Use short codes. Typing F07 at 6 AM is quicker and safer than a name.
- Give the slip with every payment. Farmers trust a day-wise slip more than a single total.
- Match your litres with the plant every day. Small daily losses add up over a month.
Download the free Milk Collection Register
There are four sheets: Setup, Collection, Farmer Bill and Summary. Fill in the yellow cells; everything else is worked out.
Get updates and new free templates
Your download below doesn’t need this. Leave your WhatsApp number or email and I’ll send you fixes for this file and new free templates. No spam, unsubscribe anytime.
Was this template useful?
Related free templates Free Excel files people download with this one
FAQs
My dairy pays on fat only. Can I use it?
Yes. Set the SNF rate to 0 and put the full rate in the fat rate cell. Then the rate is fat % × fat rate.
Can I make a 15-day bill?
Yes. The slip takes any period up to 16 days. Change the From and To dates.
Can a farmer have both cow and buffalo milk?
Give each animal its own code, for example F07 and F07C, so the slip and rate stay clear.








Leave a Review