By Jwellex — Jewellery Management Software Sri Lanka
Gold is the most valuable and most vulnerable asset in a jewellery business. Unlike most retail inventory, gold can be lost in ways that are almost impossible to detect without the right systems — through craftsman wastage above the agreed allowance, informal stock movements, unrecorded old gold purchases or simple administrative errors that compound over time.
This guide explains how to track gold stock accurately across every stage of your jewellery operation, from raw material purchase to finished article sale.
Most jewellery businesses track gold in one of two ways: counting finished pieces at stocktake, or maintaining a weight ledger updated manually. Both approaches have significant weaknesses.
Piece counting tells you how many items you have. It does not tell you whether the weight of those items is correct. Gold shaved from multiple pieces will not show up in a piece count.
Manual weight ledgers depend on accurate entry by staff at every transaction. Errors accumulate, adjustments go unrecorded and the ledger gradually diverges from reality.
The only way to track gold accurately is a system that records weight automatically at every transaction, reconciles totals at each stage and flags any discrepancy immediately.
Stage 1: Raw Material Purchase
Record every gold purchase with supplier name, date, weight and purity. Issue a GRN (Goods Received Note). This is the starting balance from which all subsequent reconciliations flow.
Stage 2: Material Conversion
When raw gold is processed — melted, alloyed or rolled — record the input weight and output weight. The difference is conversion loss, which should match industry norms for the process used.
Stage 3: Craftsman Gold Issue and Return
Record the exact weight issued to each craftsman for each job. When finished articles are returned, record the actual weight of finished items. Wastage = issued weight minus returned weight minus agreed wastage allowance. Any excess is flagged.
Stage 4: Finished Article Tagging
Tag every finished piece with a unique identifier, weight, purity and description. This tag links the piece to every subsequent transaction in the system.
Stage 5: Branch Stock Management
Track stock at each branch by item and weight. Formal transfers between branches use a dispatch and receipt process with in-transit tracking. Items are not counted at either branch until formally received.
Stage 6: Sale and Setoff
Every sale removes the tagged item from stock and links it to the customer invoice. Old gold purchased from customers enters a separate register and is reconciled against subsequent remelting or resale.
A proper gold tracking system should:
Tag every piece on arrival with weight and a unique identifier. Record every movement — sale, transfer, reservation, return — against the tagged piece in a management system. Reconcile physical stock against system records regularly. For manufacturing, track gold issued to craftsmen at job level and reconcile returned finished articles against issued weight.
Issue gold to craftsmen by job with a recorded weight. Agree on a wastage allowance per job in advance. When finished articles are returned, weigh them and calculate actual wastage. Any wastage above the agreed allowance is flagged immediately. This is the craftsman gold balancing module in Jwellex.
Craftsman gold balancing is the process of tracking gold issued to a craftsman for a specific job and reconciling the weight of finished articles returned against the issued gold. The difference is wastage. A proper system tracks this at job level, calculates expected versus actual wastage and flags excess.
With a proper management system, stock counts should match system records at any time because every movement is recorded. Physical stocktakes should be done at least monthly to verify the system. With item-level tagging, a full stocktake can be completed quickly by scanning or counting tagged pieces against the system register.
Yes. A centralised system like Jwellex maintains a single stock register across all branches. When stock is transferred between branches, it goes into an in-transit register until formally received. Head office can see stock levels, in-transit items and reserved pieces at every location in real time.
Talk to our team in Sinhala or English. Free demo available.
REQUEST RETAILER DEMO REQUEST MANUFACTURER DEMO