
Craft Fair Stock Reconciliation Workbook
Craft Fair Inventory Spreadsheet, Event Stock and SKU Variant Tracker, Taken Returned Sold Reconciliation, Market Comparison
- Organize products and variants
- Reconcile taken, returned and sold
- Compare completed market events
- Follow a separate worked example
What you get
- craft-fair-stock-reconciliation.xlsxExcel workbook · 111 KB
Know what you packed, what came home and what needs a recount. This craft fair inventory spreadsheet organizes handmade product variants and reconciles stock after autumn markets, holiday fairs and year-round events.
You receive
One offline .xlsx workbook with seven worksheets: Start Here, Products, Events, Event Stock, Event Comparison, SKU Review and Worked Example. Includes room for 100 product variants, 24 events and 500 event-stock lines. Each event-stock line tracks one event and SKU combination: taken, added during the event, returned, sold and other out (such as damaged stock or samples). The calculated difference flags stock that does not reconcile.
Useful details
Event and SKU dropdowns, missing-entry and duplicate flags, unit totals, sell-through comparisons and a separate fictional example with balanced, mismatched and unfinished counts. Event and SKU summaries withhold totals until their records are complete and balanced. Enter zero only for a confirmed count; leave an unknown count blank. Open events stay out of completed comparisons. Written setup and closing instructions are inside the workbook.
Compatibility and scope
For desktop Excel or LibreOffice Calc with .xlsx formula and dropdown support. No macros, online account or Google login required. All counts and event statuses are entered manually. Formulas cover the prepared rows and do not expand automatically. Designed for screen use; print selected rows as needed. No PDF, physical product, mobile app, barcode scanner, marketplace sync, transaction ledger or automatic stock-on-hand balance is included. Records units rather than revenue, costs or taxes. Recordkeeping only; not tax, legal or financial advice.
Designed by seller. Designed by OEFR Digital with AI assistance. Use for your own craft business recordkeeping; do not redistribute or resell the workbook.
Designed by OEFR Digital with AI assistance.
