A perfumer's inventory is small volumes of expensive liquids, and the same material from two lots can smell different. So a perfume inventory template counts aroma materials in milliliters, each with a cost a milliliter that makes you careful, and keeps the supplier's lot and a use-by date for every bottle that comes in. Carriers (alcohol, jojoba), roll-on bottles and boxes sit on the same sheet, with finished perfume by batch. When a customer says the new bottle isn't like the last one, the batch and its lots are where you look. Here's the template, with a made-up perfumer's numbers.
The short version
- Aroma materials in milliliters; carriers in fluid ounces; bottles and boxes in eaches.
- A lot and a date for every bottle of material received. Citrus first.
- Finished stock by batch, with the blend it came from.
- Count by weighing: grams are faster and truer than eyeballing a bottle.
- TaroStack records which lot of each material went into every batch. More below.
An example sheet
Wild Iris Perfumery is a made-up Rhode Island maker of roll-on perfume oils. Six of nine rows:
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Jojoba oil, clear | fl oz | 96 | 64 | $1.45 | $139.20 | OK |
| Perfumer's alcohol | fl oz | 64 | 32 | $0.62 | $39.68 | OK |
| Bergamot essential oil | ml | 120 | 100 | $0.34 | $40.80 | OK |
| Sandalwood accord | ml | 60 | 50 | $0.95 | $57.00 | OK |
| Jasmine absolute, 10% dilution | ml | 28 | 30 | $1.80 | $50.40 | REORDER |
| Vanilla CO2 extract | ml | 35 | 20 | $1.25 | $43.75 | OK |
Roll-on bottles, boxes and 44 finished roll-ons of one scent bring the total to $773.19. Jasmine and boxes are under their amounts.
Milliliters into bottles
A 10 ml roll-on at 20% fragrance holds 2 ml of the blend and 8 ml of jojoba. If jasmine is 15% of the blend, each bottle takes 0.3 ml of it.
| Jasmine on hand | 28 ml |
| Bottles that covers (28 ÷ 0.3) | 93 |
| Bottles in a batch | 72 |
One batch, with a little over. That's why the reorder amount is 30 ml and why the row is red. The same sum for each material in a formula tells you which one limits your next batch, and it's rarely the one you'd guess.
Counting is easier by weight. Put the bottle on a gram scale, subtract the empty bottle's weight, and convert once using the material's density (or count in grams throughout, which many perfumers do).
Lots and dates
| Received or made | Item | Lot | Quantity | Use by |
|---|---|---|---|---|
| Apr 14 | Bergamot essential oil | BG-24-0388 | 250 ml | Dec 20, 2026 |
| Sep 2 | Sandalwood accord | SA-25-1107 | 100 ml | Sep 30, 2028 |
| Oct 20 | Neroli Dusk, 10 ml roll-on | ND-1020 | 72 | Oct 20, 2028 |
Citrus oils oxidize first, and oxidized citrus is the kind of thing that irritates skin. The bergamot from April is the short-dated row, and the sheet flags it USE FIRST inside 45 days. Keep citrus cold and buy it in smaller bottles than you think you need.
The finished row names its batch: ND-1020, 72 bottles from blend B-1006. Put ND-1020 on the bottle. If the next lot of sandalwood smells greener and customers notice, you'll know which batch numbers are which.
Get the template
Download the perfume inventory template. Four sheets: inventory with value and REORDER, lots with days left, a count sheet, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. The numbers behind a roll-on line are in perfume oil business plan, and label rules in cosmetic labeling requirements.
Where this stops working
A formula has twelve materials. A batch takes a few milliliters of each, and writing twelve lot numbers on a batch sheet by hand is the first thing dropped when orders pile up. Then the one time it matters, the record isn't there.
How TaroStack does it
TaroStack writes the twelve lot numbers for you.
A blend is a recipe, and a bottle is another. The blend lists each material by weight or volume. The roll-on takes 2 ml of blend, 8 ml of jojoba, a bottle, a box. Record a batch and every material comes off its oldest lot, and the batch record notes which lots were used, automatically.
Formula versions. Recipes are versioned. When you adjust the formula for a new lot of sandalwood, batches made after carry the new version.
It says what limits you. "What could I make right now" shows how many bottles the materials on hand allow.
Dates watched. Lots close to their use-by are flagged.
| The job | Template | In TaroStack |
|---|---|---|
| Lots in a batch | Twelve, by hand | Recorded with the batch |
| Milliliters left | Subtract after each batch | Come off as you make |
| Bottles the stock can make | A sum for each material | Shown for you |
| Formula changes | Notes | Versions |
Recipes, batches and lots are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
