How I Track My Candle Production Every Month Without Losing My Mind
I keep a spreadsheet that I call my monthly candle making workbook, and honestly it's the only reason I haven't gone back to guessing what my margins actually are. At the start of each month I sit down, pull my supplier invoices from the last cycle, and enter every raw material purchase along with the projected output. From there it's just row after row of batch data until the month closes out and I know exactly how much wax I used, how many fragrance oils burned through, and what I sold versus what's sitting in storage. The Workbook For Candle Making Monthly approach works because it forces you to confront the gap between what you think you're spending and what you actually are. I learned that the hard way back in 2019 when I was running a half-dozen Etsy listings and completely lost money on a batch of soy wax pillars that I thought were profitable. I had no record of the wax loss from pouring, no tracking of broken candles, no accounting for the amount of wick trim waste that accumulated. My spreadsheet from that month later showed I'd sold three dozen jars and lost four hundred dollars after factoring in shipping materials, broken product write-offs, and the fragrance oil I'd estimated too conservatively. That was the year I started building this thing out properly.
What the Workbook For Candle Making Monthly Actually Contains
It's not some fancy software. It's a structured sheet with columns for date, batch number, vessel type, wax weight, fragrance load percentage, dye or colorant used, wick type and size, pour temperature, cure time, quantity poured, quantity damaged, quantity sold, and unit cost. Each row is one batch. At the bottom you get rolling totals for material cost per unit, profit per unit after shipping and packaging, and a summary table that breaks everything down by product type. The key section that beginners skip is the fragrance oil consumption log. You'd be surprised how many people buy a five-pound bag of a scent and never record how much they actually used per batch. Soy wax holds fragrance at about six to ten percent by weight depending on the oil, and if you're making a 12-ounce jar at eight percent load that's roughly 0.96 ounces of fragrance oil per candle. Multiply that across a hundred jars and you're burning through a pound of oil fast. Without recording it you have no idea whether your current fragrance budget can cover next month's runs. Wax yield is another thing nobody tracks until they're already over budget. When you melt wax you lose some to the pot, some to the thermometer probe, some to residue left in the pouring pitcher, and some to spillage during transfer. A typical 10-pound block of soy wax will give you about 9.2 to 9.5 pounds of usable product if you're careful. That 0.5 to 0.8 pound loss needs to be built into your cost calculations or your per-unit pricing will drift downward every month without you noticing.
Setting It Up So It Actually Gets Used
The biggest failure point with these trackers is that they become overwhelming and then get abandoned. I keep my sheet simple enough that entering a new batch takes about forty-five seconds. That means I use drop-down menus for vessel type, pre-set fragrance percentages for each scent I carry, and automated formulas that calculate cost the moment I hit enter. The less I have to think about, the more likely I am to actually enter the data while the batch is still fresh in my head. One specific workaround I developed involves the wick testing section. Early on I was testing wicks individually and logging each trial on a separate line, which bloated the sheet and made the data useless for trend analysis. I restructured it so every wick test for a given vessel and wax combination lives in a single row with columns for burn time, tunnel depth, flame height, and sooting level. That way when I look at last month's data I can see at a glance which wick performed best across all my runs. It also caught something I'd completely missed: my #10 cotton-core wicks were performing fine in June but started flooding in humid July conditions. I switched to a braided cotton blend for the summer months and hasn't had a flooding issue since. That kind of insight only comes out if the data is structured for comparison.
Get the Full Details
Advanced Detail: How to Calculate Real COGS Per Candle
Most people add up wax, fragrance, wicks, and jars and divide by the number of candles. That's wrong because it misses several hidden costs. You need to include the labor time for cleaning, the electricity for melting, the depreciation on your scale and thermometer, and the packaging materials like lids, labels, and ship boxes. I track all of these as a percentage overhead applied to each batch based on total production hours. Here's how my calculation actually works. If I pour a batch of fifty jars and it takes me two hours of active labor, I apply an hourly rate to that time and distribute it across the fifty units. Then I add packaging cost per unit including the jar, lid, label, tissue paper, and the box. Fragrance oil cost comes from my per-ounce purchase price divided by the weight used. Wax cost follows the same method. The sum of all these gives me the true landed cost before shipping. My Etsy listing prices are then set at roughly 2.5 to 3 times that landed cost to leave room for platform fees, payment processing, and profit. This is where the monthly view becomes valuable. When I roll up my COGS across the entire month I can see whether a particular scent or vessel size is consistently eating into my margins. Last November I discovered that my 8-ounce tumbler candles using a certain amber glass supplier were costing 40 percent more per unit than I'd estimated because the glass jars had gone up in price and I hadn't updated my sheet. I caught it mid-month because the tracker was flagging the cost increase before it became a structural problem. Without the monthly view I would've shipped the entire holiday run at a loss and blamed it on seasonal demand.
Where This System Falls Apart
For one-off makers who do three or four batches a month, this level of tracking is overkill. You're better off writing costs on a notepad and moving on. The workbook shines when you're producing twenty or more batches per month across multiple product lines. Below that threshold the time spent maintaining the sheet eats into actual production time and the marginal benefit drops off quickly. Another failure mode is data entry inconsistency. If you switch between tracking in ounces and grams mid-month, or forget to update your fragrance oil purchase price when the supplier raises it, your totals become unreliable. I solved this by locking the unit type at the top of the sheet and setting up a price update log where I record the new unit cost the day I receive a shipment. That keeps the historical data intact while still allowing the current month to reflect accurate pricing. There's also the issue of broken or damaged product. I used to just ignore it in my spreadsheets because accounting for waste felt depressing. That changed when I realized my damage rate on a certain candle line was running at 18 percent due to thermal shock during cooling. Once I started tracking damaged units separately I was able to identify the root cause, adjust my cooling protocol, and bring the damage rate down to under 4 percent within two months. The workbook made that visible in a way that memory never could.
Getting Started
You don't need to buy anything. Google Sheets or Microsoft Excel will work fine. I'd suggest starting with columns for batch date, product name, wax weight in ounces, fragrance weight in ounces, wick type, vessels used, quantity poured, quantity sold, quantity damaged, and total material cost. Add a formula column that divides total material cost by quantity poured to get your cost per unit. From there you can expand into the more detailed sections as your operation grows. The real value isn't in the spreadsheet itself. It's in the habit of looking at the numbers at the end of each month and asking whether your pricing, your material choices, and your production volume are all aligned. Most candle makers skip that step because the math feels uncomfortable. I've found that discomfort is exactly where the useful information lives.
