How to Manage Gold Shop Inventory by the Gram

In many jewelry shops the piece count is right and the cash drawer balances, yet the grams do not. A gold shop is different from other retail: each item's value is its weight, and a single gram of 21K is worth roughly 6,300 EGP at today's prices. Counting pieces alone is not enough. You need to know, at any moment, exactly how many grams of each karat you hold.

1. Tag every piece: barcode, gross and net weight

Every piece that enters the shop should get a tag with a unique barcode and these fields:

• Karat: 24K, 21K or 18K.
• Gross weight: the whole piece on the scale.
• Stone weight: for set pieces.
• Net weight: gross minus stones; this is what the gold is priced on.
• Making-charge type: per gram, flat or percentage, plus the supplier or workshop.

Barcodes turn a sale into a scan instead of hand-typing, so cashiers do not mistype weight or karat and the price is calculated correctly. To see how weight and making charge become a price, read how to calculate gold price with making charge.

2. Keep a separate gram ledger per karat

Never add 21K grams to 18K grams in one number; they are worth different amounts. Each karat needs its own ledger recording every movement in grams: receipts from workshops and suppliers, sales, used gold bought from customers, scrap sent for melting, and returns.

3. Daily reconciliation

This is the single most important habit in a gold shop. At closing, for each karat separately, calculate the expected balance and weigh the actual stock:

A small variance like this may be a recording error, a piece sold with the wrong weight, or a scale that needs calibration. What matters is chasing it the same day, while the transactions are still fresh, not at month end.

4. Periodic stock-take

Daily reconciliation works on total weight. A periodic stock-take, weekly or monthly, goes piece by piece: scan every barcode in the showcases and the safe and match it to the system. That reveals missing pieces, pieces on hand but never recorded, and tags swapped between items.

5. Connect the scale to your system

Every hand-written weight is a chance for error. When the electronic scale feeds the system directly, weight is captured at the moment of receiving, selling or buying back. Use a scale with at least 0.01 g resolution, calibrate it regularly with certified weights, and keep it on a stable surface away from air-conditioning drafts.

6. Chains and gold sold by weight

Some stock is sold by cutting, such as chain on a roll. It cannot be treated as one piece; record it as a weight item, and deduct each cut length's weight from the roll balance.

7. Controlling shrinkage

• Clear permissions: who can receive stock, edit a weight, or void an invoice.
• Log every weight or price edit with the staff member's name and time.
• Lock and weigh the showcases at closing, before staff leave.
• Weigh used gold in front of the customer and record it immediately.
• Note the cause of every reconciliation variance, even after it is resolved.

Buybacks are one of the most common sources of gram discrepancies, so it pays to get the process right. See how to calculate used gold buyback and exchange.

How GoldCore helps

With GoldCore inventory, every piece has a barcode, gross and net weight and karat, and each karat's gram ledger updates automatically with every sale, buyback and receipt. The daily reconciliation is generated for you, showing variance in grams and in pounds at today's gold price. You can try it free for 14 days with your real stock.