- Qintar
- Free sheets
- Display stock: pieces and weight by category
Display stock: pieces and weight by category
The stock in the display cases is the largest part of a gold shop's money. This sheet sums it up category by category: how many pieces and grams of each karat, the pure gold, and the value at today's price.
Opens in Excel, or upload the file to Google Drive and open it with Google Sheets. You type in the yellow cells. Or try it online without downloading.

How to use it
- The prices: Today's buying price per gram for each karat.
- The categories: One line per category and karat, with the number of pieces and the weight.
- The calculation: Pure gold, average weight per piece and value.
- The totals: Total pieces and weight for each karat.
- Compare: Check it against your stock count and books every month.
Example The calculation with numbers
Buying price, 1 g of 24K (example): 7,009.37 · Buying price, 1 g of 21K (example): 6,160.25 · Buying price, 1 g of 18K (example): 5,259.00
| Category | Karat | Pieces | Total weight (g) | Pure gold (g) | Average weight per piece (g) | Value at the buying price |
|---|---|---|---|---|---|---|
| Example: rings | 21 | 64 | 278.500 | 243.688 | 4.352 | 1,715,629.63 |
| Example: chains | 21 | 40 | 412.000 | 360.500 | 10.300 | 2,538,023.00 |
| Example: bracelets | 21 | 22 | 596.200 | 521.675 | 27.100 | 3,672,741.05 |
| Example: wedding bands | 18 | 30 | 162.000 | 121.500 | 5.400 | 851,958.00 |
| Example: bars | 24 | 12 | 95.000 | 94.905 | 7.917 | 665,890.15 |
| Example: gold pounds | 21 | 10 | 80.000 | 70.000 | 8.000 | 492,820.00 |
| Result | Value |
|---|---|
| Total pieces | 178 |
| Total weight (g) | 1,623.700 |
| Of which 21K (g) | 1,366.700 |
| Of which 18K (g) | 162.000 |
| Of which 24K (g) | 95.000 |
| Total pure gold (g) | 1,412.268 |
| Value at the buying price | 9,937,061.83 |
Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made.
The calculation
- Pure gold = weight × karat purity (24K = 0.999, 21K = 0.875, 18K = 0.75).
- Average weight per piece = total weight ÷ number of pieces.
- Value = weight × today's buying price per gram of the same karat (without the making charge).
Terms used on this sheet
- Display stock
- The finished pieces in the shop's cases and window (المعروض), as opposed to scrap or gold at the workshop.
- Pure gold
- The gold inside an alloy: weight × purity. It lets different karats add up to one figure.
- Gold pound
- A coin of 8 g of 21K gold (جنيه ذهب), sold in Egypt alongside bars and jewelry.
- Buying price
- The price at which a shop buys gold. It is lower than the selling price that customers pay.
Read more
- A gold shop's display stock: grams by category and karatA step-by-step guide with a worked example.
- Display stock calculator: pieces, weight and value per karatThe same sheet online, with today's prices.
Frequently asked questions
Does the value include the making charge?
No. The value is at the buying price of the gold only, so you know what the metal you hold is worth. The making charge belongs in your pricing.
Does this replace a stock count?
No, it is a summary of the display stock. Counting the stock and matching it with the books is done in Qintar's gold stock count and loss sheet.
Why the average weight per piece?
It tells you about the kind of stock you carry. If the average weight of your rings rises or falls, that matters for your next purchases.
Why value at the buying price and not the selling price?
The buying price is what the gold would fetch if it were sold today. It is the cautious figure for what the stock is worth as metal.
Prices and calculations are for information only. They are not financial advice, an offer to buy or sell, or a religious ruling. Check tax matters with your accountant.
Live prices in the app. The Qintar app shows gold and silver buy and sell prices in Egypt, your holdings at today's price, and a zakat calculator. Free, with no ads.
More free sheets
- Customer orders and depositsWhat does each order cost, how much has the customer paid, and what is still due?
- Customer repairs: weight in and weight outDid the piece go back to the customer at the same weight? And what does the repair cost?
- Staff sales and commissionHow many grams did each salesperson sell, and what is their commission?