Craft Fair Tracker Spreadsheet, Market and Pop Up Sales Tracker, Booth Fee and Profit per Event, Vendor Inventory Log, Google Sheets Excel

Find out which craft fairs and markets are really worth your weekend.

A busy booth is not always a profitable one. Booth fees, driving, parking, food, card reader fees and the cost of what you sold all come off before you keep anything. This tracker adds it all up for every event and shows your net profit, profit per hour and sell-through, so you know which events to book again.

HOW IT WORKS
- List your products once with your usual price and cost per item.
- For every event, type the booth fee, hours, miles or km driven and other costs.
- Event Inventory: pick the event and product, type how many you brought and how many you sold. Sales, cost of goods, leftovers and sell-through fill in.
- The Dashboard ranks your events by net profit and by profit per hour.

FEATURES
- Events: 100 event rows with booth fee, mileage, travel, lodging and food, other costs and card fees
- Net profit, profit per hour, items sold and sell-through for every event
- Event Inventory: 1,000 rows, brought vs. sold per product, optional event price (e.g. a fair discount)
- Products: sales, sold and sell-through per product across all events
- Dashboard: totals, best 10 events by net profit, best 5 by profit per hour, results by event type, From / To filter, chart
- "Go again?" and a 1-5 rating for your own notes
- Editable settings: card reader fee %, your mileage rate, event types

WHAT YOU GET
+ Craft-Fair-Market-Tracker.xlsx (Dashboard, Events, Event Inventory, Products, Settings, Start Here)
+ How-to-open PDF (Google Sheets and Excel)

HOW TO OPEN IT IN GOOGLE SHEETS
1. Download the files from You > Purchases and reviews.
2. Upload the .xlsx file to Google Drive and open it.
3. Choose File > Save as Google Sheets.
It also opens directly in Excel 2016 or newer.

GOOD TO KNOW
- Digital download. Nothing will be shipped.
- Works for craft fairs, farmers markets, holiday markets, pop-ups, festivals and art walks.
- Comes with sample data, clearly marked SAMPLE, so you can see how it works. Sample numbers are made up and are not benchmarks.
- Not affiliated with or endorsed by Etsy, Inc.
- Organizes your own numbers. Not tax, legal or accounting advice.

Designed by seller. This spreadsheet was created with the help of AI tools, built and tested by hand (formulas recalculated and checked with sample data and with empty inputs).

Questions or a problem with the file? Message us on Etsy and we will help.