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

    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.