InkSheet Studio
Candle Business Spreadsheet | Cost Calculator, Batch Log, Inventory, Pricing and Profit Tracker
Candle Business Spreadsheet | Cost Calculator, Batch Log, Inventory, Pricing and Profit Tracker
Couldn't load pickup availability
INSTANT DOWNLOAD — HOW IT WORKS: This is a digital download, not a physical product — nothing is shipped. After checkout, your download link appears right on the confirmation page and is also emailed to you. Use the files in your favorite apps and projects, or print the PDF files at home or at a local print shop.
You poured thirty candles this weekend. The market table looked great, the wholesale box went out on Tuesday — but what does one candle actually cost you? Wax, fragrance, the jar, the lid, the label... and after the testers and the two that never cured right, what did the batch really cost per candle you can sell?
Most candle spreadsheets stop at a recipe card or a sales list. This one runs the whole business: every candle is priced from its true ingredient cost at your target margins — wholesale and retail — every batch turns into a cost per sellable candle, wax and jars flag themselves before you run out mid-pour, finished stock counts itself from your batches and your sales, and the month rolls into a profit-and-loss by itself. In the sample month inside, the studio sells 136 candles for $1,608 and keeps $463.61 — and one candle, priced by eye at $18.00, sits BELOW its target margin the whole time, flagged in red from the day it was priced. Guessed prices hide. This sheet does the math out loud.
Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.
THE 8 TABS
• Start Here + Dashboard — plain-English quick start, the two settings that run the whole sheet (your target retail margin % and your target wholesale margin %), and a live dashboard: units sold, revenue, your best-margin product, material lines flagged low and finished products at reorder
• Product Cost Calculator — the pricing heart: one row per candle — wax (oz × cost per oz) + fragrance (oz × cost per oz) + wick + vessel + lid + label + packaging add up to the unit cost by formula; wholesale price and retail price each figure themselves from the cost at your target margin for that channel; and the margin on the price you actually charge is shown and flagged AT TARGET or BELOW TARGET
• Batch Log — one row per pour: date, product, batch size, units poured, units sellable after cure and testers, and the batch material cost — cost per sellable unit figures itself, so testers and cure losses land where they belong
• Materials Inventory — wax, fragrance oils, jars, wicks and packaging: cost per unit, on hand, par level, the exact amount to order, an OK / ORDER SOON / OUT flag, and your total stock value
• Finished Goods Inventory — one row per candle: opening stock plus sellable candles pulled from your Batch Log, minus units sold pulled from your Sales Log — on hand and the REORDER flag figure themselves
• Sales & Orders Log — one row per order: date, product, channel (retail, wholesale or market), units, price each, revenue by formula, and fees — and a COGS column that prices every sale at that candle's true unit cost
• Price List — your shelf-ready list: per product, the unit cost, wholesale price, retail price and both margins, every number pulled by formula from the Cost Calculator
• Expenses & Monthly P&L — log what the business spends, and the monthly P&L rolls revenue, COGS (units sold × unit cost), sales fees and expenses into profit and profit margin by month, by itself
HOW THE MATH WORKS — ONE METHOD, NO HIDDEN MATH
Unit Cost = wax (oz × cost per oz) + fragrance (oz × cost per oz) + wick + vessel + lid + label + packaging, added up line by line on the Cost Calculator — nothing else is folded in. Wholesale Price = unit cost ÷ (1 − your wholesale target margin) and Retail Price = unit cost ÷ (1 − your retail target margin), so at either suggested price the margin you aimed for is the margin you keep. Your Actual Price is always yours to set — the sheet just shows you the true margin it really earns and flags anything below your retail target. Batch costing works the same honest way: Cost per Sellable Unit = batch material cost ÷ units sellable after cure and testers, not units poured — testers are real candles you paid to make, so their cost is carried by the candles you can actually sell. The manager starts at a 60% retail target and a 40% wholesale target; change either in one shaded cell on Start Here and every price, margin and flag follows it.
THE SAMPLE MONTH
It comes loaded with one fictional month (Ember & Oak Candle Co., October 2026 — 3 candle products, 4 batches, 12 orders across retail, wholesale and market) so you can watch every formula work before you delete the samples and type your own: the Autumn Ember costs $5.55 a candle and prices itself to $9.25 wholesale and $13.88 retail, batch 1 works out to $5.95 per sellable candle, the Citrus Cedar fragrance oil sits OUT on the materials shelf, and October closes at $463.61 profit on $1,608 of sales. Formulas are pre-filled down the columns — 30 batch rows, 30 materials rows, 40 sales rows, ready to go.
FINISHED FILE — This listing is a digital item, delivered instantly as a file at checkout. The file is finished and ready to use — nothing is customized or personalized. If anything ever breaks or a formula misbehaves, message us and you will receive a corrected file free — forever, no time limit.
REQUIREMENTS: a free Google account. Your manager lives in Google Sheets — nothing to install, and your price list is right there on your phone at the market table. (The file also opens in Excel.)
This is a digital product — no physical item will be shipped, and all sales are final (we can't accept returns or cancellations on digital downloads). Your files are available instantly after checkout. But don't worry: if anything isn't working right, message us anytime and we'll fix it for you — no time limit.
Share
