A barn full of hay looks like plenty until you divide it by the days left before grass. A hay inventory spreadsheet does that sum. It counts bales by kind and cutting, one row each, with where they're stacked and what they're worth. A second sheet treats each cutting from each field as a lot, with the date baled, the moisture, the average bale weight and any test results. From those it answers three questions: how many days of feed are in the barn, how many bales can be sold, and which stack a given bale came from. Below is a sheet filled in for a made-up farm that sells small squares and feeds eight horses, and the file.
The short version
- One row for each kind of hay and each cutting.
- Each field and cutting is a lot: date, moisture at baling, bale weight.
- Feed needed = animals × pounds a day × days until grass, plus waste.
- What's left after that is what you can sell.
- Stack so the oldest and the dampest come out first.
- TaroStack tracks bales by lot, takes off what's fed and sold, and shows days of cover. More below.
An example sheet
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Orchard grass, first cutting, small squares | bale | 640 | 300 | $6.50 | $4,160.00 | OK |
| Orchard grass, second cutting, small squares | bale | 410 | 200 | $8.00 | $3,280.00 | OK |
| Timothy mix, first cutting, small squares | bale | 280 | 150 | $7.25 | $2,030.00 | OK |
| Alfalfa, second cutting, small squares | bale | 120 | 80 | $10.50 | $1,260.00 | OK |
| Round bales, grass, 4x5, net wrapped | bale | 34 | 20 | $55.00 | $1,870.00 | OK |
| Straw, wheat, small squares | bale | 90 | 60 | $4.25 | $382.50 | OK |
Eight rows in all, $13,343.50 of hay, straw and supplies. The values are what the farm would sell at; for hay you grew, your cost to make it is a different and lower number.
Will it last?
| Horses | 8 |
| Hay a day, each (about 2% of a 1,000 lb horse) | 20 lb |
| Hay a day, all | 160 lb |
| First-cutting bale, average | 48 lb |
| Bales a day | 3.3 |
| Days until grass (Nov 19 to May 1) | 163 |
| Bales needed | 543 |
| Plus 10% for waste and a late spring | 598 |
Call it 600. There are 640 first-cutting bales in the east bay, so the horses are covered with 40 to spare, and everything else in the barn can be sold: 410 second cutting, 280 timothy, and the 40. Without the sum, the usual mistake is selling freely in December and buying back at March prices.
The 20 lb a day is a common rule of thumb for a horse at maintenance. Yours may need more or less, and the right figure comes from the animals and, if you've tested, the hay. Use bale weight, not bale count: a 40 lb bale and a 55 lb bale are both "a bale".
Each cutting is a lot
| Baled | Hay | Lot | Bales | Moisture | Weight | Note |
|---|---|---|---|---|---|---|
| Jun 4 | Orchard grass, first cutting | F2-C1-0604 | 920 | 14% | 48 lb | |
| Jul 22 | Orchard grass, second cutting | F2-C2-0722 | 560 | 13% | 50 lb | Tested 12% protein |
| Jun 11 | Timothy mix, first cutting | F5-C1-0611 | 400 | 17% | Stacked loose; watch for heat | |
| Aug 2 | Alfalfa, second cutting | Bought in | 150 | 55 lb | No test | |
| Jul 30 | Round bales, grass | F7-C1-0730 | 46 | 850 lb |
The lot code is the field, the cutting and the date: F2-C1-0604. It's worth keeping for three reasons.
Moisture. The timothy went up at 17%, wetter than the rest. Hay baled damp can heat and mold in the stack, so that lot was stacked loose, checked for heat, and is the one to sell or feed first.
Complaints. When a buyer calls about dusty bales, the first question is which lot. If you know, you know what else came off that field that day, and who else bought it.
Price. Second cutting tested at 12% protein and sells for $8.00 against $6.50 for first. A test result on a lot is a reason for the price.
Stacking and counting
Stack each lot on its own, and write the lot on a tag at the front of the stack. Count by rows: bales wide × bales high × rows deep, less the hole where you've been pulling. Recount at the first of each month. Hay disappears a few bales at a time, to the horses, to a neighbor, to a customer who loaded their own, and a monthly count is how you catch that the east bay is going down faster than 3.3 a day.
The rest of the farm's stock is in farm inventory template. The same idea of a lot for each field and date, for vegetables, is in seed planting log, and lot codes in general in how to create lot numbers.
Get the spreadsheet
Download the hay inventory spreadsheet. Four sheets: inventory with value and REORDER, lots by field and cutting, a count sheet, and a read-me. Set each "reorder at" to the bales you need to keep for your own animals. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
Nobody updates a spreadsheet from the barn. Bales fed, bales sold for cash at the door, a load delivered on a Sunday: by February the sheet is the November count with a few guesses. The feed sum was right once and hasn't been checked against the stack since.
How TaroStack does it
TaroStack keeps the count moving, from a phone, in the barn.
Each cutting is a lot. Record it with its date and your own fields: moisture, bale weight, test results.
Sales come off the lot. An order records which lot the bales came from, so a buyer's question leads to one stack.
What's fed comes off too. Record the week's feeding as an adjustment with a reason, or count the stack, and the lot goes down.
Counting works with no signal. Count on a phone in the pole shed and it catches up when it's back in range.
Days of cover. The reorder list shows how long each hay will last at the rate it's really going.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Bales sold at the door | Written down later, maybe | An order, from the lot |
| Which stack did those come from | Memory | On the order |
| Will it last to May | A sum done once | Days of cover |
| Counting in the barn | Paper, then typing | On a phone, offline |
Stock, lots and counting are on every plan, from $9.99 a month. 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.
