A craft fair planner spreadsheet that shows which fairs really pay
Fairstall is a craft fair planner spreadsheet for Microsoft Excel, made for makers who sell at holiday markets, church bazaars, school craft fairs and pop-up shops. You list the fairs you are thinking about, price your products, log what sells, and Fairstall works out what each booth really earned you. Not just sales. Profit, after the cost of the goods you sold, booth and application fees, mileage, card fees, sales tax and every other cost.
Most vendors finish a season with a cash box, a pile of receipts and a feeling. Fairstall gives you the numbers instead: profit per fair, profit per hour, average sale, best sellers and a clear verdict on which fairs to book again next year.
Who it is for
- Makers of candles, soap, ornaments, wreaths, knits, jewelry, pottery, prints and other handmade gifts
- Vendors doing a busy Christmas market season, from three fairs to forty
- Small craft businesses who want to price properly and stop guessing which shows are worth the fee
- Beginners: you type in the white cells and the workbook does the math
What Fairstall does
Plan the season
The Fairs tab holds up to 40 fairs with dates, venue, status, booth and application fees, application deadlines and fee due dates. Each fair gets a countdown and a next-deadline note that turns pink a week out and burgundy if a booth fee is overdue. The Season Calendar shows three months of fair days and open deadlines, with Christmas Day marked, and the Dashboard counts down the days to Christmas.
Decide before you pay to apply
The Scorecard rates each fair from 1 to 5 on crowd size, shopper fit, booth cost, travel, reputation and promotion, using weights you can change. It gives a Go, Maybe or Pass verdict, the sales you need to break even, and your projected profit at the sales you expect.
Price your products
The Products tab is a pricing calculator for up to 150 products. Enter materials, packaging and labor minutes, and it suggests a wholesale and a retail price from your hourly rate, overhead and multipliers. Use the suggestion or type your own price. It warns you when a price is below your full cost and tracks stock left after every fair.
Log sales and stock at each fair
The Sales log takes 2,000 lines: pick the fair and the product, type the quantity, and the price fills in. Log each sale or one line per product at the end of the day. Inventory shows what you packed, what sold, what should come home and the sell-through for each product, with a bring more or bring fewer note for next time.
See the true profit
Results works out gross sales, sales tax to set aside, net sales, cost of goods, fees, mileage, card fees, other costs, net profit, margin, profit per hour, average sale, units per customer and the share of booth visitors who bought. Every fair gets a rank and a verdict: Book again, Maybe or Skip.
Features
- Dashboard with 10 KPI cards, 4 charts, upcoming deadlines and a Needs attention list
- One currency setting that every money label follows, plus miles or km
- Card fee (percent plus fixed fee), sales tax with a per-fair rate, and prices with or without tax
- Best Sellers tab: top 15 products, sales by category, price tier and payment method
- Packing checklist with 59 booth essentials, six fair columns and progress for each
- Cash Box tab: starting float, cash taken, counted at close and an over / short check, plus a cash counter
- Fair Report: a one-page recap of any fair you pick, ready to print
- Dropdowns read from your own editable lists, formulas are locked (no password), and there are no macros
What is included
- Fairstall Craft Fair Vendor Planner (Excel .xlsx), 15 tabs, clean and ready for your season
- Fairstall User Guide (Word .docx), 17 pages with screenshots, tips, troubleshooting and FAQ
How it works
- Set your currency, card fee, mileage rate and sales tax on Settings.
- Add your fairs with fees and deadlines, and rate new ones on the Scorecard.
- Enter your products and costs. Use the suggested prices or your own.
- Before each fair, tick the packing list, log what you packed and count your float.
- After each fair, log sales and expenses, add customers and hours, and check the Dashboard.
File format and software
Fairstall is an .xlsx workbook for Microsoft Excel 2010 or later on Windows, Excel 2016 or later on Mac, and Microsoft 365 on desktop. It uses classic Excel formulas and no macros. The user guide is a Word .docx file. This is an instant digital download. No physical item will be shipped.
Customizing
Rename fair statuses, product categories, payment methods, expense and packing categories on the Settings tab and every dropdown updates. Change the scorecard criteria and weights, the price tiers, your target profit per hour and the first month of the Season Calendar. Sheets are protected without a password, so you can unprotect them if you want to redesign a layout.
Use cases
- A candle maker comparing a pricey two-day Christmas market with a small church bazaar on profit per hour
- A knitter deciding whether a juried show is worth the application fee before the deadline
- A jewelry seller checking which price tier sells best at school craft fairs
- A soap maker packing for three December markets in one week without forgetting the card reader
- Any vendor collecting mileage and booth fees in one place for tax time
Craft fair planner FAQ
Does it work on a Mac?
Yes, in Excel 2016 or later for Mac and in Microsoft 365.
Can I use my own currency?
Yes. Pick or type a currency symbol on Settings and every money label follows it. You can switch distance to km too.
Do I need to log every single sale?
No. One line per product per fair with the total quantity works just as well.
Does it connect to my card reader or online shop?
No. Fairstall does not connect to other apps. You type or paste your sales in.
How many fairs and products does it hold?
40 fairs, 150 products, 2,000 sales lines, 600 inventory lines and 400 expenses.
Can I reuse it next year?
Yes. Keep your original download as a clean copy and start a fresh file for each season.
Can I share it with another vendor?
No. The license covers personal use and your own craft or small business. Each business needs its own copy.












Reviews
There are no reviews yet.