Tracker For Candle Making Monthly

Setting Up A Monthly Tracker For Your Candle Making Business

Most candle makers I talk to still track their monthly numbers on scattered spreadsheets or memory. It works fine until you need to know exactly how much wax you used versus how much you sold three months ago. A dedicated Tracker For Candle Making Monthly is just a organized system that logs materials, labor, sales, and profit in one place so you can see what's actually profitable. I stopped guessing my margins after one batch ruined my quarter. I had no record of how much fragrance oil went into a particular run, and when the wax supplier changed their base, I couldn't backtrack and adjust pricing. That cost me about $400 in lost margin on a single product line.

What A Monthly Tracker Actually Needs

Before you build anything, here are the fields that matter. Anything else is decoration. Inventory log: wax by type and weight, fragrance oils by supplier and batch, wicks by core and size, containers by source, colorants, additives like soy or beeswax blends. Track purchase date, quantity bought, remaining stock, and reorder threshold. Production log: batch date, product name, number of units made, wax used in ounces or pounds, fragrance load percentage, wick type per unit, container type, curing time, and any rejects or remelts.

Sales log: date, product, quantity sold, price per unit, platform or channel, shipping costs, payment processing fees, returns, and net revenue per item. Overhead and fixed costs: utilities, rent if applicable, equipment depreciation, insurance, licensing, website hosting, packaging supplies that aren't tied to a specific candle. Profit calculation: gross revenue minus cost of goods sold minus overhead allocation gives you net monthly profit. Do not skip overhead. Beginners consistently forget it and then wonder why they're broke despite looking busy.

I built mine as a Google Sheet with four tabs and conditional formatting that turns red when wax inventory drops below two weeks of projected use. The conditional formatting is the only part that saves me time anymore. Everything else is manual entry, which is the actual hard part.

How To Build It In About An Hour

Open a new spreadsheet. Create tabs for inventory, production, sales, and summary. Set up the inventory tab with columns for item name, category, supplier, unit type, purchase date, quantity purchased, quantity used, quantity remaining, and reorder point. Lock the top row as headers. The production tab needs batch date, product name, unit count, wax oz used, fragrance oz used, fragrance percent, wick style, container style, units rejected, curing days, and notes. Calculate fragrance load automatically with a formula: fragrance ounces divided by wax ounces times 100. Sales tab columns: sale date, product name, units sold, unit price, gross revenue, platform, transaction fee rate, fee amount, shipping cost, refund flag, net revenue. Sum the net revenue column at the bottom.

Summary tab pulls data from the other three tabs. Use a SUMIF function to total wax used by month. Another SUMIF totals fragrance oil consumption. A third sums net sales by product. Subtract estimated COGS from net sales to get gross margin. Deduct a monthly overhead flat or allocated amount for net profit. The formula structure looks like this: gross margin equals total net sales minus total material costs pulled from inventory consumption times unit cost. Net profit equals gross margin minus allocated overhead. Nothing fancy. Just accounting basics applied to candles.

The Part Nobody Warns You About

Wax shrinkage. Soy wax shrinks differently than paraffin. Blends shrink unpredictably. If you pour by volume instead of by weight, your cost calculations are wrong every single month. I found this out the hard way when my projected wax usage consistently ran 8 to 12 percent lower than actual purchases over a three month period. The workaround was simple but annoying. Weigh every batch before pouring. Record the actual wax poured per candle, not the theoretical amount. Track the difference between pour weight and final cured weight as shrinkage loss, and include that loss in your COGS calculation. Wax costs more than the container and the fragrance combined on low margin products. Ignoring shrinkage makes your numbers look better than they are. Another thing: fragrance oil compatibility. Some FOs burn cleaner at higher loads, others smell terrible below a certain percentage. Your tracker should note the tested optimal load per fragrance per wax type. When you switch suppliers, retest. Write it down. I once used a fragrance at 10 percent in a new wax blend without adjusting and had significant sooting issues across an entire batch. The tracker didn't catch it because I hadn't logged the wick pairing properly.

Downloadable Template Structure

I don't host files directly, but here's exactly what to copy into your own sheet if you want to skip building from scratch. Tab 1: Inventory Columns: Item ID | Category | Item Name | Supplier | Unit Type | Purchase Date | Quantity Purchased | Quantity Used | Quantity Remaining | Reorder Threshold | Unit Cost | Total Cost | Last Restocked

Tab 2: Production Columns: Batch | Date | Product Name | Units Made | Wax Oz Used | Fragrance Oz Used | Fragrance % | Wicks Used | Container Type | Units Rejected | Curing Days | Notes Tab 3: Sales

Columns: Sale Date | Order | Product | Units Sold | Price Per Unit | Gross Revenue | Platform | Fee Rate | Fee Amount | Shipping | Refunded | Net Revenue Tab 4: Monthly Summary This tab uses SUMIFS pulling from the other three. Monthly wax consumption, monthly fragrance consumption, total units produced, total units sold, gross revenue, COGS, gross margin, overhead, net profit. Add a pivot table if your spreadsheet supports it for faster rollover analysis.

When This Tracker Falls Short

It doesn't replace accounting software if your volume is above a certain level. Once you're moving more than maybe 200 units a month across multiple products, the manual entry becomes a part-time job. At that point you migrate to something like QuickBooks or a dedicated inventory management tool with barcode scanning. The tracker still works for smaller operations, hobby-scale to small business, where the overhead of a full system isn't justified. It also won't catch edge cases like gifted materials, bartered supplies, or samples that left your door without a recorded transaction. Those slip through the cracks unless you build them into the system. I started logging everything including free samples and gifts as zero-cost inventory entries so they at least show up in consumption totals. And the tracker assumes you actually enter the data consistently. If you skip a week because you're busy filling orders, your monthly numbers drift. I learned this in month four when my COGS looked suspiciously low and realized I'd stopped logging two weeks of production during a holiday rush. I had to pull receipts from that period and backfill manually.

Practical Habits That Make It Work

Enter production data the same day you pour. Enter sales data within 24 hours of the transaction. Review the summary tab at the end of each month. Adjust reorder thresholds based on actual consumption, not guesses. Update unit costs whenever suppliers change prices. Keep a separate column for price changes on finished goods so you can see margin impact over time. The whole process takes maybe ten minutes a day if you're consistent. Without consistency it takes an hour every Sunday and still isn't accurate. There's no shortcut around that. If you're just starting out and candle making is seasonal or occasional, a simplified version with just production and sales is enough. Don't overbuild it. The tracker that survives is the one you actually use, not the one with the most features.