Home/Spreadsheets/Small Business Tools/Candle Making Batch Inventory

Candle Making Batch Inventory

Works the way candles are actually made - batch, materials consumed, cost per candle - and records the fragrance load so a good batch repeats. It opens in Microsoft Excel and in Google Sheets, has no macros and nothing to install, and is yours to reuse as often as you like.

What you get

Raw material inventory with unit cost, reorder point, max load and flashpoint
Batch log that consumes materials from stock and gives a cost per candle
Fragrance percentage and cure date recorded so a good batch can be repeated
Low-stock reorder queue that fills itself, with suggested quantities
Candle costing to a suggested wholesale and retail price at your target margin
Opens in Excel and in Google Sheets

$18.99one-time, no subscription

Buy on Etsy

Instant digital download · one-time purchase · no subscription

Candle Making Batch Inventory — the workbook open in Excel

What it does

Raw material inventory with unit cost, reorder point, max load and flashpoint
Batch log that consumes materials from stock and gives a cost per candle
Fragrance percentage and cure date recorded so a good batch can be repeated
Low-stock reorder queue that fills itself, with suggested quantities
Candle costing to a suggested wholesale and retail price at your target margin

What it looks like

Candle Making Batch Inventory screenshot

Every tab in the workbook

These are the actual sheet names in the file, not a feature list.

Batch Log
Dashboard
Supplies
Purchases & Reorder
Candle Costing

Works in

Microsoft Excel 2016 or later, Windows and Mac
Google Sheets — upload to Drive and open
No macros, no add-ins, no subscription

Honest scope

This is a planning and bookkeeping template, not tax or accounting advice. The numbers it reports are the numbers you enter.

Others in Small Business Tools

Candle Making Batch Inventory$18.99Buy on Etsy