SheetSmart Template Co.
Craft Fair Sales Tracker

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

$4.99 USD
Buy on Etsy

Instant digital download for Microsoft Excel and Google Sheets. Checkout and delivery are handled securely by Etsy.

Craft Fair Sales Tracker for Microsoft Excel and Google Sheets, instant digital download. Find out which markets are really worth it: log sales by item and payment method, pack smarter with sell-through per event, and see profit after booth fees, card fees and cost of goods. Perfect for craft fair and craft show vendors. ✨ NOW INCLUDES 4 FILES: a SAMPLE version filled with example data so you can see how it works, plus a BLANK version ready for your own info, each for Excel and Google Sheets. ★ WHAT'S INCLUDED ★ • 9 tabs with a clickable Start Here cover page and a How To Use guide with FAQ • Dashboard: 8 KPI tiles (sales, net profit, events done, average profit per event, booth fees, cost of goods, best event, card and app fees), profit per event, your top 10 best sellers, how customers pay, coming up, plus a profit per event chart and a sales by payment method chart • Events (100 rows): date, location, type, booth fee, other costs and hours, with sales, items sold, cost of goods, payment fees, profit, profit per hour, sales per booth dollar and % of your goal • Sales Log (5,000 rows): event, item, quantity, price override, discount and payment method, with price, fees, cost of goods and profit worked out • Products (200 rows): category, SKU, unit cost, price, margin, units sold, sales, profit and stock value • Event Inventory (1,500 rows): what you packed, what sold, what came home and sell-through %, with bring more or bring fewer tips • Event Report: pick an event to see sales, costs, profit, items sold, sales by category, how people paid and what you packed, with a chart • Setup: business name, year, profit goal, payment fees (percent plus per-sale fee), product categories and event types • Sample data from a candle and handmade goods vendor's season so you can see how it works ★ PERFECT FOR ★ ✓ Craft fair and craft show vendors ✓ Farmers market and holiday market sellers ✓ Makers selling candles, soap, jewelry, art prints and ceramics ✓ Pop-up shop and festival vendors ★ COMPATIBILITY ★ • Microsoft Excel (desktop, Mac, web) • Google Sheets (upload to Google Drive and open with Google Sheets) • 4 files included: Excel (sample) + Excel (blank) + Google Sheets edition (sample) + Google Sheets edition (blank) • Not designed for Apple Numbers ★ HOW IT WORKS ★ 1. Download and open the file in Excel, or upload it to Google Drive and open with Google Sheets. 2. On Setup, add your payment fees and categories. 3. Add your products and events, list what you pack, then log each sale. 4. See profit per event, best sellers and sell-through on the Dashboard. Works in any currency ($, £, €, C$, A$ and more): just change the currency symbol. ★ PLEASE NOTE ★ • This is a digital download. Nothing will be shipped. • If you collect sales tax, check your local rules. This is a business tool, not tax advice. • Because it's a digital file, returns aren't accepted, but if you have any trouble with the file, message me and I'll fix it or help you right away.
Free Monthly Budget Starter Kit

5 printable pages: a monthly budget sheet, a 12-month bill checklist and 3 savings-goal trackers. Free when you join the email list.

Get the free kit