Your spreadsheet is not the problem. It is worth saying that first, because a lot of advice on this subject opens by implying that anyone still on a sheet is disorganized, and that has never been true. Spreadsheets are one of the great tools of the last fifty years. Yours is probably a genuinely impressive piece of work — color-coded, formula-driven, built over two Sundays and one very determined evening in January.
The problem is that a candle catalog grows by multiplication and a spreadsheet grows by copy-paste, and those two things diverge quietly, in your favor, right up until they don't.
The short version: stay on the sheet while your line is small and your components are few — one wax, a handful of scents, one vessel. Move to inventory software once at least two of these three are true: a supplier invoice means editing the same number in several places, your wax purchases and your candle count stopped agreeing months ago, or you cannot say what you are able to pour this weekend without going and counting. Candle making runs into all three quickly, because scents multiply against vessels, wax leaves the building in ways no invoice records, and the item that limits your Saturday is often not the one you were watching.
Twelve scents is not twelve things
Here is the arithmetic that makes a candle catalog behave differently from a flat list of products.
You launch with four scents in one nine-ounce jar. Four SKUs, four rows, one lovely sheet. Two years later you carry twelve scents, and because customers kept asking, you offer each in three sizes — a four-ounce tin, the nine-ounce jar, and a sixteen-ounce three-wick.
You did not add eight things. You added thirty-two. Twelve scents across three vessels is thirty-six sellable items, each with its own wax weight, its own fragrance weight, its own wick, its own label, and its own price.
But — and this is the part the sheet cannot see — those thirty-six items are built from roughly twenty things you actually buy:
| Component type | Distinct items you purchase | Finished SKUs each one touches |
|---|---|---|
| Wax | 1 | 36 |
| Fragrance oil | 12 | 3 each |
| Vessel | 3 | 12 each |
| Wick | 3 | up to 12 each |
| Lid (one fits two vessel sizes, one fits the third) | 2 | 24 and 12 |
| Label stock, printed 36 ways | 1 | 36 |
Thirty-six rows describing twenty-two purchases. Every one of those rows carries a copy of a cost that lives somewhere else — and copies are how a workbook lies to you without ever containing a mistake.
Labels are the one row in that table that can scale with the catalog: buy pre-printed labels per design rather than printing onto blank stock and they become thirty-six purchases instead of one. The table above assumes blank stock, which is why its total sits at twenty-two. Every other row stays flat while the SKU count multiplies — which is exactly what points at the fix, and it is a structural one rather than a tidier workbook. Stop modeling thirty-six finished candles and start modeling the components they share, then let each candle reference them.
One wax invoice, thirty-six edits
Your soy supplier raises the case price. It happens; freight moves, crops move, everything moves.
In a sheet where each finished candle has its own cost block, that single invoice is thirty-six edits. Not thirty-six difficult edits — thirty-six boring ones, which is worse, because boring is what gets abandoned at edit nineteen when someone needs the car keys. You come back the next day genuinely unsure whether you finished, and the answer is stored nowhere, so you either redo all thirty-six or accept that some unknown subset of your prices is now built on last quarter's wax.
Neither of those is a decision. Both of them are a Tuesday.
"But my sheet uses a lookup table"
Some of you are already objecting, and you are right to. A well-built workbook can store the wax price once and have every SKU reference it. VLOOKUP exists. So does a components tab. So does the person reading this who built exactly that and maintains it beautifully.
If that describes you, this section genuinely does not apply, and you should be a little smug about it. But be honest about the failure mode: a sheet with proper references does not stay that way on its own. It stays that way because you keep it that way. Six months of a busy Q4, one urgent price test typed straight into a cell, one tab duplicated as a backup and then quietly edited, one collaborator who did not know the rule — and the single source of truth becomes three sources of truth with no error message anywhere.
That is the real difference, and it has nothing to do with formulas. Software enforces the structure. A spreadsheet asks you to. Under pressure — and a candle business has a season that supplies plenty of it — those are not the same offer.
Where six pounds of wax went
This is the one that is easiest to miss, so here it is with numbers.
Say you bought one 45-pound case of soy over a quarter — 720 ounces. Your nine-ounce jar takes 6.5 ounces of wax, a fill line you decided once and have never improvised on. Ninety-six candles from that case reached your shelves as sellable stock.
The recipe says those 96 candles consumed 624 ounces. You bought 720. Here is the missing 96 ounces:
| Where it actually went | Ounces |
|---|---|
| Candles that became sellable stock (96 × 6.5 oz) | 624.0 |
| Residue in the pour pitcher and melter (12 sessions × 4 oz) | 48.0 |
| Wick-test pours for the new vessel (6 candles) | 39.0 |
| One candle kept for the shop shelf | 6.5 |
| Spill, scrape, and rounding | 2.5 |
| Case total | 720.0 |
Now divide the other way. Seven hundred twenty ounces of wax bought, ninety-six candles sold: 7.5 ounces of wax per sellable candle. Your recipe says 6.5. Your bank statement says 7.5.
In this example that is a 15% understatement of wax cost on every candle sold, and it does not appear as a line item anywhere, because there is no line item for it. Your purchases live on one tab. Your production lives on another. A spreadsheet will hold both of those facts forever and never once subtract one from the other, because subtracting them is not a formula — it is a relationship, and relationships are the thing spreadsheets do not have.
Wax is the forgiving example, incidentally. Run the same reconciliation on fragrance oil, where the per-ounce cost is several times higher and half-used bottles go off on the shelf, and the gap stops being an accounting curiosity. (The full costing version of that exercise, per candle rather than per case, is in the candle cost math post.)
The Saturday you cannot pour for
It is Thursday. The market is Saturday. Cedar & Amber in the nine-ounce jar is your best seller and you are nearly out, so you check the sheet: 28 pounds of soy in stock. Plenty. You'll pour tomorrow.
Except a candle is not made of wax. It is made of six things, and you can only make as many as the scarcest one allows.
| Component | On hand | Per candle | Candles it supports |
|---|---|---|---|
| Soy wax | 448 oz | 6.5 oz | 68 |
| Cedar & Amber fragrance oil | 19 oz | 0.52 oz | 36 |
| 9 oz amber jar | 40 | 1 | 40 |
| Black lid | 60 | 1 | 60 |
| Label | 200 | 1 | 200 |
| Wick — the limiting item | 22 | 1 | 22 |
Twenty-two. Not sixty-eight. Your Saturday was decided by the cheapest line on the entire bill of materials, and you found out about it thirty-six hours before the market, in the least useful possible way — by walking to the shelf.
Notice what the sheet did wrong here, because it is subtle: nothing. Every number in that table was in the workbook. All six of them were correct. What was missing was the single operation that turns six correct numbers into one useful one, and no spreadsheet performs that operation unless you build it, per scent, per vessel, and rebuild it every time your recipe changes.
The tell: if you cannot say what you are able to pour this weekend without going and counting, you do not have an inventory list. You have six inventory lists that have never been introduced to each other.
When the spreadsheet is genuinely the right answer
None of this makes spreadsheets bad, and plenty of candle businesses should stay exactly where they are. The honest test is not revenue and it is definitely not what anyone on the internet says a real business uses:
| Stay on the sheet if… | Start looking if… |
|---|---|
| One wax, one vessel, a handful of scents | Scents multiplied against sizes, and the SKU count has a "times" sign in it |
| You buy from one or two suppliers, rarely | Component prices move often enough that you have stopped repricing |
| You pour to order, or close to it | You pour to a forecast and guess at the shopping list |
| You can see your whole component shelf from one spot | Components live in a garage, a closet, and a shelf at a friend's |
| Maintaining the sheet is genuinely satisfying | You have quietly stopped reconciling and hope nobody asks |
One row on the right is a nuisance you can absorb. Two or more deserves the same urgency as the three signs at the top of this post: the sheet has stopped saving you time.
If you are in the left column, close this tab and go pour something. It is a legitimate answer, and it will stay legitimate for as long as it is true.
What moving actually involves
Less than you'd think, and considerably less than rebuilding the sheet a fourth time. Your waxes, fragrance oils, vessels, wicks, and their costs export to CSV, which is precisely what inventory software imports.
Inside Ardent Seller, the three problems above have three specific answers:
- Variants generated, not typed. You define twelve scents and three vessels; the thirty-six SKUs and their structured codes are generated from those attributes rather than copied down a column. Adding a fourth vessel adds twelve items without adding twelve opportunities to mistype a cost. Reusable wax bases and fragrance blends are built once as subassemblies and shared across the whole line.
- Production runs that decrement. Pouring a batch draws the wax, fragrance, wicks, and vessels it consumed out of stock and stamps the run with a lot. The 6.5-versus-7.5-ounce gap stops being invisible, because the wax leaving inventory is the wax that actually left.
- The scarcest-component question, answered before Thursday. The Season Readiness report projects a selling window from your sales in the same window last year, nets out what you hold, and explodes the rest through your recipes into a shopping list dated against each supplier's lead time. It reads one level deep, so a wax-base subassembly lands on the list rather than the raw wax behind it. It is the Cedar & Amber table above, run for your whole catalog, in October rather than on pour night.
The sensible way to test any of it is in parallel. Rebuild one scent in all its vessel sizes, run it beside the sheet for a few weeks, and see which one tells you the truth about what you can build. That costs an evening on the free tier (plan details), and there is a craft-neutral version of this whole argument at spreadsheets vs. Ardent Seller if you want the general case.
You already do the harder version of this discipline every time you pour. You do not eyeball the fragrance in and hope — you weigh it, to the tenth of an ounce, because the difference between 8% and 11% is the difference between a candle and a complaint. The business side deserves the same scale. It is only that the consequences arrive slower, and disguised as a busy quarter.
Weigh the business the way you weigh the pour. Start free, rebuild one scent, and find out what you can actually make on Saturday.
Related reading
- Candle Maker's Cost Math — What one candle actually costs, worked from the wax up: fill line, fragrance load percentage, vessel, wick, labor, and the per-channel prices that follow from it.
- Why Is My Candle Tunneling? — The diagnostic for the wick-and-vessel side of the same catalog: why a wick that works in one jar fails in the next size up.
- Spreadsheet Breakup — The craft-neutral case: the signs any maker business has outgrown Excel, what switching genuinely costs, and how to choose what replaces it.
Free resources
Free companion downloads if you want to put any of this into practice:
- Spreadsheet vs Inventory Software: The Decision Guide — A self-assessment scorecard and migration checklist, so the stay-or-switch call in the table above gets made on evidence rather than on how the workbook made you feel last Tuesday.
- Monthly Inventory Count Sheet — A printable sheet with expected, actual, and variance columns for raw materials, finished goods, and packaging — the paper version of the wax reconciliation above, which is how you find your own 6.5-versus-7.5 number.
- Fragrance Load Calculator — Typical and maximum load percentages for eighteen waxes and bases, plus the exact fragrance weight and per-unit fragrance cost for a given batch size, which is the number that sets the fragrance row in the scarcity table.
This article is provided for educational purposes only and does not constitute financial, tax, or business advice. Component costs, batch quantities, and the reconciliation figures above are illustrative and will vary by your own materials, fill lines, and suppliers. Consult a qualified accountant or small-business advisor before making financial decisions based on this content.