Sri Lanka was once called Rathna Deepa, the island of jewels, and that reputation was earned honestly. Few countries anywhere hold the same variety of gem-bearing ground in such a small area, and the trade built around it, from the pits of Ratnapura to the trading floors of Colombo, still runs on relationships, reputation and a stone-by-stone attention that most business software was never designed to handle.

That’s really the whole problem. A general inventory system can count boxes. It can’t tell you that the 3.2 carat blue sapphire in the safe is worth considerably more than the 3.4 carat one sitting next to it, because it doesn’t know what carat, colour, clarity and certification actually mean to the value of what you’re holding.

TL;DR

• Gem inventory isn’t stock in the usual sense. Two stones of similar size can carry very different values, so tracking by weight or unit count alone tells you almost nothing.
• Every export needs an NGJA-approved dealer license with a set stock value ceiling, and staying inside that ceiling depends on knowing your real inventory value at any moment, not last month’s estimate.
• Consignment, sending stones out to be shown to a buyer before a sale is confirmed, is common in this trade, and it’s exactly where stones quietly go missing from proper records if nothing’s tracking them.
• Export buyers pay in dollars or euros, local buyers in rupees, so your system needs to handle both without someone reconciling two currencies by hand.
• Blue Lotus 360 tracks individual stones with their own attributes and certification, not generic SKUs, and keeps consignment and export documentation properly connected to your inventory.

Why generic inventory software falls apart here

Most inventory systems are built around the assumption that every unit of a product is roughly interchangeable, a hundred identical bags of cement, a thousand identical bottles of shampoo. A gem business doesn’t work that way at all. Every stone is genuinely one of one, with its own weight, colour grade, clarity, cut, treatment history and certification. Two “1 carat blue sapphires” sitting side by side can differ in value by a considerable margin, and a system that only tracks “1 carat blue sapphire, qty 2” is quietly throwing away the information that actually matters.

What a jewellery or gem business actually needs is something closer to a proper record for each individual piece: its own reference number, its certification if it has one (GIA, GRS, or a local gemmological report), where it came from, and its current status, in stock, on consignment, sold, or under valuation. That’s a very different shape of data to what most off-the-shelf inventory software expects.

The paperwork that comes with every stone

Anyone trading gems or jewellery for export knows the NGJA isn’t optional. A valid Official Gem Dealers License is required to export at all, and that license comes with a stock value ceiling, meaning your declared, exportable inventory can’t exceed a set figure. Staying inside that ceiling with confidence means actually knowing your current stock value at any given moment, not estimating it from a stocktake done three months ago.

Exports themselves get physically inspected and cleared either at the Diamond Export Unit at Bandaranaike International Airport or the Geuda Export Unit in Ratnapura, alongside proper insurance cover on the consignment. None of that changes because you’ve got good software. What good software does is make sure the numbers you’re presenting for that process, current stock value, consignment status, certification details, are accurate and ready rather than pulled together under pressure the night before a shipment.

Consignment: where stones quietly go missing from the books

This is one of the most Sri Lanka-specific realities of the trade, and one generic software genuinely doesn’t handle well. Stones regularly leave the safe on consignment, sent to another dealer, shown to a buyer overseas, taken to a trade fair, without a confirmed sale attached. That stone is still yours, still needs to be accounted for in your stock value, and still needs a clear paper trail of exactly who has it and since when.

Without a system built to track this properly, consignment stock tends to live in a notebook, a WhatsApp message, or someone’s memory, which works fine right up until a stone can’t be accounted for and nobody’s entirely sure whether it’s with a buyer in Bangkok or sitting in a drawer at the office. Proper tracking means a stone’s status updates the moment it leaves on consignment, and stays visible, not invisible, until it either comes back or the sale is confirmed.

Two currencies, one set of books

A trader selling locally in rupees and exporting to buyers paying in dollars or euros needs a system that handles both cleanly, not a spreadsheet where someone’s converting figures by hand and hoping the exchange rate they used last week is still close enough. Getting this wrong doesn’t just create an accounting headache, it makes it genuinely difficult to know your actual margin on an export sale until well after the fact.

Where Blue Lotus 360 fits in

Blue Lotus 360 tracks gemstones and jewellery pieces as individual items with their own attributes, certification and status, not generic SKUs treated as interchangeable. Consignment movements stay visible through the whole cycle, so a stone out with a buyer or at a trade fair is still properly accounted for in your records, not quietly missing until someone remembers to ask. Multi-currency support means local rupee sales and export sales in dollars or euros sit in the same system without manual reconciliation.

For a trade built as much on reputation and precision as it is on the stones themselves, having records that actually match what’s in the safe matters more than most software categories admit. If your current tracking still runs on a notebook and good memory, a demo is worth an hour of your time to see what it looks like properly tracked.

 

FAQ Section

Do I need special software just to track a small collection of stones, or is this only for large traders?

Even a modest inventory benefits from per-item tracking rather than generic stock counts, since a handful of high-value stones misrecorded can matter far more financially than a large volume of low-value goods being slightly off. The need shows up earlier in this trade than most others.

How does software help with the NGJA stock value ceiling specifically?

By keeping your current, accurate stock valuation available at any time rather than reconstructed manually before an export. Knowing exactly where you sit against your licensed ceiling in real time avoids last-minute scrambling before a consignment ships.

Can consignment stock really be tracked properly without something showing up as “sold” too early?

Yes, provided the system distinguishes consignment status from a confirmed sale as separate states. A stone can be marked as out on consignment, still counted in your inventory, without the sale being recorded until it’s actually confirmed.

Does this kind of system replace the need for proper gemmological certification?

No. Certification, whether from GIA, GRS or a recognised local gemmologist, remains a separate professional process. What the system does is store and attach that certification to the right stone’s record, so it’s always linked to the item it belongs to rather than sitting in a separate folder somewhere.