You drove home from the show, counted the cash box twice, and still could not say whether the day actually made money. The Craft Fair & Vendor Show Tracker fixes that: one workbook for the whole season — the shows you book, the stock you bring, every sale, every cost down to the miles you drove — and a straight answer, per show, to “was that worth doing?”

It starts with the season you are planning. Book the show and its booth fee, list what you are making and what you are bringing, then log sales as they happen. The workbook does the rest: inventory counts itself down, each show’s profit builds itself from your sales and costs, and the season summary is always current.

The 6 tabs:
• Show Schedule — every show in one place: date, event, location, booth fee, hours, status (Booked, Applied, Waitlisted, Done, Cancelled) and the notes you will thank yourself for next year.
• Inventory & Pricing — what you made, what you brought, what each item costs you and what you charge. Qty Sold, Remaining and Sell-Through % calculate themselves from the Sales Log.
• Sales Log — one row per sale: date, show, item, quantity, price, payment type. Log it on your phone at the show or type it up afterwards; every total in the workbook reads from here.
• Profit Calculator — type a show’s name once and the row fills itself in: gross sales, booth fee, travel & mileage, supplies, other costs, NET profit and margin %. This is the tab that tells you which shows to rebook.
• Expenses & Mileage — every non-booth cost by show and category, plus your miles, valued automatically at an editable rate (shipped at $0.70/mile, the 2025 IRS standard rate). It doubles as your tax-season mileage log.
• Goals & Summary — the season on one screen: gross, costs, net, average net per show, best show, best-selling item, miles, and progress against the gross and net goals you set.

Nothing is ever counted twice. Booth fees live on the Show Schedule only, and the Profit Calculator pulls them from there — the Expenses tab deliberately cannot double-count them. Costs are pulled by show and category, sales are pulled by show and item, and the one habit the system asks of you is typing names consistently, which the Quick Start guide makes painless.

The example is a real-shaped season, not a fantasy. The filled example is a fictional candle-and-soap seller’s 3-show spring: $3,776 gross on 342 items, $617.80 of show costs (booth fees, 138 miles of travel, supplies, food, parking), and $3,158.20 of net profit — with the strongest show netting $1,238.90, the weakest still clearing $860.90, and the best seller turning out to be the wax melts, not the candles. Every number is hand-verifiable from the Sales Log up.

Selling in more places? The rest of the shelf:
• Online card sales instead of a booth: the TCG Reseller Profit Tracker ($14.99) — inventory, grading costs, platform fees and per-card profit.
• Quoting hands-on work: the Job Costing & Quote System ($24.99) — labor, materials, markup and margin on every quote.
• The jobs themselves, kept simple: the Handyman Job Tracker Mini ($12.99).

You receive 3 files:
1. The tracker, BLANK — all 6 tabs with every formula built in, ready for your season.
2. The tracker, EXAMPLE — the complete fictional 3-show season filled in, so you can see exactly how everything connects.
3. A Quick Start Guide (PDF) — setup in about 5 minutes, every tab explained, and a walkthrough of the example.

Good to know:
• Works in Microsoft Excel and Google Sheets. Yellow cells are for typing, grey cells are formulas — that’s the only rule.
• No subscriptions, no macros, no add-ons. Buy once, use it every season.
• Instant download — files are available as soon as you check out.
• No TODAY() tricks: nothing in this workbook guesses what today’s date is or changes a number because a day passed.

About how this was made: This spreadsheet was created with the help of AI tools, then independently formula-tested (157 automated checks recalculated and verified, including blank and zero-value cases) and reviewed before listing — the same standard as every RemodelLedger product. The example seller, shows and figures are fictional.

vendor booth tracker

Craft Fair Tracker Spreadsheet | Vendor Show Sales Log, Inventory and Per-Show Profit Calculator | Excel and Google Sheets