Skip to content

Greenhouse Inventory: A Supply List and a Spring Sum

A greenhouse inventory sheet for pots, growing mix, trays, fertilizer, seed and tags: reorder levels, what a spring crop needs against what's on hand, lots.

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

A greenhouse has two inventories. One is the plants on the benches, which is the crop. The other is everything the crop is grown in and with: growing mix, pots, trays, fertilizer, seed, tags. This page is about the second, because it's the one that stops a season. A reorder level catches the slow leak, the bag of fertilizer used up in October. It doesn't catch spring, when one delivery of plugs needs more pots in a week than the greenhouse used all autumn. So the sheet below does two jobs: a supply list with reorder levels, and a sum of what the spring crop needs set against what's on hand. The example is a made-up one-acre greenhouse.

The short version

  • List every supply the crop uses up: mix, pots, trays, fertilizer, seed, tags, crop protection.
  • Count in the unit you buy: bales, cases, bags.
  • A reorder level is for steady use. For spring, work out the need from the crop plan.
  • Order the spring supplies when you order the plugs, not when they arrive.
  • Write the lot of each delivery of mix and seed.
  • TaroStack keeps stock by lot and suggests what to buy. More below.

An example list

Counted in mid November, before the spring orders go in.

Item Unit On hand Reorder at Unit cost Value Status
Potting mix, 3.8 cu ft bale bale 14 20 $38.00 $532.00 REORDER
Perlite, 4 cu ft bag bag 6 4 $26.50 $159.00 OK
Pot, 4.5 in, case of 500 case 5 6 $62.00 $310.00 REORDER
Pot, 1 gallon, case of 200 case 9 5 $58.00 $522.00 OK
Tray, 1020, case of 100 case 3 2 $95.00 $285.00 OK
Plug tray, 288 cell, case of 100 case 1 2 $110.00 $110.00 REORDER

Twelve rows in all, $3,334.00 at cost, with four to reorder: potting mix, 4.5 inch pots, plug trays and plant tags. The other six rows are two fertilizers, tomato seed, hanging baskets, tags and insecticidal soap.

Plugs and rooted cuttings aren't on this list. They're ordered to a delivery week, not to a level, so they belong on the crop plan, and on the deliveries sheet the day they arrive.

What spring needs

The reorder levels above are for a quiet greenhouse. This is what the spring crop asks for.

Supply The crop needs On hand To order
Pot, 4.5 in, case of 500 24 cases 5 19
Pot, 1 gallon, case of 200 15 cases 9 6
Potting mix, 3.8 cu ft bale 115 bales 14 101
Plant tags, box of 1,000 15 boxes 3 12

The crop is 12,000 bedding plants in 4.5 inch pots and 3,000 vegetable starts in gallons. Pots are simple: 12,000 ÷ 500 is 24 cases, 3,000 ÷ 200 is 15. Every pot gets a tag, so 15,000 tags, 15 boxes.

Mix is the one to measure yourself. This grower fills about 250 small pots or 45 gallon pots from a bale, counted on its own potting bench, and your mix, your pots and how firmly you fill them will give different numbers. At those rates: 48 bales for the small pots and 67 for the gallons, 115 in all.

The list said OK and the sum says order six. Gallon pots: nine cases on hand against a reorder level of five. Nothing on the supply list flags them. The crop needs 15.

A hundred and one bales is a truck, not a pickup. That's the other reason to do the sum in November. Mix by the pallet has a lead time and a freight bill, and both are better when it isn't March.

How the levels themselves are set is in reorder point example, and the difference between a level you top up to and a level you reorder at in par level vs reorder point.

Deliveries, with their lots

Received Item Lot or batch Quantity Use by Note
Nov 3 Potting mix, 3.8 cu ft bale Lot PM-26-4417 20 Lot from the bale's tag
Nov 10 Tomato seed, 1,000 count Lot T-88213 4 Dec 31, 2027 Germination tested 2026-08: 94%
Nov 12 Insecticidal soap, 2.5 gal Batch IS-0926 2 Sep 30, 2029 Label and safety sheet in the chemical room binder

When a bench of seedlings stalls, the supplier's first question is which lot of mix or seed it was. A grower who wrote the lot on the delivery row, and which benches got it, can answer, and can check whether the other benches from the same lot are doing the same thing. A grower who didn't has an argument instead of a claim.

Seed has a date and a germination figure: write both. Crop protection products have a label that says how they may be used and stored. Keep it and the safety sheet where the product is, and ask your State's pesticide regulator what records it expects.

A list for the plants themselves is in nursery inventory spreadsheet, and one for seed alone in seed inventory spreadsheet.

Counting

Count supplies once a month in the off season, in the order of the list, and every week from the first plug delivery until the last flat ships. Count in whole units and write the opened one as a fraction: half a bale is 0.5. The file's count sheet takes what the list said and what you found, and works out the difference at cost. A plan for what to count when is in cycle count form.

Get the list

Download the greenhouse inventory sheet. The supply list with values and a status for each row, a deliveries sheet with lots and dates, 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.

Where this stops working

The list is right on the day it's counted. In the second week of February, with three people potting, 14 bales on Monday is 6 on Wednesday and nobody has typed anything. The spring sum has to be redone whenever the crop plan changes, which it does. And the lot of mix is on the deliveries sheet, but which benches it went onto is in somebody's head.

How TaroStack does it

TaroStack keeps the count as things happen, not once a month.

Receiving records the lot and its dates. Scanning a supplier's GS1-128 case label fills in the lot and the use-by date.

Buy by the bale or the case, use by the pot or the pound. TaroStack does the conversion.

A reorder list in days of cover, with reorder points suggested from how stock actually moves.

Suppliers with lead times and minimums, and the lead time each one promises checked against how long deliveries really take.

Counting on a phone, with no signal in the far house, sent later. It shows what a difference is worth before you post it.

The job Spreadsheet In TaroStack
What's on hand today Whatever was last typed Stock, by lot
What to order Compare two columns The reorder list, in days of cover
Which lot of mix is in use The deliveries sheet The lot on the stock
How long the supplier really takes Memory Lead times checked against deliveries

Stock, lots, receiving and the reorder list are on every plan, from $9.99 a month (50 items) or $39 a month (3,000 items). On Growth, a finished pot can be a recipe (a pot, a tag, a plug and a share of a bale), and planning says what to buy for the batches you mean to make. 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 should a greenhouse inventory include?

The supplies the crop uses up: growing mix, pots and trays, fertilizer, seed, tags and crop protection products, each with its unit, the amount on hand, a reorder level and a cost. Plants on the benches are a separate list.

How do I work out how much potting mix to order?

Count how many pots of each size you fill from one bale on your own bench, then divide the crop's pots by that number. The example fills about 250 small pots from a bale, so 12,000 pots need 48 bales.

Why record the lot number of growing mix and seed?

So that when a crop does badly you can tell the supplier which lot it was, and check whether other benches from the same lot have the same problem.

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.