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.
