Skip to content

Seed Inventory Spreadsheet: Lots, Sow-By Dates, Reorders

A free seed inventory spreadsheet for a market farm or seed saver: each variety, what's on hand, its seed lot and sow-by date, and what to reorder.

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 · 7 min read

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.

Questions people also ask

How do I keep track of my seed inventory?

One row for each variety with the amount on hand, and one row for each lot with its date. Update it when seed arrives and after each big sowing, and count twice a year.

How long do seeds last in storage?

It depends on the crop and on how cool and dry they're kept. Onion and parsnip fade within a year or two; tomato, squash and beans keep for several. When in doubt, test ten seeds on a damp paper towel before you sow a bed.

What should a seed inventory include?

The variety, the unit, the amount on hand, a reorder amount, the cost, the supplier, where it's kept, the lot number and the year or date it should be sown by.

Is there a free seed inventory spreadsheet?

Yes, the one above. It's free, with no email asked for. The business side of selling seed is in seed company business plan.

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.