Craft Fair & Market Stall Profit Tracker Spreadsheet
This spreadsheet works out what each market day and craft fair actually paid you for an hour of standing behind the stall.
There are plenty of spreadsheets that help you get ready for a fair — pack lists, price labels, a float, a break-even target — and every one of them stops working the moment the van is loaded. This one runs afterwards. You put in what you took, what you carried home and what the day really cost, and it ranks the season by what each event paid you an hour.
What is in it
- Eight linked tabs, from Start Here through to a one-screen Overview of the whole season.
- Setup — four figures: your mileage rate, the fee your card takings are charged, what your hour is worth, and the float you start with.
- Products — 30 rows. What each thing costs you to make and what it sells for, with the margin per unit worked out.
- Stock — 300 lines, one per product per event: brought and sold, with revenue, the cost of what actually sold and what came home all calculated.
- Events — 60 rows: pitch fee, round-trip miles, hours away, other costs, and the card and cash you took. Everything else calculates.
- Cash Check and Worth Going Back — what the tin should have held against what it did hold, and every event ranked by profit per hour and labelled.
Who it is for
Anyone who pays for a pitch and then stands behind it: makers at craft fairs, bakers and growers at farmers markets, candle, print and plant sellers at night markets, and anyone who books a county show or a Christmas fair once a year and wonders afterwards whether to book it again.
The worked example
The worked season in the file runs nine events over one year. A summer festival took $1,071.00 across 10.0 hours and 92 miles and paid $48.81 an hour. A weekly market took $398.00 in 4.5 hours and 12 miles and paid $60.10 an hour. The festival took nearly three times the money and paid less for the time; takings rank the day, hours rank the year.
One weekend was a bill. The county show carried a $240 pitch fee — the largest of the season — a paid helper, a 136-mile round trip and eleven hours, against $248.50 of takings, for a net of −$240.39. The season as a whole still made $3,557.19 on $6,622.50 of takings: a 53.7% net margin, and $55.58 for each of the 64 hours away from the bench. The cash check caught one event $18.50 short — two discounts given late in the day and never written down.
How it works
Compatible with Microsoft Excel 2016 or newer on Windows or Mac, Google Sheets, and LibreOffice. No macros, no add-ons, no account to create, nothing to install.
The download has two workbooks: one with the example above already filled in, so you can see what every column expects, and the same file completely blank for your own figures. A plain-English guide comes as a PDF. WhatsApp’tan sipariş ver — $9
Orders are taken on WhatsApp: message me and I’ll send the payment details, then the files as soon as the payment is confirmed.
A look inside the file
Questions people actually ask
How do I work out what a market or craft fair actually paid me per hour?
You put in the pitch fee, the round-trip miles, the hours away, any other costs and the cash and card you took, plus what you brought and sold from each product, and the file returns the profit for the day and the profit per hour standing there. In the worked season a summer festival took $1,071.00 over 10.0 hours and 92 miles — $48.81 an hour — while a weekly market took $398.00 over 4.5 hours and 12 miles and paid $60.10 an hour. Takings rank the day; hours rank the year.
I sell food rather than craft. Does it still fit?
Yes — products are whatever you type: loaves, jars, plants, prints, candles. Anything you can count in and count out again works the same way, across 30 products, 300 stock lines and 60 event rows, which is more than most makers do in a year. The worked season is nine events — two craft fairs, three farmers markets, two night markets, a festival and a county show — producing $6,622.50 of takings and $3,557.19 of net profit, a 53.7% margin and $55.58 for each of the 64 hours away from the bench.
What if I only take cash, or do not want to fill in the stock tab?
Leave the card column at zero and the card fee goes to zero, while the cash check still works. The stock tab is where the takings come from, so fill it in if you want profit per event; if you only ever want the cash check, type your takings straight in. The cash check is takings minus card takings against the cash you actually counted — in the worked season one event came up $18.50 short, from two discounts given late in the day and never written down.
Does it need Excel, or will Google Sheets do?
Google Sheets is fine — the file is .xlsx and imports through File then Import then Upload, and it also opens in Excel 2016 or newer on Windows and Mac and in LibreOffice. No macros, no add-ons, no account and no subscription, and nothing to install. It holds one season per file, deliberately, so last year stays readable.
Will it tell me what to charge or keep my stock levels?
No — you put your prices in and it measures what they did; it is a record of the season, not a pricing calculator or a stock control system. It is not a pack list, a planner or a booth checklist either. It connects to no till, card reader or online shop — nothing syncs and nothing logs in — and it is not tax or accounting advice.
Need it built around your business?
This file assumes one stall, one pitch fee, your own car and a season you book yourself. If yours works differently — two pitches running the same weekend with paid help on each, a permanent weekly place where you pay rent monthly instead of a fee per day, a van with its own fuel, insurance and servicing rather than a mileage rate — I can build the same arithmetic around the way you actually trade.
All other templates are listed on the Excel & Google Sheets Templates page.