Craft Fair Vendor Profit, Inventory & Event Tracker

Stop guessing whether a busy craft fair was actually profitable.

This Excel workbook is built for handmade sellers, farmers market vendors, pop-up shops, festival vendors, and event-based small businesses. It combines event planning, product sales, inventory movement, payment fees, labor, travel, and true event profit in one organized file.

WHAT IT CALCULATES

• Gross sales by event and product

• Discounts, refunds, and payment fees

• Product cost for sold, sampled, and damaged units

• Booth fees, mileage, travel, labor, and other event costs

• Event profit and profit margin

• Break-even sales estimate

• Average order value

• Product sell-through rate

• Current inventory and reorder quantity

• Business-level event and product dashboard

SIX INCLUDED WORKSHEETS

1. Start Here

2. Products & Settings

3. Event Planner

4. Sales & Inventory

5. Event Profit

6. Dashboard

CAPACITY

• 50 products

• 30 events

• 150 product-by-event sales entries

• Fictional sample data demonstrates how the formulas work

Yellow cells are inputs. Blue cells calculate automatically. Green highlights positive results and red flags losses or low inventory.

WHAT YOU RECEIVE

One Microsoft Excel .xlsx workbook as an instant digital download. No physical product is shipped. Microsoft Excel is recommended.

This is a recordkeeping and arithmetic tool, not tax, accounting, legal, inventory-valuation, or financial advice. Results depend on buyer-entered information and do not guarantee sales, attendance, or profit.

LICENSE

For one buyer's own business use. The workbook may not be resold, shared, redistributed, sublicensed, or offered as a competing template.