How to Manage Consignment Inventory as a Jewelry Retailer

Consignment is one of the oldest practices in the jewelry industry. A vendor places pieces in your store — bridal sets, designer watches, fashion collections — and you display and sell them on their behalf. When a piece sells, you pay the vendor their agreed share and keep the margin. When it doesn't sell, you return it. On paper, it's simple. In practice, it's one of the most operationally complex aspects of running a jewelry store, and most retailers are managing it with spreadsheets, email chains, and good intentions.

What Consignment Means Operationally

The core mechanic is straightforward: a vendor places goods in your store, you try to sell them, and you settle up periodically. But the details multiply fast. Each vendor has different payout terms — some want 70/30, others 60/40, some negotiate per-piece. Return windows vary: 90 days, 180 days, or open-ended with quarterly reviews. Insurance requirements differ by vendor. Some vendors want monthly statements; others want real-time visibility into what's sold. Some allow you to discount their pieces; others have strict minimum advertised pricing. When you're working with five or ten consignment vendors simultaneously — which is typical for an independent jeweler — the matrix of terms, deadlines, and obligations becomes genuinely complex.

The physical tracking layer adds another dimension. Consignment pieces sit in your cases alongside your owned inventory and your memo goods, but they have fundamentally different rules. You can't send a consignment piece out for modification without vendor approval. You can't transfer it to another location without updating the consignment agreement. If a consignment piece is damaged or lost, the financial liability falls on you, and the terms of that liability are defined in the consignment contract — not in your insurance policy's general coverage. Every consignment piece in your store is simultaneously an opportunity and a liability, and you need to treat it as both.

The Accounting Treatment Most Retailers Get Wrong

Here's where consignment trips up even experienced retailers: consignment inventory does not belong on your balance sheet as an asset. You don't own it. It's not yours. It should not inflate your inventory valuation, and it should not appear as a current asset on your financial statements. When a consignment piece sells, the vendor's share becomes a liability — an amount you owe — and your margin becomes revenue. This distinction matters for tax purposes, for loan applications, for insurance valuations, and for any scenario where someone needs to understand what your business actually owns versus what it's holding on behalf of others.

The MJSA (Manufacturing Jewelers and Suppliers of America) and industry accounting professionals have long emphasized the importance of proper consignment classification, but the reality is that many jewelers still lump everything together because their software doesn't support the distinction. When your POS has one inventory bucket and no ownership-type field, the accounting treatment is wrong from day one.

Why Spreadsheets Fail

Jewelers who recognize the complexity of consignment often try to manage it in spreadsheets. They build elaborate workbooks: one tab per vendor, columns for piece descriptions, cost, retail, date received, date sold, amount owed, amount paid. It works for a while — maybe a few months, maybe a year. Then a vendor sends twenty new pieces and someone forgets to add them. A piece sells and the spreadsheet doesn't get updated until the following week. A vendor changes their payout terms and the formula doesn't get adjusted. Two pieces get returned but one stays on the spreadsheet. Slowly, inevitably, the spreadsheet drifts from reality. By the time the quarterly vendor reconciliation comes around, you're spending a full day cross-referencing the spreadsheet against POS sales records, vendor invoices, and physical inventory — exactly the kind of work software should eliminate.

The disputes that arise from spreadsheet-managed consignment are predictable and damaging. A vendor says you owe them for a piece you believe was returned. You say a piece was sold at a discount the vendor approved verbally but never confirmed in writing. The vendor claims a piece has been in your store for 200 days; your records show 160. Each dispute erodes the vendor relationship, and vendor relationships are the foundation of consignment. When vendors stop trusting your reporting, they stop placing goods in your store. When they stop placing goods, your cases get thinner and your selection suffers. The spreadsheet isn't just inefficient — it's a relationship risk.

What Software Should Handle

Proper consignment management software needs to handle several things natively, not as workarounds. First: per-vendor tracking with individual terms. Every consignment relationship has its own payout percentage, return window, and settlement schedule. The system should store these terms at the vendor level and apply them automatically when a piece sells. No manual calculations, no formula errors, no looking up the agreement to check whether this vendor is 70/30 or 65/35.

Second: automatic payout calculations and reporting. When the month ends, the system should generate a vendor statement showing every piece that sold, the sale price, the vendor's share, and the total owed — with zero manual input. The Jewelers of America has consistently recommended that retailers maintain transparent, auditable vendor payment processes, and automatic payout reporting is the most reliable way to achieve that.

Third: aging reports for unsold consignment. You need to know which pieces have been sitting in your cases for 30, 60, 90, or 180 days without selling. Aging data drives critical decisions: should you return slow-moving pieces to free up case space? Should you negotiate a discount with the vendor? Should you move the piece to a different showcase or feature it in a promotion? Without aging reports, consignment pieces quietly accumulate, occupying valuable case real estate while generating no revenue — and you don't notice until the vendor asks for a status update.

Fourth: digital signatures and agreement tracking. Every consignment relationship should start with a signed agreement specifying terms, insurance requirements, and return conditions. Your software should store these agreements, attach them to the vendor record, and reference them when calculating payouts. When a dispute arises — and disputes will arise — you should be able to pull up the signed agreement, the payout history, and the current inventory status in under a minute. Not in a filing cabinet. Not in an email thread from eight months ago. In the system, attached to the data it governs.

Real-Time Reconciliation, Not Monthly Surprises

The ultimate goal of consignment management software is simple: at any given moment, you should be able to answer four questions without opening a spreadsheet. How many consignment pieces do I have from each vendor? What has sold and what do I owe? What's been here the longest without selling? And what's my total consignment liability right now? If answering any of those questions requires exporting data, cross-referencing files, or calling someone in accounting, your system is failing at a basic level. Consignment is too important — and too financially sensitive — to manage with tools that weren't designed for it. The jewelry industry runs on trust between retailers and their vendor partners. Your software should make that trust auditable, automatic, and effortless.