A flower farm has two kinds of stock, and they need different sheets. What's bought and stored lasts months: dahlia tubers, seed, plug trays, landscape fabric, sleeves and buckets. That goes on an ordinary inventory spreadsheet, with a count, a cost and a level to reorder at. What's cut lasts a week: stems are counted the day they're harvested, bunched, sold or composted, and are gone before any monthly count. Those go on a harvest tally. The stored side has one item that needs more care than the rest. Dahlia tubers are counted by variety, because a tuber of the wrong variety is a year lost. Below is a sheet for a made-up one-acre farm in November, a week's harvest tally, and the file.
The short version
- Stored stock on the inventory sheet. Cut stems on a harvest tally.
- Dahlia tubers: one line for each variety, labeled the day they're dug.
- Seed: the lot and the year it was packed for.
- Plugs have a date to be in the ground by.
- Sleeves, bands and flower food stop a market day as surely as flowers do.
- The tally shows what was composted, by crop.
- TaroStack keeps tubers and seed by lot, counted on a phone. More below.
An example sheet
Counted in November, after the dahlias were dug.
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Dahlia tubers, divided | each | 340 | 100 | $3.50 | $1,190.00 | OK |
| Zinnia seed, 1,000 seeds | packet | 6 | 4 | $9.00 | $54.00 | OK |
| Snapdragon plugs, tray of 128 | tray | 8 | 6 | $28.00 | $224.00 | OK |
| Drip tape, 4,000 ft | roll | 2 | 2 | $140.00 | $280.00 | REORDER |
| Flower sleeves, case of 500 | case | 3 | 2 | $42.00 | $126.00 | OK |
| Mason jars, case of 12 | case | 5 | 6 | $11.00 | $55.00 | REORDER |
Ten rows in all, $2,576.00 in the barn, the cellar and the shed, with two to reorder: drip tape and mason jars. The tubers are nearly half of it.
Tubers by variety
| Dug | Variety | Tubers | Where | Note |
|---|---|---|---|---|
| Oct 28 | Cafe au Lait | 85 | Cellar, crate 1 | Stored at 45°F; check monthly for rot |
| Oct 30 | Cornel Bronze | 120 | Cellar, crates 2 and 3 | |
| Six other varieties | 135 | Cellar, crates 4 to 8 | ||
| All | 340 |
Dahlias don't come true from seed, so each variety exists only as tubers divided from last year's plants. A clump dug in October looks like every other clump. Label at the digging fork: a tag on the stalk before the clump leaves the ground, the variety written on each tuber with a marker when it's divided, and one variety to a crate. The $3.50 is this farm's own estimate of what a tuber is worth to it.
Then count again in February. Some rot and some shrivel in storage. If 85 Cafe au Lait went in and 70 come out sound, the sheet should say 70 before anyone sells 60 of them. The storage temperature here is this farm's own practice.
Seed and plugs
| Received | Item | Lot | Quantity | Plant or use by |
|---|---|---|---|---|
| Feb 10 | Zinnia seed | Lot 25-8841, packed for 2026 | 6 packets | End of 2027 |
| Nov 12 | Snapdragon plugs | Order 3310 | 8 trays | Nov 26 |
Seed loses germination as it ages, so the year on the packet matters as much as the count. Keep the lot number: if a sowing fails, it tells you whether it was the seed or the weather. More in seed lot number and seed inventory spreadsheet. Plugs are the opposite of seed: they arrive alive and have two weeks.
The harvest tally
One week in August.
| Crop | Stems cut | Bunch size | Bunches made | Sold | Composted |
|---|---|---|---|---|---|
| Zinnias | 1,200 | 10 | 120 | 96 | 24 |
| Dahlias | 600 | 5 | 120 | 108 | 12 |
| Snapdragons | 400 | 10 | 40 | 34 | 6 |
| The week | 2,200 | 280 | 238 | 42 |
Forty-two bunches of 280 were composted: 15%. Zinnias were a fifth unsold. Dahlias, at a tenth, were closer to right. Over a season this is the table that says what to plant less of. Without it, the compost pile is just part of the scenery.
Count in bunches once they're made, because that's what's sold. Count stems at the cut, because that's what a bed yields. Both, because the bunch size is your choice.
What to charge is in how to price cut flowers, the business in flower farm business plan, and a shop's version of this sheet in florist inventory list.
Get the spreadsheet
Download the flower farm inventory spreadsheet. Four sheets: inventory with value and REORDER, varieties and lots with dates, a count sheet that works out each difference and what it's worth, and a read-me. Add the harvest tally above as a fifth for the season. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
January: a florist wants 60 Cafe au Lait tubers and a garden club wants 25. The sheet says 85, from October. The February count hasn't been done. Twelve have gone soft. Both orders get promised, and in March somebody is refunded. The spreadsheet was right when it was written and nobody has been down to the cellar with it since.
How TaroStack does it
TaroStack keeps each variety as its own count, by lot.
Each variety is an item, and each year's digging a lot with its date.
Counting works on a phone with no signal, in the cellar. A count shows what a difference is worth.
Every adjustment carries a reason, so tubers lost to rot are a number by variety.
Customers and sales orders for tuber sales, with one picking list when it's time to pack them.
A reorder list in days of cover for sleeves, bands and flower food in the season.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Sound tubers of one variety, today | October's number | The last count, by lot |
| Tubers lost in storage | Not written down | Adjustments by reason |
| Two orders for the same variety | Both promised | Stock by lot, beside the orders |
| Sleeves before a market day | Look in the shed | The reorder list |
TaroStack doesn't plan beds or successions. Stock, lots and sales orders are on every plan, from $9.99 a month. A farm with many varieties needs Growth at $39 a month. 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.
