The stone that sat for two years
Dead stock costs nothing you can see and everything you can’t. How to run an aging report that means something, and why another month isn’t a decision.
The Gemercel team
Diamonds, manufacturing, and the system behind the counter
In this note
There’s a ring in the second case from the register that you could find with your eyes closed. Yellow gold, oval halo, a stone you picked yourself at a show because you liked the color better than anything else in the parcel that day. The tag read $4,200 the week it went in the case. It reads $4,200 today. Nobody has asked about it since spring, and somewhere along the way you stopped seeing it — which is exactly the problem, because you still dust the glass around it every week.
Dead stock doesn’t send you a bill. Nothing beeps when a piece turns a year old. That’s what makes it the most expensive thing in your store: it costs you money precisely because the cost is invisible — cash tied up in a setting instead of doing anything, a spot in the case that a piece which actually turns could be using instead, a debt that never shows up until you go looking for it.
Run the aging report like you mean it
An aging report isn’t complicated. Pull every piece by the date it came into stock — not the date you last dusted it, not the date you think you remember — and sort by days on hand. What matters is that the buckets mean something, instead of being round numbers for their own sake:
- Zero to ninety days. New. This is what a normal buying season looks like on the shelf, not a warning sign.
- Ninety-one to one hundred eighty days. The piece has stopped being new and started being furniture. Worth a look. Not yet a panic.
- One hundred eighty-one to three hundred sixty-five days. Something should already have happened here — a markdown, a re-tag, a call to the customer who almost bought it back in the spring.
- Past three hundred sixty-five days. This is dead stock, not “slow.” It has outlasted a full buying season and the case never noticed.
Sort within each bucket by what the piece cost you, not what the tag says it’s worth. Cost is the number that’s actually tied up. Retail is just what you’re hoping happens next.
The piece you paid the most for is the one you won’t touch
Here’s the part no report shows you. You remember exactly what you paid for that ring. You remember the show, maybe the dealer, maybe the argument you had with yourself before you bought it. Marking it down feels like admitting the buy was wrong, so the priciest, most personal piece in the case gets protected from the discount pile precisely because it deserves that protection least.
That’s backwards. The $4,200 ring sitting still is costing you more every month than the $400 pair of earrings next to it — not because it’s worse, but because there’s more of your money frozen inside it. The size of the number is exactly why it should be the first thing you look at on the report, not the last.
What two years actually costs you
Say that ring cost you $2,400 — cash, no memo, no terms, just money that left your account and turned into a ring. For two years, that $2,400 has been sitting in a case instead of turning over into something else, or sitting anywhere that pays you for the use of it. If money left alone in your business would reasonably earn something elsewhere — call it eight percent a year, just as an example — two years of that $2,400 tied up is close to $400 in cost before you’ve counted a dime of insurance or case space.
Now weigh that against moving it. Mark it down twenty-five percent, from $4,200 to roughly $3,150, and you still clear $750 over cost — today, in a customer’s hand, funding the next buy instead of sitting under a display light. The holding cost is real money. The markdown is smaller money. Run that comparison honestly and there isn’t much of an argument left.
Five moves, roughly in order of how much you give up
- Reset the tag. Keep the setting, keep the stone, reprice it at today’s metal and stone cost instead of the number it was built at years ago. Sometimes that alone moves it out of the “too expensive, looks old” pile a customer has been quietly putting it in.
- Break it and reuse the stones. Pull the center stone and any melee, send the mounting to scrap, and let that stone go into a special order or a fresh setting instead of staying married to a ring nobody wants.
- Send it to a bench for a re-style. A dated setting on a good stone is an easy win for a bench jeweler — new prongs, a new profile, a metal change — sold as a piece that looks like it was made this year, because now it was.
- Trade it back. If it came from a supplier who still deals in that shape and quality, ask whether they’ll take it against something that will actually move. You give up a little on the swap. You gain a stone that isn’t costing you a monthly charge just for existing.
- Take the loss and free the money. Mark it to whatever number sells it this month, treat that number as the real one, and stop paying rent on a decision you already know you need to make.
Put a date on it
None of this works as a one-time cleanup. The ring in the second case didn’t get old in a week, and it won’t get sold by one inspired Tuesday, either. What works is a standing date — the first Monday of the month, say — where you pull everything past a set age and every piece on that list leaves the meeting with a decision attached to it.
A decision is one of the five moves above, or a specific, dated reason to hold. “This one’s spoken for — a repeat customer’s anniversary in six weeks” is a decision. “It’ll sell eventually” is not; it’s just this month again with a different date on the calendar. The point of the standing date isn’t which choice you make. It’s that a choice gets made on your schedule, instead of an audit finding it for you two years later.
This is the same discipline Gemercel builds into the books it runs for a store: every piece carries the date it came in, aging views that surface a stone before it turns a year old instead of after, and pricing that updates from real metal and stone costs instead of a tag nobody has touched since it was written. If your oldest pieces only get looked at during a slow week, put your store on the list.