Skip to content

Produce Inventory Spreadsheet for a Farm Stand or Shop

A free produce inventory spreadsheet for a farm stand, market or small grocer: what's in the cooler by pick date, what it cost, what to sell first, shrink.

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 19, 2026 · 5 min read

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.

Questions people also ask

How do you keep track of produce inventory?

By crop and by lot: what was picked or delivered on which day, what's left of it, and when it should be sold by. Count the cooler every morning in season.

How do you reduce produce shrink?

Sell the oldest lot first, mark down what's close to its date, and write down everything you throw out so you can see which crops you're over-picking.

How do I start a farm stand?

The permits, the pricing and the stand itself are in how to start a farm stand.

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.