Most of a mushroom farm's inventory isn't on a shelf. It's in bags, turning from sawdust into mushrooms over five or six weeks. So a mushroom inventory spreadsheet needs the usual rows (substrate, spawn, bags, tills) and two that are unusual: blocks colonizing and blocks fruiting, each run with the date it was made, the spawn lot it got, and the day it moves on. When a run goes green with mold, that record is how you find out whether it was the spawn, the steam or the week. Here's a sheet with a made-up farm's numbers in it.
The short version
- Substrate in pounds, spawn in bags with the lab's lot and a use-by.
- Each run of blocks is a lot: the date, the species, the spawn lot.
- Blocks sit in two rows, colonizing and fruiting, valued at what they cost to make.
- Harvests by lot, in pounds, with a sell-by.
- TaroStack records which spawn and substrate lots went into each run, and each flush that came out. More below.
An example sheet
Hilltop Greens is a made-up farm in Asheville, North Carolina, growing oyster and lion's mane on supplemented sawdust:
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Hardwood fuel pellets | lb | 600 | 400 | $0.18 | $108.00 | OK |
| Soy hulls, pelleted | lb | 350 | 400 | $0.24 | $84.00 | REORDER |
| Grain spawn, blue oyster | bag | 8 | 6 | $14.00 | $112.00 | OK |
| Grain spawn, lion's mane | bag | 3 | 4 | $16.00 | $48.00 | REORDER |
| Filter-patch grow bags | each | 420 | 300 | $0.42 | $176.40 | OK |
| Blocks, colonizing | block | 180 | 0 | $2.95 | $531.00 | OK |
With 96 fruiting blocks, quart tills and 34 lb of fresh blue oyster, the farm holds $1,639.90. The biggest number on the sheet is work in progress: 276 blocks, $814.20.
What a block costs
The $2.95 is the materials in one 5 lb block:
| Part | Cost |
|---|---|
| Pellets, 1.1 lb at $0.18 | $0.20 |
| Soy hulls, 1.1 lb at $0.24 | $0.26 |
| Spawn, one bag across seven blocks | $2.00 |
| Bag | $0.42 |
| Filter, tie and steam | $0.07 |
| A block | $2.95 |
Spawn is two thirds of it. That's the argument for tracking it closest. (Your time and the room's power come on top; the full figures are in mushroom farm business plan.)
Runs are lots
| Made or cut | Lot | Quantity | Next date | Note |
|---|---|---|---|---|
| Oct 27 | BLK-1027-BO | 96 blocks | To fruiting Nov 17 | Spawn BO-G2-1020 |
| Nov 10 | BLK-1110-BO | 84 blocks | To fruiting Dec 1 | Spawn BO-G2-1103 |
| Nov 16 | BO-1116 | 52 lb | Sell by Nov 23 | First flush from BLK-1013-BO |
Three weeks colonizing, then to the fruiting room. The sheet counts down to each move.
The spawn lot in the note is the point. If BLK-1110-BO comes up contaminated and BLK-1027-BO didn't, they had different spawn (1103 against 1020). If both do, look at the steamer or the lab. Without the lot on the row, every bad run is a mystery and you fix nothing.
Harvests point back the other way. Fifty-two pounds came off the October 13 run's first flush. Write each flush against its run and you get pounds per block, which is the number the whole farm lives on. A run of 96 blocks at 5 lb each is 480 lb of substrate; 52 lb on the first flush is a start, and the second and third will tell you whether the run paid.
Get the spreadsheet
Download the mushroom inventory spreadsheet. Four sheets: inventory with value and REORDER, lots for spawn, runs 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. Selling what you pick is in how to sell mushrooms at farmers market.
Where this stops working
A farm making two runs a week has a dozen lots alive at once, each at a different stage, each due to move on a different day. Moving 96 blocks from one row to another by hand, and remembering which run each flush came from, is the part that slips.
How TaroStack does it
TaroStack keeps each run as a batch from bag to basket.
A run is a batch. A block is a recipe: pellets, hulls, spawn, a bag. Record a run of 96 and the materials come off stock, and the batch record notes which spawn lot and which pellets went in, automatically.
Stages are stock. Colonizing blocks are a lot you hold, with a cost. Fruiting is the next step. Nothing is invisible because it's in a dark room.
Harvests carry the run. Fresh mushrooms picked from a run become a lot with a sell-by, sold oldest first, and traced back to the blocks, the spawn and the substrate.
Yield, run by run. From your batch history, TaroStack shows whether a recipe yields what it claims, so you can see which species and which spawn pay.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Which spawn went into a run | A note, if written | On the batch record |
| Blocks at each stage | Move rows by hand | Lots, with dates |
| Pounds per block | Add up by run | Yield against the recipe |
| What's in the cooler, oldest first | Read dates | First expired, first out |
Recipes, batches and lots are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). 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.
