Free Craft Fair Break-Even Calculator UK | XLSX Spreadsheet
How many sales will cover your next craft fair?
This free UK craft fair break-even calculator helps market stallholders include pitch fees, travel, parking, goods costs and card fees before booking an event.
Enter your own costs, typical transaction value, matching goods cost, card-paid share and fee assumptions. See the estimated whole transactions needed to break even, profit at your entered sales and profit per hour across setup, selling and packdown. One sale means one typical payment transaction, not necessarily one item.
Included: sample and blank XLSX files, Calculator and How to use tabs, editable inputs and GBP formatting. No macros, add-ins, subscription or external data links are required by the files. Downloadable files only; no physical item.
Example, not actual trading results: £55 in fixed costs and £6.80 contribution per transaction means nine transactions to cover those costs. Owner pay and tax are separate considerations.
Compatibility: tested in LibreOffice Calc. Intended for Excel and Google Sheets XLSX import, but not directly tested in either; styling, validation and protection may change. A spreadsheet app or account may be needed. Formula protection has no password.
Important: built with AI assistance and checked through LibreOffice recalculation and hand-calculated tests. Planning estimates only, before owner wages, income tax and sales VAT. The editable mileage allowance is an assumption, not tax advice. Check your own card rates and costs. No guarantee of profit.
No paid workbook is needed to use this free tool. Your statutory rights are unaffected.