PRACTICAL GUIDE · CRAFT FAIRS

A busy market is not automatically a profitable event.

Gross sales can make an event look successful while booth, travel, lodging, payment fees and product cost absorb most of the revenue. A useful event record connects sales to inventory and assigns every direct event cost before calculating profit and return.

Practical methodReviewed 17 August 2026Excel + Google Sheets

Core takeaway

Record stock brought and sold, capture every event cost, calculate profit after COGS and compare completed events with the same ROI method.

1. Create the event before loading inventory

Assign an event ID and record date, location, status, booth fee, travel, lodging and other fixed costs. The same ID should appear on every sale from that market.

2. Track units brought, sold and remaining

Use SKU-level starting stock and event sales to calculate units sold and sell-through. Revenue without units cannot explain what inventory mix worked.

3. Calculate profit after product and event costs

Subtract cost of goods sold, payment fees and fixed event costs from revenue. Keep tax and owner labor assumptions explicit if you include them in the analysis.

4. Compare completed events with one ROI definition

Define ROI consistently, such as event profit divided by direct event operating costs. Use it with absolute profit and sell-through; one metric alone can favor small or large events unfairly.

Educational organization and planning content only. It does not replace tax, legal, accounting, financial or technical advice where applicable.

WORKFLOW CHECKLIST

The complete routine in six steps.

  1. 01Assign an event ID
  2. 02Record all fixed costs
  3. 03Load SKU-level starting stock
  4. 04Log every sale
  5. 05Subtract COGS and payment fees
  6. 06Compare profit, sell-through and ROI

APPLY THE METHOD

Use a workbook that already connects the steps.

The template turns this method into editable inputs, checks and summaries with realistic example rows.

Craft Fair Sales, Inventory and Event ROI

Craft Fair Sales, Inventory and Event ROI: real dashboard

FREQUENTLY ASKED QUESTIONS

Before you begin.

What should count as an event cost?

Include costs caused by attending the event, such as booth, travel, lodging and event-specific services. Keep product cost and payment fees visible as separate components.

Is a high ROI always the best event?

No. A small event can have high ROI and low absolute profit. Review profit, ROI, sell-through, time and strategic value together.

Should labor be included?

You can add an internal labor assumption for planning. Document the method and verify employment or tax treatment separately.