Candle Batch Record Sheet Excel | Candle Production Log Google Sheets | Candle Maker Batch Tracker | QC Checklist Instant Download

🕯 Candle Batch Record Sheet — 6 Sheets. Complete Production & Compliance System.

Stop losing track of your batches, ingredients and QC results.
Record every formula, track every ingredient, and sign off
every batch — all in one spreadsheet built specifically
for candle makers.

─────────────────────────────
📦 WHAT’S INCLUDED — 6 SHEETS
─────────────────────────────

📋 Sheet 1 — Start Here
Setup guide and colour key so you know exactly what to do.
– 5-sheet walkthrough
– Colour key explained (blue = input, green = auto)
– Zero learning curve

🗂️ Sheet 2 — Batch Log (Master)
Running log of ALL batches ever made. One row per batch.
– Batch #, date, candle name and scent
– Wax type, wax used, FO name and FO% load
– FO used (g) auto-calculated
– Wick type and jar / container
– Units made, units passed and failed QC
– QC pass rate auto-calculated
– Batch cost, sell price, revenue and profit auto
– Cure-ready date, poured by and status
– Notes per batch
– Status: In Production, Curing, Ready to Sell,
Sold Out, Archived

🕯️ Sheet 3 — Single Batch Detail Record
Full deep-dive form for one batch. Print or save as PDF.
– Section 1: Batch identification
– Section 2: Full ingredient list with supplier and lot code
– Section 3: Production process log with temps and times
– Section 4: Cure period and QC sign-off
– Section 5: Labelling and compliance checklist
(GHS / CLP for EU, ASTM F2417 for USA)
– Batch sign-off with signatures

📦 Sheet 4 — Ingredient Inventory Tracker
Track every ingredient — auto-flags when stock is low.
– Stock on hand and reorder level
– Stock status auto: OK, Low Stock, Reorder Now
– Cost per unit and total stock value auto
– Per-candle usage and batches possible auto
– Supplier and last reorder date
– Red = Reorder Now, Amber = Low Stock, Green = OK

📊 Sheet 5 — Production Summary Dashboard
See your production at a glance. Auto-pulls from Batch Log.
– Total batches, units made, revenue and profit
– Average QC pass rate and profit per batch
– Batch status breakdown
– Monthly production totals (12 months)
– Revenue, cost and profit per month

✅ Sheet 6 — QC Inspection Checklist
Complete before marking any batch Ready to Sell.
– Visual inspection (surface, wick, colour)
– Container and packaging check
– Scent and performance test
– FDA / CLP compliance checklist
– Overall batch QC result: Pass or Fail

─────────────────────────────
✅ WHY CANDLE MAKERS LOVE THIS
─────────────────────────────

✔ Built specifically for candle makers
✔ Complete batch history in one searchable log
✔ Full ingredient traceability with supplier lot codes
✔ FDA / CLP compliance checklist included
✔ Auto stock alerts before you run out
✔ Know exactly how many batches you can still make
✔ QC pass rate, batch profit auto-calculated
✔ Works on Excel and Google Sheets (free)
✔ Pre-filled with sample data
✔ Print or save Batch Detail as PDF per batch
✔ Unlimited use, one purchase forever

─────────────────────────────
📥 HOW TO GET STARTED
─────────────────────────────

1. Purchase and download the file instantly
2. Open in Google Sheets (free) or Excel
3. Go to Start Here tab for setup guide
4. Log your first batch in Batch Log
5. Track stock in Ingredient Inventory
6. Sign off every batch with QC Checklist

⚠️ Download via web browser only.
Not supported through the Etsy app.
Go to etsy.com/your/purchases to access your file.

─────────────────────────────
📌 FILE DETAILS
─────────────────────────────

– Format: .xlsx (Excel + Google Sheets compatible)
– Delivery: Instant Digital Download
– Use: Personal and commercial use for your own business
– Support: Message me anytime if you need help!

─────────────────────────────
💡 ALSO IN MY SHOP
─────────────────────────────

Complete your candle business toolkit:
– Candle Pricing & COGS Calculator
https://bizmindstudio.etsy.com/listing/4504850202/candle-pricing-cogs-calculator-6-sheets

– Candle Business Invoice System
https://bizmindstudio.etsy.com/listing/4504156508/candle-business-invoice-template-excel

– Candle Order Form & Business Tracker
https://bizmindstudio.etsy.com/listing/4508828821/candle-order-form-template-excel-candle
─────────────────────────────

© BizMind Studio
For personal and commercial use within your own candle business.
Please do not resell or redistribute this file.