Skip to content

Mushroom Inventory Spreadsheet: Spawn, Blocks, Flushes

A free mushroom inventory spreadsheet for a small farm: substrate and spawn by lot, blocks colonizing and fruiting by date, harvests by flush, and reorders.

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

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.

Questions people also ask

What records should a mushroom farm keep?

For each run: the date, species, substrate recipe, spawn lot, number of blocks, the dates it moved, and the pounds picked on each flush.

How do you track contamination?

Log every run with its spawn lot and steam date, and note which blocks were lost. Patterns show after a few weeks.

Do I need a license to sell mushrooms?

It depends on the state and where you sell. See mushroom business license.

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.