Review recorded market results, cancelled-event costs and stock differences for the chosen period.
Suggested for your taskOperations / connected records for an ordinary job
Craft Fair & Market Workbook
Plan the market. Compare the close-out.
Save event budgets and product forecasts before packing. Then compare the plan with recorded sales, refunds, fees, stock costs and event expenses. Preparation, physical returns and financial results stay distinct.
- Format
- Excel · .xlsx
- Inside
- 12 worksheets
- Included
- Clean file + example + guide
$10.90USD · one-time priceTaxes included where applicable.Explore the sheets Follow the real example
Check the capacity and fitWho it is for, supplied record limits and software requirements
Optional guideNeed help getting started?Choose where to begin. All listed files are included.
Add the complete product to your cart whenever you’re ready. Use this guide only if you’d like help choosing what to open first; your choices do not change the product or its price.
Guide step 1 of 4
What would you like to do?
Pick a useful task, or build your own selection.
Which sheets would you explore first?
Choose your starting points. The workbook keeps all its connected sheets and formulas; this does not remove or rebuild worksheets.
Nothing selected yet.
Set the reporting period, review date and a single currency for actual market records.
Suggested for your taskGive each market an ID, date, status, sales target and actual hours worked.
Suggested for your taskKeep one product reference for the stock and sales recorded at each event.
Suggested for your taskReconcile units taken with returns, damage and net sales. Keep the historical unit cost of this event.
Suggested for your taskRecord gross sales, refunds and actual selling fees separately for each event and product.
Suggested for your taskRecord actual market costs, including non-refundable costs for a cancelled event.
Suggested for your taskCompare net sales with fees, consumed stock, damage and event costs before reading profit per hour.
Suggested for your taskReview each product’s recorded sales and contribution across the selected period.
Suggested for your taskFollow stock-out, sales and close-out in order. Review differences before relying on profit.
Suggested for your taskBefore leaving, review incomplete tasks and packing. After the event, separately confirm equipment returns.
Suggested for your taskSave the forecast. Compare the recorded close-out.
Suggested for your taskWhich file would you open first?
Both files are included. Choose which one you would open first in a desktop spreadsheet application.
Your starting plan.
Your first file or method
Both XLSX files, all 12 connected sheets and the single included guide remain in the complete kit. Your selection identifies where to begin.
Read the complete setup guideThe complete product. Your starting choices do not change its contents or price.
Your choices help you understand the complete product. They do not alter its contents or price.
Both XLSX files, all 12 connected sheets and the single included guide remain in the complete kit. Your selection identifies where to begin.
Read the tasks, contents and file choices
Useful starting tasks
Give the market its own plan before close-out.. Use the included START_HERE.pdf guide to follow one complete task in a disposable example copy.
Choose my own starting points. Explore the contents and select only the parts you would use first.
Contents to explore
- Dashboard: Review recorded market results, cancelled-event costs and stock differences for the chosen period.
- Settings: Set the reporting period, review date and a single currency for actual market records.
- Events: Give each market an ID, date, status, sales target and actual hours worked.
- Products: Keep one product reference for the stock and sales recorded at each event.
- Stock: Reconcile units taken with returns, damage and net sales. Keep the historical unit cost of this event.
- Sales: Record gross sales, refunds and actual selling fees separately for each event and product.
- Expenses: Record actual market costs, including non-refundable costs for a cancelled event.
- Event Review: Compare net sales with fees, consumed stock, damage and event costs before reading profit per hour.
- Product Review: Review each product’s recorded sales and contribution across the selected period.
- Start: Follow stock-out, sales and close-out in order. Review differences before relying on profit.
- Market Prep: Before leaving, review incomplete tasks and packing. After the event, separately confirm equipment returns.
- Market plan: Save the forecast. Compare the recorded close-out.
Both files are included. Choose which one you would open first in a desktop spreadsheet application.
Explore the worked example: Fictional records show how the sheets work together. Save a disposable copy before trying a change. craft-market-example.xlsx
Start my own working copy: Open the clean workbook after reading the guide. Keep the original and save a copy for your own records. craft-market-clean.xlsx
Follow the complete first taskUse the included guide and a disposable example copy.
Your first useful session / Start with the example
Give the market its own plan before close-out.
Follow this one complete task before entering your own records. Keep the blank original and save a working copy.
Select the saved E-01 plan.
Market plan selects E-01. Its saved event budget is EUR 40 costs, 6 hours and a 5% selling fee. Forecast P-01 is 15 units at EUR 12, with EUR 4 unit cost. Changing event selection retrieves that event’s records.
Inspect Market planCompare forecast and records.
The supplied fictional plan gives EUR 71 after fees, stock and event costs. Recorded E-01 gives EUR 30 after actual sales, fees, stock, damage and event costs. Sales/expenses use the cut-off; stock/damage/hours reflect entered close-out.
Inspect Event ReviewChange the assumption, preserve history.
In a working copy, change planned price E104 to EUR 14. Planned result becomes EUR 99.50; recorded result remains EUR 30. Revert this disposable change. Reconcile stock physically before treating the event result as final.
Inspect Market plan
RECORDED WORKBOOK / FOLLOW EACH CHANGE
Follow a real workbook decision.
Recorded worksheet images, not an online editor. These fictional steps use a disposable copy of the supplied example. Every change is stated beside its result.
All 3 recorded steps are shown below.
STEP 01 / FICTIONAL WORKING COPY
Save quantities and price assumptions.
The supplied E-01 forecast expects 15 P-01 units at EUR 12, with EUR 4 unit cost. The saved event budget adds EUR 40 event costs, 6 hours and a 5% selling fee. Inputs are saved by ID, not reused when selection changes.
Inspect all 12 supplied sheetsScroll the real worksheet horizontally to read each column, or open its full-size view.
Loading the actual worksheet…
STEP 02 / FICTIONAL WORKING COPY
Compare with the complete event.
Planned sales EUR 180 minus EUR 9 fees, 60 stock and 40 event costs gives EUR 71. Recorded result is EUR 30 after damage too. Products without a forecast still remain in the recorded event result.
Inspect all 12 supplied sheetsScroll the real worksheet horizontally to read each column, or open its full-size view.
Loading the actual worksheet…
STEP 03 / FICTIONAL WORKING COPY
Change the plan without rewriting a sale.
In a disposable copy, change planned price to EUR 14. Planned result becomes EUR 99.50; recorded result remains EUR 30. Sales/expenses use the cut-off; stock, damage, returns and hours are undated close-out snapshots.
Inspect all 12 supplied sheetsScroll the real worksheet horizontally to read each column, or open its full-size view.
Loading the actual worksheet…
These images were produced from the actual example XLSX after the stated edits and local recalculation. The buttons change the recorded view; they do not run Excel or save your records. Start your own file with the included first-session supplement.
EVERY WORKSHEET / ACTUAL EXAMPLE FILE
See what you enter.
Understand what updates.
Inspect all 12 sheets. These are images of the delivered example, with fictional records. Open an image to read its full detail.
Actual example worksheet · Preview range A1:E39. Image only; entries are made in your downloaded workbook.
Dashboard
Review recorded market results, cancelled-event costs and stock differences for the chosen period.
- You enter
- No routine entries
- Calculated or supplied reference
- Linked review and navigation
Actual example worksheet · Preview range A1:D27. Image only; entries are made in your downloaded workbook.
Settings
Set the reporting period, review date and a single currency for actual market records.
- You enter
- Currency, review date and labelled period
- Calculated or supplied reference
- Visible settings check
Actual example worksheet · Preview range A1:H14. Image only; entries are made in your downloaded workbook.
Events
Give each market an ID, date, status, sales target and actual hours worked.
- You enter
- 60 rows: Event ID, Market / event, Event date, Status, Net sales target, Actual hours, Location / notes
- Calculated or supplied reference
- Input and link checks
Actual example worksheet · Preview range A1:F14. Image only; entries are made in your downloaded workbook.
Products
Keep one product reference for the stock and sales recorded at each event.
- You enter
- 100 rows: Product ID, Product, Current list price, Status, Category / notes
- Calculated or supplied reference
- Input and link checks
Actual example worksheet · Preview range A1:M14. Image only; entries are made in your downloaded workbook.
Stock
Reconcile units taken with returns, damage and net sales. Keep the historical unit cost of this event.
- You enter
- 150 rows: Stock ID, Event ID, Product ID, Units taken, Units returned, Units damaged, Actual unit cost, Notes
- Calculated or supplied reference
- Net sold units, Stock difference, Stock consumed cost, Damage cost
Actual example worksheet · Preview range A1:N14. Image only; entries are made in your downloaded workbook.
Sales
Record gross sales, refunds and actual selling fees separately for each event and product.
- You enter
- 300 rows: Sale ID, Event ID, Product ID, Actual date, Gross units sold, Units refunded, Gross receipts, Refunds paid, Actual selling fees, Receipt / notes
- Calculated or supplied reference
- Net revenue, Historical stock cost, Contribution
Actual example worksheet · Preview range A1:G14. Image only; entries are made in your downloaded workbook.
Expenses
Record actual market costs, including non-refundable costs for a cancelled event.
- You enter
- 200 rows: Expense ID, Event ID, Actual date, Category, Amount, Receipt / description
- Calculated or supplied reference
- Input and link checks
Actual example worksheet · Preview range A1:J19. Image only; entries are made in your downloaded workbook.
Event Review
Compare net sales with fees, consumed stock, damage and event costs before reading profit per hour.
- You enter
- No routine entries; review the source records
- Calculated or supplied reference
- Net sales, Selling fees, Stock consumed, Damage, Expenses, Actual profit, Profit / hour, Stock differences
Actual example worksheet · Preview range A1:G19. Image only; entries are made in your downloaded workbook.
Product Review
Review each product’s recorded sales and contribution across the selected period.
- You enter
- No routine entries; review the source records
- Calculated or supplied reference
- Net units sold, Net revenue, Selling fees, Stock consumed, Contribution
Actual example worksheet · Preview range A1:D40. Image only; entries are made in your downloaded workbook.
Start
Start with event preparation, then follow stock, sales, expenses and close-out.
- You enter
- Choose the right register using the supplied internal links. Set the explicit review date before evaluating preparation.
- Calculated or supplied reference
- Instructions, capacity and links to all eleven sheets. Start is a supplied reference, not an editable result.
Actual example worksheet · Preview range A1:P19. Image only; entries are made in your downloaded workbook.
Market Prep
Prepare the stand and bring the equipment back.
- You enter
- Prep ID, event ID, task or material, description, owner, due date, needed/packed/returned quantities, return policy and manual confirmation.
- Calculated or supplied reference
- Input warnings, preparation readiness, overdue work, equipment return checks and the selected event summary.
Actual example worksheet · Preview range A1:H27. Image only; entries are made in your downloaded workbook.
Market plan
Save the forecast. Compare the recorded close-out.
- You enter
- Event selector, 60 saved event budgets and 400 product forecasts below the report.
- Calculated or supplied reference
- Planned versus recorded result, event-cost coverage and missing forecast/source warnings.
Craft Fair & Market Workbook / Version 1.2
Your own working copy.
Clean workbook, separate example and one START_HERE.pdf guide covering setup, practical limits and the internal-use license.
$10.90USD · One-time purchaseTaxes included where applicable.
Desktop spreadsheet software required; it is not included. Native Excel compatibility is still awaiting verification.
Digital download. Review availability and the final total in your cart.
Follow the supplied fictional exampleRead the inputs and the result together
From the supplied fictional example
Close one market without losing the refunds.
The completed fictional market has 10 net units sold, a zero stock difference and a 30 result after selling fees, consumed stock, damage and expenses. A separate cancelled event retains its 15 actual cost.
- E-01 / stock ST-01
- 20 taken − 9 returned − 1 damaged
- Sales SL-01
- 12 sold − 2 refunded; EUR 144 received − 24 refunded
- Recorded costs / actual hours
- EUR 6 fees + 40 stock + 4 damage + 40 expenses; 6 hours
- Completed market result
- 30.00
- Actual event hours / result per hour
- 6 / 5.00
- Period result including cancelled-event cost
- 15.00
From setup to a regular review
How you use it.
Open the 5-step setup and review routineInputs, calculations and the decision each step supports
- 01
Save the assumptions with the event
You enterCreate an event budget and a product forecast for each chosen product. Enter deliberate zero where a known amount is zero.
CalculatedMarket plan sums product forecasts and subtracts event costs once. Recorded sources stay independent; invalid records block recorded outputs.
Your next stepReview the planned result and coverage. After the day, reconcile stock and compare against the recorded result, including products without forecasts.
- 02
Prepare the stand
You enterCreate a valid event, then link each Market Prep task or material to its Event ID. Enter an owner, due date, manual confirmation and the applicable packing quantities.
CalculatedThe E-01 example has three preparation items: two Ready and one Overdue. Packing all 20 paper bags makes that third item ready, provided its confirmation remains valid.
Your next stepReview every warning and pending action. Readiness describes the list you entered; it does not check a venue or confirm a task for you.
- 03
Record the stock and actual sales
You enterUse one Stock row per event/product. Record units taken, returned and damaged with historical cost. Sales separately records gross units, refunds, receipts and selling fees.
CalculatedST-01 takes 20 units, returns nine and records one damaged. SL-01 sells 12 and refunds two: ten net units sold, EUR 120 net sales and zero stock difference.
Your next stepResolve stock differences before relying on profit. Equipment quantities in Market Prep do not alter sale stock.
- 04
Review the actual result
You enterRecord actual event expenses and hours. Keep a cancelled event and any non-refundable costs in the record.
CalculatedE-01 has net sales 120 less fees 6, stock consumed 40, damage 4 and expenses 40: profit 30, or 5 per actual hour. E-02 retains cancelled cost 15, giving dashboard period profit 15.
Your next stepCompare events on recorded results. Product contribution and event profit answer different questions; neither is a forecast of earnings.
- 05
Confirm the equipment return
You enterAfter the event, update Returned qty in Market Prep for each material whose Return expected is Yes. Keep tasks and consumable supplies separate.
CalculatedTwo of three packed display trays are returned in the example, so Return state says Check return. Recording the third tray clears only that check.
Your next stepPhysically confirm the return and save your workbook. The return check does not book an expense, change financial stock or synchronise Inventory.
12 sheets. Inspect each one.Inputs, outputs and when to use every worksheet
DashboardOpen sheet details
Editable inputs
- No routine entries
Calculated or reference
- Linked review and navigation
Review recorded market results, cancelled-event costs and stock differences for the chosen period.
Inspect the actual Dashboard sheetSettingsOpen sheet details
Editable inputs
- Currency, review date and labelled period
Calculated or reference
- Visible settings check
Set the reporting period, review date and a single currency for actual market records.
Inspect the actual Settings sheetEventsOpen sheet details
Editable inputs
- 60 rows: Event ID, Market / event, Event date, Status, Net sales target, Actual hours, Location / notes
Calculated or reference
- Input and link checks
Give each market an ID, date, status, sales target and actual hours worked.
Inspect the actual Events sheetProductsOpen sheet details
Editable inputs
- 100 rows: Product ID, Product, Current list price, Status, Category / notes
Calculated or reference
- Input and link checks
Keep one product reference for the stock and sales recorded at each event.
Inspect the actual Products sheetStockOpen sheet details
Editable inputs
- 150 rows: Stock ID, Event ID, Product ID, Units taken, Units returned, Units damaged, Actual unit cost, Notes
Calculated or reference
- Net sold units, Stock difference, Stock consumed cost, Damage cost
Reconcile units taken with returns, damage and net sales. Keep the historical unit cost of this event.
Inspect the actual Stock sheetSalesOpen sheet details
Editable inputs
- 300 rows: Sale ID, Event ID, Product ID, Actual date, Gross units sold, Units refunded, Gross receipts, Refunds paid, Actual selling fees, Receipt / notes
Calculated or reference
- Net revenue, Historical stock cost, Contribution
Record gross sales, refunds and actual selling fees separately for each event and product.
Inspect the actual Sales sheetExpensesOpen sheet details
Editable inputs
- 200 rows: Expense ID, Event ID, Actual date, Category, Amount, Receipt / description
Calculated or reference
- Input and link checks
Record actual market costs, including non-refundable costs for a cancelled event.
Inspect the actual Expenses sheetEvent ReviewOpen sheet details
Editable inputs
- No routine entries; review the source records
Calculated or reference
- Net sales, Selling fees, Stock consumed, Damage, Expenses, Actual profit, Profit / hour, Stock differences
Compare net sales with fees, consumed stock, damage and event costs before reading profit per hour.
Inspect the actual Event Review sheetProduct ReviewOpen sheet details
Editable inputs
- No routine entries; review the source records
Calculated or reference
- Net units sold, Net revenue, Selling fees, Stock consumed, Contribution
Review each product’s recorded sales and contribution across the selected period.
Inspect the actual Product Review sheetStartOpen sheet details
Editable inputs
- No routine entries
Calculated or reference
- Instructions and practical limits
Follow stock-out, sales and close-out in order. Review differences before relying on profit.
Inspect the actual Start sheetMarket PrepOpen sheet details
Editable inputs
- Prep ID, event ID, task or material, description, owner, due date, needed/packed/returned quantities, return policy and manual confirmation.
Calculated or reference
- Input warnings, preparation readiness, overdue work, equipment return checks and the selected event summary.
Before leaving, review incomplete tasks and packing. After the event, separately confirm equipment returns.
Inspect the actual Market Prep sheetMarket planOpen sheet details
Editable inputs
- Selected Event ID; 60 event budgets with costs, hours and fee rate.
- 400 product forecasts with stable Plan ID/event/product, whole units, price/cost snapshots and note.
Calculated or reference
- Planned sales/fees/stock/event costs/result; recorded result and differences.
- Event-cost coverage at fixed mix, source state and actual products missing a forecast.
Prepare assumptions before a market, then reconcile and compare the close-out. Stock/damage/hours are undated manual snapshots.
Inspect the actual Market plan sheetCompare with a manual starting pointWhat the connected workbook adds
| What is included | A manual list | Craft Fair & Market Workbook 1.2 |
|---|---|---|
| Records | Separate notes | 12 connected XLSX sheets with saved records, planning views and checks |
| Calculation | Manual arithmetic | Connect stock taken, returned and damaged to actual sales, refunds and event expenses. Close the stock loop before comparing the result from one market to another. |
Files, capacities and practical limitsRead these before choosing your working copy
The download
Files with a purpose.
craft-market-clean.xlsx
12 connected sheets with blank records for your own use.
craft-market-example.xlsx
The same 12 sheets with fictional worked records. START_HERE.pdf explains the starting task and optional market-planning steps.
START_HERE.pdf
Your single guide to setup, the first useful task, file recovery, practical limits and license.
English labels and guides. One currency, explicit dates and stable text IDs.
Before you choose
Fit and practical limits.
- A maker taking finished products to craft fairs
- a small seller comparing market weekends.
Understand the boundaries.
- 60 events; 100 products; 150 event/product stock records; 300 sales records; 200 expense records; 150 preparation records.
- One currency. Manual receipts and historical costs; no POS, barcode, tax, payment collection, accounting or marketplace integration.
- Refunded units are treated as reusable stock. Record non-reusable units in damaged stock. Review stock differences before trusting profit.
- A returned unsold unit is not an expense; current list price never reprices a recorded sale. Event hours are manually entered actual hours.
- Equipment and supplies in Market Prep do not change sale stock or profit. Readiness needs manual confirmation; there are no automatic venue requirements or reminders.
- Native Excel verification pending.
- Planned sales assume entered quantities sell at entered prices, without refunds or damage. Event-cost coverage holds the planned mix constant. Sales/expenses use a date cut-off; stock, returns, damage and hours are undated entered close-out snapshots, not a historical reconstruction.
Desktop spreadsheet software is separate. Native Excel verification remains pending; Google Sheets and Numbers support has not been established.
Questions about this workbook
The details that affect your choice.
Can I compare a forecast with what the market earned?
Yes. Market plan saves budgets by Event ID and forecasts by event/product with manual price and cost snapshots. Editing those assumptions or current Products prices cannot reprice historical Sales. Recorded results include products without forecasts. Sales/expenses use the cut-off; stock, damage, returns and hours are entered undated close-out snapshots. Missing plans are not zero; fix source and plan warnings separately.
How do I know what to edit?
Blue cells accept records. Grey cells contain formulas. Begin with the separate fictional example and follow START_HERE.pdf. Each register has visible input checks.
Can I add unlimited rows?
No. Capacities are fixed and listed sheet by sheet. Adding rows requires extending formulas, validation and review ranges; it is not a supported automatic expansion.
Does the file send my records anywhere?
No macros or external connections are supplied. Your spreadsheet application and cloud-storage settings are separate.