Produce inventory is a race against the calendar, and a produce inventory spreadsheet is mostly a way to see who's losing. It needs a row for each crop with what's on hand, what a unit cost you, and where it's kept. Then it needs the part that matters more than for any other stock: when each lot was picked or delivered, and the day it should be sold by. Sweet corn is at its best for about three days. Cured garlic holds for months. A sheet that treats them the same will let the corn go starchy in the cooler. The one below is filled in for a made-up farm stand in July, and it's free to download.
The short version
- One row a crop, in the unit you sell it in: pounds, dozens, eaches.
- A lot for every picking or delivery: the field and the date is enough.
- A sell-by date on each lot, short for corn and lettuce, long for garlic.
- Write down what you throw out, with the reason.
- TaroStack sells the oldest lot first and shows what's about to turn. More below.
An example sheet
Mill Creek Farm is a made-up vegetable farm with a self-serve stand in Bloomington, Indiana. In the third week of July, six of its nine rows:
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Tomatoes, slicing | lb | 85 | 40 | $1.60 | $136.00 | OK |
| Sweet corn | dozen | 30 | 20 | $2.40 | $72.00 | OK |
| Cucumbers | lb | 22 | 25 | $0.90 | $19.80 | REORDER |
| Green beans | lb | 18 | 10 | $1.85 | $33.30 | OK |
| Peaches | lb | 60 | 30 | $1.45 | $87.00 | OK |
| Watermelons | each | 14 | 8 | $3.20 | $44.80 | OK |
Lettuce, eggs from a neighbor and cured garlic make nine. The cooler, the shade bench and the shed hold $640.50 at cost. Cucumbers and lettuce are under their amounts.
For crops you grow, read REORDER as "pick more". For the peaches and eggs you buy in, it means what it says. And "cost" for your own tomatoes is what it took to grow, pick and wash a pound. If you've never worked that out, a rough figure is better than a blank; farm stand prices shows one way.
Lots: the field and the pick date
| Picked or received | Item | Lot | Quantity | Sell by |
|---|---|---|---|---|
| Jul 20 | Tomatoes, slicing | F3-0720 | 120 lb | Jul 27 |
| Jul 21 | Sweet corn | F1-0721 | 45 dozen | Jul 24 |
| Jul 18 | Peaches | OR-0718 | 100 lb | Jul 25 |
| Jul 21 | Lettuce, heads | F2-0721 | 40 | Jul 26 |
| Jul 10 | Garlic, cured | F4-0710 | 60 lb | Jan 31, 2027 |
A lot here is nothing fancy. F3-0720 is field 3, picked July 20. Write it on the crate with a marker. For produce bought in, use the date on the grower's crate, and keep their name on the row.
The sell-by dates are the farm's own judgment, and yours will differ with your cooler. The sheet counts the days left and marks a lot USE FIRST when two or fewer remain. On the morning of July 22, corn picked on the 21st is already flagged. That's the list to read before you set out the stand: flagged lots go at the front, or into a "seconds" basket, or to the kitchen for salsa.
There's a second reason to keep the field and date. If someone gets sick and it might have been your lettuce, "field 2, picked July 21, 40 heads, sold at the stand and to one restaurant" is the answer an inspector needs. More on that in what is lot tracking.
Count what you throw away
Shrink is the produce business's quiet expense. Add a line to the Lots sheet's notes whenever something goes to compost: "12 lb tomatoes, split, Jul 26." At the end of the month, the notes tell you whether you're picking more than you sell, or holding it too long. A waste log does this properly.
Get the spreadsheet
Download the produce inventory spreadsheet. Four sheets: the inventory with value and status, lots with days left, a count sheet that fills itself, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. The rest of the farm's stock is in farm inventory template.
Where this stops working
Produce moves faster than anyone types. By noon the stand has sold 14 dozen corn from two pickings and nobody knows how many from each. The restaurant order went out from the newest crate because it was on top. The sheet was right at 7 a.m.
How TaroStack does it
TaroStack keeps each picking as its own lot and sells the oldest first.
Every harvest is a lot with a date. Receive the morning's picking into stock, by field, with its sell-by. Two pickings of corn stay two lots.
First expired, first out. Sales and orders take the lot that's due soonest by default. A forecast shows what will pass its date unsold, and what that's worth, while there's still time to mark it down.
Waste has a reason. Every write-off carries one (spoiled, damaged, sample), so shrink is a report by crop and by reason.
The stand and the cooler have no signal. Count and record on a phone offline; it sends itself later.
A recall is one report. Which lot went to which customer, and what's still on your shelves.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Which corn to sell first | Read the dates | Oldest lot by default |
| What's about to turn | Check each morning | An alert, with its value |
| What was thrown out, and why | Notes | Adjustments with reasons |
| Who got field 2's lettuce | Memory | One report |
Lots, expiry and recalls are on every plan, from $9.99 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.
