Craft Fair & Christmas Market Seller Kit Google Sheets, Market Stall Sales Tracker, Stock & Inventory, Pricing Calculator & Packing List for Makers

🎄 After a busy craft fair, most makers know what was in the cash tin but not what they actually made once the pitch fee, travel, card fees and the cost of their stock come out. So it is hard to say which fairs are worth booking again. This Google Sheet works it out for you. Log each sale on your phone as it happens (pick the item, type how many) and it totals every market: takings, stock cost, card fees, profit and profit per hour. Your stock count goes down as you sell, and anything running low is flagged to make before the next one. 📊 WHAT'S INSIDE (7 tabs) • Markets — one row per fair: date, pitch fee, hours, travel. Takings, stock cost, card fees, profit, profit per hour and items sold fill themselves, plus Crowd and Go again? to note while you still remember • Sales — one row per sale. Pick the market and the item and type the quantity; the price comes from your stock list, or type a deal price for bundles. Cash, card or other • Stock — what you made, what it cost, its price, how many have sold and how many are left, with In stock / Make more / Sold out status and the margin on every item • Pricing — materials, packaging and your making time, times your markup, gives a suggested price, then shows what is left after card fees and paying yourself • Packing List — tick boxes for display, money, stock, paperwork and comfort, with a packed count • Dashboard — takings, profit, items sold, best market by profit per hour, best seller, cash vs card split, what to make, and charts of profit by market and items sold • Start Here — set up in five minutes, with tips for using it on the day ⚙️ HOW IT WORKS 1. Open your link and click "Make a copy" 2. On Stock, list what you make with its cost and price 3. On Markets, add each fair you've booked with the pitch fee and hours 4. On the day, keep the Sales tab open in the Google Sheets app and add a row per sale 🏷️ PERFECT FOR • Makers selling at Christmas markets, craft fairs and pop-ups • Candle, jewellery, card, crochet and gift sellers deciding which fairs to book again • Anyone pricing handmade items who wants to be paid for their time • New stallholders doing their first market season 💻 FORMAT & ACCESS • Made for Google Sheets — works on phone, tablet & desktop • Money cells have no currency sign, so it works in £, $ or € • Pure formulas: no add-ons, no scripts, no permissions to grant • Delivered as a private "Make a Copy" link — one click and it's yours ⚡ INSTANT ACCESS — Your template link is available immediately after purchase. No physical item will be shipped. 📌 Give each market a unique name, as Sales rows are matched to markets by name. Card fees use the percentage you set on the Pricing tab, so check your card reader's rate. No signal at the venue? Make the file available offline in the Sheets app before you go. This is a digital product; all sales are final.