Skip to content

Perfume Inventory Template: Aroma Materials by Lot

A free perfume inventory template for an indie perfumer: aroma materials by the milliliter with lots and dates, carriers, bottles and boxes, finished stock.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 19, 2026 · 5 min read

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.

Questions people also ask

How do perfumers track their materials?

By weight or volume for each material, with the supplier's lot and date, and by batch for finished perfume.

How long do perfume ingredients last?

It varies widely. Citrus oils are best used within a year or so; many woods, resins and synthetics keep for several. Go by your supplier's guidance and your nose.

Do I need batch numbers on perfume?

They're how you connect a bottle to what went into it, which matters for complaints and recalls. See how to create lot numbers.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.