Gold & Jewelry Inventory and Item Coding: Stock Card, Melting

To manage gold and jewelry inventory properly, give every item a unique, meaningful code, track stock both by count and by weight and karat, start from a counted opening stock, record every melting and separation as a separate output and input, and reconcile stock with the stock card regularly.

The stockroom of a jewelry store or gold gallery is unlike any other: items are small and expensive, almost no two pieces weigh the same, each item’s value depends on its weight and karat, and part of the stock, such as old gold, is constantly melted down and turned into something else. If the coding structure and stock recording are not designed properly from day one, the inventory report becomes a number nobody trusts. This guide covers gold item coding, weight-based stock and stock cards, opening stock, melting and separation, and periodic counts, with practical examples.

How is gold and jewelry inventory different from ordinary stock?

• Two units of measure at once: piece count and weight (with karat). A ring counts as one, but its value is measured by its weight.
• Unique items: even two bracelets of the same model usually differ by a few milligrams or tenths of a gram.
• Different karats: 750, 900, 995 and old gold of varying purity must be brought to a common basis before they can be added up.
• Constant transformation: gold bought from customers is melted, jewelry sets are split up, and the shape of stock keeps changing.
• Stones and gems: in stone-set pieces, the gold weight and the stone details are two separate pieces of information.

Principles of item coding for gold and jewelry

1. Unique: no two items share a code, and the code of a sold piece is never reassigned to another one.
2. Stable: don’t tie the code to anything that changes. Never put price or making charge in the code; they are attributes of the item, not its identity.
3. Meaningful but short: a few simple segments showing group and type are enough; a code that tries to hold everything gets so long nobody enters it correctly.
4. Room to grow: leave enough space in each segment for future groups and serial numbers.
5. Written and shared: document the code table and give it to all staff so nobody invents codes to their own taste.

A sample coding structure for gold and jewelry

The structure below is only a suggested example; adapt it to your own type of business and items. The code has four segments: main group, subgroup, karat, serial.

With this structure, code 20370125 means a finished women’s ring in 750 gold with serial 0125. Main groups could look like this:

Individual items or weight-based groups?

A key coding decision is whether each piece gets its own code or a group of items shares one code with a weight-based balance.

• An individual code per piece: for gem-set jewelry, stone-set pieces, high-value items and anything a customer may want exactly. Traceability is complete, but it takes more data entry.
• A group code with weight-based stock: for melted gold, old gold and items where the individual piece doesn’t matter. Entry is simpler, but you only know the group’s total weight and karat.

Most stores use a mix: jewelry and gem-set pieces individually, raw and old gold by weight, and coins by count.

Weight-based stock and the gold stock card

A stock card (also called a kardex) is the history of receipts and issues for an item or item group. In a gold business, the stock card should show not just quantity but weight, and ideally 750-equivalent weight, so that items of different karats can be added up. Below is a hypothetical stock card for an “old gold” group over a few days:

To convert any karat’s weight to 750 equivalent, use weight × fineness ÷ 750; the full explanation and a factor table are in our gold karat conversion guide.

Recording opening stock in a jewelry store, step by step

Opening stock is the zero point for every later report; if this figure is wrong, no stock card will ever be right.

1. Set a cut-off date: ideally the end of a working day or a day off, so no trading happens during the count.
2. Group the items: separate display cases, safe, consignment items and items under repair. Customers’ items held in trust are not your stock.
3. Count and weigh in pairs: one person weighs, the other records; write each piece’s weight to the milligram.
4. Establish the karat: record the known karat for jewelry, and the assayed fineness for old and melted gold.
5. Assign codes: give each piece or group a code according to your code table.
6. Total and sign: calculate the count and 750-equivalent weight of each group and sign the sheets.
7. Enter into the system: post the list as opening stock and compare the system total with the sheet totals.

If you are moving from a ledger or Excel, see the rest of the migration steps in our article on Excel vs software for jewelry store accounting.

Melting and separation: how should they be recorded in stock?

When old gold or broken pieces are melted, the original items leave stock and a new product with a new weight and karat comes in. The right rule is to record this as a separate output and a separate input, so the difference between them, usually the melting loss, is clearly visible, rather than simply overwriting the old weight with the new one.

A hypothetical example: 50 g of old gold with an average fineness of 740 is sent for melting. Its 750 equivalent is 50 × 740 ÷ 750 = 49.333 g. After melting, 49.6 g of melted gold comes back with an assayed fineness of 735, whose 750 equivalent is 48.608 g.

As you can see, the real loss in terms of gold content (0.725 g of 750 equivalent) is larger than the apparent weight difference (0.4 g), because the fineness dropped too. Compare weights alone and this loss stays hidden.

Separation follows the same logic: when a jewelry set is split into separate pieces, or stones are removed from the gold, the original item goes out and each new component comes in with its own code and weight. The components should add up to the original item, plus or minus the recorded loss.

Periodic gold stock counts and reconciliation

• Daily: count display items at opening and closing.
• Weekly: weigh one or two item groups in rotation and compare with the stock card (cycle counting).
• Monthly or quarterly: a full count and weighing of every group.

Follow every difference until you find its cause: an unrecorded invoice, a wrong karat, an unrecorded melt or items moved between groups. Only post an adjustment once you know the cause. Adjusting stock without a reason hides the problem and lets it happen again. For complementary controls on the cash drawer and invoices, see our article on cash control and fraud prevention in jewelry stores.

Common mistakes in gold and jewelry inventory

• Putting price or making charge in the item code
• Adding up weights of different karats without converting to a common basis
• Overwriting the pre-melt weight with the post-melt weight instead of recording separate output and input
• Starting with an opening stock that was copied from old books rather than weighed
• Reusing a code for a new piece after the previous piece was sold
• Adjusting count differences without finding the cause

What does Zaran do for gold inventory and item coding?

Zaran gold and jewelry inventory and accounting software keeps stock in step with invoices and the cash drawer:

• From Zaran Start: item definitions with custom coding, so you can design a structure like the example above yourself; automatic conversion of karats to a standard equivalent; and sales and purchase invoices with exact weight, karat, making charge and price calculation.
• From Zaran Pro: opening stock entry; melting and refining with precise input and output records; and reports such as stock and stock card, trial balance and profit and loss.
• In Zaran Elite: full user change history and fiscal period closing, so the approved stock of past periods stays untouched.

If you keep weight-based accounts and transfers with partners, also read our article on gold wholesale accounting, and for every criterion in choosing a jewelry accounting system, visit our complete guide to gold and jewelry accounting software.

Frequently Asked Questions

How should items be coded in a jewelry store?

Each item code should be unique, stable and short, built from a few simple segments such as main group, subgroup, karat and serial. Never put price or making charge in the code.

What is a gold stock card?

It is the history of receipts, issues and balance for an item or item group. In a gold business it should show weight, and preferably 750-equivalent weight, as well as quantity.

How do I record opening stock for a jewelry store?

On a set cut-off date, count every item in pairs, weigh it to the milligram, establish its karat, assign a code, and enter the signed totals into the system.

How is melting gold recorded in inventory?

The melted items are recorded as an output and the resulting melted gold, with its new weight and fineness, as an input, so the melting loss is visible in 750-equivalent terms.

How often should gold stock be counted?

Count display items daily, weigh one or two groups weekly, and count all stock monthly or quarterly, following every difference until you find its cause.

Want to see item coding, opening stock and melting and refining in gold accounting software? Request a Zaran demo and the P-Soft team will walk through your store’s stock routine with you.

Further reading

• How to Choose the Best Gold Accounting Software for Your Shop
• How to Calculate Gold Jewelry Price: Making Charge, Profit, VAT
• Gold Wholesale Accounting: Transfers and Weight-Based Settlement

Complete guide: gold and jewelry accounting software