Candle Business

Candle Business Profit Tracker Excel for your candle business - scents and sizes, daily sales, expenses, and a monthly P and L dashboard. Know which candles actually make money - and whether the month actually made money.

WHAT'S INCLUDED (6 sheets):

- Products and Pricing - scent, category, unit price, unit cost, margin per unit, units sold, revenue, cost of goods, and gross profit for every scent and size. Change a price and the margin and totals update.

- Daily Sales Log - date, scent, quantity, unit price, unit cost, amount, cost of goods, and channel for every sale. Unit price and unit cost are pulled from sheet 1 by formula.

- Expenses - rent, utilities, materials and supplies, packaging, marketing, software and fees, and other costs, with a monthly cost for each.

- Monthly P and L - revenue, cost of goods, rent, utilities, materials, packaging, marketing, software and fees and other expenses by month, Jan-Dec, with net profit and margin. Revenue and cost of goods are formulas from the Sales Log.

- Dashboard - total revenue, units sold, transactions, average sale value, gross profit and margin, expenses, net profit and margin, best and weakest products, revenue by product, costs by category, and units by product.

- Cover and How to Use - start here. Yellow cells are the only ones you edit.

EXAMPLE DATA (October 2026 - replace with your own numbers):

- 12 products; 164 units sold in 32 transactions; total revenue 3,390.00.

- Cost of goods 1,205.00; gross profit 2,185.00; gross margin 64.5 percent.

- Rent 550, Utilities 140, Materials 640, Packaging 150, Marketing 120, Software and Fees 110, Other 110; total expenses 1,820.00; net profit 365.00; net margin 10.8 percent.

- Best product by revenue: Desert Rain - 8 oz, 600.00. Best margin per unit: Candle Gift Set (3 x 4 oz), 23.00 per unit. Lowest margin per unit: Wax Melt Pack, 8.00 per unit.

- Best seller by units: Wax Melt Pack, 39 units. Average unit price 20.67; average revenue per product 282.50.

HOW IT WORKS:

1. Download the Excel file instantly after purchase.

2. On sheet 1, enter each product, category, unit price, and unit cost. Margin per unit, revenue, cost of goods, and gross profit fill in by formula.

3. On sheet 2, add a row per sale: date, product (spelled exactly as on sheet 1), quantity, and channel. Amount and cost of goods fill in by formula. Unit price and unit cost are pulled from sheet 1 by formula.

4. On sheet 3, enter each month's rent, utilities, materials, packaging, marketing, software and fees and other costs.

5. On sheet 4, enter rent, utilities, materials, packaging, marketing, software and fees and other expenses each month, then check gross margin and net profit on the Dashboard.

HOW THE NUMBERS WORK:

Margin per unit is unit price minus unit cost. Revenue is unit price times units sold. Cost of goods is unit cost times units sold. Gross profit is revenue minus cost of goods. Average sale value is total revenue divided by transactions. Net profit is gross profit minus rent, utilities, materials, packaging, marketing, software and fees and other expenses.

WHO IT'S FOR:

Candle makers and home fragrance sellers who sell online, in stores, and at markets and want scent prices, margins, units sold, and a monthly P and L in one workbook - without accounting software.

PLEASE NOTE:

- This is a digital download. No physical item will be shipped.

- Works in Microsoft Excel and Google Sheets (upload to Google Drive to open in Sheets).

- Example data for October 2026 is included (12 products, 164 units sold, 12 expense items). Replace it with your own numbers.

- The example October shows wax melts as the best seller by units but the lowest revenue per unit - volume hides thin dollars - while the gift set earns the most per order and sold only 8. Materials are the biggest cost at 640, more than rent.

- This is a bookkeeping and planning tool only, not tax, legal, or CPA advice.

- Due to the nature of digital downloads, refunds are not available. Message me before buying if you have a question.

Built by an accountant: B.S. Accountancy, ASU W. P. Carey, with revenue-reconciliation experience at Marriott and audit work at PwC.