Market Vendor Event Profit Tracker Spreadsheet | Craft Fair and Farmers Market Sales Log, Booth Profit Calculator, Google Sheets
"Was that market worth it?"
If you sell at craft fairs, farmers markets, or pop-ups, you know the feeling: a busy-looking day, a decent stack of cash — and no real idea whether the booth fee, the drive, the cost of your products, and six hours of your time actually left you ahead. Most vendors guess. Then they rebook the same money-losing market next season, because the guess felt fine.
This tracker ends the guessing. Log your sales in one line each — right at the booth, on your phone — and every event gets a true settlement: sales minus product costs, booth fee, and travel, divided by your hours. Then it gives each event a verdict: Rebook, Maybe, or Skip. Next season's calendar decides itself.
BUILT FOR THE BOOTH, NOT THE DESK
The sales log is one line per sale batch — date, event, product, quantity, amount. It takes seconds between customers, in the free Google Sheets app. No tally sheets to decode at home, no reconstructing the day from memory and a card reader report.
HOW IT WORKS
1. Download the PDF and click your link to make your own copy of the tracker.
2. List your products once: price and what one unit costs you. Margins fill in by themselves.
3. At each event, log sales one line at a time. Afterwards, add the booth fee, travel cost, and hours you worked.
4. Read the settlement and the verdict. That is it.
Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.
THE VERDICT RULE
Every event is graded on profit per hour:
• $25 or more = REBOOK
• $10.00 to $24.99 = MAYBE
• Under $10 = SKIP
Your numbers may differ — the cut-offs live right in the Verdict formula, and the Start Here tab shows you exactly where to change them.
WHAT YOU GET — 6 tabs:
• Start Here — plain-English guide, the verdict rule, and how to make the tracker yours
• Sales Log — fast one-line sale entry, made for your phone at the booth
• Products — your prices and unit costs, with margins, units sold, and revenue counted for you
• Events — booth fee, travel, and hours in; revenue, product costs, profit, profit per hour, and the verdict out
• Dashboard — the whole season at a glance: totals, best and worst events, and your Rebook / Maybe / Skip counts
• Event Notes — what sold, the weather and foot traffic, and your own rebook notes while the day is fresh
Your copy arrives with one fictional sample season already filled in (three markets, three different verdicts) so you can see exactly how it reads — then delete the sample rows and start with your own.
FINISHED FILE — This listing is a digital item, delivered instantly as a file at checkout. The file is finished and ready to use — nothing is customized or personalized. If anything ever breaks or a formula misbehaves, message us and you will receive a corrected file free — forever, no time limit.
REQUIREMENTS: a free Google account. Your tracker lives in Google Sheets — nothing to install, and it works at the booth, at home, and on your phone.
This is a digital product — no physical item will be shipped, and all sales are final (we can't accept returns or cancellations on digital downloads). Your files are available instantly after checkout. But don't worry: if anything isn't working right, message us anytime and we'll fix it for you — no time limit.