Skip to main content

Silversmith and Handmade Jewelry Maker Bookkeeping: Why Recipe-Based COGS Beats a Spreadsheet Guess

8 min readMike ThriftMike Thrift
Silversmith and Handmade Jewelry Maker Bookkeeping: Why Recipe-Based COGS Beats a Spreadsheet Guess

Gold hit roughly $4,200 an ounce in mid-2026, up more than 50% from the 2025 average, and silver isn't far behind, with forecasts pointing to nearly double its prior-year price. If you're a silversmith or jewelry maker still pricing pieces off "what I paid for that spool of wire six months ago," you are almost certainly losing money on every sale — and you might not find out until your supplier bill outpaces your revenue for the month.

Jewelry is one of the few handmade crafts where the raw material itself is a volatile, actively traded commodity. A potter's clay costs roughly the same in December as it did in June. A silversmith's metal does not. That difference changes how you have to think about cost of goods sold (COGS), and it's why the bookkeeping habits that work fine for candle makers or knitters can quietly bankrupt a jewelry business.

The Core Mistake: Costing at Purchase Price, Not Replacement Price

Most new jewelry makers cost a piece using whatever they paid for the materials when they bought them. It feels intuitive — you paid $38 for that ounce of fine silver, so that's the cost, right?

The problem is timing. Say you bought a stock of silver at $32/oz in January. You use it to make and sell rings all spring. By July, silver has climbed to $42/oz. If you're still pricing new orders off your January cost, every ring you sell today is underpriced by the amount silver has appreciated — and when you go to restock, you'll pay today's price with revenue that was calculated on yesterday's cost. This is exactly the trap the trade press has been flagging jewelers about in 2026: metal prices fluctuate, and most small shops absorb the increase silently instead of repricing, slowly bleeding margin with every sale.

The fix is to always cost materials at their current replacement price — what it would cost you to buy that same gram of silver or gold today — not what you originally paid. Your pricing should answer "what does it cost me to make this piece again right now," not "what did this piece cost me historically."

This matters for two separate numbers that often get confused:

  • Pricing decisions (what you charge a customer today) should always use current replacement cost.
  • Historical COGS on your books (what you record as the cost of an item you already sold) should reflect what you actually paid for the specific material lot that went into that piece — otherwise your profit-and-loss statement doesn't match reality.

Keeping these straight is exactly why "recipe-based" costing works better than a running spreadsheet guess.

What Recipe-Based COGS Actually Means

A recipe, in this context, is a fixed bill of materials for a specific design: 4.2 grams of sterling silver, one 6mm labradorite cabochon, 30 minutes of bench time, 2 jump rings, and a length of chain. Once you've defined the recipe for a design, you can reprice every future unit of that design in seconds just by updating the current metal price — instead of re-deriving the whole cost from scratch every time you quote a custom order.

Compare that to the common alternative: a spreadsheet where each sale gets its own ad hoc cost estimate, entered by memory or a rough eyeball of "probably about $15 in materials." That approach has three failure modes:

  1. It drifts. Estimates creep toward round numbers ("call it $20") that stop reflecting reality as metal prices move.
  2. It hides your best and worst sellers. Without a consistent per-design cost, you can't tell whether your bestselling earrings are actually your most profitable item or just your most popular one.
  3. It breaks at tax time. A rough guess for each of 200 sales during the year is much harder to defend under audit than a documented recipe applied consistently.

Recipe-based costing solves all three: define materials + labor + overhead once per design, store it as a line-item breakdown, and multiply by current prices whenever you need a quote or a COGS entry.

Building the Recipe: Materials, Labor, and Overhead

Materials. List every component with weight or quantity: metal grams (by karat/fineness — 14k, sterling, fine silver all price differently), stone or bead costs, findings, chain, packaging. Track metal in grams or troy ounces consistently, since suppliers quote in both.

Labor. Set an hourly rate for yourself and estimate bench time per design, even roughly. Skipping labor cost is the single most common way makers end up "profitable" on paper while effectively paying themselves nothing. Design time, sketching, and problem-solving on a custom commission count as labor too, not just the physical fabrication.

Overhead. This is the bucket most jewelry makers forget entirely: studio rent or the portion of your home used as a workspace, electricity for kilns and torches, tool maintenance and replacement (files, burs, polishing compounds wear out), insurance, website hosting, marketing, and packaging. A common approach is to allocate overhead as a percentage of labor cost or materials cost — say, 10–15% — so it scales naturally as your production volume changes.

Markup Formulas by Sales Channel

Once you have a true cost (materials + labor + overhead), the markup you apply depends heavily on where you're selling:

  • Direct-to-consumer (your own site, in-person, craft fairs): a common baseline is (Materials + Labor) × 2 + Extras = Retail Price, targeting a 50–67% gross margin.
  • Etsy and other marketplaces: apply a higher multiplier — often 3x to 4x cost — to absorb transaction fees, payment processing, and ad spend, which together can eat 10–12% of a sale before shipping is even factored in.
  • Wholesale: keep your base cost at or below roughly 25% of eventual retail price, since wholesale customers typically pay about half of retail, and you need room for their markup too.
  • Fine jewelry with expensive materials: use a lower multiplier (roughly 1.2–1.5x) on the metal and stone cost specifically, since doubling the cost of a $2,000 diamond makes the piece unsellable — then apply a normal 2x multiplier to labor and overhead.

A trap worth naming directly: don't benchmark your prices against Etsy search results. A large share of Etsy sellers are underpricing relative to their true costs, often because they never accounted for labor or overhead in the first place. Matching an unprofitable competitor's price just means you're both losing money — you're only copying their homework, and their homework is wrong.

Recording Metal Price Swings on the Books

Beyond pricing, jewelry makers need a bookkeeping habit most other craft businesses don't: reconciling inventory value against a commodity that moves daily. A few practical patterns:

  • Track metal inventory separately from finished-goods inventory. Raw silver/gold stock and completed pieces should sit in distinct accounts so you can see how much value is tied up in unworked metal versus inventory ready to sell.
  • Revalue on a schedule, not ad hoc. Pick a cadence — weekly or monthly — to check current spot price against your book value for on-hand metal, rather than reacting every time you notice a price move in the news.
  • Review your recipe prices every 6–12 months at minimum, and more often during a sharp move like 2026's gold and silver rally. A recipe that was profitable in January can be underwater by July if you haven't touched it.

This is where plain-text, version-controlled bookkeeping has a real edge over a spreadsheet or a black-box app: every price update and every COGS entry is a discrete, timestamped change you can diff against the last one. You can see exactly when you last repriced a design and what the metal cost was at the time, instead of wondering whether "the spreadsheet" is even up to date. Beancount.io lets you define an account for raw metal inventory, another for finished goods, and post entries as prices move — the same double-entry discipline larger jewelry businesses use, just without the overhead of dedicated jewelry ERP software. See the docs for how to set up inventory and cost-basis tracking.

A Simple Recipe Costing Example

Here's how it looks in practice for a sterling silver ring with a small gemstone:

Line itemDetailCost
Sterling silver4.5g at current $1.10/g$4.95
Gemstone (cabochon)1 unit$6.00
Findings (jump ring, backing)$0.75
Labor40 min at $25/hr$16.67
Overhead (12% of labor + materials)$3.40
Total cost$31.77
Direct-to-consumer price (2x + $5)$68.54
Etsy price (3.5x)$111.20

Update one number — the silver price per gram — and every recipe using sterling silver repriced instantly across your entire catalog, without re-deriving each design from scratch.

Simplify Your Financial Management

Jewelry pricing is unusually sensitive to input costs that move daily, which makes disciplined bookkeeping the difference between a hobby and a sustainable business. Beancount.io offers plain-text accounting that's transparent, version-controlled, and easy to audit — so you can see exactly how a metal price swing worked its way through your inventory and margins, instead of guessing. Get started for free and bring the same rigor to your studio's books that you already bring to your bench work.

Share this article