Craft Fair Profit & Stock Tracker UK | Market Stall Spreadsheet

See what each craft fair leaves after costs—not just what went through the till. This UK market stall spreadsheet combines event profit tracking, a stock list, sales log and dashboard for comparing craft fairs.

Planning your first event? Try the free craft fair break-even calculator first.

Record gross cash and card takings, pitch fees, travel and other event expenses. Add setup, selling and packdown hours to compare profit per hour. Log item quantities and cost snapshots by event: sales deduct stock and goods costs feed into event profit.

Included: sample and blank XLSX workbooks; Dashboard, Events, Stock, Sales, Settings and How to use tabs; capacity for 100 events, 100 stock products and 500 sales lines; editable mileage allowance, per-event card fees, stock deductions, status checks and GBP formatting.

The dashboard totals all 100 event rows and highlights the best and worst events by profit per hour. Its simple chart covers the first ten event rows. Status warnings flag duplicate IDs, negative stock, missing sales details and differences between entered takings and logged sales. These checks depend on accurate manual entries.

Compatibility: tested in LibreOffice; intended for Excel and Google Sheets XLSX import, not directly tested in either. Chart layout, validation and protection may vary. No macros, add-ins or external data connections. Formula protection has no password; an app/account may be needed.

Built with AI assistance and checked with recalculation and hand calculations. Single-currency planning tool only: no till integration, formal inventory valuation, returns system or VAT return. Profit excludes owner wages, income tax and sales VAT. No promised profitable events. Digital files only. See rights/support information below.

UK consumers normally have a 14-day cancellation right. If you expressly consent to immediate digital supply and acknowledge losing that right, it ends when supply begins. This does not affect statutory rights if content is faulty, not as described or otherwise fails legal standards, including repair/replacement and price reduction/refund where applicable. Contact the seller using the store contact details for help. No blanket “no refunds” policy applies.