Free Download

Free Cosmetics & Skincare Inventory Spreadsheet

Track Every Drop — Free Cosmetics Inventory Template

Download our FREE cosmetics inventory spreadsheet to track base oils, emulsifiers, preservatives, active ingredients, fragrance, packaging, batch records, and cost of goods for your skincare or cosmetics making business.

Trusted by 3,000+ makers
Free cosmetics and skincare inventory spreadsheet template
Excel Numbers Google Sheets

Join the Craftybase mailing list and we'll send you our cosmetics inventory spreadsheet template for free! We typically send 2-4 emails a month about small batch production topics which we hope are useful to our readership.

Stop guessing what actives you have left, which batch is about to expire, and what each product actually costs to formulate

If you're tracking cosmetics inventory in your head — knowing roughly how much hyaluronic acid powder you have, hoping your preservative doesn't run out mid-batch, and guessing whether your face serum is actually profitable — you're not alone. Cosmetics and skincare formulating means juggling dozens of ingredients, each with different units, shelf lives, usage rates, and costs. Without a system, scaling without chaos is nearly impossible.

This free cosmetics inventory spreadsheet helps you track everything that goes into making skincare and beauty products — from base oils and butters to emulsifiers, preservatives, active ingredients, fragrance, colorants, and packaging. It calculates batch costs, per-unit COGS, and inventory values so you can see exactly what you have on hand and what each product costs to formulate.

  • Ingredient tracking for oils, butters, emulsifiers, preservatives, actives, fragrance, colorants, packaging
  • Batch record management with ingredient usage and INCI names
  • Usage rate and percentage tracking for formulation compliance
  • Per-unit cost tracking (COGS per jar, bottle, or tube)
  • Stock status and reorder point alerts
  • Purchase tracking with landed costs (including shipping)
  • Order logging with revenue and COGS calculations
  • Year-end inventory valuation for taxes

Download our free cosmetics inventory spreadsheet today and take control of your formulation business.

Track ingredients across every phase

Map out your formulation process quickly and easily: see at a glance your current stock levels for water phase, oil phase, cool-down, and preservative ingredients. Know exactly when to reorder actives before you run out mid-batch.

Batch costing and recipe tracking

Calculate the true cost of every batch including base ingredients, actives, preservatives, fragrance, and packaging. Track usage rates and percentages to maintain formulation consistency and regulatory compliance across batches.

Automatic COGS and profit calculations

Use our template to automatically generate the numbers you need: cost per batch, cost per unit, and total COGS. See exactly what profit margin you're making on every product you sell — before you price it wrong.

Ready to get your cosmetics inventory under control?

Our free spreadsheet template helps you track every ingredient, batch, and product cost — so you can stop guessing and start growing.

Download the free spreadsheet ↑

Excel, Numbers & Google Sheets compatible

How to Use the Cosmetics Inventory Spreadsheet

This cosmetics inventory spreadsheet is designed as a simple, periodic Excel-based system to help you understand inventory tracking fundamentals and build good stock management habits for your formulation business. To get started, enter your email address above to receive the download link.

Important Note

The spreadsheet is designed for use over a single calendar year as it calculates your start and end of year inventory values. Once you reach the end of the year, create a new version for the next year, copy over your ingredient and product tabs, then update stock levels and starting numbers.

Some columns are calculated and should not be edited — they are marked with a light turquoise color.

1

Ingredient Inventory

This tab tracks all your cosmetic ingredients — base oils (jojoba, argan, rosehip, sweet almond), butters (shea, mango, cocoa), emulsifiers (BTMS-50, Emulsifying Wax NF, Olivem 1000), preservatives (Optiphen, Phenoxyethanol, Leucidal), active ingredients (hyaluronic acid, niacinamide, vitamin C, peptides, AHA/BHA acids), fragrance and essential oils, colorants, mica, and packaging. For each ingredient, you'll track on-hand quantity, unit cost, stock status, INCI name, and more.

SKU & Name
Your unique identifier for each ingredient (e.g., "ACT-HA" for Hyaluronic Acid Powder) and a clear name. What is a SKU?
INCI Name
The International Nomenclature Cosmetic Ingredient name. Tracking this alongside your common name makes product labeling and regulatory compliance much easier.
On Hand Qty
How much of this ingredient you currently have in stock. Update regularly through cycle counting to keep your numbers accurate.
Unit Cost
The fully landed cost per tracking unit (including shipping and discounts). This is critical for accurate COGS calculations on each product you formulate.
Tracking Unit
How you measure this ingredient (g, oz, ml, each). For actives used in small percentages, tracking in grams gives you the most precision for recipe costing.
Preferred Vendor
Where you typically source this ingredient. Detailed purchase history is logged in your Purchases tab, but this gives you a quick reference for reordering.

Pro tip for formulators: Track each active ingredient separately even if they come from the same supplier. Niacinamide, hyaluronic acid, and vitamin C each have different usage rates, costs, and shelf lives — they need individual tracking for accurate recipe costing.

2

Personal Use

This tab logs ingredients you've removed from business inventory for personal use or product testing. It ensures you're not claiming ingredients for tax deductions that weren't used in products you sold. This matters if you test formulations on yourself, give products to friends for feedback, or use your own cosmetics personally.

Date Removed
When you officially took this ingredient out of your business inventory for personal or testing use.
Ingredient Name & SKU
Which ingredient was removed (e.g., "Niacinamide Powder" or "Finished Vitamin C Serum batch").
Quantity Used
How much you removed, in your tracking unit (e.g., 10g of hyaluronic acid, or 3 finished jars of face cream).
Total Cost
Automatically calculated. This amount is deducted from your business expenses for accurate tax reporting.
3

Purchases

This tab tracks every ingredient purchase so you have a complete expense history and can factor purchases into your end-of-year inventory valuation. Create a new row for each ingredient purchased — if you bought 6 different actives from the same supplier, enter 6 rows.

Purchase Date & Vendor
When you bought the ingredient and from whom. This creates a purchase history for future ordering decisions and batch traceability.
Item Total Cost
The total paid for this ingredient excluding shipping and tax (those are added separately as proportional amounts).
Shipping & Tax (proportional)
Your proportional share of shipping and tax for this ingredient. Calculate based on relative cost or weight to distribute the total order costs across items.
Landed Unit Cost
Automatically calculated. Your true cost per gram or ounce including all fees — use this for accurate recipe costing and product pricing.

Why landed cost matters for cosmetics: If you pay $30 for 100g of hyaluronic acid powder plus $8 shipping, your true cost is $0.38/g, not $0.30/g. Using accurate landed costs ensures your serum prices actually cover your ingredient expenses.

4

Manufactures (Batch Records)

This tab records each production batch you make, tracking which ingredients were used and how much they cost. For cosmetics, good batch record keeping is also important for traceability — if a batch has an issue, you can trace it back to specific raw materials and lot numbers. Enter a row for each ingredient in a batch for detailed tracking, or calculate the total cost outside the spreadsheet and enter a single row per batch.

Manufacture Date & Product
When you made the batch and what product you created (e.g., "Hyaluronic Acid Serum 30ml" or "Whipped Shea Body Butter 4oz").
Ingredient Used
Which ingredient went into this batch (e.g., "Niacinamide Powder") along with the ingredient SKU and unit cost from your Ingredient Inventory tab.
Quantity Used
How much of this ingredient you used (e.g., 5g niacinamide in a 100g batch = 5% usage rate). This amount is deducted from your on-hand inventory.
Total Ingredient Cost
Automatically calculated (quantity used × unit cost). Sum all ingredient rows for a batch to get your total batch cost.

Batch traceability tip: Add a batch number column (e.g., "SERUM-2026-001") to this tab. If a customer reports a problem with a product, you can trace exactly which ingredients and lot numbers went into that batch. This is especially important if you're subject to cosmetics regulations.

5

Product Inventory

This tab tracks your finished cosmetics inventory — products that are properly formulated, filled, labeled, and ready to sell. You'll see at a glance what you have in stock, what each unit costs to make, and the total value of your finished goods inventory.

Name & SKU
Your product identifier (e.g., "SER-HA-30" for Hyaluronic Acid Serum 30ml). Helpful for multichannel selling where SKUs keep products synced across platforms.
On Hand Qty
How many finished units you currently have ready to sell. Update this after production runs and sales. Stock status is auto-calculated.
Manufacture Cost
How much it costs in ingredients and packaging to make one unit. Calculated from your Manufactures tab by dividing total batch cost by units produced.
Current Inventory Value
Automatically calculated. The total value of all on-hand units based on manufacture cost — your finished goods inventory value for this product.
6

Orders

This tab tracks all cosmetics sales. By logging each sale and the associated cost of goods, you can calculate total revenue, COGS, and gross profit for the year. Create a separate row for each product in an order — if a customer bought a face serum and a moisturizer, that's 2 rows.

Order Date & ID
When the order was placed and your unique order number (from Etsy, Shopify, in-person, or your own numbering system).
Quantity Sold
How many units of this product were in the order, along with SKU, name, and unit price for each line item.
Unit Manufacture Cost
The cost to make one unit (from your Product Inventory tab). This is your Cost of Goods Sold (COGS) per unit.
Grand Total
Automatically calculated. The total revenue for this line item including tax and shipping. Also calculates total price and total manufacture cost.
7

Reports

This tab tallies up your key financial numbers for the year. Everything here is automatically calculated from the other tabs — do not edit these numbers manually.

Total Revenue
Sum of all sales for the year, pulled from your Orders tab.
Total Ingredient Purchases
Sum of all ingredient purchases for the year, pulled from your Purchases tab.
Total COGS
Total cost of goods sold — the formulation cost of all units you sold during the period.
Inventory Values
Starting and ending inventory values for tax reporting, plus personal use deductions.

These numbers are what you'll need for tax time, bookkeeping, and understanding whether your cosmetics business is actually profitable. Make sure your ingredient unit costs are accurate — if you're forgetting to include shipping in landed costs, your profitability numbers will be off.

What is a Cosmetics Inventory Spreadsheet?

A cosmetics inventory spreadsheet is a structured document that helps beauty product makers track raw ingredients (base oils, butters, emulsifiers, preservatives, active ingredients), production batches, finished product inventory, and sales. It's a material and product tracking system tailored to the specific needs of cosmetics businesses — tracking things like INCI names, usage rates, batch numbers, and cost per jar or bottle.

Think of it as a combination of a formulation tracker, batch costing tool, and sales log. For every product batch you make, the spreadsheet helps you document what ingredients went into it, how much they cost, and what your profit margin is after selling. It also tracks on-hand inventory so you know when to reorder actives before you run out mid-formulation.

Unlike a simple stock count, a good cosmetics inventory spreadsheet goes deeper — it tracks batch records for each formula, calculates COGS per unit, and gives you inventory valuation numbers you need for tax reporting and regulatory compliance.

Why do cosmetics makers need inventory tracking?

The most common reason cosmetics businesses hit a growth wall is poor inventory visibility. You think you have enough Optiphen for the weekend production run, but you're actually nearly out. You reorder niacinamide only to find you already had a bag buried in storage. You price serums based on rough estimates instead of actual ingredient costs, and you're not sure if you're making money or just staying busy.

Inventory tracking solves this. With organized data, you know exactly what you have on hand, what you need to reorder, and what each product costs to formulate. This means:

No more stockouts mid-batch.
You can see when hyaluronic acid powder is running low and reorder before you're stuck waiting on shipping during a busy production week.
Accurate pricing.
You know your real costs — base ingredients, actives, preservatives, fragrance, packaging — so you can set prices that actually cover expenses and leave room for profit.
Better purchasing decisions.
Is it worth buying niacinamide in 500g or 1kg quantities? Does bulk argan oil actually save money after shipping? With cost data, you can compare unit prices and make smarter buying choices.
Tax-ready COGS.
At year-end, you'll have accurate cost of goods sold (COGS) numbers for tax filing. No more scrambling through invoices in April.
Traceability for compliance.
If you're subject to FDA cosmetics regulations or selling in markets that require documentation, tracking batch records and ingredient sources protects you and your customers.

What should a cosmetics inventory spreadsheet track?

A comprehensive cosmetics inventory spreadsheet should cover the full production cycle — from raw ingredients to finished products. At a minimum, it should include:

Ingredient Inventory:
A master list of all ingredients — water phase ingredients (distilled water, aloe vera, hydrosols, glycerin, hyaluronic acid, water-soluble actives), oil phase ingredients (base oils, butters, oil-soluble actives, emollients), emulsifiers (BTMS-50, Emulsifying Wax, Olivem), cool-down phase ingredients (fragrance, heat-sensitive actives, water-soluble preservatives), and packaging. For each ingredient, track on-hand quantity, unit cost, INCI name, tracking unit (g, oz, ml), and preferred vendor.
Purchase Tracking:
A log of every ingredient purchase with date, vendor, quantity, cost, shipping, and tax. This gives you a full expense history and helps you calculate landed costs.
Batch Records (Production Log):
Record each production batch you make. List what product you made, what date you made it, what ingredients and quantities you used, and the batch number. This is how you calculate cost per unit and track ingredient depletion — and it supports Good Manufacturing Practice (GMP) documentation.
Finished Product Inventory:
Track your ready-to-sell products by SKU, quantity on hand, unit price, and manufacture cost. This is your finished goods inventory value.
Sales/Orders:
Log every sale with order date, product, quantity, price, and manufacture cost. This gives you revenue, COGS, and gross profit per sale.
Reports:
Calculated totals for revenue, expenses, COGS, inventory values, and profit. These are the numbers you need for taxes and to understand whether your cosmetics business is sustainable.

Why spreadsheets may not be enough as your cosmetics business grows

A cosmetics inventory spreadsheet is a great starting point — especially if you're formulating small batches for local markets or testing new products. But as your business grows — more SKUs, more orders, more sales channels — spreadsheets become a serious bottleneck.

Here's what usually breaks first: You start selling on Etsy, then add Shopify, then start supplying wholesale to spas or boutiques. Now you're tracking inventory across three channels manually. A customer orders 5 face serums on Shopify and you need to open the spreadsheet, find the product row, subtract 5, update the inventory value, recalculate COGS, and hope you didn't break a formula.

Spreadsheets also struggle with the complexity of cosmetics formulation. If you buy argan oil at different prices each time, calculating true COGS requires choosing a cost flow method — FIFO, LIFO, or weighted average. Most spreadsheets don't handle this well. You end up using rough average costs, which means your profitability numbers are estimates, not reality.

That's where skincare inventory software like Craftybase comes in. Instead of manually tracking every ingredient use, Craftybase does it automatically. When you log a purchase, it updates ingredient costs and on-hand quantities. When you make a batch, it deducts ingredients from inventory and calculates cost using your actual purchase prices. When you sync sales from Etsy or Shopify, it updates finished product inventory and calculates COGS in real time.

Cosmetics makers find that moving to Craftybase saves hours per week in manual spreadsheet updates, reduces ingredient ordering mistakes, and gives them confidence in their pricing and profitability numbers.

When to switch from a spreadsheet to cosmetics inventory software

If any of these sound familiar, it's probably time to move beyond spreadsheets:

  • You're spending more time updating the spreadsheet than actually formulating.
  • You're selling on multiple channels (Etsy, Shopify, in-person, wholesale) and can't keep inventory synced.
  • You've run out of a key ingredient mid-batch because the spreadsheet wasn't up to date.
  • You're not sure what your true COGS is because ingredient costs change and the spreadsheet can't handle FIFO or weighted average costing.
  • You need to maintain compliance records for MOCRA regulations or GMP standards and a spreadsheet isn't adequate for traceability.
  • You're ready to scale — doing wholesale to spas, expanding product lines, or entering retail — and need inventory accuracy you can trust.

Craftybase is built for small batch cosmetics makers who want the accuracy of real-time inventory tracking without enterprise complexity or cost. It tracks ingredients, recipes, production, and sales in one system — and it's designed specifically for makers like you, not generic businesses. Learn more about cosmetic manufacturing software and how it differs from a spreadsheet.

Cosmetics Inventory Spreadsheet FAQ

To calculate cost per unit for a skincare product, list every ingredient used in the formula and determine the cost per gram or ounce using your landed unit cost. Multiply the quantity of each ingredient used in the batch by its unit cost, then sum all ingredient costs. Add the cost of packaging (jar, pump bottle, label). Divide the total batch cost by the number of units produced to get your per-unit cost. For example, if a 1,000g batch of face cream costs $42 in ingredients and produces 33 units at 30ml each, your cost per unit before packaging is $1.27. This is your baseline for setting a profitable retail price.

A formulation spreadsheet (also called a recipe spreadsheet) helps you develop and refine formulas — it typically shows ingredient percentages, INCI names, usage rates, and phase structure. An inventory spreadsheet is focused on the business side — it tracks how much of each ingredient you have on hand, what it cost, how much you've used in production, and what your COGS and profitability look like. You need both: use your formulation spreadsheet to develop recipes, then use the inventory spreadsheet to track whether those recipes are commercially viable. This free template focuses on the inventory and costing side.

Set reorder points based on your typical batch usage and supplier lead time. For example, if you use 50g of niacinamide per production run and your supplier takes 7 days to ship, maintain at least 100-150g as your reorder trigger. Track on-hand quantities in your spreadsheet and flag items that drop below reorder points. For specialty actives with longer lead times (some peptide suppliers ship from overseas), set higher buffer quantities. Also consider shelf life — perishable ingredients like certain botanical extracts shouldn't be over-stocked, while stable materials like waxes and preservatives can be ordered in larger quantities for cost savings.

Yes — track packaging items (jars, bottles, pumps, caps, labels, boxes) as separate inventory items in your spreadsheet, not lumped in with formulation ingredients. This is important for two reasons: first, packaging can be a significant portion of your unit cost (especially for premium glass containers), and you need to see that cost clearly when pricing products. Second, packaging runs out at a different rate than ingredients — you might need to reorder 2oz amber glass jars well before you need more argan oil. Treat packaging components the same as raw materials in your Ingredient Inventory tab.

COGS (Cost of Goods Sold) for a cosmetics business is the total ingredient and packaging cost of all products you sold during a period. It includes all ingredients in the formula plus packaging (jars, bottles, labels, boxes) — but not general business expenses like marketing, rent, or equipment. Calculate COGS by multiplying units sold by the manufacture cost per unit for each product, then summing across all products. For example, if you sold 40 face serums at $3.50 cost each and 20 lip balms at $0.80 cost each, your total COGS is $156. This number is required for tax reporting and calculating gross profit.

Most successful handmade skincare businesses aim for 65-80% gross profit margins on direct-to-consumer sales. Skincare products — especially those with premium active ingredients like vitamin C, peptides, or plant stem cells — can command higher retail prices that support strong margins. For wholesale (supplying to spas, boutiques, or retailers), margins are typically 40-55% because you're selling at wholesale price (around 50% of retail). Your target margin should cover all business expenses (rent, utilities, marketing, packaging design, website fees, insurance) and still leave room for net profit. Active ingredients can be costly, so accurate cost tracking is especially important in this niche.

Yes — cosmetics makers who sell commercially in the US are subject to the Modernization of Cosmetics Regulation Act (MoCRA), which requires manufacturers to maintain records that can be used for product tracing and recall. Even outside regulatory requirements, tracking batch numbers is best practice: if a customer reports an adverse reaction or product defect, batch numbers let you identify exactly which ingredients went into that production run and whether other products from the same batch need to be recalled. Add a batch number field to your Manufactures tab and note it on your product labels. Your spreadsheet becomes part of your Good Manufacturing Practice (GMP) documentation.

Add a "Received Date" and "Best Before Date" column to your Ingredient Inventory tab. For oils and butters, note the typical shelf life (unrefined rosehip oil: 6-12 months; refined shea butter: 1-2 years). For water-soluble actives and botanicals, shelf life can be shorter. When you receive a new order of an ingredient, log the received date and calculate the expiration date based on the supplier's certificate of analysis or typical shelf life. This helps you use older stock first (FIFO), identify which ingredients are approaching expiry, and avoid using expired ingredients in products sold to customers.

Who Should Use This Cosmetics Inventory Template?

This free cosmetics inventory spreadsheet is designed for skincare and beauty product makers at any stage who need to organize ingredients, track formulation costs, and understand profitability.

Home formulators transitioning to selling

If you've been making skincare as a hobby and are now starting to sell on Etsy, at markets, or to friends, this template helps you move from hobby pricing to business pricing. You'll learn what it actually costs to make each product — ingredients, packaging, and all — so you can set prices that make your business sustainable.

Etsy and Shopify skincare sellers

If you're selling cosmetics online and juggling ingredient orders, production batches, and sales across platforms, this spreadsheet gives you a central place to track everything. You'll know what you have in stock, what you need to reorder, and what each sale cost you in materials.

Small cosmetics business owners

If you're running a cosmetics business with a core product line (5-20 SKUs), this template gives you the inventory foundation you need without investing in software. It's perfect for tracking ingredients, calculating COGS, and keeping your numbers organized for tax season.

Natural and organic skincare formulators

If you formulate with natural oils, botanical extracts, and plant-based actives, tracking ingredient shelf life alongside inventory quantity is essential. Rosehip oil goes rancid, botanical extracts expire — this template helps you use older stock first and catch ingredients approaching their best-before date.

Wholesale skincare suppliers

If you're supplying products to spas, boutiques, or aestheticians, accurate costing is critical. Wholesale pricing is typically 50% of retail, which means tighter margins. This template helps you calculate ingredient costs precisely so you can quote wholesale prices that cover expenses and still leave room for profit.

Cosmetics makers with compliance requirements

If you're subject to MoCRA, GMP standards, or selling internationally, you need documentation. This template helps you record ingredient sources, batch numbers, and INCI names — creating a foundation for compliance records and product traceability.

Lotion, serum, and moisturizer makers

Whether you make water-based serums, anhydrous balms, or emulsified lotions and creams, this template adapts to your product range. Track oil phase, water phase, and cool-down phase ingredients separately to understand where your costs sit and which formulations are most profitable to produce.

Active-ingredient focused skincare brands

If your products feature premium actives — peptides, vitamin C derivatives, exfoliating acids, growth factors — those ingredients represent a significant portion of your COGS. This template helps you track active usage rates and costs precisely, so you can price premium formulations to reflect their true value and protect your margins.

Cosmetics makers preparing for growth

If you're considering scaling your skincare business — adding wholesale accounts, expanding product lines, or attracting investors — this spreadsheet gives you the cost visibility you need. Once you outgrow it, you'll have clean data to migrate to skincare inventory software like Craftybase to manage growth without chaos.

Ready to outgrow the spreadsheet?

Streamline your end-to-end cosmetics production process and gain real-time visibility into your inventory with Craftybase. Skincare and cosmetics makers have made the transition from spreadsheets to solve problems like ingredient ordering mistakes, batch traceability challenges, and accurate COGS tracking.

Start a 14 day free trial →

No credit card required. Cancel anytime.