Skip to content

Milk Production Record: Each Cow, Each Milking

A milk production record for a small herd: a row for each cow at each day's milkings, pounds and gallons, the herd's total, where the milk went, and a file.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 21, 2026 · 6 min read

A milk production record has a row for each cow on each day: what she gave in the morning, what she gave in the evening, the day's total, and a note. A second page has the herd's total for the day and where the milk went. The first page is about the cows: it shows which one is climbing, which is tailing off toward the end of her lactation, and which one gave a third less tonight than last night. The second is about the milk: it's the start of every bottle and every cheese made from it. A tank total alone does neither job. Below is a record for a made-up three-cow dairy, what each column is for, and the file.

The short version

  • One row for each cow, each day, with morning and evening apart.
  • Weigh or measure the milk the same way at every milking.
  • The sheet adds the day and turns pounds into gallons.
  • A sudden drop in one cow's row is a reason to look at her that day.
  • A second page: the herd's total and where every gallon went.
  • Give each day's milk a code, and put it on what's made from it.
  • TaroStack keeps each day's milk as a lot. More below.

An example record

Date Cow Morning Evening Day Day, gallons Note
Nov 16 Clover 24.5 lb 21.0 lb 45.5 lb 5.3
Nov 16 Daisy 31.0 lb 27.5 lb 58.5 lb 6.8
Nov 16 Maple 18.0 lb 16.5 lb 34.5 lb 4.0 Late lactation
Nov 17 Clover 24.0 lb 21.5 lb 45.5 lb 5.3
Nov 17 Daisy 30.5 lb 19.0 lb 49.5 lb 5.8 Evening milk down a third: checked, off feed. Temperature taken
Nov 17 Maple 18.5 lb 16.0 lb 34.5 lb 4.0

The weights are this made-up dairy's own. They aren't what a cow should give.

What the record shows

Daisy, on the evening of the 17th. She gave 27.5 lb the evening before and 19.0 lb tonight. Clover and Maple are within half a pound of yesterday at both milkings. The herd's total fell 9 lb, from 138.5 to 129.5, and the rows say all of it was one cow at one milking. This dairy's rule is that a cow whose milk falls by a fifth from one milking to the same milking the day before gets looked at before the barn lights go off. The note says what was found.

Without the rows, the same evening is a tank that's a gallon short, which could be anything.

Maple. Her note says late lactation, and her 34.5 lb is steady. A falling number is expected from her over the coming weeks. The record is how this dairy decides when to dry her off, and it's what next year's Maple is compared with.

Morning and evening apart. Kept as one number, Daisy's day reads 49.5 lb against 58.5 lb. Kept as two, it reads a normal morning and a poor evening, which is more to go on.

Pounds and gallons

This dairy hangs each pail on a scale and writes pounds, because the scale reads the same with foam on the milk or without. The sheet turns pounds into gallons at 8.6 lb to the gallon, the figure this dairy uses, because bottles and cheese recipes are in gallons. Clover's 45.5 lb is 5.3 gallons.

If you measure by volume, write gallons or quarts and leave the pounds out. What matters is that every row is measured the same way.

The herd's day, and where the milk went

Date Cows milked Total Gallons Bottled To cheese Calves or dumped Lot
Nov 16 3 138.5 lb 16.1 10.0 5.0 1.1 M-1116
Nov 17 3 129.5 lb 15.1 9.0 5.0 1.1 M-1117

The three uses add up to the day's gallons: 10.0 + 5.0 + 1.1 is 16.1. When they don't, something wasn't written down. On the 17th the cheese still got its 5 gallons and the bottles took the shortfall, 9 in place of 10. That's a choice someone made, and the page shows it.

Milk kept out of the tank goes in the last column, with the reason in a note.

The lot. M-1117 is the 17th's milk. Put that code on the bottles filled from it and on the make sheet for the cheese: see cheese make sheet. Then a question about a bottle or a wheel leads back to a day, and from the day to the cows. What a State allows a small dairy to sell, and how, is in raw milk laws by state.

What the cows ate is the other half of the picture: see feed log template. The same kind of record for a laying flock is in egg production log template.

Get the record

Download the milk production record. Two sheets and a read-me: a milk record that adds each cow's day and turns pounds into gallons, and a herd page for the day's total, where the milk went and its lot. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. Change the 8.6 if you use a different figure.

Where this stops working

A clipboard in the barn does the first page well. The second page is where it gives out. Which day's milk is in the bottles in the cooler? Which two days went into Thursday's cheese? Who bought the bottles from the 17th? Each answer means carrying a code by hand from the herd page to a label, a make sheet and a delivery note, and on a morning when the milking ran late, the code doesn't get carried.

How TaroStack does it

TaroStack carries the day's milk through to the customer.

Each day's milk is a lot, with its date.

A bottling or a cheese make is a batch. Record it and the milk comes off stock, by lot. The batch notes which lots it used, automatically.

Every batch is a lot with a best-by date, from the recipe and the day it was made.

Your checks are fields on the batch record: a temperature, a pH, a time.

One report for a lot: from a day's milk to the bottles and cheese made from it, the customers who got them, and what's left.

The question Clipboard In TaroStack
Which milk is in this bottle The code, if it was written The lots on the batch
Which cheeses used the 17th's milk Read every make sheet One report
Who got them Memory The deliveries, by lot
What's in the cooler, by date Walk and look Lots with dates

TaroStack doesn't keep herd, breeding or health records: keep the cow-by-cow page for that. Recipes, batches and lots are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.

Questions people also ask

What should a milk production record include?

For each cow each day: the morning and evening milk, the day's total and a note. For the herd: the day's total and where the milk went, with a code for the day's milk.

Should milk be recorded in pounds or gallons?

Either, as long as every row is measured the same way. This example weighs in pounds and turns them into gallons at 8.6 lb to the gallon, the figure this dairy uses.

Why record each cow and not just the tank?

A tank total shows that the herd gave less. A row for each cow shows which cow, and at which milking. In the example the herd fell 9 lb in a day, all of it one cow's evening milk.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.