Skip to content

Flower Farm Inventory Spreadsheet: Tubers, Seed, Stems

A flower farm inventory spreadsheet: dahlia tubers by variety, seed lots, plugs and supplies with value and reorder, a weekly harvest tally, and a free file.

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 21, 2026 · 6 min read

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.

Questions people also ask

How do you keep track of dahlia tubers?

One line for each variety, with the number of sound tubers. Label each clump before it's dug and each tuber as it's divided, store one variety to a crate, and count again before selling.

What inventory does a flower farm need to track?

Stored stock: tubers and bulbs by variety, seed by lot and year, plugs, field supplies and selling supplies. Cut flowers are tracked on a harvest tally instead.

How do I know which flowers to grow less of?

Keep a weekly tally of bunches made, sold and composted for each crop. In the example, a fifth of the zinnias went unsold against a tenth of the dahlias.

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.