How to Track Gemstone Inventory by Cut, Carat, and Cert

If you make jewelry with precious metals, you already know how to track by weight. Weigh a tray, record the grams, compare to your books. Metals are fungible—a gram of 14K yellow is the same as any other gram of 14K yellow. (Our karat purity guide covers the nuances of alloy and fineness tracking.)

Gemstones don't work that way. Every stone has an identity: shape, carat weight, color, clarity, cut grade, origin, certification. You can't weigh a tray of loose diamonds and know what you have. You can't swap one 0.80ct round brilliant for another without checking whether the color, clarity, and cert match. And if half the stones in your safe belong to a dealer on memo, you'd better know which half.

Most jewelers start tracking stones the same way they started tracking metal—a spreadsheet, maybe some Ziploc bags with sticky notes. That works until it doesn't. This guide covers what a proper gemstone tracking system looks like, what data you need, and where the common approaches break down.

What makes gemstone inventory different

Precious metals are commodities. A gram of 18K white gold has a market price, and any gram is interchangeable with any other gram of the same alloy. Gemstones are not commodities. They're discrete items, or discrete lots, with individual characteristics that determine value.

Two round brilliant diamonds, both 1.00ct, can differ in price by 5x or more depending on color, clarity, and cut. A pair of 6x4mm oval sapphires from the same parcel can look completely different once you start comparing saturation and tone. Even calibrated melee varies enough that your 1.3mm round brilliants from one supplier won't perfectly match those from another.

Your inventory system needs to handle identity, not just quantity. For metals, the question is "how many grams?" For gemstones, the question is "which stones, with what specs, owned by whom, and where are they right now?"

What to track for every stone

Whether you serialize individual stones or track by lot, each entry needs enough data to identify the stone, price it, and find it. Below is the full field list. Every field serves an inventory purpose, not just an appraisal one.

The basics

• Stone type—diamond, sapphire, ruby, emerald, tourmaline, etc. This is your primary category for filtering and reporting.
• Shape/cut—round brilliant, oval, cushion, emerald cut, pear, marquise, princess, cabochon, etc. Shape determines which settings and designs a stone fits.
• Carat weight—the single most referenced spec. 1ct = 0.2g. Record to the hundredth: 0.83ct, not "about 0.8."
• Measurements (mm)—length x width x depth. Critical for setting fit. A 7.0x5.0x3.2mm oval won't seat in a bezel cut for 7.0x5.0x3.5mm.

Grading data (the 4Cs and beyond)

• Color grade—for diamonds: D through Z on the GIA scale. For colored stones: hue, tone, and saturation (e.g., "medium-dark slightly purplish blue").
• Clarity grade—FL, IF, VVS1/2, VS1/2, SI1/2, I1/2/3 for diamonds. "Eye-clean," "slightly included," etc. for colored stones where standardized grading is less rigid.
• Cut grade—Excellent, Very Good, Good, Fair, Poor for round brilliants. Fancy shapes don't carry a GIA cut grade but you should still note proportions and light performance.
• Fluorescence—None, Faint, Medium, Strong, Very Strong. Affects pricing and desirability, especially in D–F color diamonds.
• Polish and symmetry—Excellent to Poor. These appear on every GIA report and affect both value and visual performance.

Certification and provenance

• Cert lab—GIA, IGI, GCAL, HRD, etc. (You'll still encounter legacy AGS reports from before GIA absorbed their grading operations in 2022.) The lab name matters for consistency and customer trust.
• Cert/report number—the unique identifier that ties your physical stone to its grading report. Store the number and, ideally, a URL to the online report for instant verification.
• Treatment—heated, unheated, fracture-filled, irradiated. Treatment status can swing a stone's value by half or more, and it has to be disclosed at point of sale. If your tracking system doesn't store it, you're relying on memory.

Inventory fields

• Acquisition cost—what you paid, or the memo value if consignment. This is your COGS basis.
• Supplier/dealer—who you bought it from or who consigned it.
• Ownership status—owned vs. on memo (consignment). More on this below.
• Location—safe, bench, out for setting, out for appraisal, shipped to customer.

That's a lot of fields. But they're all doing work. When a customer asks for a 1ct G/VS2 round brilliant and you need to know what's in stock, you're filtering on all of them. When you're building a bill of materials for a halo ring, the center stone line item needs shape, size, grade, and cost. "Diamond" isn't enough.

Serialized vs. lot tracking

Not every stone needs its own serial number. It depends on value and whether the stone is replaceable.

When to serialize

Serialize individual stones when:

• The stone has a grading certificate (GIA, IGI, GCAL)
• It's a center stone or feature stone worth more than roughly $150–$200
• It's a one-of-a-kind colored gemstone (you can't reorder "the same one")
• It's on memo from a dealer (you need to return that specific stone)
• You need to track it through production and tie it to a specific finished piece

A serialized stone gets a unique identifier—your own internal prefix + number (e.g., DIA-0472, SAP-0088) or the cert number itself. Every movement, allocation, and status change is logged against that serial. When the stone goes into a ring, the finished piece record links back to the specific stone.

When to track by lot

Lot tracking makes sense for:

• Melee diamonds (0.01–0.20ct each)
• Calibrated accent stones (matched sets of 2mm sapphires, 1.5mm rubies)
• Beads and cabochons used in volume
• Any stones where individual identity doesn't affect pricing or customer expectations

A lot gets a single record: stone type, shape, size range, quality grade, total carat weight, cost per carat, and quantity on hand. When you pull 16 stones from a melee parcel for a halo setting, you deduct 16 pieces (or the carat weight) from the lot—you don't need to know which 16.

The practical threshold

Most studios land on a threshold somewhere between $100 and $300 per stone. Below that, lot tracking. Above it, serialize. The exact number depends on your volume and how much time you want to spend on per-stone data entry. A studio setting 500 melee stones a month isn't going to serialize each one. A studio buying $2,000 sapphires from dealers absolutely should.

The consignment problem

Consignment, called "memo" in the diamond and colored stone trade, is when a dealer lends you stones to examine, show to clients, or hold for future use. You don't own them. The dealer retains title until you either buy the stone or return it. And if your records don't clearly separate memo from owned, you have a problem.

Why memo tracking matters

• Ownership clarity. If you can't instantly tell which stones in your safe you own and which are on memo, you don't actually know your inventory value. Your balance sheet is wrong.
• Return obligations. Memo stones have return dates. Miss a return and you owe the dealer—or worse, they stop lending to you. Your system needs to flag stones approaching their memo expiration.
• Insurance. Your insurance policy likely covers owned inventory differently from consigned goods. Memo stones may need separate coverage or a rider. If you can't produce a list of which stones are on memo vs. owned, you're guessing at your coverage needs.
• Cash flow. Memo is effectively free inventory. Knowing how much of your available stock is memo vs. purchased tells you the true capital tied up in gemstones. That number matters when planning purchases or negotiating with dealers.

How to track it

Every stone record needs an ownership field: Owned or Consignment. For consignment stones, also store the dealer name, memo date, return-by date, and memo value (which may differ from the buy price if you decide to purchase). Keep memo stones physically separated in your safe if possible. A labeled tray or pouch per dealer avoids confusion during counts.

When you decide to buy a memo stone, the record flips from Consignment to Owned and the acquisition cost gets locked in. When you return one, it leaves your inventory. Log both transitions with a date and reason.

Lifecycle of a stone through your studio

A stone isn't just "in stock" or "sold." It moves through stages, and if you don't track which stage each stone is in, you can't answer the most basic question: what's actually available right now?

Typical lifecycle statuses

• Received—stone has arrived and been inspected, but not yet put into general inventory (maybe pending a quality check or cert verification)
• In Stock—available for allocation to a build or for sale as a loose stone
• Allocated—reserved for a specific order or build but not yet set. The stone is committed; it shouldn't show as available to other orders.
• Consumed (Set)—physically set into a piece. The stone's identity now lives with the finished product.
• Sold—the finished piece containing this stone has been sold and fulfilled
• Returned—sent back to the memo dealer or returned by a customer
• Lost/Damaged—accounted for but no longer usable. Needs documentation for insurance and write-off.

Why status tracking matters

Without statuses, you end up double-allocating. A customer asks for a 1.20ct oval sapphire. You check your spreadsheet, see one in stock, quote the job. Meanwhile, your bench jeweler already pulled that stone for another order yesterday. The spreadsheet still shows it as available because nobody updated the cell.

With proper status tracking, the stone moved to "Allocated" the moment it was assigned to the first order. When you check availability, it doesn't appear. The second customer gets an honest answer instead of a callback two days later.

This is the kind of allocation problem Forge is designed to eliminate. When you assign a stone to an order, it moves to "Allocated" and stops appearing as available stock. Every status change gets a timestamp and a reason, so you can trace any stone's path from receipt to sale.

Physical counts for gemstones

Counting gemstones is not the same as counting metals by weight. You can't weigh a tray of loose stones and compare to a book number. The method depends on whether you're counting serialized stones or lots.

Serialized stone counts

For serialized stones, you're verifying identity, not just quantity. Pull each stone from the safe, confirm its serial or cert number, check it against your inventory list, and mark it as verified. If a stone is listed as "In Stock" but isn't physically present, it's either been allocated without updating the system, set into a piece without logging the consumption, or it's genuinely missing.

The count produces two lists: verified (present and accounted for) and missing (on record but not found). Every missing stone needs investigation—check WIP trays, the setting bench, the return-to-dealer pile, and pieces recently shipped.

Lot counts

For melee and calibrated lots, weigh the parcel and compare to the book weight. If your records say you have 8.4ct of 1.5mm round diamond melee and you weigh 8.1ct, that 0.3ct gap is probably stones consumed in production that weren't deducted. A variance of 1–3% on melee lots is typical. Beyond that, investigate.

Memo stone verification

Count memo stones separately and reconcile against each dealer's memo slip. If a dealer's memo says you have five stones and you can only find four, that's an urgent problem—you owe them for the missing stone. Memo verification should happen every time you do a gemstone count, not just at year-end.

Forge is building a dedicated stone count workflow that works serial by serial: scan or enter each one, get a verified/missing result on the spot, and reconcile owned vs. memo in the same pass.

Spreadsheet vs. dedicated tracking

A spreadsheet can store all the fields listed above. Plenty of jewelers run their stone inventory in Google Sheets or Excel, and for a small collection it's fine. The problems show up as volume grows.

Where spreadsheets break down

• No status management. A spreadsheet cell says "in stock" until someone remembers to change it. Nothing triggers when a stone is allocated to a build, nothing updates when an order ships, and there's no record of who changed what or when.
• No allocation logic. When you quote a stone to a customer, nothing prevents you from quoting the same stone to someone else. The spreadsheet doesn't know about your orders.
• No cert linking. You can paste a GIA report number into a cell, but you can't click through to verify it or attach the PDF.
• No Shopify sync. If a stone is set into a piece listed on Shopify, the spreadsheet doesn't know the piece sold. The stone still shows as "in stock" until you manually update it.
• Consignment tracking is manual. You need a separate sheet or column for memo stones, manual date tracking for returns, and discipline to keep it current. Most jewelers start strong and drift.
• Physical counts are a printout-and-pencil affair. Print the list, walk to the safe, check things off, type variances back in. No real-time verification, no per-serial history.

When to move to a dedicated system

You'll know it's time when one of these is true:

• You have more than 30–50 serialized stones in inventory at any time
• You regularly hold memo stones from two or more dealers
• You've double-allocated a stone to two orders (or come close)
• Your physical counts consistently show discrepancies you can't trace
• You sell finished pieces on Shopify and want stone consumption to deduct automatically when an order fulfills

Forge is being built for exactly this point. The gemstone tracking on the roadmap includes serialized records with full GIA grading fields (the 4Cs plus fluorescence, polish, symmetry, and measurements), cert lab and report number linked to each stone, owned vs. consignment tagging, and statuses that update as stones move from receipt through allocation, setting, and sale. The goal: when a Shopify order fulfills, the stones in that piece deduct from inventory automatically, and physical counts run against serial numbers with real-time verified/missing results.

For the metals side of your inventory (weight-based tracking, alloy purity, spot pricing), see our raw materials tracking guide. If you're evaluating tools more broadly, our comparison of Craftybase and its alternatives covers where each option falls short on stone-level tracking.

Questions about tracking gemstones in your studio? Email hello@startforge.app.