Milk Collection Register in Excel (Free) – Morning & Evening Entries, Farmer Payment Slip

Milk collection farmer payment slip in Excel with morning and evening litres and fat

Advertisement

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.

↓ Jump to the free download

FOR MILK COLLECTION CENTRESFrom milk entry to 10-day bill — every rate worked out.XploreDairy prices milk by fat & SNF or your rate chart and makes farmer bills with feed and advance recovery.See XploreDairy — from ₹599 →⚡ Instant download · ♾️ Lifetime access · 💳 Pay onceXploreDairy

Milk collection farmer payment slip in Excel with morning and evening litres and fat
Gurmeet Singh, 11–20 Oct: 45 litres at an average fat of 6.61 = ₹2,342.91. Less ₹1,000 advance, he is paid ₹1,343.

Summary for all farmers

Milk collection register summary in Excel – litres, average fat and amount per farmer
One line per farmer for the period, with total litres and average fat for the centre.

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.

Advertisement

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

  1. Setup: type your centre name, the fat rate and SNF rate, and your farmers with a short code, village and animal.
  2. Collection: after each shift, enter the date, shift, farmer code, litres, fat and SNF.
  3. Farmer Bill: type a farmer code and the From and To dates. Enter any advance or feed recovery, then print the slip.
  4. 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.
Outgrown the free sheet? Here’s what XploreDairy adds

Free sheetXploreDairy
Collection vs dairy margin—✓
Cow & buffalo rate charts—✓
Farmer statement—✓
Dispatch register—✓
WhatsApp bills—✓
Fill-in forms & one-click PDF (macro edition)—✓

⚡ Instant download · ♾️ Lifetime access · 💳 Pay onceGet XploreDairy — from ₹599 →

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?

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.

More free templates

Advertisement

Amanpreet Kaur Bharaj
I'm Amanpreet Kaur Bharaj from Hoshiarpur, Punjab. I've worked in Excel for about 12 years, and since 2022 I've run my own ethnic-wear boutique, Punjabi Libas, on Excel files I built myself. XplorExcel is where I share those files: free templates for everyday business work, and ready-made Excel software for shops, boutiques, clinics, dairies, mandis and offices. Every file comes with a filled-in sample so you can see how it works. Stuck with one? Message me and I'll help.