Candle Making Doesn't Need Another Spreadsheet
The template for candle making weekly circulates across forums and Pinterest boards, and most of it is fluff. I built my own after burning through three batches last year because commercial trackers didn't account for humidity swings or wax-specific cure windows. Here's what actually matters in a weekly candle making template and how to set it up without overcomplicating it.
Template For Candle Making Weekly: The Fields That Matter
A functional template tracks eight columns. Anything more and you'll stop filling it out by week two. Here's the minimum viable version: 1. Batch Date — MM/DD/YYYY format. Don't get fancy with ISO dates unless you're shipping to Europe. Just track when you poured. 2. Wax Type & Source — Soy, paraffin, coconut blend, beeswax, whatever. Note the supplier too. I switched from Golden Brands 464 to Natural Soya 888 once because the cold throw on GB464 degraded after month three in my workshop. Tracking which wax came from which vendor saved me two weeks of troubleshooting when a new lot tested differently.
3. Fragrance Load % — This is the number most people skip and immediately regret. Write it down. 6%? 10%? If you eyeball it every time, your scent throw will vary batch to batch and customers will notice. I keep a separate column for fragrance oil name/ID so I can cross-reference later when testing new blends. 4. Wicker Used — Cotton core, wood wick, size (HBI 10, CDL 4H, etc.). This is critical because wick performance changes with wax type and container. A wick that worked in one batch might charring in the next if the wax blend shifted even slightly. 5. Pour Temperature — I pour soy around 170°F and check with an instant-read thermometer. If I'm rushing and don't record it, I can't reproduce results when a batch looks odd later.
Get the Full Details
6. Add Temperature (for FO) — This one trips up beginners. Adding fragrance at the wrong temperature causes sinkholes, weeping, or poor throw. Track it. My rule of thumb is adding FO at 185°F for soy, but your wax might differ. Write yours down. 7. Cure Days Target — Soy needs 7–14 days. Paraffin can sometimes be sold sooner. Beeswax? Give it three weeks minimum. Tracking cure time helps you plan inventory. If you pour on Monday and forget when you need to ship, you'll either rush it or miss deadlines. 8. Notes — Free text. This is where you capture what went wrong. "Mold adhesion issue," "tunneling on left side," "CT weak but FT strong." Over time these notes become your personal reference library.
How I Actually Use It Week to Week
My template lives in Google Sheets because it syncs across my phone and laptop. I have three tabs: Production Log (the main tracker), Recipe Database (a master list of wax/FO/wick combos I've tested), and Supply Inventory (so I know when to reorder). The Production Log pulls from the other two with VLOOKUP formulas so I'm not retyping the same supplier names. Every Sunday night I spend maybe 10 minutes entering that week's pours. If I had a off day or skipped pouring, I still log a placeholder entry. Empty weeks create gaps in my data and make trend analysis impossible. I once tried taking a two-week break and when I returned I had no idea why my latest batch was performing worse. Filling the template daily or weekly would've caught the problem — humidity spiked that week and I hadn't adjusted my pour temp.
Where This Template Falls Short
It doesn't solve everything. A spreadsheet won't tell you your wick is too small for a new container diameter. You still need to test. It also doesn't replace good workshop habits — ventilation, proper molds, quality fragrance oils. The template tracks decisions; it doesn't make them for you. Another limitation: small batch makers (one to five candles per week) might find the overhead annoying. If you're pouring four jars on a weekend afternoon, a full template might feel like bureaucracy. In that case, a simple index card or phone note with just wax type, FO percentage, and wick size is sufficient. Scale the system to your output. Cost tracking is also weak in this version. I don't track cost per candle in the basic template because I calculate that separately in a different sheet. If you're selling, you need a unit cost model — wax cost per ounce, container cost, label cost, labor, fragrance cost. The weekly template tells you what you made, not whether it was profitable. Consider combining it with a costing sheet if this is a revenue activity.
Setting Up Your Own Version
Create a new spreadsheet. Set the headers exactly as I listed them above. Freeze the top row so you always see them. Use data validation dropdowns for wax type and wick size to prevent typos from corrupting your data. Conditional formatting on the Notes column turns red when you flag a problem — makes patterns visible when you scroll back months later. I also recommend adding a "Scent Profile" column if you develop signature blends. This way you can sort by fragrance family later and see which scent categories sell fastest or cause the most issues. Export to PDF once a month for backup. Cloud sync is convenient but files break. A monthly PDF archive means you always have a snapshot you can open anywhere.
The real value of a template for candle making weekly isn't the tracking itself. It's the pattern recognition. After three months of entries you'll start noticing things — certain wicks consistently underperform with a specific fragrance, your pour temp needs adjusting in winter, your cure times are too short for a particular wax blend. Those insights come from accumulated data, not intuition. Build the habit. Fill it in even on slow weeks. The spreadsheet will repay you when you need to reproduce a batch or troubleshoot a problem months later.
