Stock Control Spreadsheet

Track your ingredients, fragrances, colours and packaging with ease

Running out of ingredients mid-batch or forgetting what stock you already have is one of the biggest frustrations for cosmetic makers.

This Stock Control Spreadsheet has been designed specifically for bath, body and cosmetic makers to help you stay organised, monitor usage and know exactly when it’s time to reorder.

Simply record what you buy and what you use, and the spreadsheet automatically calculates your remaining stock.

No complicated systems just a simple, effective way to keep your making supplies organised.

What You Can Track

This spreadsheet allows you to monitor all of your essential making supplies, including:

• Raw ingredients
• Fragrance oils
• Colours / micas / dyes
• Packaging

Everything is stored in one place so you can quickly see what you have available for production.

Key Features

✔ Automatic stock calculations
✔ Track purchases and usage
✔ Monitor remaining stock levels
✔ Set reorder levels to avoid running out
✔ Separate sections for ingredients, fragrances, colours and packaging
✔ Simple transaction log system
✔ Designed specifically for cosmetic makers

How It Works

1. Add your ingredients, fragrances, colours and packaging items to the stock sheets.

2. Record new purchases in the Transactions sheet.

3. Log materials used when making products.

The spreadsheet will automatically calculate:

• Total purchased
• Total used
• Remaining stock levels

You will also be able to see when items drop below your reorder level.

THIS IS A DIGITAL PRODUCT NO PHYSYICAL ITEM WILL BE SENT