A seed inventory spreadsheet needs one row for each variety, with the unit you buy it in, how much is on hand, the amount where you reorder, what a unit costs, who sold it and where it's kept. Then it needs the thing a plain list leaves out: the seed lot and a date you'd want it sown by. Seed is alive. Twelve pounds of sweet corn from two seasons ago isn't the same stock as this year's bag, even though the shelf count is the same. The sheet below is built for a market farm, a seed saver who sells packets, or a nursery's seed shelf, with a made-up farm's numbers in it.
The short version
- One row for each variety, counted in the unit on the invoice: ounces, pounds, thousand seeds or packets.
- A reorder amount on every row, set once, so the sheet says REORDER before the catalog rush.
- A second sheet of seed lots: each delivery or saved batch with its lot number and a sow-by date.
- Count twice a year: after the last fall sowing, and when the order arrives.
- TaroStack keeps each lot, its date and what's left of it, and lists what's short. More below.
What goes on the sheet
| Column | What to type | Why it's there |
|---|---|---|
| Item | Crop and variety, with "pelleted" or "treated" if it is | Two lettuces are two rows |
| Unit | oz, lb, M seeds (a thousand) or packet | Count in the unit you're billed in |
| On hand | What's in the fridge or the bin today | |
| Reorder at | The amount you won't go below | The next sowing, and one resow |
| Unit cost | What you paid for a unit, shipping included | The shelf's value, and a bed's cost |
| Supplier | Who sold it, or "saved on the farm" | |
| Where kept | Seed fridge, barn bin 2 | Half of counting is finding |
An example: a vegetable farm's seed shelf
Mill Creek Farm is a made-up vegetable farm in Bloomington, Indiana, that I use in these examples. In November its sheet has ten rows. Six of them:
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Lettuce, salad mix (pelleted) | M seeds | 6 | 4 | $9.80 | $58.80 | OK |
| Carrot, Nantes type | oz | 3 | 4 | $11.50 | $34.50 | REORDER |
| Tomato, slicing hybrid | packet | 2 | 1 | $21.00 | $42.00 | OK |
| Sweet corn, bicolor | lb | 12 | 5 | $16.40 | $196.80 | OK |
| Green bean, bush | lb | 4 | 5 | $8.25 | $33.00 | REORDER |
| Garlic seed, hardneck | lb | 20 | 10 | $14.00 | $280.00 | OK |
The whole shelf is worth $850.60, and three rows say REORDER: the carrot, the bush bean and the basil.
The carrot row shows how to pick a reorder amount. The farm sows carrots every three weeks and each sowing takes about 2 oz. Four ounces is two sowings: the next one, and a resow if rain crusts the bed. At 3 oz the sheet turns the row red, with a sowing and a half left. That's the whole method: what one sowing uses, times the number you want in reserve.
Seed lots and sow-by dates
The second sheet has a row for every delivery: the date it came, the variety, the supplier, the lot number printed on the packet or bag, how much, and a sow-by date. The lot number is the seed company's. If a bag germinates badly, it's the first thing they'll ask for.
The sow-by date is yours to set. Mine would be short for onion, parsnip and pelleted lettuce, and long for tomato, squash and beans kept cool and dry. That's a rule of thumb and not a regulation. The sheet counts the days left and says USE FIRST inside 60 days and EXPIRED after.
Two rows on the farm's sheet earn their keep. The sweet corn is lot SC-2291, bought in February 2025, with 12 lb left and a sow-by of December 31, 2026. It shows USE FIRST, with a note: second season, sow thick or test first. A test is ten seeds on a damp paper towel for a week. If seven sprout, sow about 1.4 times as thick (10 divided by 7).
The garlic is the farm's own, lot MC-G26, 20 lb saved in July to plant this fall. Its date is November 15, and the day after, the row says EXPIRED. That's a nudge you want before the ground freezes.
If you sell seed in packets, put the lot number on the packet so it leads back to this row. Selling seed has labeling rules of its own under the Federal Seed Act and your state's seed law, and they deserve their own read.
Counting it
Twice a year is enough for most farms. The Count sheet fills itself from the inventory. Print it, walk the fridge and the bins, type what you counted, and it shows each difference and what it's worth. More on the method is in how to count inventory.
Get the spreadsheet
Download the seed inventory spreadsheet. Four sheets: the inventory with value and REORDER, the seed lots with days left, a count sheet and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. The plants that come out of the seed are in nursery inventory spreadsheet, and the rest of the farm in farm inventory template.
Where this stops working
The sheet only changes when somebody types. Two people sow from the same bag in April and neither writes it down. A second lot of corn goes into the bin on top of the first, and now nobody knows which is which. By June the sheet says 12 lb and the bin holds 5.
How TaroStack does it
TaroStack keeps the count as the work happens, lot by lot.
Each delivery is received with its lot and date. The supplier's lot number and your sow-by date go on the delivery, typed or scanned from a case label. Two lots of the same corn stay two lots.
Sowing takes seed off the oldest lot first. Set a flat of lettuce plugs up as a recipe: so many seeds, so much potting mix. Record the batch and the seed comes off the lot that's due first, without anybody doing arithmetic.
The reorder list writes itself. Every item has a reorder point, and the list shows what's under it in days of cover. Lots near their date are flagged before they pass it.
Counting works in the barn. Count on a phone with no signal, and it sends itself later. It shows what a difference is worth before you post it.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| What's on hand | Whatever was last typed | Comes off as you sow |
| Two lots of one variety | One row, mixed | Each lot on its own, oldest first |
| What to order | Scan the red rows | A reorder list |
| Seed past its date | Open the sheet to see | An alert |
Lots, dates and the reorder list are on every plan. Starter is $9.99 a month and holds 50 items and 5 recipes; a bigger seed shelf fits Growth at $39 a month. The first 14 days are free, with no credit card. Bring the spreadsheet: items import from it. If you'd like a hand setting up, ask, and we'll do it with you.
