Craft Fair Stock and Cash Tracker, Market Vendor XLSX Workbook

Track stock and closing cash for one craft fair or vendor market. Enter your products, sales and refunds, then compare expected stock and cash with your actual counts.

Includes a blank XLSX, a clearly fictional example, README and license. Five sheets: Closing, Stock, Sales, Refunds and Stock count. Limits: one event per copy, 30 products, 100 sale lines and 30 refund lines. Save another copy for your next event.

Refunds and physically returned stock stay separate. Cash, card and other receipts are recorded separately. Mixed payments are supported by allocating units once. Blank required inputs stay unknown; explicit zero counts are valid. Invalid quantities, duplicate/unmatched IDs, oversold stock and differences are flagged.

Manual entry. One currency with two decimal places. No POS sync, automatic fees, profit or tax calculation. Tested in LibreOffice Calc; Microsoft Excel, Google Sheets and physical printing are unverified. Stock count sheet included, with a one-page US Letter layout checked in LibreOffice Calc. Check your print preview before printing. Digital download only, no physical product. Personal or business use for your own records under the included license; no template redistribution.

Created with AI assistance.