Skip Navigation

Candle

Candle Making Wick Testing Log & Fragrance Load Calculator — Soy Candle Batch Log, Inventory & Cost-Per-Candle | Excel + PDF

Candle business workbook: a wick-testing log, a batch log with cure-ready dates, a fragrance-load calculator, and a cost-per-candle calculator. Excel + PDF.

Click to enlarge the image / Click × or press ESC to close

What you'll love

  • A systematic wick-testing log — every wax × vessel × wick × fragrance burn-tested to a PASS / SIZE UP / SIZE DOWN verdict, so you only sell what passed (Excel)
  • A batch record log — pour date, lot code, candle type, wax & vessel, wax weight, fragrance & load, wick, cure days — and the workbook computes the cure-ready date (Excel)
  • A wax, fragrance & supplies inventory by supplier lot, and a vessels & packaging inventory — auto low-stock & reorder flags (Excel)
  • A fragrance load calculator — a safe fragrance weight per batch & per candle, checked against the wax's stated maximum usage rate, with an ounces-to-grams converter (Excel)
  • A cost-per-candle calculator — materials, the vessel, packaging, your labour & overhead totalled into a true cost per candle, then a real price (Excel)
  • A wax & candle type reference — soy jar to wax melt, with cure times, fragrance loads & burn notes
  • A Wick-Testing, Burn-Safety & Labeling guide — the burn-test method, wick sizing, the fire-safety warning, & troubleshooting
  • A working Excel workbook (8 tabs) + 5 PDF guides — evergreen, instant download

You already know how to pour a candle. This workbook is for the other half of a candle business — testing every candle until it burns clean, keeping a clean record of every batch, dosing fragrance safely, and the one that quietly decides whether it pays: knowing what a candle truly costs you, so you can price it for a profit instead of a guess. It turns the back-room chaos into a calm, repeatable system without getting in the way of the part you love.

One workbook, the whole selling side of the bench. Test every wick, log every batch with a cure-ready date, keep your wax and vessels stocked, dose fragrance safely, and finally price your candles for a profit — with the jar and your labour counted, the two lines many makers leave out.

What’s inside:

  • A wick-testing log (Excel) — one row per burn test for the wax and vessel, the wick series and size, the fragrance load, the full-melt time, the melt pool / flame / soot, the hot and cold throw, the burn rate, and a PASS / SIZE UP / SIZE DOWN verdict — because a candle is an open flame in someone’s home, and only a tested one is safe to sell
  • A batch record log (Excel) — one row per batch: the pour date, a unique lot code, the candle type, the wax and vessel, the wax weight, the fragrance and its load, the wick, and the cure days — and the workbook works out the cure-ready date, so nothing sells before it’s ready
  • A wax, fragrance & supplies inventory + a vessels & packaging inventory (Excel) — track materials by supplier lot and vessels & packaging by a reorder point; it auto-flags low stock so a recall is traceable and a tested batch never strands
  • A fragrance load calculator (Excel) — turn a target percentage into a fragrance weight for a batch and per candle, with a check that flags whether your rate is within the wax’s stated maximum usage rate
  • A cost-per-candle calculator (Excel) — your material cost per candle (the batch’s material cost divided by the candles it yields), then your true cost per candle (materials, the vessel, packaging, labour, overhead), then a fair price
  • A wax & candle type reference — every candle from a soy jar to a flameless wax melt, with its cure time, typical fragrance load, and how it burns
  • A Wick-Testing, Burn-Safety & Labeling guide + printable records — the burn-test method, wick sizing, fragrance load and flashpoint, the fire-safety warning label, the batch-and-test workflow, troubleshooting, and print-and-use wick-test / batch / receiving sheets

The working part really works: the Excel workbook has eight tabs with live calculators — type your numbers and the cure-ready dates, the fragrance weights, the costs, and the prices compute for you.

Evergreen — use it any year: candle types, cure times, the batch and fragrance math, the wick-testing method, and the pricing method are timeless, and the logs use a date column you fill in yourself.

Instant digital download. Nothing ships. The files are yours to use in your own candle business.

Created with AI assistance under Ardent Workshop’s creative direction, then reviewed and edited before release. This is a record-keeping & testing book and maker’s reference, not a recipe book or fire-safety, regulatory, or legal certification. A candle is an open flame in someone’s home, so your own burn testing — not this workbook — is what proves a particular candle is safe to sell. Always burn-test every wax, wick, vessel, and fragrance combination, follow each fragrance’s stated maximum load and flashpoint for your wax (fragrance suppliers publish these, generally following IFRA — the International Fragrance Association — guidelines), use heat-safe vessels, and confirm the labeling and fire-safety rules for your country with the current standard (in the US, ASTM F2058 for candle fire-safety labeling), the relevant safety body (such as the US Consumer Product Safety Commission, the CPSC), and your insurer. Cure times, fragrance loads, and burn rates are typical starting points; confirm with your own testing and your scale. The costing and pricing examples are illustrative, not financial or tax advice. Not affiliated with or endorsed by any standards body, supplier, or marketplace.

See it in action

Play

Compatibility & terms

This digital product is copyrighted. It is intended for personal use only. It is strictly prohibited to reproduce, resell or share this product, in part or in full, with or without modifications. No refunds, exchanges, or cancellations. Given this is a digital product, no physical product will be delivered.

Why a workbook

Most tools force a choice between a blank spreadsheet you build from scratch and a monthly app that's overkill. Ardent Workshop is the rung in between — structure you own.

  1. Blank spreadsheet

    Free, but you build and maintain every formula, tab and layout yourself.

    • Free
    • Infinite setup
    • No structure
  2. You are here

    Ardent Workshop

    Owned, structured, connected workbooks — a one-time price, yours to keep.

    • One-time price
    • Structured & connected
    • Yours to own
  3. Generic SaaS app

    Powerful, but overkill, rented and locked-in — built for someone bigger than you.

    • Monthly rent
    • Overkill
    • Lock-in

Running an operation that's genuinely outgrown the file? Ardent Seller isn't the generic SaaS app this ladder warns about — it's maker-first software built by the same workshop: your data stays yours, you can start free or pay as you go with no subscription required, and it's sized for your operation, not someone bigger. The platform to graduate to when a spreadsheet honestly can't keep up.

Ready to start

Instant download · Free lifetime updates · Personal use license

$12.95 USD
Buy now

Pairs well with

From the blog

Hand-picked reading on how to actually use a tool like this.