Gold and Diamond Stock Management: Complete Guide for Jewelry Brands

Introduction: The Challenge of Managing Precious Materials

For a jewelry brand that outsources its production, managing raw materials is a complex daily challenge:

💰 An expensive stock: 100g of 18K gold = ~6000EUR, and you probably have several kilograms 📍 Geographically dispersed: At your location, at manufacturer A, at manufacturer B, in transit... 📊 Variable valuation: The price of gold changes every day 🔒 Mandatory compliance: RJC certification requires total traceability ⚖️ Invisible losses: Between the gold sent and the scraps returned, where did those 3 grams go?

This guide gives you the methods and tools to transform this complexity into total control.

1. Understanding the Stakes of Precious Materials Management

Materials Concerned

Precious Metals:

• Gold (18K/750, 14K/585, 9K/375) - The most common
• Platinum (950) - High jewelry
• Silver (925) - Accessible collections
• Palladium - Alternative to platinum

Diamonds and Stones:

• Certified diamonds (GIA, HRD, IGI) - Traceability by certificate
• Calibrated diamonds (0.01ct to 0.30ct) - Accounting by size/quality
• Colored stones (sapphires, emeralds, rubies)
• Semi-precious stones (amethysts, citrines, topazes...)

Financial Stakes

Concrete example for a mid-size brand:

Average Stock:

• 500g of 18K gold = 30,000EUR
• 200 diamonds of 0.02ct DEF/VVS = 8,000EUR
• 50 diamonds of 0.10ct GH/VS = 15,000EUR
• Total tied up: 53,000EUR

Possible annual losses without good management:

• 2% losses/errors on gold = 600EUR
• 3% losses/errors on diamonds = 690EUR
• Total avoidable losses: 1,290EUR/year (minimum)

But the real costs are elsewhere:

• ⏱️ 5-10h/week of manual management = 260-520h/year
• 💸 At 40EUR/h, that's 10,400 to 20,800EUR/year in hidden costs
• 📉 Stock-outs blocking productions = lost opportunity

Regulatory Obligations

RJC Certification (Responsible Jewellery Council):

If you are RJC certified (like Viltier and most serious brands), you MUST:

• ✅ Trace the origin of each gram of gold
• ✅ Document each material movement
• ✅ Prove the chain of custody (from supplier to finished product)
• ✅ Keep documents for at least 5 years

Non-compliance = loss of certification = loss of credibility

Kimberley Process (diamonds):

• Mandatory for imported rough diamonds
• Certificate of origin to prove "non-conflict"
• Possible audit by authorities

2. The Different Locations of Your Materials

Typical Mapping for an Outsourcing Brand

At your location (safe/office): 30-40% of stock

• Gold awaiting allocation
• Certified diamonds (important pieces)
• Safety reserve for emergencies
• Colored stones

At your manufacturers: 40-50% of stock

• Gold allocated to ongoing orders
• Diamonds sent for setting
• Material awaiting return (scraps)

In transit: 5-10%

• Shipments to manufacturers (value carrier)
• Returns from manufacturers
• Purchases being delivered

At your B2B clients: 5-10% (if consignment)

• Finished products on consignment
• To be counted in overall valuation

The problem: Without a tool, you don't know precisely who has what, and especially how much you have available.

3. Gold Management: Methods and Best Practices

The "Weight Account" System

What is it?

Rather than buying physical gold delivered, you open a weight account with a refiner (Metalor, Argor-Heraeus, PAMP...).

How it works:

1. You "credit" your account (e.g., purchase of 1 kg of 18K gold)
2. You request deliveries as needed (e.g., 50g to you, 100g to manufacturer A)
3. Scraps returned by manufacturers are re-refined and credit your account
4. You only pay for actual losses (refining ~1%, manufacturing losses ~2%)

Advantages:

• ✅ No massive physical stock to secure
• ✅ Fast deliveries (1-2 days)
• ✅ Optimized scrap recycling
• ✅ Valuation at daily rate (gain if rate rises)

Disadvantages:

• ⚠️ Minimum commitment (often 500g-1kg)
• ⚠️ Refining fees (1-2%)
• ⚠️ Dependency on one supplier

Calculating Requirements per Order

Traditional method (manual):

To make an 18K gold solitaire ring:

1. Consult the product nomenclature: "6.5g of 18K gold needed"
2. Add 10% for losses/adjustments: 6.5g x 1.10 = 7.15g
3. Multiply by the number of rings ordered
4. Check availability in your Excel spreadsheet
5. Order if insufficient (1 week delay)

Problem: Time-consuming, error-prone, impossible to scale.

Automated method:

1. The nomenclature is entered once and for all in the product
2. When creating an order, the system automatically calculates:
   • 10 rings = 71.5g needed
   • Current available stock: 120g
   • Stock after allocation: 48.5g
   • ⚠️ Alert if below minimum threshold (50g)
3. The gold is automatically "allocated" to this order (reserved)
4. When shipping to manufacturer, delivery note is generated
5. Upon return, stock is updated with scraps

Time savings: 30 minutes → 30 seconds (60x faster)

Managing Different Alloys

The mixability problem:

You probably work with several alloys:

• Yellow gold 18K (750/1000)
• White gold 18K (750/1000)
• Rose gold 18K (750/1000)
• Perhaps 14K gold (585/1000) for certain markets

Common mistake: Keeping a global "gold" stock without distinguishing alloys.

Best practice:

• Separate stock by alloy AND by location
• Example: "80g yellow gold 18K at your location + 120g yellow gold 18K at manufacturer A"
• Calculate needs by alloy (a rose gold ring cannot use your yellow gold)

Gold Stock Valuation

Valuation changes every day with the price of gold.

Concrete example (price as of November 22, 2024):

• Pure gold rate (24K): ~60EUR/gram
• 18K gold (75% pure): 60EUR x 0.75 = 45EUR/gram
• Stock of 500g 18K gold: 500 x 45EUR = 22,500EUR

If the rate rises to 65EUR/g:

• Your stock is now worth: 500 x (65 x 0.75) = 24,375EUR
• Latent gain: +1,875EUR (without doing anything)

If the rate drops to 55EUR/g:

• Your stock is worth: 500 x (55 x 0.75) = 20,625EUR
• Latent loss: -1,875EUR

Why is this important?

• 📊 Correct valuation of your balance sheet
• 💰 Calculation of real margins (cost price changes)
• 🏦 Bank guarantees (stock = collateral)

Best practice: Recalculate valuation monthly (or daily with an automated tool).

Scrap Return: Critical Process

The normal cycle:

1. You send 100g of 18K gold to the manufacturer
2. They make rings totaling 80g
3. They return 15g of scraps (filings, casting residues, etc.)
4. Gap of 5g = normal losses (acceptable: 3-7%)

Red flags:

• ⚠️ No scrap return from manufacturer
• ⚠️ Gap > 10% (possible theft or poor management)
• ⚠️ Late return (>30 days after delivery)

Best practice:

• Contractualize scrap returns (max delay, minimum expected weight)
• Document each shipment/return with signed delivery notes
• Track an average loss rate per manufacturer (benchmark)
• Automatic alert if abnormal gap

4. Diamond Management: Specificities and Complexities

Classification and Storage

Calibrated diamonds (melee):

Used for pave, halos, etc. Classified by:

• Size (diameter in mm, converts to carats): 0.01ct, 0.02ct, 0.03ct, 0.05ct, 0.10ct...
• Quality (color + clarity): DEF/VVS, GH/VS, IJ/SI...

Stock example:

• 100 diamonds 0.02ct DEF/VVS
• 50 diamonds 0.03ct GH/VS
• 20 diamonds 0.10ct DEF/VVS
• Etc.

Valuation:

• A 0.02ct DEF/VVS diamond: ~40EUR
• A 0.10ct GH/VS diamond: ~300EUR
• A 0.50ct DEF/IF diamond: ~5,000EUR

The challenge: Managing hundreds of diamonds of different sizes/qualities.

Certified diamonds (solitaires):

For important pieces (engagement rings, pendants...):

• Individual certificate (GIA, HRD, IGI)
• Unique number laser-engraved on the table
• Total traceability (origin, journey)

Storage:

• Each diamond = 1 line in your database
• Associated PDF certificate
• Status: Available / Allocated to order X / Set in product Y

Diamond Nomenclature per Product

The complexity problem:

A "halo solitaire" ring typically contains:

• 1 center diamond (0.50ct GH/VS)
• 12 halo diamonds (0.02ct DEF/VVS)
• 48 band pave diamonds (0.01ct GH/VS)
• Total: 61 diamonds of 3 different types

Multiply by 40 different products in your catalog, and you understand the puzzle.

The solution: Nomenclature integrated into the product

For each product, you define once and for all:

"Eternal" Ring:

• 1x Diamond 0.50ct GH/VS (center stone)
• 12x Diamond 0.02ct DEF/VVS (halo)
• 48x Diamond 0.01ct GH/VS (pave)

When creating an order for 10 "Eternal" rings:

• The system automatically calculates:
  • 10 diamonds 0.50ct GH/VS needed
  • 120 diamonds 0.02ct DEF/VVS needed
  • 480 diamonds 0.01ct GH/VS needed
• Checks availability in your stock
• Alerts if insufficient (supplier order time: 1-2 weeks)

Gain: You never calculate manually. Zero errors.

Traceability and Kimberley Compliance

Kimberley Process: What is it?

International certification system aimed at preventing "blood diamonds" (conflict diamonds) from entering the legal market.

Obligations:

• ✅ Certificate of origin for each lot of imported rough diamonds
• ✅ Keep certificates for 5 years
• ✅ Be able to prove the supply chain in case of audit

For polished diamonds:

• No direct Kimberley obligation (already polished)
• BUT: due diligence requirement on your suppliers
• Prefer RJC-certified dealers

Best practice:

• Systematically request an origin declaration from your suppliers
• Archive all documents (invoices, certificates, declarations)
• Implement a vetting procedure for new suppliers

Managing "Memos" (Diamond Loans)

What is a memo?

In the diamond industry, it is common to temporarily "lend" stones:

• You receive 10 diamonds from a dealer to evaluate
• You only pay for the ones you keep
• You return the others within 7-30 days

Advantages:

• ✅ You can evaluate real quality (photos are not enough)
• ✅ You don't tie up cash
• ✅ You only keep what interests you

Risks:

• ⚠️ Losing a memo stone (you have to pay full price)
• ⚠️ Confusion with your own stock
• ⚠️ Forgetting to return within deadlines

Rigorous management required:

• Keep a separate register of memos (NEVER mix with your stock)
• Status "On memo at our location" with return deadline
• Automatic alert 3 days before expiration
• Confirm each return (transport slip + dealer signature)

5. Integrated Management System: From Purchase to Finished Product

Complete Flow: Example of a 20-Ring Order

Phase 1: Order Creation

• Product: "Elegance Solitaire" Ring
• Quantity: 20 units
• The system automatically calculates:
  • Gold needed: 20 x 7g = 140g of 18K white gold
  • Diamonds needed:
    • 20 diamonds 0.50ct GH/VS (centers)
    • 240 diamonds 0.02ct DEF/VVS (halos)

Phase 2: Stock Verification

• Available 18K white gold stock: 200g → ✅ Sufficient
• 0.50ct GH/VS stock: 15 available → ⚠️ Missing 5
• 0.02ct DEF/VVS stock: 500 available → ✅ Sufficient

Automatic action:

• Alert: "Order 5 diamonds 0.50ct GH/VS minimum"
• Supplier suggestion based on history
• Estimated supply time: 1 week

Phase 3: Material Allocation

• Once the 5 diamonds received, automatic allocation:
  • 140g white gold allocated to order #2847
  • 20 diamonds 0.50ct allocated to order #2847
  • 240 diamonds 0.02ct allocated to order #2847
• These materials are no longer "available" for other orders

Phase 4: Shipment Preparation to Manufacturer

• Automatic generation of a delivery note:
  • 150g 18K white gold (140g + 7% margin)
  • Complete list of diamonds with references
• Value transport request (Brink's, Loomis)
• Automatic insurance (declared value)

Phase 5: Tracking at Manufacturer

• Status: "Material sent" → "Material received" (confirmed by manufacturer)
• For 3 weeks: "In production"
• Progress photos uploaded by manufacturer

Phase 6: Return and Reception

• 20 rings delivered + confirmed compliant
• Scrap return: 18g white gold (gap of 8g = 5.3% → ✅ Normal)
• Return of 3 unused 0.02ct diamonds (design adjustments)

Phase 7: Automatic Stock Update

• White gold stock: +18g scraps → 78g available
• 0.02ct stock: +3 diamonds → 263 available
• Alerts if below minimum thresholds

Total manual management time:

• Excel/Email method: 2-3 hours
• With automated tool: 15 minutes

Savings: 1h45 to 2h45 per order For 50 orders/month: 87 to 137 hours saved = 2-3 weeks of work!

6. Defining Your Alert Thresholds

Why Thresholds Are Critical

Without thresholds:

• You discover a stock-out when creating the order
• Supplier delay: 1-2 weeks
• Production blocked, unhappy client

With well-defined thresholds:

• Automatic alert when you go below the threshold
• You order BEFORE the stock-out
• No production blockage

How to Calculate Your Thresholds

General formula:

Minimum threshold = (Average consumption per week) x (Supplier lead time in weeks) x (Safety coefficient 1.5)

Example for 18K white gold:

• Average consumption: 50g/week
• Supplier lead time: 1 week (weight account) or 2 weeks (standard purchase)
• Safety coefficient: 1.5 (for unforeseen events)

Minimum threshold = 50g x 1 week x 1.5 = 75g

→ Alert when available stock goes below 75g

Example for 0.02ct DEF/VVS diamonds:

• Average consumption: 30 diamonds/week
• Supplier lead time: 2 weeks
• Safety coefficient: 1.5

Minimum threshold = 30 x 2 x 1.5 = 90 diamonds

Thresholds by Material Type

Tip: Adjust thresholds according to seasonality

• Higher before Christmas, Valentine's Day (peak season)
• Lower in summer (slow season)

7. Tools and Technical Solutions

The Manual Approach (Excel + Paper)

What this concretely involves:

Typical Excel file "Gold Stock Management":

• Tab 1: Yellow gold stock (columns: Date, Movement type, Quantity, Location, Balance)
• Tab 2: White gold stock
• Tab 3: Rose gold stock
• Tab 4: Movement history
• Tab 5: Valuation

For each order:

1. Open the Excel file
2. Calculate needs manually
3. Check the "Balance" line (hope it's correct)
4. Create a "Shipment to manufacturer X" line with date, quantity
5. Recalculate the balance
6. Generate a Word delivery note
7. Print, have it signed, scan, archive

Upon return:

1. Reopen the Excel file
2. Create a "Return from manufacturer X" line
3. Recalculate the balance
4. Compare with what was sent
5. Calculate the gap manually
6. If gap > 10%, send an email to manufacturer

Typical Excel file "Diamond Management":

• Even more complex (dozens of lines per type/quality)
• VERY high risk of error (one forgotten line = wrong stock)

Total time: 30-45 min per order just for stock management

Problems:

• ❌ Error-prone (omissions, double entries)
• ❌ No consolidated real-time view
• ❌ Impossible to share easily
• ❌ No automatic alerts
• ❌ Colossal time waste
• ❌ Non-RJC compliant (insufficient traceability)

Specialized ERP Modules

Traditional jewelry ERPs (PIRO, Jewely Retail, ODEIS) have "Materials Management" modules:

Features:

• ✅ Multi-location management
• ✅ Automatic needs calculation
• ✅ Real-time valuation
• ✅ Complete history
• ✅ Threshold alerts
• ✅ Accounting export

Limitations:

• ⚠️ High price (module often >300EUR/month on top of ERP)
• ⚠️ Complexity (significant learning curve)
• ⚠️ Rigidity (difficult to adapt to your specific processes)

Good for: Large structures with internal workshop and complex needs

Modern Collaborative Platforms

New generation of tools (like LIINK) natively integrate materials management:

Approach:

• Module integrated with order management system
• Automatic needs calculation when creating order
• Automatic allocation/release
• Traceability per order (which gold, which diamonds for which piece)

Advantages:

• ✅ Simplicity of use (no training needed)
• ✅ Integrated with rest of platform (no double entry)
• ✅ Price included (no separate module)
• ✅ Native RJC compliance

Good for: Mid-size brands without workshop, who outsource and want a simple and complete solution

8. RJC Compliance: Proving Your Traceability

Concrete RJC Requirements

RJC Code of Practices 2019:

Article 4.1: Supply Chain Due Diligence

"Members must implement a due diligence system to identify and assess risks in their gold and diamond supply chain."

Article 4.3: Traceability

"Members must be able to demonstrate the chain of custody of their precious materials from source to finished product."

Concretely, during an RJC audit, you must be able to:

1. Take a random finished product (e.g., "Eternal" Ring ref #2847-015)

2. Trace the entire chain:

   • Which order? (Order #2847)
   • Which manufacturer? (Dupont Workshop)
   • Which gold? (150g 18K white gold sent on 03/15/2025)
   • Where did this gold come from? (Metalor weight account, purchase of 02/01/2025)
   • Which diamonds? (20x 0.50ct GH/VS + 240x 0.02ct DEF/VVS)
   • Where did these diamonds come from? (Durand Dealer, invoice #45872 of 02/10/2025)
   • Is the dealer compliant? (RJC certification verified, due diligence OK)

3. Provide supporting documents:

   • Materials purchase invoice
   • Delivery note to manufacturer (signed)
   • Return note from manufacturer (signed)
   • Photos of final piece
   • Sales certificate to client (if applicable)

If you cannot provide this in less than 10 minutes for any product: → ❌ RJC non-compliance → Risk of certification loss → Impact on your image (RJC is a mark of seriousness)

How a Modern Tool Facilitates Compliance

With a well-designed digital system:

The auditor selects ring #2847-015.

You open the tool:

1. Search "2847-015"
2. Immediate access to order file
3. "Materials Traceability" tab:
   • List of all gold sent (with attached PDF delivery notes)
   • List of all diamonds (with attached supplier PDF invoices)
   • Photos of the piece at each stage
   • Manufacturer name + their RJC certificate (verified)
4. "Complete traceability file" PDF export in 1 click

Time: 2 minutes instead of 2 hours of digging through paper files.

9. Performance Indicators (KPIs) to Track

KPI 1: Stock Turnover Rate

Formula: Turnover rate = Annual consumption / Average stock

Example:

• Annual 18K gold consumption: 2,400g
• Average stock: 400g
• Turnover rate = 2400 / 400 = 6x per year

Interpretation:

• <4x: Stock too large (capital tied up)
• 4-8x: Good balance
• >10x: Stock too low (stock-out risk)

Goal: 5-7x for gold, 4-6x for diamonds

KPI 2: Material Loss Rate

Formula: Loss rate = (Material sent - Material in finished products - Scraps returned) / Material sent

Example:

• Gold sent to manufacturer: 200g
• Gold in the 25 delivered rings: 175g
• Scraps returned: 15g
• Losses = 200 - 175 - 15 = 10g
• Loss rate = 10g / 200g = 5%

Interpretation:

• <3%: Excellent (very professional manufacturer)
• 3-7%: Normal (acceptable)
• 7-10%: High (to monitor)
• > 10%: ⚠️ Problem (negligence or potential theft)

Goal: <5% on average

Action if exceeded:

• Discussion with manufacturer
• Process audit
• Renegotiation of conditions (loss at their expense beyond X%)

KPI 3: Scrap Return Delay

Formula: Average delay = Sum of delays / Number of returns

Example:

• Order A: Scraps returned after 15 days
• Order B: Scraps returned after 40 days
• Order C: Scraps returned after 25 days
• Average delay = (15+40+25) / 3 = 26.7 days

Interpretation:

• <15 days: Excellent
• 15-30 days: Normal
• > 30 days: Problem (money tied up)

Goal: <20 days on average

Action if exceeded:

• Contractual clause for return within 15 days
• Penalties if exceeded
• Or invoice scrap value if no return within 30 days

KPI 4: Tied-Up Stock Value vs Monthly Revenue

Formula: Ratio = Materials stock value / Average monthly revenue

Example:

• Valued materials stock: 50,000EUR
• Average monthly revenue: 150,000EUR
• Ratio = 50,000 / 150,000 = 0.33 (or 33%)

Interpretation:

• <20%: Stock probably too low
• 20-40%: Good balance
• > 50%: Stock too large (cash tied up)

Goal: 25-35%

KPI 5: Documentation Compliance

Formula: Compliance rate = (Orders with complete traceability / Total orders) x 100

Example:

• Orders this month: 50
• Orders with all docs: 45
• Rate = 45 / 50 = 90%

Interpretation:

• <80%: ⚠️ RJC non-compliant (audit risk)
• 80-95%: To improve
• > 95%: Compliant

RJC Goal: 100% (no tolerance)

10. Implementation Checklist

Week 1: Audit of Existing Situation

• Do a complete physical inventory of your materials
  • Gold by alloy (yellow, white, rose, platinum)
  • Diamonds by size/quality
  • Colored stones
• Identify all locations
  • At your location (safe, office)
  • At each manufacturer
  • In transit
• List your current suppliers
  • Refiners / smelters
  • Diamond dealers
  • Verify their RJC certifications
• Evaluate your current system
  • Excel? Paper? Software?
  • How much time spent per week on management?
  • Have you had blocking stock-outs before?

Week 2-3: Defining Target System

• Calculate your alert thresholds per material
• Define your nomenclatures per product
  • Gold needed per product
  • Diamonds needed per product
• Choose a management tool
  • Stay on improved Excel (temporary)
  • Invest in an ERP module
  • Adopt a modern collaborative platform
• Establish your RJC traceability processes
  • Delivery note template
  • Filing of supporting documents

Week 4: Implementation

• Configure the chosen tool
• Import your current data
• Train the team (if applicable)
• Test with 2-3 pilot orders

Week 5-8: Gradual Deployment

• Use the new system for all new orders
• Continue the old system in parallel (safety)
• Adjust parameters based on feedback
• Verify stock consistency (physical vs digital)

Month 3: Optimization

• Analyze first quarter KPIs
• Adjust alert thresholds if necessary
• Train manufacturers on the tool (if they have access)
• Automate monthly reports

Conclusion: Materials Management as a Competitive Advantage

Good management of your gold and diamond stocks is not just an administrative obligation. It is a major performance lever:

💰 Direct savings: Reduced losses, better supplier negotiation, less overstock ⏱️ Time savings: From 5-10h/week to a few minutes per order 🔒 Guaranteed compliance: Stress-free RJC audits, total traceability 📊 Financial visibility: Precise valuation, real margins calculated 🚀 Operational agility: No production blockage, needs anticipation

The tools exist today to transform this complexity into automation. The question is not "is it worth it?" but "how much does NOT doing it cost me?"

Try LIINK: Automated Management of Your Precious Materials

LIINK natively integrates a complete gold and diamond management module:

✅ Automatic calculation of needs per order (product nomenclatures) ✅ Automatic allocation/release of stock ✅ Total traceability for RJC compliance (all linked documents) ✅ Threshold alerts (email + in-app) ✅ Real-time valuation according to metal prices ✅ Multi-location tracking (you, manufacturers, transit) ✅ Complete history of movements ✅ Excel export for your accountant

15-day free trial, no credit card required → www.liink.ink

Import your current stocks, create a few orders, and see the difference. If it doesn't transform your daily work, no problem. If it saves you 5h/week, you'll have won.

Further Reading

• Gold Traceability in Jewelry: From Ingot to Finished Jewel
• Valuation of Precious Materials Stocks in Jewelry
• RJC Certification: The Complete 2025 Guide for Responsible Jewelry

SEO Keywords: jewelry gold stock management, diamond traceability jewelry, gold weight account, precious metals valuation, RJC compliance jewelry, jewelry materials needs calculation, product diamond nomenclature, manufacturer gold scrap return, gold stock alert thresholds, precious materials management software