A microgreens grower's stock is in three places: seed in the bin, trays on the rack that aren't food yet, and clamshells in the cooler with about a week to sell. A microgreens inventory spreadsheet has to show all three, because the question you're really asking is "can I fill Thursday's orders?", and the answer depends on what was sown ten days ago, not on what's in the cooler today. The sheet below counts seed by the pound and lot, logs every sowing as a lot with its harvest date, and tracks what's cut. A made-up grower's week is filled in.
The short version
- Seed in pounds, by variety, with the supplier's lot and a reorder amount.
- Every sowing is a row: crop, date, trays, expected harvest day.
- Harvested clamshells get the sowing's lot and a sell-by.
- Know seed per tray and clamshells per tray for each crop.
- TaroStack takes seed off its lot when you record a sowing and dates the harvest. More below.
An example sheet
Hilltop Greens is a made-up grower in Asheville, North Carolina. Six of its nine rows:
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Seed, sunflower (black oil) | lb | 38 | 25 | $3.10 | $117.80 | OK |
| Seed, pea (speckled) | lb | 44 | 25 | $2.20 | $96.80 | OK |
| Seed, radish (daikon) | lb | 9 | 10 | $9.50 | $85.50 | REORDER |
| Seed, broccoli | lb | 6 | 5 | $14.00 | $84.00 | OK |
| Coco coir, compressed | block | 12 | 8 | $7.25 | $87.00 | OK |
| Trays, 10 x 20 | each | 160 | 120 | $1.90 | $304.00 | OK |
Clamshells, labels and 46 finished clamshells of sunflower shoots bring it to $1,132.58. Radish seed is at its reorder amount.
Two numbers for each crop
Everything else follows from these, and they're yours to measure:
| Crop | Seed a tray | Clamshells a tray (2 oz) | Days to harvest |
|---|---|---|---|
| Sunflower | 8 oz | 8 | 10 |
| Pea | 10 oz | 9 | 10 |
| Radish | 1.5 oz | 6 | 8 |
| Broccoli | 1 oz | 5 | 10 |
These are this grower's own figures. Yours depend on your seed, your trays and your light.
With them, the seed row turns into trays. Thirty-eight pounds of sunflower is 608 oz, or 76 trays, or about 608 clamshells. At 12 trays a week, that's six weeks of seed. Nine pounds of radish is 96 trays, which sounds like plenty until you notice it's the costly seed with a three-week lead time from this supplier.
Sowings are lots
| Sown or cut | Lot | Trays or clamshells | Date |
|---|---|---|---|
| Sown Nov 9 | SUN-1109 | 12 trays | Harvest Nov 19 |
| Cut Nov 17 | SUN-1107 | 96 clamshells | Sell by Nov 24 |
The lot is the crop and the day it was sown. SUN-1107 was sown November 7, cut on the 17th, and its 96 clamshells carry that code. Twelve trays at 8 clamshells is 96, so nothing went missing between the rack and the cooler.
The first row is the one that answers Thursday's question. Twelve trays of sunflower will be ready on the 19th, good for about 96 clamshells. If standing orders for that day add up to 110, you know nine days ahead, when it's still possible to sow two more trays for the following week or warn a chef.
The supplier's seed lot matters as well. Seed has been the source of outbreaks in sprouts, and buyers ask microgreens growers about theirs. The row for sunflower seed SF-25-1140 is where a recall of that seed lot would start.
Get the spreadsheet
Download the microgreens inventory spreadsheet. Four sheets: inventory with value and REORDER, lots for seed, sowings and harvests, 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. Packaging choices are in how to package microgreens for sale.
Where this stops working
Sowing happens three times a week across eight crops, each with its own days to harvest. Working back from Thursday's orders to what should have been sown on which day is a small planning problem, repeated daily, and a spreadsheet makes you do it in your head.
How TaroStack does it
TaroStack treats a tray like any other batch.
A sowing is a batch. A tray of sunflower is a recipe: 8 oz of seed, coir, a tray's worth of clamshells and labels at harvest. Record the sowing and the seed comes off its lot. The harvest becomes stock with a lot and a sell-by.
The seed lot is on the record. Which seed lot grew which clamshells is noted automatically. A seed recall is one report, down to the customers.
What can I sow? "What could I make right now" shows how many trays the seed on hand allows.
Planning, on Growth. Standing orders and your days to harvest become a plan of what to sow and when, as drafts you approve.
Sell the oldest first. Clamshells go out first-expired-first-out, with an alert before one passes its day.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Seed after a sowing | Subtract ounces by hand | Comes off with the batch |
| What's ready Thursday | Count back the days | Batches with harvest dates |
| What to sow today | In your head | A plan, on Growth |
| Which seed lot fed a customer | Two sheets and memory | One report |
Recipes, batches and lots are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes, with planning). 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.
