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.
