Why can craft-fair stock, sales and cash disagree?
Stock movement and payments answer different questions. Record what sold, how it was paid, and any non-sale stock changes separately. Inspect the actual free workbook below before choosing the larger closeout template.
Try the real free sample
Read-only excerpt from the actual free XLSX. Empty cells stay empty; formulas are not recalculated on this page. Download the sample to edit it.
Closeout · sample excerpt
| Craft Market Closeout | ||||||
| Currency | USD | One currency. No conversion. | ||||
| Rows needing input | 0 | Fill every yellow numeric cell on used rows; use 0 for none. | ||||
| Stock count differences | 2 | Positive stock difference = more counted than expected. | ||||
| Recorded sales after discounts / refunds | 136 | |||||
| Recorded net payments | 132 | |||||
| Payment difference: payments − sales | -4 | Zero means totals agree; not proof every sale was recorded. | ||||
| Direct event costs | 45 |
Stock · sample excerpt
| Stock closeout | ||||||
| 5 products. Yellow cells: enter data. Grey cells: formulas. | ||||||
| Returns = units back in sellable stock. Put money refunds in Refunds. | ||||||
| Sold = gross units sold, including a resold return. Damage is removed stock. | ||||||
| SKU | Product | Opening units | Added units | Sold units | Sellable returns | Damaged units |
| BK-01 | Bookmarks | 20 | 5 | 12 | 1 | 1 |
| LP-02 | Linen pouches | 10 | 0 | 4 | 0 | 0 |
| GS-03 | Gift sets | 6 | 0 | 0 | 0 | 0 |
When the full edition fits
60-product workbook, refunds and stock/payment/cash differences; a worked closeout rather than just a stock list.
Check its limits
No POS, live inventory sync, certified profit/tax calculation or guaranteed discrepancy detection.
View full edition · $3.99 USDQuestions before choosing
What is free here?
The actual existing sample shown above. It is not the full paid edition.
What do I get from the full edition?
60-product workbook, refunds and stock/payment/cash differences; a worked closeout rather than just a stock list.
Why not use a free alternative or a chatbot?
Craftybase free craft-show inventory sheet, Square inventory for eligible buyers, or paper logs. A chatbot can help you make your own version. Choose this only if the existing file format, worked example or focused workflow is worth the listed price to you.
What should I check before choosing?
No POS, live inventory sync, certified profit/tax calculation or guaranteed discrepancy detection.
Do I need to provide bank details here?
No. This hub has no checkout or payment form. Product purchases happen on Payhip. Never email passwords, OTPs or bank details to support.
For the same kind of task
What this preview proves
These are actual existing sample files, not testimonials or customer results. Creation used AI assistance. Independent customer outcomes, physical print quality and sales results are not established by showing this sample.