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.
