Market Day Profit Tracker — Craft Fair Sales & Stock Spreadsheet

A colourful, modern workbook design with pastel result cards, clear yellow inputs and coordinated lilac calculation areas.

Market Day Profit Tracker helps creative business owners work through their own figures using editable spreadsheets and clear guidance.

• Cash + card reconciliation
• Sales, refunds + restocking
• Stock counts + damage costs
• Event expenses + break-even

What you receive

One ZIP containing one blank XLSX workbook, one fictional worked example XLSX workbook, an in-workbook Guide, a quick-start text file and license.

• 100 product rows
• 300 transaction lines
• 50 event expense rows
• 5 worksheet tabs

Designed for one event per workbook. Save a new copy for each market. Records sales and refunds by Cash/Card, reverses cost and stock for restocked refunds, and includes damaged/lost stock costs. Profit deducts goods sold, damage costs, entered expenses, actual card fees and entered labour. Break-even is an estimate based on your planned average price, unit cost and weighted fee rate; it excludes damage/loss. No automatic annual consolidation.

Event controls

Choose whether to include labour, and mark card payout and cash count pending or complete. Separate input, cash, card and stock statuses show unresolved differences. Enter a unique transaction-line ID for every sale and refund, then link each refund to a recorded sale in the same event. Duplicate IDs and refunds exceeding the linked sale’s quantity or value are flagged; invalid sales or missing required cost inputs withhold affected profit results.

Earlier-event refunds are outside this one-event workbook’s scope. Multiple partial money refunds for the same item must be combined into one refund line, with each refunded unit counted once. Save a fresh copy for each event.

Compatibility and use

Microsoft Excel desktop recommended. Standard .xlsx files with no macros or subscriptions. Software is not included. No hosted Google Sheets version is included. Use one currency of your choice; currency conversion, tax/VAT, bank feeds and automatic platform fee updates are not included. Fee and cost assumptions are entered by you. Calculation cells use sheet protection to reduce accidental edits; yellow input cells stay editable. Protection has no password. Save a backup and unprotect the sheet before sorting or customising; sort the full table. Instructions explain formula recovery using the supplied blank workbook. Results depend on complete, correct inputs. Screens show fictional examples, not promised business results.

Digital download only. No physical item. For your own personal and commercial business planning; digital files may not be resold or redistributed.