A market vendor's inventory sheet needs four numbers for each thing on the table: what you brought, what was sampled or damaged, what's left at close, and the price. From those it works out what sold, the sales it should have made, and the share of what you brought that sold. That takes five minutes: count into the car, count out of it. In return you get the day's takings to check your cash against, and after a few weeks the best guide there is to what to pack. The share-sold column is the one to read: 100% means you ran out and left money on the table, and 54% means you carried half of it home. Below is one Saturday for a made-up jam and baked goods stall, and the file.
The short version
- Count each item into the car and out of it. Nothing else has to be written during the market.
- Sold = brought − samples and damaged − left.
- Check the sheet's sales against card and cash, less your float.
- Sold out early: bring more. Under 60%: bring less.
- Write the lot or the bake date beside each item.
- TaroStack takes what you sold off stock by lot, and tells you what to make before next week. More below.
One Saturday
| Item | Lot or made on | Price | Brought | Samples, damaged | Left | Sold | Sales | Share sold |
|---|---|---|---|---|---|---|---|---|
| Strawberry jam, 8 oz | SJ-1102 | $10 | 36 | 1 | 9 | 26 | $260 | 72% |
| Peach jam, 8 oz | PJ-0824 | $10 | 24 | 11 | 13 | $130 | 54% | |
| Pepper jelly, 8 oz | PP-1019 | $11 | 24 | 1 | 2 | 21 | $231 | 88% |
| Granola, 12 oz | MP-1106 | $10 | 30 | 8 | 22 | $220 | 73% | |
| Banana bread, loaf | Baked Nov 13 | $12 | 20 | 0 | 20 | $240 | 100% | |
| Scones | Baked Nov 14 | $4 | 48 | 2 | 6 | 40 | $160 | 83% |
| Gift box, 3 jams | Packed Nov 12 | $32 | 10 | 4 | 6 | $192 | 60% | |
| Total | $1,433 |
The cash check
| Sales the sheet expects | $1,433 |
| Card sales, from the reader | $705 |
| Cash counted at close | $825 |
| Less the float you started with | -$100 |
| Money actually taken | $1,430 |
| Over or short | -$3 |
Three dollars short on $1,433 is a miscounted coin or a rounded-down price for a regular. Fifty dollars short would mean something else: a count that was wrong on the way in, a price sign that didn't match the sheet, or stock that left without being paid for. The check only works if samples and breakages are written down, which is why they have their own column.
What to pack next week
Banana bread, 100%, gone by 10:40. The market runs until 1 PM. That's more than two hours of people asking for it. Twenty wasn't enough: try thirty.
Pepper jelly, 88%, nearly out by 11. Close to selling out. Bring thirty.
Peach jam, 54%. Eleven jars came home. Jam keeps, so nothing was lost, but they took table space and a place in the car. Bring eighteen.
Scones, 83%, six left. For something that's stale tomorrow, six left over is about right. The aim with a perishable isn't 100%. It's to have a few at closing time and none in the bin.
Gift boxes, 60% in their first week. Too early to judge. Holiday items climb.
One Saturday is noise. Rain, a football game or a new stall next door all move the numbers. Keep the sheets, and look at the last four weeks together before changing what you bake. More on the sums in how much inventory for a craft fair.
Why the lot column is there
The jam has a lot code and the bread has a bake date. Writing them on the sheet takes a moment, and it's the only record of which batch was on the table on which Saturday. Market sales are cash to strangers. If a jar from SJ-1102 ever has a problem, you can't phone the buyers, but you can say "sold at the market on November 14 and 21" and put up a sign there. For shop and online sales you'd know more.
Bring the oldest lot first. If two lots of strawberry are in the crate, the older goes at the front of the table.
A stall selling crafts counts the same way, with a sheet in craft fair inventory sheet. What a market stall needs before its first day is in farmers market vendor permit, and what to charge for the jam in how to price jam.
Get the template
Download the market vendor inventory template. Two sheets and a read-me: the market day sheet, where sold, sales and share sold work themselves out, and the cash check. Save a copy for each market day. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. Print it and fill in "brought" as you load.
Where this stops working
The sheet knows about Saturday. It doesn't know that the 26 jars of strawberry it sold came off a shelf at home that now has ten left, with a shop order for twenty-four due Wednesday. The market count and the stock at home are two separate lists, and it's Sunday night when you find out they disagree.
How TaroStack does it
TaroStack makes the market one more place your stock goes.
The market is a place. Move what you load to it, and move back what comes home. What's missing is what sold or was sampled.
It works with no signal. Count on a phone at the stall and it catches up when you're back in range. TaroStack connects to Square.
Record the day's sales as one order. The oldest lot goes first by default, and each lot's history shows the day it was sold at the market.
"What could I make right now" and the reorder list say what to make and what to buy before next Saturday, counting the shop order too.
Dates on every lot. An alert flags lots close to their best-by, which decides what goes to the front of the table.
| The job | Market sheet | In TaroStack |
|---|---|---|
| What sold | Brought less left | The same, off your real stock |
| Stock at home after the market | A separate list | One count |
| Which lot was on the table | A column, if filled in | The lot's history |
| What to make this week | Read four sheets | The reorder list |
Stock, lots and counting 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.
