Wax Melt Stock & Supplies Tracker | Inventory, Reorder Alerts & Finished Stock Spreadsheet (UK)

Never run out of clamshells halfway through a pour again. This spreadsheet tracks every supply you buy and every melt you make and sell, and tells you what to reorder before it becomes a problem.

List your wax, fragrance oils, dyes, clamshells, labels and packaging once and set a reorder level for each. Log purchases as they arrive and what you use for each batch, and your stock updates on its own. Anything running low turns amber, and anything at its reorder level turns red. It also works out your true average cost per gram or item, delivery included.

For finished melts, log what you make and sell by scent. You'll see what's in stock, what's selling and which scents to make next.

The dashboard pulls it all together: what to reorder, supplies stock value, spend this month, melts sold this month and your best-selling scent.

Made for UK makers, with grams and £. Example data is included. Works in Excel, Google Sheets and Numbers.

What's included:

- Supplies inventory with on-hand stock, reorder levels and red/amber/green reorder flags

- Purchase log that adds to your stock automatically and works out your average cost per unit

- Supplies used log for batches, testing and stock counts

- Finished stock by scent, with made, sold, samples and "make more" alerts

- Dashboard with a reorder list, spend this month, best sellers and an in-stock vs sold chart, plus a supplier list with spend this year