Skip to content

Market Vendor Inventory Template: Brought, Sold, Left

A market vendor inventory template: what you brought, what's left, what sold and for how much, a cash check at close, and how to use it to pack next week.

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 20, 2026 · 6 min read

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.

Questions people also ask

How do I track inventory at a farmers market?

Count each item before you leave and again when you pack up. What's missing, less samples and breakages, is what sold.

How much should I bring to a farmers market?

Enough that you have a little left at closing. Use the share sold over the last few weeks: bring more of what sold out, less of what came home.

How do I check my cash at the end of a market?

Add card sales and the cash counted, take off your starting float, and compare with units sold times price.

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.