Skip to content

Hay Inventory Spreadsheet: Bales by Field and Cutting

A free hay inventory spreadsheet: bales by field and cutting with moisture and weight, where each stack is, days of feed left, and what's left to sell.

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 19, 2026 · 6 min read

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.

Questions people also ask

How do I calculate how much hay I need?

Animals times pounds a day times the days until pasture, divided by your bale weight, plus an allowance for waste. Eight horses at 20 lb a day for 163 days is about 543 bales of 48 lb.

How do you keep track of hay inventory?

Count bales by kind and cutting, keep each field and cutting as a lot with its date and moisture, and recount the stacks once a month.

Why record moisture when baling hay?

Hay baled too damp can heat and mold in the stack. Knowing which lot went up wet tells you what to watch, and what to feed or sell first.

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.