Skip to content

Farm Stand Inventory Sheet: Put Out, Sold, in the Box

A farm stand inventory sheet: what's on the stand and its value, a daily sheet of put out, left and sold, the cash box check, and a free spreadsheet.

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 farm stand needs two sheets. The first is an ordinary inventory sheet: what's on the stand and in the cooler today, counted in the unit you sell it in, with what each cost you and a level to restock at. The second is the one that matters for a stand nobody is watching: a daily sheet. For each thing, what you put out in the morning, what was left at night, and so what sold. Multiply by the prices and you know what the cash box should hold. Compare it with what's in the box. Without that sum, a self-serve stand has no idea whether it's selling, giving food away, or being robbed. Below are both sheets for a made-up stand, and the file.

The short version

  • Count what's on the stand in selling units: pounds, dozens, jars, bunches.
  • Each morning, write what you put out. Each night, what's left.
  • Sold = put out − left. Sold × price = what the box should hold.
  • Count the box. A small gap is change and kindness. A big one is a problem.
  • What's left and can't be sold tomorrow is waste: write it down.
  • Eggs and jam get a date.
  • TaroStack keeps each day's eggs and each batch of jam as a lot. More below.

The inventory sheet

A made-up self-serve stand, a Friday morning in September.

Item Unit On hand Reorder at Unit cost Value Status
Tomatoes lb 60 30 $1.20 $72.00 OK
Sweet corn dozen 18 20 $3.00 $54.00 REORDER
Eggs, large dozen 14 12 $2.80 $39.20 OK
Strawberry jam, 8 oz jar 22 12 $3.10 $68.20 OK
Honey, 1 lb jar 9 12 $6.50 $58.50 REORDER
Cut flower bunches bunch 8 10 $3.00 $24.00 REORDER

Ten rows in all, $437.20 at cost, with four to restock: sweet corn, honey, flower bunches and egg cartons. For your own crops "reorder" means pick more. For the honey it means call the neighbor.

Unit cost is what a pound or a dozen cost you to grow or buy. It's rough for your own tomatoes, and still worth writing down: it's what tells you whether a $3 pound is worth growing.

The daily sheet

Saturday Put out Left Sold Price Should be in the box
Tomatoes, lb 40 12 28 $3.00 $84.00
Sweet corn, dozen 18 2 16 $7.00 $112.00
Eggs, dozen 10 1 9 $6.00 $54.00
Jam, jar 12 9 3 $8.00 $24.00
Flower bunches 8 3 5 $10.00 $50.00
Total $324.00
The box
Should hold $324.00
Cash counted, less the $20 float $241.00
Paid by phone app $62.00
Collected $303.00
Short $21.00

Twenty-one dollars short on $324 is about 6%. On an honor stand some of that is people rounding down, a dozen corn that was really fourteen ears, a tomato that got squashed and thrown in the ditch. Know your usual gap. This stand's runs 4% to 7%, and a day at 30% means something changed.

When the gap is big, look at which item it could be. If the corn is all gone and the box is $100 light, someone took corn. A camera, a locked box bolted down, and emptying the box at midday are the usual answers.

What's left. Two dozen ears of corn left on Saturday night are Sunday's pig feed. Write it as waste, not as stock: tomorrow's sheet starts from what's actually fit to sell.

Dates

Collected or made Item Lot or date Quantity Sell by
Sep 14 Eggs Collected Sep 14 6 dozen Oct 14
Sep 17 Eggs Collected Sep 17 8 dozen Oct 17
Jul 2 Strawberry jam J-0702 48 jars Jul 2 next year
Sep 18 Sweet corn Picked Sep 18 18 dozen Sep 21

Write the collection date on every egg carton and put the oldest at the front. The dates here are this stand's own. Your state may set rules for selling eggs and jam from a stand: check before you put them out. Jam gets a batch code on the lid, so that if one jar is ever a problem you know which pot it came from.

What to charge is in farm stand prices. A sheet for selling at someone else's market is in market vendor inventory template, and for eggs alone in egg inventory template.

Get the sheet

Download the farm stand inventory sheet. Four sheets: inventory with value and REORDER, lots with days left, a count sheet that works out each difference and what it's worth, and a read-me. Add a copy of the daily table above for each day you're open. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.

Where this stops working

The daily sheet takes five minutes, twice a day, in the season when there's no five minutes. By August it's filled in on Saturdays. The jam in the stand is from three batches and nobody's sure which. And the question you actually want answered in November, which crop paid for its row, needs every day's sheet added up by hand.

How TaroStack does it

TaroStack keeps the stand as its own place, with what went there and what came back.

The stand can be a site of its own, with its own stock. What you carry out in the morning is a transfer, and what's left is counted on a phone.

Counting works with no signal, at the roadside. A count shows what a difference is worth.

Each day's eggs and each batch of jam is a lot with its date, and the oldest goes out first by default.

Every adjustment carries a reason, so unsold corn and missing tomatoes are two different numbers.

The job Paper sheets In TaroStack
What went to the stand, what's left Two columns, most days Transfer and count
What the gap was worth A sum On the count
Which jam batch is on the shelf Unknown Stock by lot
Waste by crop, for the season Add up the sheets Adjustments by reason

TaroStack doesn't watch the cash box or take payments. It connects to Square. More than one site is on Business at $89 a month. Stock, lots and counts 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 inventory at a farm stand?

Write what you put out each morning and what's left each night. The difference is what sold. Keep a count of what's on hand, with a level to restock at, for jars, eggs and supplies.

How do I know if people are paying at a self-serve stand?

Multiply what sold by its price and compare the total with the cash and app payments. A steady small gap is normal. A sudden large one isn't.

How much do honor system farm stands lose?

It varies by place. The stand in this example runs 4% to 7% short of what the daily sheet says it should collect. Measure your own before deciding what to do about it.

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.