Home/Spreadsheets/Craft & Fiber/Bead and Jewelry Supply Inventory Spreadsheet
Bead and Jewelry Supply Inventory Spreadsheet
A bead and findings inventory spreadsheet for jewelry makers: track your stash, see what needs reordering, and cost every piece you make from your own inventory. It opens in Microsoft Excel, has no macros and nothing to install, and is yours to reuse as often as you like.
What you get
- Dashboard tiles: materials tracked, stock value, low or out of stock, open purchase orders, spend logged and designs costed
- Master inventory with supplier, SKU, bin location, unit cost, quantity on hand and your reorder point
- Product costing: pick a Material ID, enter how much one piece uses, and the material cost fills in
- Purchase log from Ordered to Received, with a low-stock queue that builds itself
- Pricing and margin from your labour rate, Etsy fees, payment processing and target margin
- Opens in Excel
$16.99one-time, no subscription
Buy on Etsy
Instant digital download · one-time purchase · no subscription
What it does
- Dashboard tiles: materials tracked, stock value, low or out of stock, open purchase orders, spend logged and designs costed
- Master inventory with supplier, SKU, bin location, unit cost, quantity on hand and your reorder point
- Product costing: pick a Material ID, enter how much one piece uses, and the material cost fills in
- Purchase log from Ordered to Received, with a low-stock queue that builds itself
- Pricing and margin from your labour rate, Etsy fees, payment processing and target margin
- 25 sample rows marked SAMPLE so every formula works before you type
What it looks like
Every tab in the workbook
These are the actual sheet names in the file, not a feature list.
- Dashboard
- Product Costing
- Inventory
Works in
- Microsoft Excel 365, Windows or Mac (uses Excel Tables and FILTER, UNIQUE and CHOOSECOLS)
- Not built for Google Sheets, Apple Numbers or LibreOffice
- No macros, nothing to install
Others in Craft & Fiber
- Yarn Stash and Project TrackerA yarn stash tracker that tells a knitter or crocheter READY or SHORT before they cast…$14.99View →
- Cross Stitch Stash TrackerPaste any pattern's DMC list and the workbook tells you what you own, what is short…$13.99View →
- Craft Show Vendor KitA craft show vendor kit that answers the only question that matters after a market…$10.99View →
- DMC Colour ChartThe complete DMC six-strand range on ten printable pages, with a swatch, a name and the…$3.99View →
