What this does that no other jewelry template does: it prices a piece the way a real jeweller does. It takes the metal-only weight (your gross weight minus the weight of the stones), multiplies by today's spot price per gram and the fineness of the karat, adds the stones (carat × price per carat) and a making charge, and gives you the true cost of the piece — then the margin, the markup, the price to hit a target margin and the margin left after a markdown. Almost every "jewelry inventory" template on the market treats a diamond ring like a t-shirt with one flat cost; this one models gold, karat, stones and labour separately, so your prices are right to the cent.

It also does the thing jewellers need at the counter that spreadsheets never include: a buy-back / scrap calculator. Enter the metal, karat and weight a customer brings in, and it nets out the stones and pays your buy-back percentage of the real metal value — so you never overpay for gold. Change one spot price on the Reference sheet and every piece, every buy-back and every margin recalculates instantly.

And it is a complete shop, not just a calculator. A real stock room values every piece at cost, shows sell-through % so you can see what moves, and flags each SKU OK, REORDER or OUT OF STOCK from your own sales pace and supplier lead time. The Sales sheet logs each day; the Dashboard adds it all up — revenue, cost of goods, gross profit and margin, net after fixed costs and the tax to set aside, stock value and which pieces earn the most. Margin and markup are shown side by side and named correctly (a 100% markup is only a 50% margin), so you never confuse the two again.

Built for Excel 2016+ and Google Sheets with classic, compatible formulas only — no macros, no add-ons, nothing locked. Any currency (one symbol cell). The purity table (24K, 22K, 18K, 14K, 9K, silver 925/999, platinum) is pre-filled; you set the spot prices. Sample data for a real jeweller is filled in so every number and the chart are alive on first open; clear the yellow cells and it is yours. Every headline figure in this listing was measured from the built file, recalculated by LibreOffice and checked against an independent model of the same arithmetic.